DataJobs.io
← Back to all jobs

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

Similar Jobs