Senior Data & Analytics Engineer
S3 Connections LLC
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- Fabric Data Factory
- Fabric Spark
- azure
- DAX
- insurance
Summary
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.
Key Responsibilities:
- 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.
Required Qualifications:
- 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.
- Dice Id: 91172064
- Position Id: 9124305
- Posted 1 hour ago
Company Info
We are 🏄passionate about modern technologies and it’s possibilities to unfold challenges keeps us excited in what we do. We work with leaders in creating a unified experience for their teams across platforms - work seam less with intelligent automations at the back.
We deliver intelligence to every member that determines their challenge and enable them to innovate solutions, so that your members should say, “Yes – I Did it”. 🏋
We help employees experience growth at individual level by visualizing their contributions, assess effectiveness and efficiency, identify areas of improvement and ⛽️fuel their problem solving skills with the help of data. We help providing them an experience of Journey from good to great.
At S3, We’re just passionate about transformation as you are. That’s why we digitalize operations in order to help you fuel the 🚀orbital shift. We help you productize your ideas & thoughts so quick that sometimes approvals come late and your idea is already under user test. You will also appreciate the automation at the back, taking care of mundane jobs and you are more, free to be creative & innovative in what you do.
Scale your ideas to enterprise grade on demand, customize your product to the core and integrate into your digital landscape for a seamless experience and all this always within your budgets. Rapid Application Development, AI / ML, BoT’s, Robotic Process Automation, Process Automation, Analytics, Integrations, Change Management, and more is what we can do for you.
Think of us as partners dedicated to nurturing your business, much like providing essential elements for growth such as Soil, Water, Nutrients and right Environment to transform from 🌱 "Plant to Tree", similarly we work with Process, People, Technology & Culture to help you "Rise to Transform" the orbital shift.