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

QUALIFICATIONS:

Minimum Qualifications:

• Three years of relevant experience
• Associates of Arts (AA) or Bachelor's degree

-OR-

• An approved equivalent combination of education and experience

Preferred Qualifications:

• Data Warehouse development in a hospital or healthcare environment extracting data
• Experience with Epic Cogito data infrastructure
• Advanced development experience with reporting tools, such as Crystal Reports and Microsoft Visual Studio (specific to SQL Server Integration Services)
• An Advanced level of SQL programming skills (IE. Oracle, Microsoft, or similar syntax)
• An advanced level of data warehouse development experience using the Microsoft BI toolset or similar
• Training or experience specific to data warehousing (i.e. Kimball Dimensional Data Modeling)

Knowledge/ Skills/ Abilities:

• Ability to work through the development process from request, design, implementation, to testing and maintenance with limited guidance
• Developing analytical, quantitative, problem solving, and critical thinking skills to assess reporting and data modeling needs
• Great verbal and written communication skills
• Customer service skills following proper business requirements and managerial expectations
• Growing comfort working in a large, dynamic, and complex technical and operational environment
• Time management skills
• Advanced knowledge of relational and/or star schema database structure, tables, views, and stored procedures
• Knowledge of data quality and validation

You've made the right choice in considering Hennepin Healthcare for your employment. We offer a wealth of opportunities for individuals who want to make an impact in our patients' lives. We are dedicated to providing Equal Employment Opportunities to both current and prospective employees. We are driven to connect talented individuals with life-changing career opportunities, enabling you to provide exceptional care without exception. Thank you for considering Hennepin Healthcare as a future employer.

Please Note: Offers of employment from Hennepin Healthcare are conditional and contingent upon successful clearance of all background checks and pre-employment requirements.

• We offer a competitive pay rate based on your skills, licensure/certifications, education, experience related to this position, and internal equity.
• We provide an extensive benefits program that includes Medical; Dental; Vision; Life, Short and Long-term Term Disability Insurance; Retirement Funds; Paid Time Off; Tuition reimbursement; and license and Certification reimbursement (Available ONLY for benefit eligible positions).
• For a complete list of our benefits, please visit our career site on why you should work for us.