Data Engineer
Job Description
Data Engineer role in Chicago, IL focused on building data pipelines and models, supporting Microsoft Fabric, and maintaining data quality and governance.
Responsibilities
- Build and maintain data pipelines that move data from business applications (EMR, payroll/HR, Salesforce, and other line-of-business systems) into CJE’s data lake and enterprise data warehouse, aligned to standards and designs set by the Senior Systems Developer.
- Support day-to-day operations of Microsoft Fabric for the data platform after handover from the implementation partner, including monitoring pipeline runs and data refreshes, resolving routine issues, and escalating platform problems under the Senior Systems Developer’s direction.
- Develop and maintain data models for reporting, analytics, and downstream application requirements, with design review by the Senior Systems Developer.
- Implement and monitor data quality checks; flag data quality issues to data stewards and application owners for resolution.
- Support the grounding and evaluation of AI tools by preparing and validating the data sources used, helping ensure sources are accurate, current, and well-governed.
- Build and maintain dashboards and scheduled reports for business stakeholders.
- Document data models, pipeline logic, and data lineage to support stewardship and troubleshooting.
- Work with the Senior Systems Developer and Systems Developer to ensure application changes are reflected correctly in downstream data and reporting.
- Follow data governance, privacy, and HIPAA requirements when handling data pipelines, models, and reports.
- Research data integration, transformation, and reporting tools; contribute findings to recommendations made by the Senior Systems Developer and Applications & Data Lead.
- Troubleshoot pipeline and reporting issues; escalate complex problems to the Senior Systems Developer.
- Participate in code review, incorporate feedback, and grow skills through mentoring and training.
Requirements
- SQL and relational database knowledge.
- Bachelor’s degree in computer science, information systems, data analytics, or a related field (preferred).
Technologies
- SQL
- Microsoft Fabric
- Power BI
- OneLake
- Lakehouse architecture
- HIPAA
- EMR
- Salesforce
Benefits
- Medical, dental, and vision insurance
- Competitive pay
- Paid vacation and sick time
- Employer-provided life insurance, with optional spouse and dependent coverage
- Short-term and long-term disability insurance
- Retirement plan
- Employee assistance program
- Employee purchase and health club discounts
- Ongoing training and professional development
Schedule
- Monday to Friday, 8:30 am to 5:00 pm
Work Location and Arrangement
- Location: Horwich, 3003 W. Touhy Ave., Chicago, IL 60645
- Hybrid: 2 days on site
- Hybrid work includes in-person and remote work options; remote work is subject to agency policy, operational needs, and satisfactory job performance.
Travel
- Occasional travel amongst local company locations
Compensation
- USD 50,000 - 50,000 per year
Union Status
- Not eligible for membership