IT Data Engineer III

Paradigm•Lombard, IL

3d•Remote

About The Position

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.

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.
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.
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 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.