Data Engineer Intermediate

Hennepin Healthcare is an integrated system of care that includes HCMC, a nationally recognized Level I Adult Trauma Center and Level I Pediatric Trauma Center and acute care hospital, as well as a clinic system with primary care clinics located in Minneapolis and across Hennepin County. The comprehensive healthcare system includes a 473-bed academic medical center, a large outpatient Clinic & Specialty Center, and a network of clinics in the North Loop, Whittier, and East Lake Street neighborhoods of Minneapolis, and in the suburban communities of Brooklyn Park, Golden Valley, Richfield, and St. Anthony Village. Hennepin Healthcare has a large psychiatric program, home care, and operates a research institute, philanthropic foundation, and Hennepin EMS. The system is operated by Hennepin Healthcare System, Inc., a subsidiary corporation of Hennepin County.  

Equal Employment Opportunities: We believe equity is essential for optimal health outcomes and are committed to achieve optimal health for all by actively eliminating barriers due to racism, poverty, gender identity, and other determinants of health. We are committed to equitable care and working in an environment that celebrates, promotes, and protects diversity, equity, inclusion, and belonging. We are committed to bringing in individuals with new cultural perspectives to assist in creating a more equitable healthcare organization.

SUMMARY:

We are currently seeking a Data Engineer Intermediate to join our team. This full time role will work days. The position is remote, however the ability to come on campus periodically is desired.

Purpose of this position: Under general supervision, the Data Engineer Intermediate role performs transformations of data to fulfill the needs of the organization. They will combine data from multiple source systems to produce the
solution required. They will develop, optimize, and support architecture to enable the full lifecycle of
business intelligence development for teams within the organization. Their solutions are expected to be
optimized to support the health of the data environment. They are expected to select the appropriate tool,
depending on the expected result of the solution.

RESPONSIBILITIES:

• Gather business requirements to ensure the needs are met of the requestor
• Follow and inform query standards and practices
• Develop, support, and optimize advanced data structures, including cubes, data marts, SSIS packages, and data warehouse objects
• Develop reporting and data extracts for use by business customers
• Develop data extracts that follow business user expectations
• Utilize enterprise reporting and data manipulation tools including, but not limited to SSIS
• Design, develop, and maintain SQL Code, with considerations to optimization and future supportability
• Collaboration with requestors on an advised tool set for the solution, as well as data quality and validation to ensure accurate results
• Follow and maintain documentation of internal and delivered solutions
• Receive, analyze, and resolve incidents from the service desk
• Create knowledgebase articles for recurring incidents
• Exhibit responsibility and accountability towards quality completion of projects and consistently hitting project timelines
• Provide higher level support within the team and to related teams for resolving issues
• Monitor data quality and validation metrics in data environments
• Perform other duties as assigned