Data Engineer
Job Description
Build and support enterprise data pipelines, models, and reporting systems in a hybrid role supporting CJE’s data platform.
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 designs and standards set by the Senior Systems Developer.
- After handover from the implementation partner, support day-to-day Microsoft Fabric operations (data warehouse and data lake), including:
- Monitoring pipeline runs and data refreshes
- Resolving routine platform issues
- Escalating platform problems under the direction of the Senior Systems Developer
- Develop and maintain data models for reporting, analytics, and downstream application needs, with design review by the Senior Systems Developer.
- Implement and monitor data quality checks and flag 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 use, supporting accuracy, freshness, and governance.
- Build and maintain dashboards and scheduled reports for business stakeholders.
- Document data models, pipeline logic, and data lineage to support stewardship and troubleshooting.
- Coordinate 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 pipelines, models, and reports.
- Research data integration, transformation, and reporting tools and contribute findings to recommendations from 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.
Requirements
- SQL and relational databases: working knowledge required.
- Education: 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 Arrangement
- Hybrid: 2 days on site
- Hybrid role includes in-person work and remote work options; remote work is subject to agency policy, operational needs, and satisfactory job performance.
Location
- Horwich, 3003 W. Touhy Ave., Chicago, IL 60645
- Chicago, IL (hybrid)
Travel
- Occasional travel amongst local company locations
Compensation
- USD 50,000 - 50,000 per yearly
Union Status
- Not eligible for membership