SSIS Developer/ ETL Developer/ Data Engineer
Role details
Job location
Tech stack
Job description
Design, develop, and maintain batch ETL/ELT processes using SQL Server and SSIS to support ODS, staging, and enterprise data warehouse solutions. Build and optimize complex SQL queries, stored procedures, and T-SQL scripts to ensure high-performance data processing and analysis. Develop and implement scalable data warehouse solutions using Star and Snowflake schemas to support reporting and analytical needs. Design and manage end-to-end data pipelines, including data ingestion, transformation, validation, and loading across multiple environments. Implement data quality, audit, balance, and control mechanisms to ensure data accuracy, consistency, and reliability. Collaborate with cross-functional teams to understand business requirements, translate them into technical solutions, and adhere to best-in-class data engineering standards.
Requirements
Bachelor's or master's degree in computer science, Engineering, Mathematics, or a related quantitative field. 6-8 years of hands-on experience in SSIS, SQL Server, and data warehousing/ETL development. Strong expertise in designing, developing, and optimizing batch ETL/ELT processes and enterprise data pipelines using SSIS and T-SQL. Proven experience implementing data warehouse solutions (Star/Snowflake schemas), data modeling, and data quality, audit, and control mechanisms.
Benefits & conditions
Rate Range: $45/hour to $47/hour; The rate may be negotiable based on experience, education, geographic location, and other factors., Pay Details: $45.00 to $47.00 per hour Benefit offerings available for our associates include medical, dental, vision, life insurance, short-term disability, additional voluntary benefits, EAP program, commuter benefits and a 401K plan. Our benefit offerings provide employees the flexibility to choose the type of coverage that meets their individual needs. In addition, our associates may be eligible for paid leave including Paid Sick Leave or any other paid leave required by Federal, State, or local law, as well as Holiday pay where applicable. Equal Opportunity Employer/Veterans/Disabled Military connected talent encouraged to apply To read our Candidate Privacy Information Statement, which explains how we will use your information, please navigate to https://www.akkodis.com/en/us/candidate-privacy-policy The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable:
- The California Fair Chance Act
- Los Angeles City Fair Chance Ordinance
- Los Angeles County Fair Chance Ordinance for Employers
- San Francisco Fair Chance Ordinance
Massachusetts Candidates Only: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.
