Hybrid Data Engineer: Azure, SQL & Power BI

PDS Inc.; Overland Park (KS); Hybrid; USD 120,000 - 129,000; Full time

Job summary

PDS Inc. is seeking a Data Engineer to advance the firm’s data strategy and analytics ecosystem, transforming raw data into actionable insights for business decisions.

You will design reliable, scalable pipelines and reporting solutions while collaborating with stakeholders across marketing, underwriting, and IT. The ideal candidate brings strong SQL, BI, and data modeling skills, with hands-on Azure/Data Factory experience and a drive for continuous learning and innovation.

Qualifications

• Strong SQL development skills and experience with Microsoft SQL Server/Azure SQL Database.
• Hands-on experience with data import, transformation, and integration using Azure Data Factory, SSIS, or similar tools.
• Proficiency in building BI solutions using Power BI and/or SSRS.
• Strong data modeling and relational database design skills.
• Proficiency in Microsoft Excel (advanced formulas, pivot tables, external data connections).
• Ability to translate business goals into data requirements and technical solutions.
• Excellent communication and collaboration skills.
• Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent experience).
• Experience with cloud-based data platforms (Azure Data Lake, Synapse Analytics, Databricks).
• Familiarity with version control tools (Git, Azure DevOps) and Agile practices.
• Exposure to Python or PowerShell for data transformation or automation.
• Experience integrating data from insurance or financial systems.

Responsibilities

• Design, build, and maintain data pipelines and integrations using ETL/ELT tools.
• Automate data imports, transformations, and loads from multiple sources.
• Optimize and monitor data workflows for reliability, performance, and cost efficiency.
• Implement and maintain data quality, validation, and error-handling frameworks.
• Design and publish dashboards and visualizations in Power BI and SSRS aligned with KPIs.
• Collaborate with stakeholders to define analytical and data integration requirements.
• Maintain data integrity, governance, and promote best practices in data stewardship.
• Support data security and compliance initiatives with IT and business teams.
• Stay current with emerging data technologies and analytics practices.

Skills

SQL development

Data analysis

Communication

Business-to-technical translation

Education

Bachelor's degree in CS/IS or related

Tools

Azure Data Factory

SSIS

Power BI

SSRS

Azure DevOps

Git

Python

PowerShell

Azure Data Lake

Synapse Analytics

Databricks

Job description

PDS Inc. is seeking a Data Engineer to advance the firm’s data strategy and analytics ecosystem, transforming raw data into actionable insights for business decisions.

You will design reliable, scalable pipelines and reporting solutions while collaborating with stakeholders across marketing, underwriting, and IT. The ideal candidate brings strong SQL, BI, and data modeling skills, with hands-on Azure/Data Factory experience and a drive for continuous learning and innovation.