Talent.com
Azure Data Engineer - Kansas City, MO

Azure Data Engineer - Kansas City, MO

LEVERAGEncy, LLC (dba Amplified Sourcing)Grandview, MO, US
job_description.job_card.variable_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
  • serp_jobs.job_card.permanent
job_description.job_card.job_description

Job Description

Job Description

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 .

    Job Posted by ApplicantPro

    serp_jobs.job_alerts.create_a_job

    Azure Data Engineer • Grandview, MO, US