Sr. Data Engineer

We're looking for a Senior Data Engineer with a strong foundation in Microsoft technologies to help us evolve and scale our clients data platforms. You'll be instrumental in designing, building, and maintaining data warehouses, data marts, data conversions, and supporting ETL processes across on-prem and cloud (Azure) environments.

This is not just a technical role - we want someone who is curious, business-aware, and capable of working alongside stakeholders to build meaningful data solutions. You'll contribute to shaping data strategy and architecture while deepening your expertise in statistics and insurance data.
Key Responsibilities:

• Design and implement scalable data warehouse and data mart solutions
• Build and manage ETL pipelines using SQL Server Integration Services (SSIS) and Azure Data Factory
• Perform complex data transformations, cleansing, and conversions
• Work with both on-premises SQL Server and Azure-based data platforms
• Collaborate with business users and analysts to understand data needs and translate them into effective solutions
• Troubleshoot data issues and ensure high-quality, reliable data pipelines
• Drive technology decisions and contribute to data architecture discussions
• Document data processes, standards, and workflows

Required Skills & Experience:

• 10+ years of experience with SQL Server
• 10+ years of experience with SSIS
• 5+ years of experience working with Azure (Azure Data Factory, Data Lake, Synapse, etc.)
• 5+ years designing and supporting enterprise data warehouses
• 5+ years of hands-on ETL development and support

Preferred Skills:

• Experience with Python
• Hands-on experience with SSAS
• Familiarity with data visualization tools (Power BI, etc.)

What We're Looking For:

• A problem solver who loves a good challenge and enjoys digging into data
• Someone who takes ownership of their work and contributes to team success
• A data professional who's not just technical but also curious about how the business works
• Strong communicator, comfortable working with technical and non-technical stakeholders alike
• Willingness to learn from and contribute to a collaborative and supportive team environment

We value real experience over keyword-heavy resumes. Please include specific accomplishments and examples of how you've contributed in past roles. We're looking for thoughtful professionals - not AI-generated summaries or "alphabet soup" resumes. Compensation: to $160K
We look forward to reviewing your application. We encourage everyone to apply - even if every box isn't checked for what you are looking for or what is required.

PDSINC, LLC is an Equal Opportunity Employer.