Data Engineer Intermediate

Hennepin Healthcare; Minneapolis (MN); Remote; USD 80,000 - 110,000; Full time

Job summary

Hennepin Healthcare is seeking a Data Engineer Intermediate who will engage in data transformations to meet organizational needs. This role requires collaboration in a remote setting with occasional on-site visits. Candidates should have experience in data warehousing and SQL programming, and a passion for enhancing healthcare outcomes.

Benefits

Medical, Dental, Vision insurance

Short and Long-term Disability Insurance

Retirement Funds

Paid Time Off

Tuition reimbursement

License and Certification reimbursement

Qualifications

• Three years of relevant experience.
• Strong SQL skills and data warehousing experience.
• Ability to develop data structures and optimize processes.

Responsibilities

• Gather business requirements to meet requesters' needs.
• Support and optimize advanced data structures.
• Develop reports and data extracts for business customers.

Skills

Data transformation

SQL Programming

Data warehousing

Analytical skills

Problem solving

Customer service skills

Documentation

Data quality assurance

Education

Associates of Arts (AA) or Bachelor’s degree

Tools

SSIS

Microsoft BI toolset

Crystal Reports

Microsoft Visual Studio

Job description

Job Description

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 aData 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 fulfillthe 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 futuresupportability
• Collaboration with requestors on an advised tool set for the solution, as well as data quality andvalidation 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 hittingproject 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 environmentextracting data
• Experience with Epic Cogito data infrastructure
• Advanced development experience with reporting tools, such as CrystalReports and Microsoft Visual Studio (specific to SQL Server IntegrationServices)
• An Advanced level of SQL programming skills (IE. Oracle, Microsoft, orsimilar syntax)
• An advanced level of data warehouse development experience using theMicrosoft BI toolset or similar
• Training or experience specific to data warehousing (i.e. KimballDimensional 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 thinkingskills to assess reporting and data modeling needs
• Great verbal and written communication skills
• Customer service skills following proper business requirements andmanagerial expectations
• Growing comfort working in a large, dynamic, and complex technical andoperational environment
• 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.

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.

Department : Analytics

Primary Location

Primary Location

: MN-Minneapolis-Downtown Campus

Standard Hours/FTE Status : FTE = 1.00 (80 hours per pay period)