> Markdown version of [/jobs/ext/4258417-senior-data-analytics-engineer](https://www.wearedevelopers.com/jobs/ext/4258417-senior-data-analytics-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Senior Data & Analytics Engineer

- **Company:** S3 CONNECTIONS LLC
- **Location:** New York, NY, United States
- **Experience:** Expert
- **Contract:** Contract
- **Skills:** Data Analysis, Business Logic, Microsoft Azure, Big Data, Information Systems, Data Architecture, Information Engineering, Data Integrity, Extract Transform Load (ETL), Data Security, Data Systems, Data Warehousing, Dimensional Modeling, Document-Oriented Databases, Python (Programming Language), Performance Tuning, Power BI, SQL Stored Procedures, SQL Server Analysis Services, Transact-SQL, Azure Data Factory, Apache Spark, Git, Data Layers, Pyspark, Information Technology, Data Analytics, Azure Synapse Analytics, Data Pipelines
- **Published:** October 26, 2026
- **Apply:** https://www.dice.com/job-detail/c7b514eb-2758-4e2e-8f5e-0206d0a77464

## About the Role

Senior Data & Analytics Engineer with a strong technical background and insurance industry exp. This role is critical in designing and delivering scalable, high-performance data solutions that empower analytics, reporting, and strategic decision-making. The ideal candidate will have expertise in Microsoft T-SQL, Azure Synapse Analytics, Azure Data Factory (ADF) and Power BI semantic layer, along with a solid grasp of insurance data domains such as policy, claims, underwriting, and actuarial., * Bachelor's or Master's degree in Computer Science, Information Systems, or a related discipline.

 * 5+ years of experience in data engineering, analytics, or BI roles.
 * Strong hands-on experience with Microsoft T-SQL, Azure Synapse Analytics, Power BI Semantic Layer (or SSAS) and Azure Data Factory.
 * Proficiency in Python/PySpark. Experience with DAX is a strong plus.
 * Experience with Git, branch management, and CI/CD pipelines in a data environment.
 * Deep understanding of P&C insurance industry data (e.g., policy administration, claims processing, underwriting, actuarial models, ceded reinsurance).
 * Working knowledge of insurance enterprise data models such as ACORD, IBM, etc.
 * Experience with data warehousing, dimensional modeling, and data architecture.
 * Proven ability to optimize performance in large-scale data environments.
 * Excellent communication and collaboration skills with both technical and business stakeholders.
 * Ability to manage concurrent deliverables in a fast-paced environment.

## Description

* Design, develop, and maintain data marts tailored to the specific needs of the insurance business.
 * Develop scalable ETL/ELT pipelines using Fabric Data Factory (Pipelines and Dataflows Gen2) and PySpark Notebooks. Optimize Fabric Spark runtimes for large-scale data processing.
 * Strong focus on data integrity, performance tuning, idempotency, cost analysis, testing, and risk mitigation.
 * Develop and optimize complex T-SQL queries, stored procedures, and views for high-performance data access.
 * Collaborate with the Data Analytics team to deliver actionable insights to the business utilizing Power BI's semantic layer, including custom KPIs using DAX.
 * Ensure data quality, consistency, and governance across all data layers.
 * Document data models, business logic, and technical specifications to ensure reliability and transparency.
 * Stay current with Azure technologies and insurance data trends to drive continuous improvement.