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 Austin Tech Scene
Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center
