Data Engineer Associate
Analytics
Business Analytics
Business Intelligence
Data
Data Analysis
Data Analytics
Data Analytics Tools
Data Architecture
Data Engineer
Data Integration
Data Pipeline
Data Platform
Data Processing
Data Visualization
Data Warehouse
Database
Databases
Digital Marketing
ETL
Hr Technology
Informatica
Information Technology (IT)
Integration
Microsoft
Microsoft Office
Power BI
Power Platform
Reporting and Analytics
SQL
Visual Design
Job Description
Build data warehouse and analytics solutions that support data consumption across the health system in Chicago.
Responsibilities
- Deliver data warehouse and analytics solutions by ingesting, integrating, and curating data, administering systems, and publishing information for the health system
- Use relational database skills, including SQL, to create queries and stored procedures
- Collaborate with the Architecture team on the design and execution of solutions
- Ensure new and existing data models and databases align with approved data architecture standards
- Create, document, and communicate the integration approach for solution components
- Define key solutions and ensure they are managed for user and cross-team consumption
- Research and analyze business needs and product/service strategies to determine capabilities and propose solution alternatives
- Assist with ETL design and development, including data analysis, source-to-target mapping, quality profiling, change data capture, and code performance
- Evaluate data quality and interpret results clearly and concisely
- Document all programming changes, design updates, system modifications, and associated maintenance
Requirements
- 0 – 3+ years of experience querying, analyzing data, and/or data modeling/architecture
- 0 – 3+ years developing and maintaining ETL / data pipelines (examples: Microsoft SSIS, Azure Data Factory)
- Experience using SQL for data extraction, manipulation, and reporting
- Relational database knowledge, including the ability to create queries and stored procedures
- Experience with reporting and data visualization tools: Microsoft Power BI, Tableau, Crystal Reports, SSRS, etc.
- 0 – 1 yrs advanced proficiency in Python, with demonstrated work experience building data solutions using Python
- Bachelor’s degree or equivalent experience in a relevant field
Technology
- SQL
- Microsoft SSIS
- Azure Data Factory
- Python
- Microsoft Power BI
- Tableau
- Crystal Reports
- SSRS
Compensation and Location
- Location: Chicago, IL (onsite)
- Salary: USD 40 - 56 per hourly
- Minimum experience: 3 years
Benefits
- 401(k) matching
- Tuition reimbursement
- Loan forgiveness
- Lifecycle benefits
Artificial Intelligence Disclosure
Artificial Intelligence (AI) tools may be used in some portions of the candidate review process for this position; however, all employment decisions will be made by a person.
Background Check
- Northwestern Medicine conducts a background check that includes criminal history on newly hired team members and, at times, internal transfers
- Results are evaluated on a case-by-case basis, following local, state, and federal laws including the Illinois Health Care Worker Background Check Act
Similar Jobs
S
