Azure Data Engineer - Kansas City, MO

Amplified Sourcing • Full-time • Remote (Kansas City, Missouri, United States) • $90k - $120k / year • 12h ago

OVERVIEW:

ROLE: Azure Data Engineer
ROLE TYPE: Direct Hire
COMPENSATION: The end client has indicated a budget of approximately $120,000 for a base salary, depending on experience (potentially higher, but requiring sign-off from the executive team).
WORK LOCATION: This position is 100% remote, assuming the candidate is a resident (or relocates) to Missouri. Occasional travel to HQ in Missouri may be required for internal meetings, but travel costs will be covered for such meetings.
WORK AUTHORIZATION: The client prefers candidates with work authorizations like: U.S. Citizen, Permanent Residents (Green Card holders), or Visas not based on employer sponsorship (such as visas sponsored by a spouse or relative). Candidates who require H1B Transfer sponsorship may still be considered if they are an exceptional fit.
NUMBER OF POSITIONS: One.
START: ASAP.
JOB ID: CH- 250514

CURRENT SITUATION:

The client's current data environment is primarily based on SQL Server and largely on-prem. Their existing data warehouse integrates data from multiple EHRs and internal systems into a centralized SQL Server environment; however, it is not cloud-native and only supports data up to the previous day, which limits real-time reporting capabilities. Much of the warehouse was built in a report-specific, ad hoc manner, leading to inconsistent structures, limited reuse, and inefficient joins. There is no established star schema, operational data store (ODS), or layered architecture to support scalability or best practices in business intelligence (BI).

This role will work with a team of three to:
- Audit and rationalize 700+ legacy reports
- Build baseline executive and operational dashboards
- Introduce automation and standard templates to reduce manual report requests (currently over 200/month)
- Lay the foundation for scalable BI infrastructure and cloud migration (e.g., Snowflake, AWS)
- Transition ownership of reporting from a reactive, SQL-only team to a forward-looking, engineering-capable group
In addition, this new team will:
- Handle all day-to-day report generation, visualization development, and data request triage
- Drive continuous improvement in data quality, performance, and consistency
- Collaborate with leadership and data warehouse/architecture counterparts to evolve the company's BI and analytics maturity

Ultimately, this phased approach ensures the new Data Operations team has both the context and capacity to modernize the reporting function sustainably and strategically.

KEY SKILLS:

SQL Server/T-SQL - foundational to the current data warehouse and essential for report development
Data Visualization/Dashboards - Power BI is the primary tool for data visualization and dashboard creation; strong design and publishing experience expected. Tableau would also be considered.
ETL Development - especially experience building and optimizing ETL pipelines (preferably using Databricks)
Databricks - required for data processing and reporting pipeline development; expected to support future modernization
Azure Data Stack - current environment includes Azure-based elements; familiarity is important as future direction may expand on Azure
Programming Languages:
Python, C#, R - scripting, automation, or integration experience using these languages is highly valued
DAX, Power Query (M) - for developing efficient Power BI reports and data transformations
Scalability - Exposure to large data set processing (scalable data solutions, etc.)
Stakeholder Liaison - History working with business stakeholders to define BI/DW solutions

NICE TO HAVE REQUIREMENTS:

Architectural Exposure to Data Modeling & Warehousing Concepts - especially familiarity with performance optimization, schema design, and data integration strategies
Business Acumen - ability to gather, interpret, and translate business needs into effective data solutions
Unit Testing & Version Control - History of defining and working within disciplined development practices and CI/CD pipelines.
EHR Data Experience - familiarity with data from healthcare systems (e.g., NextGen, myAvatar) is a plus, but not required
Mentoring/Training End Users - New report usage, dashboards, and other tools.
Healthcare Domain - Clinics, Hospitals, Behavioral Health

NOTABLE BENEFITS:

This position includes a full-time benefits package that is on par with standard offerings, including health insurance, paid time off, and related support. Additional details will be provided during the interview process. Medical, Dental, Vision, Life insurance, AD&D, Disability, FSA (healthcare/childcare), HSA, 401k

HOW TO APPLY:

If you are a motivated and organized individual passionate about Information Technology, we would love to hear from you. To apply, please answer our applicant questions and submit your resume detailing your qualifications and relevant experience. We look forward to hearing from you!

All Amplified Sourcing clients (including Amplified) are equal employers. They will consider all applicants without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.