RIT Solutions, Inc. ยท 3 months ago
Data Engineer (ETL Developer)
RIT Solutions, Inc. is seeking a skilled Data Engineer (ETL Developer) to modernize and optimize their data pipelines. The role involves designing, building, and maintaining scalable ETL pipelines to support analytics and reporting needs, leveraging Azure Data Factory, SQL Server Integration Services, and various BI platforms.
Staffing & Recruiting
Responsibilities
Design, develop, and maintain modernized ETL pipelines using Azure Data Factory, Fabric, Databricks and/or SSIS to integrate multiple data sources into the enterprise data warehouse
Collaborate with analysts, data scientists, and business stakeholders to deliver clean, reliable, and well-structured data
Optimize and refine existing ETL processes to improve performance, scalability, and maintainability
Develop and maintain and/or convert SQL stored procedures, views, functions, and scripts for analytics and reporting
Implement data quality checks, error handling, and monitoring to ensure accurate and consistent data flows
Utilize a code repository (Git or similar) to manage, version, and document ETL code
Support integration of healthcare data sources, including claims, eligibility, provider rosters, and quality/risk adjustment data
Partner with business teams to enable HEDIS measure calculation, quality reporting, and risk adjustment analytics
Collaborate with the BI team to deliver data models and datasets for dashboards in Power BI and Domo
Ensure adherence to data governance, compliance, and security best practices (HIPAA, PHI/PII handling)
Troubleshoot data issues, perform root cause analysis, and implement preventive measures
Qualification
Required
Bachelor's degree in Computer Science, Information Systems, or a related field; or equivalent experience
5+ years of professional experience in ETL development and SQL-based data warehouse engineering
Strong expertise with SQL Server Integration Services (SSIS), and T-SQL
Proven experience integrating and transforming healthcare payer data (claims, eligibility, encounters)
Proficiency with Git or other version control systems for code management
Experience supporting data visualization/reporting in Power BI and Domo
Strong understanding of data modeling, normalization, indexing, and query optimization
Strong problem-solving skills and ability to communicate technical concepts to non-technical stakeholders
Familiarity with HIPAA compliance, data privacy, and PHI/PII handling
Preferred
Experience with Azure Data Factory or Fabric (or similar), other Azure services (Azure SQL Database, Data Lake, Synapse)
Working knowledge of NCQA HEDIS quality measures and related data sets
Experience with Medicare Risk Adjustment (HCC coding, RAF scores) data structures and reporting
Background in healthcare analytics, value-based care, or health plan operations
Familiarity with APIs, scripting (Python/PowerShell), and automation for data pipeline orchestration
Company
RIT Solutions, Inc.
Jobdiva Job Portal: https://www1.jobdiva.com/candidates/myjobs/searchjobsdone.jsp?a=xbjdnwgjodtga1y1im2g881fkkeiwd0775lbvq8yqgps8vb2q36w2vj1ga6xxork&compid=-1 Recruitment (contingency search and campus selection).
H1B Sponsorship
RIT Solutions, Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2023 (2)
Funding
Current Stage
Growth StageCompany data provided by crunchbase