IT Data Engineer III

Paradigm; Lombard (IL); On-site; USD 110,000 - 140,000; Full time

Benefits offered by this job

Health insurance

401(k) matching

Paid time off

Flexible spending accounts

LEAP learning program

Volunteer time

Job summary

Paradigm is seeking a remote Data Engineer III to design, build, and maintain robust data pipelines and architectures. You will enable data-driven decision making for analysts and data scientists, focusing on data integration, modeling, and modern tooling like Power BI and Microsoft Fabric.

The ideal candidate has 5+ years in data engineering, strong SQL across SQL Server/DB2/Oracle, and experience with ETL/ELT platforms.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• 5+ years of data engineering experience.
• Strong SQL knowledge with SQL Server/DB2/Oracle.
• Experience with ETL/ELT tools such as SSIS, Azure Data Factory.
• Familiarity with Power BI, Microsoft Fabric.

Responsibilities

• Design, build, and optimize data architectures, data lakes, and warehouses.
• Develop and maintain ETL/ELT pipelines (Azure Data Factory, SSIS).
• Collaborate with analytics, BI, and application teams to define data requirements.
• Document data models, pipelines, and governance processes; maintain data dictionary.
• Enforce data governance, security controls, and compliance with regulations.
• Lead change management using Azure DevOps or similar tools.
• Evaluate new data technologies (Microsoft Fabric, Power BI) and adopt where beneficial.
• Support ad hoc data requests and production monitoring across environments.
• Promote data-driven culture and broader Power BI adoption.

Skills

Power BI

Microsoft Fabric

ETL/ELT

SQL

Data modeling

Data pipelines

Azure

Python

DevOps

Education

Bachelor's degree in CS/IS

Tools

SSIS

Azure Data Factory

Power BI (Tool)

Microsoft Fabric

SQL Server Management Studio

Git

DB2

Oracle

Job description

Req Number: Req #1960

Paradigm is an accountable specialty care management organization focused on improving the lives of people with complex injuries and diagnoses. The company has been a pioneer in value-based care since 1991 and has an exceptional track record of generating the very best outcomes for patients, payers, and providers. Deep clinical expertise is the foundation for every part of Paradigm's business: risk-based clinical solutions, case management, specialty networks, home health, shared decision support, and payment integrity programs.

We're proud to be recognized—again! For the fourth year in a row, we've been certified by Great Place to Work®, and for the third consecutive year, we've earned a spot on Fortune's Best Workplaces in Health Care™ list. These honors reflect our unwavering commitment to fostering a positive, inclusive, and employee-centric culture where people thrive.

Watch this short video for a brief introduction to Paradigm.

We are seeking a full-time, remote Data Engineer III position. This role supports the continued proliferation of data-driven decision-making throughout Paradigm by designing, building, and maintaining robust data pipelines and architectures. The Data Engineer ensures that clean, reliable, and well-structured data is readily available to analysts, data scientists, and other key stakeholders for advanced analytics, reporting, and operational needs. The ideal candidate has a strong technical background in data integration, data modeling, and modern data engineering tools — specifically Microsoft Power BI, Microsoft Fabric, and a variety of ETL/ELT platforms — along with demonstrated experience working independently to prioritize data projects. Familiarity with healthcare and/or workers' compensation terminology and business concepts is a plus.

*This position may require the final round of interviewing to be an in person interview*

RESPONSIBILITIES:

1. Design and Maintenance of Data Architectures
   • Architect, build, and optimize Paradigm's data pipelines, data lake, and data warehouse environments, ensuring efficient ingestion of data from SQL Server, and other sources.
   • Incorporate modern data platform technologies such as Microsoft Fabric where appropriate, to enhance scalability and performance.
2. Develop and Optimize Data Pipelines
   • Develop and maintain efficient ETL/ELT processes using tools like Azure Data Factory, SSIS, or equivalent platforms.
   • Leverage robust integration tools to automate data flows and ensure data quality.
   • Monitor and optimize these pipelines for performance, scalability, and reliability.
3. Collaborate with Cross-Functional Teams
   • Work independently with departmental leaders, business users, and analytics teams to define data requirements and prioritize projects with the highest ROI.
   • Partner closely with database administrators, BI developers, data scientists, and application teams to ensure data availability and alignment with business goals.
   • Support and collaborate on Power BI initiatives, enabling self-service analytics.
4. Data Governance and Documentation
   • Develop and maintain comprehensive documentation for data pipelines, data models, and data governance processes.
   • Produce and update a data dictionary to facilitate the use of self-service analytics tools by non-technical business users.
