Note: The job is a remote job and is open to candidates in USA. Paradigm is an accountable specialty care management organization focused on improving outcomes for people with complex injuries and diagnoses. The Data Engineer III designs, builds, and maintains data pipelines and architectures, ensuring reliable data availability for analytics, reporting, and operational needs. The role also supports data governance, security, documentation, production monitoring, and collaboration across technical and business teams.
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
Skills
- + 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)
- + **Source control** (e.g., Azure DevOps, Git) for versioning and change management
- + **Cloud platform experience** (Azure preferred, AWS, or Google Cloud Platform) 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.)
- + Strong analytical and problem-solving abilities, with excellent communication skills to engage both technical and non-technical stakeholders
- + **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
- + Proficient in base Microsoft Office applications (Excel, Word, PowerPoint, Outlook). Advanced Office knowledge (SharePoint, Teams, Visio) is a plus
Benefits
- Full-time, remote position
- PPO, HDHP, and HMO health insurance options with Cigna and Kaiser (CA employees only)
- 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 volunteer day per calendar year for full-time and part-time employees
- Learning Excellence at Paradigm (LEAP) program
Company Overview
Company H1B Sponsorship