Design, build, and maintain ETL pipelines and data warehousing for RCM-focused analytics. Perform gap analysis for new business onboarding, optimize ETL performance, monitor production jobs, partner with development on database and analytics projects, and author technical documentation while supporting deployments and change control.
Job Summary
The Business Intelligence (BI) Developer is responsible for the data ingestion, integration, and ETL processes that support MedEvolve's product and data solutions, along with the data warehousing of key subject areas. This role requires strong working knowledge of Revenue Cycle Management (RCM) data and the ability to perform gap analysis for new business onboarding across various practice management systems.
The BI Developer will translate MedEvolve's data goals into well-designed technical processes, continuously optimize existing ETL pipelines, and proactively identify and resolve issues. This person will also regularly report on the health and performance of the data environment, partner with the Development team on database, file, and analytics projects, and monitor and troubleshoot production jobs.
Key Responsibilities
- Design, build, and maintain ETL processes supporting MedEvolve's product and data solutions, including data warehousing of key subject areas.
- Perform gap analysis for new business onboarding across various practice management systems.
- Translate business goals and data requirements into scalable, well-architected technical processes.
- Continuously optimize existing ETL pipelines and proactively identify and resolve data issues.
- Monitor, troubleshoot, and support production jobs to ensure reliability of the data environment.
- Report regularly on the health and performance of the data environment.
- Partner with the Development team on database, file, and analytics-related projects.
- Author and maintain technical documentation for ETL processes and data workflows.
- Support planned production deployments in accordance with change control policies.
Qualifications
Required Qualifications
- Technical experience with ETL processing using Azure Data Factory (ADF), Visual Studio, database design, and data warehousing.
- Experience with Microsoft SQL Server Integration Services (SSIS), including creating and maintaining DTSX packages.
- Strong working knowledge of data warehouse implementation best practices, terminology, and loading mechanisms.
- Strong T-SQL background.
- Experience with revenue cycle (RCM) data and building analytics platforms around it, following business and technical best practices.
- Experience with auditing, data validation, and incremental ETL processes.
- Experience troubleshooting performance issues and applying coding best practices in SSIS, T-SQL, and ADF.
- Ability to write and maintain technical documentation for ETL processes.
- Experience with planned production deployments and adherence to change control policies.
- Strong understanding of the software development life cycle (SDLC).
- Ability to learn quickly, manage multiple projects simultaneously, and meet deadlines while supporting company and departmental goals.
- Highly organized, task-oriented, and able to communicate clearly with both technical and non-technical stakeholders.
- Strong analytical skills with the ability to work independently or as part of a team.
Technical Requirements
- 5+ years of experience with ADF, SSIS, and ETL processes.
- 5+ years of experience with Microsoft SQL Server.
- Experience with Microsoft Visual Studio and source code control systems.
- Strong knowledge of the Microsoft SQL Server BI stack.
- Proficiency with SQL database objects, including stored procedures, functions, triggers, and views.
- Strong T-SQL skills, including knowledge of SQL Dynamic Management Views (DMVs) for performance tuning.
- Working knowledge of the Azure ecosystem.
- Basic proficiency in Python for scripting and light automation tasks.
Preferred Qualifications
- Knowledge of medical billing, analytics solutions, or electronic medical records (EMR).
Education
- Bachelor's degree in Computer Science or a related field, or equivalent professional experience.
Similar Jobs
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Design, implement, and maintain BI solutions and analytics to deliver client insights. Use tools like Oracle BI, QlikView, and Spotfire, analyze complex data sets, build data pipelines, collaborate with stakeholders, manage teams, and uphold professional and technical standards to improve business performance.
Top Skills:
BirtJavaOracle Business IntelligencePythonQlikviewSpotfire
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Develop and implement BI solutions using Oracle BI, QlikView, and Spotfire. Build data pipelines, validate data quality, perform analysis, collaborate with stakeholders, support data architecture, and apply economic analysis to inform client strategies.
Top Skills:
JavaOracle Business IntelligencePythonQlikviewTibco SpotfireTibco Spotfire S+
Healthtech
Analyze hospital pricing transparency files: extract, transform, and prepare complex healthcare data for analysis; create repeatable processes, contribute to Power BI dashboards, compare hospitals, identify trends/outliers, and communicate findings to senior leaders.
Top Skills:
Power BIPythonSQL
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
