Data Engineer

Job Summary

This role will help shape AbsoluteCare’s Data Warehouse and Data Strategy for current and future implementations. The Data Engineer with work in close collaboration with AbsoluteCare Leaders to translate Business asks into IT solutions. This role will work on identifying the right solution for both existing and new requirements by enhancing / converting existing systems or creating newer solutions.

Duties and Responsibilities

• Design and build robust healthcare platform on MS SQL Server.
• Analyze and integrate healthcare payer data and Clinical EHR data.
• Follow best SDLC practices for developing IT solutions.
• Document and communicate strategy used for Design and Development.
• Develop and deliver on key milestones on roadmap for Data Warehouse.
• Automate manual reporting and develop novel reporting using the Microsoft BI stack and other reporting tools.
• Work collaboratively with our MedEcon team, Infrastructure team and Integrated Clinical Team to define, create, document, and implement ad-hoc reports/analytics that support the AbsoluteCare clinical care model and strategy.
• Conduct analyses using tools such as SQL and Microsoft Excel.
• Organize, clarify, and translate business processes into reporting requirements from a diverse set of end users (e.g. executives, clinicians).
• Interpret healthcare data to translate requirements into IT solutions.
• Relate disparate data sets to extract actionable insights.
• Support business needs through the development of ad-hoc and standardized reports as requested by the executive leadership team, as well as internal and external customers.
• Troubleshoot and align the reporting needs of end users to available data sets.
• Limited/occasional travel for onsite team meetings etc.

Minimum Qualifications

• Bachelor’s degree in business, information technology, statistics, mathematics, health sciences, or related field or equivalent work experience required.
• 2+ years of combined working experience on Microsoft stack including SSIS, SSMS, .NET OR C#
• Preferred 1-3 years of developing ASP.NET Core Application
• Preferred 1-3 years of C# Development
• Preferred 3 years of health care data experience
• Preferred 1 year of Python experience
• Intermediate proficiency with Microsoft Excel required.
• Technical knowledge of relational databases (SQL server), querying, data warehouses, and decision support tools required.
• Ability to work independently with limited direction and/or guidance.
• Capable of successfully balancing numerous and competing priorities.
• Excellent written and verbal communication skills with experience collaborating with executives strongly preferred.
• Insatiable curiosity.
• Highly organized with strong documentation skills.
• Passion for data and the act of transforming data to achieve results.
• Ability and willingness to travel occasionally.

Working conditions

This job operates in a professional office environment and/or in a remote capacity.  This role routinely uses general office equipment.

Physical requirements

• Ability to communicate clearly and exchange accurate information constantly.
• Ability to remain stationary for long periods of time.
• Constantly operates computer, keyboard, copy and fax machine, phone, and other general office equipment.

• Ability to occasionally move objects up to 20 lbs.

Direct reports

None.