Senior ETL Developer

Our client is seeking an experienced ETL Developer with Healthcare experience for a hybrid contract-to-hire role based in Southeast Florida. Fully remote candidates will be considered on a case-by-case basis.

The Senior ETL Developer is responsible for designing, developing, and implementing ETL processes using Microsoft Business Intelligence tools, specifically MS SQL Server and MS SQL Server Integration Services (SSIS). The role involves transforming and integrating data from multiple sources to support the organization's processes, data warehouse and business intelligence initiatives. The ideal candidate will have experience in the health plan industry and possess a strong focus on data transformation and integration. This position plays a crucial role in ensuring that data is efficiently and accurately moved, transformed, and loaded to provide meaningful insights and support data-driven decision-making.

Responsibilities:

Qualification Requirements:

• Minimum of 7 years of hands-on experience with Microsoft SQL Server and SSIS in a data integration role.
• Extensive experience in data transformation and data integration, specifically within the health plan industry, is highly preferred.
• Strong understanding of relational database design, SQL programming, and performance optimization.
• Proficient in developing complex T-SQL queries, stored procedures, and functions.
• Experience with data warehousing concepts, including the Kimball methodology for data modeling (fact and dimension tables).
• Familiarity with other Microsoft Business Intelligence tools, such as SSRS and Power BI, is a plus.
• Experience with cloud data integration, particularly with Microsoft Azure services, is highly desirable.
• Excellent problem-solving skills and attention to detail, with the ability to manage multiple tasks and meet deadlines.
• Strong communication skills, with the ability to collaborate effectively with technical and non-technical stakeholders.

Preferred Qualifications:

• Microsoft Certifications in SQL Server or related technologies.
• Knowledge of data governance, data quality, and master data management (MDM) tools.
• Experience with Agile development methodologies and tools like Jira.

Skills and Abilities:

• In-depth knowledge of ETL best practices, data integration, and data transformation techniques.
• Ability to design and implement efficient ETL processes that ensure data accuracy, quality, and integrity.
• Strong analytical skills and the ability to troubleshoot complex data integration issues.
• Ability to work independently and as part of a team in a fast-paced, dynamic environment.
• Proficient in project management principles with the ability to lead and manage ETL projects from concept to completion.
• Commitment to continuous learning and staying updated with the latest trends in ETL development and data integration.