Strategic Staffing Solutions
Job Title: Compliance Risk Technology Senior Engineer (218795)
Location(s): Charlotte, NC (Hybrid)
Duration: 12 Months
S3 supports and adheres to customer COVID-19 vaccination policies, which may include the disclosure of vaccination status.
This is a Contract Opportunity with our company that MUST be worked on a W2 ONLY, NO C2C eligibility for this position.
To apply: Please email your resume inWord FormattoPaola Martinez at: PMartinez@strategicstaff.comand Reference Job Order #: 218795
Job Description / Duties: This is a Compliance Risk Technology Senior Engineering role that will be responsible for ETL design, database design and development including ongoing support of Compliance Reporting platform. The position will be responsible for executing against the Compliance Risk Technology Strategic plan through development of the reporting platform. The success of the role will require focusing on development and working with other developers to effectively deliver software solutions that meet business requirements. The reporting database will house data from a variety of data sources transformation through SSIS/Informatica /Ab Initio and that will make it conducive to using business intelligence tools like Tableau, SSRS, Qlik, Cognos, etc, that will allow Compliance to pull together information that will aid them in their policy and decision making processes.
Responsibilities include:
• Act as senior developer working with other developers, BA and QA staff in programming, development, testing, and implementation process
• Create thorough designs – taking care to assure that designs integrate well into existing architecture.
• Analyze highly complex business requirements, designs and write technical specifications.
• Collaborate across teams, including global teams, to create high quality solution designs.
• Design, develop, test, and deploy data integration initiative. As a senior Developer, perform Design & Code reviews and process optimization.
• Provides design and development support for analytical systems and data integration applications
• Contributes in analyzing complex requirements and translates to technical design and specifications
• Design, development, test, and implement application ETL (Extract, Transform and Load) code
• Utilize a thorough understanding of available technology, tools, and existing designs to source, map, extract and load large volumes of data.
• Work on complex problems where analysis of data requires a solid grasp of compliance, regulatory and technology risk domains.
• Experience in relational and dimensional models.
• Experience in large scale data warehouse architectures & Performance optimization.
Required Qualifications:
• 7+ years of software engineering experience
• 7 + years of experience writing relational database queries for stored procedures, query optimization and performance tuning
• 7+ years of SQL experience
• 2+ years of experience creating visual reports with one or combination of the following: SSRS, Tableau, or PowerBI
• 7+ years of experience delivering ETL, data warehouse and data analytics capabilities on big-data architecture such as Hadoop
• 3 + years of experience working with large data sets
• 5+ years of experience with scripting languages such as Bash, PowerShell, Python, Shell, VBScript, or JavaScript
Desired Qualifications:
• An industry-standard technology certification
• Strong verbal, written, and interpersonal communication skills
• SQL Server Integration Services (SSIS) experience
• Basic Microsoft Visio skills
• Knowledge and understanding of data modeling tools, such as Power Designer
• Experience with Spark, Hive and Kafka
• 4+ years of experience with source coding in one or a combination of the following: GitHub, SVN(Subversion), TFVC (Team Foundation Version Control) or TFSGit (Team Foundation Server)
• Ability to communicate effectively with a quantitative development team about models and integration strategies
• Ability to dissect technical problems, analyze data, and recommend potential solutions
• Knowledge and understanding of data dimensional modeling
• Good data analytical and validation skills
• BS/BA degree or higher in information technology
Strategic Staffing Solutions (S3) prides itself on being an international IT Staffing and Solutions Company. Over 30 years’ experience recruiting and managing exceptional IT and Business consultants for customers in the Financial, Energy, Public Sector and Retail Distribution industries. A privately held, financially strong, woman-owned company, S3 is a full-service IT firm, with 24 major market locations in the U.S!
Job ID: JOB-218795
Publish Date: 08 Feb 2023