Job Title: Senior SSIS ETL Developer
Location: Remote
Salary: $125000 $130000 per year
Employment Type: Fulltime
Eligibility: U.S. citizenship required
We are a pioneering organization specializing in Data Engineering focusing on delivering advanced solutions and tangible value to our clients in the healthcare industry. We are in search of a seasoned Senior SSIS ETL Developer with indepth experience in data ecosystems necessitating stringent HIPAA compliance measures. If you possess a deeprooted passion for transforming complex datasets into meaningful insights we encourage your application.
Job Summary:
The position requires a dynamic and technically proficient Business Intelligence Developer with a minimum of 8 years of extensive experience in designing and implementing Enterprise Data Warehouses (EDW) and a robust analytics background within healthcare organizations adhering to HIPAA standards. The successful candidate will exhibit high proficiency in cloud computing environments specifically Amazon Web Services (AWS) and Google Cloud Platform (GCP) and showcase advanced skills with Microsoft Business Intelligence (BI) tools. This role is critical in converting complex healthcare data into actionable intelligence that informs strategic business decisions.
Key Responsibilities:
- Architect develop and maintain scalable ETL/data integration pipelines and data warehousing infrastructures ensuring robust adherence to HIPAA compliance during all data handling processes.
- Engage actively with stakeholders to elicit detailed business requirements translating them into precise technical specifications for execution.
- Employ SQL Python and other programming languages to construct performant data models while facilitating complex data queries across distributed environments.
- Design and implement sophisticated ETL processes to effect seamless data integration from heterogeneous sources placing a strong emphasis on data security and regulatory compliance.
- Utilize a suite of Microsoft BI tools including SQL Server Integration Services (SSIS) SQL Server Analysis Services (SSAS) SQL Server Reporting Services (SSRS) and Power BI to generate comprehensive reports and interactive dashboards tailored for healthcare analytics.
- Enforce robust data integrity protocols and ensure rigorous adherence to data governance frameworks with particular emphasis on maintaining HIPAA compliance.
- Proactively identify troubleshoot and optimize existing Business Intelligence (BI) solutions focusing on performance tuning and compliance readiness.
- Independently manage multiple project timelines and deliverables effectively within a highvelocity work environment.
- Collaborate with crossfunctional teams enhancing coordination and communication on BI projects specifically designed for healthcare applications.
Knowledge Skills and Abilities:
- Minimum of a Bachelors degree in Computer Science Information Systems or a related technical discipline (Masters degree strongly preferred).
- 510 years of demonstrable experience as a Business Intelligence Developer with a concentrated emphasis on Enterprise Data Warehousing within healthcare ecosystems.
- Extensive practical experience with AWS services such as RDS DynamoDB ElastiCache EC2 and knowledge of GCP functionalities alongside substantial production experience employing GitHub for version control and collaborative development.
- Highly proficient in SQL for advanced querying; familiarity with programming languages such as Python Java or Scala is a distinct advantage.
- Indepth understanding of data warehousing architectures dimensional modeling techniques and ETL methodologies specifically tailored to healthcare data requirements.
- Exceptional analytical and problemsolving capabilities underscored by meticulous attention to detail.
- Demonstrated ability to communicate complex technical concepts effectively fostering teamwork and stakeholder engagement.
- Prior experience in healthcare analytics Revenue Cycle Management (RCM) or financial systems is highly advantageous.
- Knowledge of largescale Healthcare Electronic Medical Records (EMRs) systems and their integration into BI frameworks is preferred.
- Relevant certifications in Microsoft BI tools and technologies as well as cloud certifications are a significant plus.
- Proven ability to operate effectively under pressure adapting to the complexities of a dynamic fastpaced environment.
If you are motivated by the opportunity to leverage data to enhance healthcare outcomes and possess the requisite technical skills to excel in this role we encourage you to apply!
gcp,ssis,data,hipaa,power bi,aws,data warehousing,data governance,ssas,data integration,sql,etl,etl processes,ssrs,healthcare,python,dimensional modeling