CJE SeniorLife is seeking a Data Engineer based in Chicago, IL, to help build and operate data pipelines and data models that support reporting, analytics, and downstream applications. The role includes day-to-day support of Microsoft Fabric and a focus on data quality, governance, and documentation.
Role Overview
This position supports the organization’s data platform by integrating data from business systems into the enterprise data warehouse and data lake, maintaining Microsoft Fabric operations after handover from the implementation partner, and ensuring reliable data for business reporting and downstream use cases.
Responsibilities
- Build and maintain data pipelines that integrate data from business applications, including EMR, payroll/HR, Salesforce, and other line-of-business systems, into CJE’s data lake and enterprise data warehouse, aligned with designs and standards set by the Senior Systems Developer.
- Support day-to-day operation of the Microsoft Fabric data platform, including the data warehouse and data lake, after handover from the implementation partner. Monitor pipeline runs and data refreshes, resolve routine issues, and escalate platform problems under the direction of the Senior Systems Developer.
- Develop and maintain data models that support reporting, analytics, and downstream application needs, 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.
- Assist with grounding and evaluation of AI tools by preparing and validating the data sources they draw on, supporting accurate, current, and well-governed data.
- Build and maintain dashboards and scheduled reports used by business stakeholders.
- Document data models, pipeline logic, and data lineage to support stewardship and troubleshooting.
- Partner with the Senior Systems Developer and Systems Developer to ensure application changes are reflected accurately 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 and contribute findings to recommendations made by the Senior Systems Developer and Applications & Data Lead.
- Troubleshoot pipeline and reporting issues, escalating complex problems to the Senior Systems Developer.
- Participate in code review, incorporate feedback, and build technical skills through mentoring and training.
Required Qualifications
- Working knowledge of SQL and relational databases is required.
Technology Stack
- SQL
- Microsoft Fabric
- Power BI
- OneLake
- Lakehouse architecture
- HIPAA
- EMR
- Salesforce
Education
A Bachelor’s degree in computer science, information systems, data analytics, or a related field is preferred.
Schedule
Monday to Friday, 8:30 am to 5:00 pm.
Location and Work Arrangement
The role is located at Horwich, 3003 W. Touhy Ave., Chicago, IL 60645.
- Hybrid with 2 days on site.
- Hybrid work is offered for flexibility, and remote work options are subject to agency policy, operational needs, and satisfactory job performance.
Travel
Occasional travel amongst local company locations.
Compensation
USD 50,000 - 50,000 per yearly.
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
Union Status
Not eligible for membership.