IT Data Engineer III - Remote

Paradigm • Lombard, IL

21h • Remote

About The Position

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. Paradigm has been certified by Great Place to Work® for four years in a row and earned a spot on Fortune's Best Workplaces in Health Care™ list for three consecutive years, reflecting their commitment to fostering a positive, inclusive, and employee-centric culture. This full-time, remote Data Engineer III position 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.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, or a related field required.
• 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.
• 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.
• 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.).
• Proficient in base Microsoft Office applications (Excel, Word, PowerPoint, Outlook).
• Strong analytical and problem-solving abilities, with excellent communication skills to engage both technical and non-technical stakeholders.

Nice To Haves

• Familiarity with healthcare and/or workers’ compensation terminology and business concepts.
• Familiarity with Power BI (development, administration, or deployment).
• Exposure to Microsoft Fabric or similar data platforms is highly desirable.
• 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.
• Advanced Office knowledge (SharePoint, Teams, Visio) is a plus.

Responsibilities

• 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.
• 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.
• 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.
• 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.
• 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.
• 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).
• 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.
• Work closely with business users on ad hoc data requests, troubleshooting data issues, and providing solutions in a timely manner.
• 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.
• 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.

Benefits

• PPO, HDHP, and HMO health insurance options with Cigna and Kaiser (CA employees only).
• Competitive salaries.
• 401(k) matching contributions.
• Employer-paid life and disability insurance.
• Flexible spending and commuter accounts.
• Employer-matched HSA contributions.
• Paid time off and personal holiday programs.
• One paid day per calendar year for full and part-time employees to volunteer.
• Learning Excellence at Paradigm (LEAP) program.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Number of Employees: 11-50 employees