Data Engineer - Analytics, Full time, Days
Chicago, IL, United States
Applications have closed
Northwestern Memorial Healthcare
Northwestern Medicine is a leader in quality healthcare and service, bringing together faculty, physicians and researchers to support and advance that care through leading-edge treatments and breakthrough discoveries.Company Description
At Northwestern Medicine, every patient interaction makes a difference in cultivating a positive workplace. This patient-first approach is what sets us apart as a leader in the healthcare industry. As an integral part of our team, you'll have the opportunity to join our quest for better healthcare, no matter where you work within the Northwestern Medicine system. At Northwestern Medicine, we pride ourselves on providing competitive benefits: from tuition reimbursement and loan forgiveness to 401(k) matching and lifecycle benefits, we take care of our employees. Ready to join our quest for better?
Job Description
The Data Engineer 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.
Working in Analytics at Northwestern Medicine, we help our clinical and administrative leadership through the development of thoughtful, highly engaging analytics products that will impact the clinical and financial areas of our health system. We do this by engaging with our customers to understand opportunities for improvement and then applying the right analytic solution to drive that improvement. Our health system looks to us to be thought-leaders in Analytics, which requires us to be analytical problem solvers by nature. We also strive to develop a deep understanding and empathy for our internal customers and communicate the value and purpose to stakeholders. Through tenacity and resilience, we will strive through ambiguity, drive impactful projects, and overcome challenges.
Northwestern Medicine is looking for a data driven, business-minded, results-oriented Data Engineer to join our team. The Data Engineer uncovers insights that drive strategy and optimal decision making for the executive team and leaders across the organization. In this role, you will be charged with understanding the ‘who, what, and whys’ of our business - working cross-functionally to realize the value of NM’s data assets.
Responsibilities:
- The Data Engineer 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.
- Serves as a functional and content expert of the data warehouse to synthesize raw data into actionable information to be used in analytical solutions.
- Applies knowledge of relational database skills including advanced SQL knowledge and the ability to create complex 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.
- Provide facilitation, analysis, design, and execution of architecture solutions and ensure solutions are leveraged. 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.
- Maintain knowledge of current trends and development in the field. Actively explores emerging technologies.
- Independently work with business users to gather and scope requirements and recommend analytical solutions to meet business needs.
- 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.
- Own analytics projects and be accountable for collaborating with the business to gather requirements, execute to provide analytical solutions, which exceed customer expectations.
- Work collaboratively with and support multi-departments efforts and projects.
- Mentor staff by sharing skills, experience, knowledge, and expertise on analytic tools and solutions.
- Serve as subject matter expert within the department.
- Provide training and support through the organization on the use of analytics tools.
- Performs other duties and functions as assigned.
Qualifications
Required:
- Bachelor’s degree or equivalent experience in relevant field
- Five or more years of experience in a role querying, analyzing data, and/or data modeling/architecture
- Experience working with a variety of data warehousing models and design fundamentals (e.g. Inmom Kimball)
- Experience with developing and maintaining ETL / data pipeline (e.g. Microsoft SSIS, Azure Data Factory)
- Experience with OLAP or Tabular cube software
- Experience using SQL for data extraction, manipulation, and reporting
- Previous experience working in an Agile environment
- Strong knowledge of relational database skills including advanced SQL knowledge and the ability to create complex queries and stored procedures
- Experience with report writing and data visualization tools such as: Microsoft Power BI, Tableau, Crystal Reports, SSRS, etc.
Preferred:
- Experience developing, designing and supporting applications and relational databases
- Experience using a software package for statistical analysis (R, Python, etc)
- Previous experience working with Epic Clarity data
- Previous healthcare experience, ideally with a health system
Additional Information
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.
Tags: Agile Architecture Azure Data analysis Data quality Data visualization Data warehouse Data Warehousing ETL OLAP Power BI Python R RDBMS Research SQL SSIS Statistics Tableau
Perks/benefits: Health care
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Marketing Data Analyst jobs
- Open MLOps Engineer jobs
- Open AI Engineer jobs
- Open Junior Data Scientist jobs
- Open Data Engineer II jobs
- Open Senior Data Architect jobs
- Open Sr Data Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Analytics Engineer jobs
- Open Power BI Developer jobs
- Open Manager, Data Engineering jobs
- Open Product Data Analyst jobs
- Open Principal Data Engineer jobs
- Open Business Data Analyst jobs
- Open Data Quality Analyst jobs
- Open Data Manager jobs
- Open Sr. Data Scientist jobs
- Open Data Scientist II jobs
- Open Big Data Engineer jobs
- Open Business Intelligence Developer jobs
- Open Data Analyst Intern jobs
- Open Principal Data Scientist jobs
- Open ETL Developer jobs
- Open Azure Data Engineer jobs
- Open Data Product Manager jobs
- Open Business Intelligence-related jobs
- Open Data quality-related jobs
- Open Privacy-related jobs
- Open Data management-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open Deep Learning-related jobs
- Open APIs-related jobs
- Open PyTorch-related jobs
- Open PhD-related jobs
- Open TensorFlow-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open NLP-related jobs
- Open Data governance-related jobs
- Open Data warehouse-related jobs
- Open Databricks-related jobs
- Open Airflow-related jobs
- Open Hadoop-related jobs
- Open LLMs-related jobs
- Open DevOps-related jobs
- Open CI/CD-related jobs