Data Engineer Associate, Full-time, Days

Benefits

• $10,000 Tuition Reimbursement per year ($5,700 part-time)
• $10,000 Student Loan Repayment ($5,000 part-time)
• $1,000 Professional Development per year ($500 part-time)
• $250 Wellbeing Fund per year($125 for part-time)
• Matching 401(k)
• Excellent medical, dental and vision coverage
• Life insurance
• Annual Employee Salary Increase and Incentive Bonus
• Paid time off and Holiday pay

Northwestern Medicine is powered by a community of colleagues who are purpose-driven and committed to our mission to deliver world-class care. Here, you'll work alongside some of the best clinical talent in the nation leading the way in medical innovation and breakthrough research with Northwestern University Feinberg School of Medicine.

We recognize where you've been, and we support where you're headed. We celebrate diverse perspectives and experiences, which fuel our commitment to equity and culture of service.

Grow your career with comprehensive training and development opportunities, mentorship programs, educational support and student loan repayment.

• Create the life you envision for yourself with flexible work options, a Reimbursable Well-Being Fund and a Total Rewards package that support your physical, mental, emotional and financial well-being.
• Make a difference through volunteer opportunities we offer in local communities and drive inclusive change through our workforce-led resource groups.

From discovery to delivery, come help us shape the future of medicine.

Description

The Data Engineer Associate, reflects the mission, vision, and values of NM, adheres to the organization’s Code of Ethics and Corporate Compliance Program, and complies with all relevant policies, procedures, guidelines and all other regulatory and accreditation standards.

Northwestern Medicine Information Services drives innovative, high-value solutions to transform health care.

We are committed to supporting the relentless pursuit of better medicine by providing exceptional service to our patients and guests as well as internal clients across the organization. To ensure excellence, our team goes to extraordinary lengths to ensure that our systems work together seamlessly.

Northwestern Medicine understands that technology plays an integral role in shaping the future of health care. Information Services strategically supports the organization by:

• Leveraging AI, automation and rollout of advanced cyber controls that support digital transformation strategies
• Implementing advanced technologies in clinical and administrative areas
• Furthering development of the end user support model to help enhance modern infrastructure

Responsibilities:

• The Data Engineer Associate is responsible for delivering data warehouse and analytic solutions by ingesting, integrating, and curating data, building analytical solutions, and administering systems to deliver information to the health system.
• Applies knowledge of relational database skills including SQL knowledge and ability to create queries and stored procedures.
• Collaborates with the Architecture team in the design and execution of solutions.
• Ensures that new and existing data models and databases are consistent with approved data architecture standards.
• Create, document, and communicate the integration approach of all the components of the solution.
• Define key solutions and ensure they are managed for consumption by users and across teams.
• Research, analyze, determine capabilities and propose solution alternatives to address specific business needs and product/service strategies.
• Assists with ETL design and development including data analysis, source-target mapping, quality profiling, change data capture, code performance.
• Evaluate data quality and interpret results in a clear, concise manner.
• Document all programming changes and design, system modifications and their associated maintenance.

Qualifications

Required:

• 0 – 3+ years of experience in a role querying, analyzing data, and/or data modeling/architecture.
• 0 – 3+ years of experience with developing and maintaining ETL / data pipeline (e.g., Microsoft SSIS, Azure Data Factory).
• Experience using SQL for data extraction, manipulation, and reporting.
• Knowledge of relational database skills including SQL knowledge and the ability to create queries and stored procedures.
• Experience with report writing and data visualization tools such as: Microsoft Power BI, Tableau, Crystal Reports, SSRS, etc.

Preferred:

• Bachelor’s degree or equivalent experience in relevant field.

Equal Opportunity

Northwestern Medicine is an affirmative action/equal opportunity employer and does not discriminate in hiring or employment on the basis of age, sex, race, color, religion, national origin, gender identity, veteran status, disability, sexual orientation or any other protected status.

If we offer you a job, we will perform a background check that includes a review of any criminal convictions. A conviction does not disqualify you from employment at Northwestern Medicine. We consider this on a case-by-case basis and follow all state and federal guidelines.