5. Implement Data Quality and Security Controls
   • Enforce data governance, security policies, and access controls to ensure data confidentiality, integrity, and compliance with regulatory requirements.
   • Configure and maintain role-based and object-level security for data pipelines, warehouses, and analytics tools.
6. Change Management and Best Practices
   • Document and refine data engineering change management policies, aligning with industry best practices to maintain stable, secure, and version-controlled environments (e.g., using Azure DevOps, AWS Pipelines, or similar tools).
7. Evaluate and Implement New Technologies
   • Research and recommend new data engineering tools, frameworks, and solutions, with a particular focus on the Microsoft technology stack (e.g., Microsoft Fabric, Power BI).
   • Maintain awareness of industry trends to inform Paradigm's strategic data architecture decisions.
8. Support Ad Hoc Data Needs
   • Work closely with business users on ad hoc data requests, troubleshooting data issues, and providing solutions in a timely manner.
9. Production Support and Monitoring
   • Proactively monitor and troubleshoot data pipelines and integrations across SQL Server, DB2, Oracle, and cloud environments to minimize downtime.
   • Quickly resolve incidents to ensure seamless data availability.
10. Champion Data-Driven Culture
    • Advocate for data best practices across the organization, helping to empower both technical and non-technical stakeholders to leverage data effectively.
    • Encourage wider adoption of Power BI for data visualization and analytics.

QUALIFICATIONS:

• Education
  • Bachelor's degree in Computer Science, Information Systems, or a related field required.
• Experience
  • 5+ years of data engineering or related experience, with a focus on designing and developing data solutions using Microsoft or equivalent enterprise BI and data platform tools.
  • Strong SQL knowledge, including both DDL and DML, with exposure to SQL Server, DB2, and Oracle.
  • Experience with ETL/ELT tools such as SSIS, Azure Data Factory, or equivalent solutions.
  • Familiarity with Power BI (development, administration, or deployment).
  • Exposure to Microsoft Fabric or similar data platforms is highly desirable.
  • Source control (e.g., Azure DevOps, Git) for versioning and change management.
  • Cloud platform experience (Azure preferred, AWS, or GCP) especially with data storage and data processing components.
  • Proficiency in at least one programming or scripting language (Python, PowerShell, SQL, DAX/MDX, etc.) is beneficial.
  • Knowledge of big data frameworks (e.g., Spark) or streaming platforms (e.g., Kafka) is a plus.
• Technical Skills
  • SQL Server Management Studio, Visual Studio, or equivalent IDEs.
  • Dimensional modeling (Kimball or similar methodologies) for data warehousing.
  • Working knowledge of modern data infrastructure concepts (data lakes, lakehouses, etc.).
• Other Skills
  • Proficient in base Microsoft Office applications (Excel, Word, PowerPoint, Outlook). Advanced Office knowledge (SharePoint, Teams, Visio) is a plus.
  • Strong analytical and problem-solving abilities, with excellent communication skills to engage both technical and non-technical stakeholders.

Paradigm Benefits:

• Health and wellness We want our people to be and stay healthy, so we offer PPO, HDHP, and HMO health insurance options with Cigna and Kaiser (CA employees only).
• Financial incentives Paradigm's financial benefits help prepare you for the future: competitive salaries, 401(k) matching contributions, employer-paid life and disability insurance, flexible spending and commuter accounts, and employer-matched HSA contributions.
• Vacation - We believe strongly that work-life balance is good for you and for our company. Our paid time off and personal holiday programs give you the flexibility you need to live your life to the fullest.
• Volunteer time We want our employees to engage with and give back to their communities in meaningful ways. Full and part-time employees receive one paid day per calendar year.
• Learning and development: One of Paradigm's core values is expertise, so we encourage our employees to continually learn and grow. We support this in a variety of ways, including our new Learning Excellence at Paradigm (LEAP) program.

Paradigm believes that fostering a diverse and inclusive workplace is central to our mission of helping more people and transforming lives. We're striving to build a culture that better reflects the society we live in and empowers our team to deliver the highest levels of compassion and care to those we serve. For us, achieving this goal requires a workforce that respectfully embraces differences and commits to positive change, creating an environment where everyone is able to bring their whole self to work.

Paradigm complies with federal and state disability laws and makes reasonable accommodations for applicants and employees with disabilities. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact Leave Management at [e-mail].

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.

As a contractor with the State of Wisconsin, Paradigm complies with Wisconsin Contract Compliance Law (§16.765). Poster link: Contract Compliance Law Poster

#LI-Remote

Other details

PI286737347