Posted on
Job Summary:
We are seeking a highly skilled Data Engineer with extensive experience in data profiling, data validation, ETL processes using SSIS, SQL, and Business Intelligence (BI) tools. The ideal candidate will have a strong background in the healthcare industry, with a deep understanding of healthcare data standards, compliance, and best practices. This role is critical in ensuring the integrity, availability, and accuracy of our data systems, contributing to data-driven decision-making across the organization.
Key Responsibilities:
Conduct comprehensive data profiling to understand data quality, structure, and content.
Implement data validation processes to ensure accuracy, consistency, and completeness of data.
Identify data anomalies and discrepancies, and work with relevant stakeholders to resolve issues.
Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS) to extract, transform, and load data from various sources.
Optimize ETL workflows for performance, scalability, and reliability.
Monitor ETL jobs, troubleshoot issues, and implement enhancements as needed.
Develop, optimize, and maintain SQL databases to support data warehousing and reporting needs.
Ensure data integrity, security, and compliance with healthcare data standards (e.g., HIPAA).
Perform regular database performance tuning and maintenance.
Develop and maintain BI solutions to support data analysis and reporting requirements.
Collaborate with business users to understand reporting needs and deliver actionable insights.
Qualifications:
Minimum of 2-4 years of experience as a Data Engineer, Data Analyst, or in a similar role within the healthcare industry.
Proficient in SQL, including complex queries, stored procedures, and performance tuning.
Extensive experience with ETL tools, particularly SQL Server Integration Services (SSIS).
Strong understanding of data profiling and validation techniques.
Experience with BI tools such as Power BI, Tableau, or similar.
Knowledge of healthcare data standards and regulations (e.g., HIPAA, HL7).
Excellent problem-solving skills and attention to detail.
Strong communication and collaboration skills.