> Markdown version of [/jobs/ext/4788123-senior-data-engineer](https://www.wearedevelopers.com/jobs/ext/4788123-senior-data-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 Engineer - **Company:** Sompo International - **Location:** Charlotte, NC, United States - **Experience:** Expert - **Salary:** $155,000 - $160,000 - **Contract:** Permanent contract - **Skills:** Business Analytics Applications, Data Analysis, Microsoft Azure, Cloud Computing, Cloud Database, Cloud Engineering, Continuous Integration, Data Validation, Information Engineering, Data Governance, Data Integration, Extract Transform Load (ETL), Data Mart, Data Systems, Data Warehousing, Relational Databases, Python (Programming Language), Meta-Data Management, Microsoft SQL Server, Operational Databases, Performance Tuning, Query Optimization, Release Management, Power BI, Azure Data Lake, Software Engineering, SQL Stored Procedures, SQL Databases, SQL Server Integration Services, Systems Integration, Transact-SQL, Enterprise Data Management, Data Logging, Azure Data Factory, Apache Spark, Indexer, Git, Event Driven Architecture, Microsoft Fabric, Data Lakes, Pyspark, Data Lineage, Star Schema, Real Time Data, Data Management, Restful APIs, Azure Synapse Analytics, Software Version Control, Data Pipelines, Sql Tuning, Serverless Computing, Databricks - **Published:** November 19, 2026 - **Apply:** https://www.careerbuilder.com/job-details/senior-data-engineer-charlotte-nc--0a3d87f1-fab3-46a3-8320-acfd047a1d95 ## About the Role Software Engineering, Data Management, SQL Server Integration Services (SSIS), Microsoft SQL Server, Cloud Computing, Microsoft Windows Azure, Data Warehousing, Business Intelligence, Business Analysis, Enterprise Data Integration, * 10+ years of experience in data engineering, ETL/ELT development, and enterprise data warehousing, with strong hands-on expertise in Microsoft SQL Server, advanced T-SQL, SSIS, Azure Data Factory, Synapse Pipelines, performance tuning, query optimization, indexing, and production troubleshooting. * Proven experience designing, developing, optimizing, and supporting scalable Azure-based data platforms, including Azure Synapse Analytics, dedicated and serverless SQL workloads, Azure Data Lake Storage Gen2, cloud data ingestion, pipeline orchestration, and migration of legacy data workloads to cloud-native Azure solutions. * Strong background in dimensional and relational data modeling, including Star Schema, Snowflake Schema, fact and dimension tables, data marts, stored procedures, views, functions, SQL scripts, and data warehouse solutions supporting enterprise reporting, BI, and analytics. * Demonstrated ability to build and support reliable production data pipelines with data quality checks, validation, reconciliation, exception handling, logging, monitoring, alerting, root cause analysis, and operational support best practices. * Experience with Azure DevOps or Git, including source control, branching, code management, release management, CI/CD deployment processes, environment migrations, documentation, metadata management, data governance, and data lineage practices. * Strong analytical, problem-solving, communication, stakeholder management, and collaboration skills, with the ability to work independently, manage competing priorities, translate business requirements into scalable technical solutions, and partner effectively with technical teams, business stakeholders, and leadership. * Experience working in the insurance industry, preferably Property & Casualty, commercial lines; preferred experience with Python, PySpark, Azure Databricks, Delta Lake, Power BI semantic models, Microsoft Fabric, Synapse Spark Pools, REST API integrations, event-driven architectures, Master Data Management, and Microsoft Azure Data Engineer certification such as DP-203. ## Description We are seeking an experienced Senior Data Engineer to design, develop, and support enterprise-scale data integration and analytics solutions. The ideal candidate will have strong expertise in Microsoft SQL Server, SSIS, Azure Synapse Analytics, Azure Data Factory, and modern cloud-based data engineering practices. This role will be responsible for building reliable data pipelines, optimizing ETL/ELT processes, supporting data warehouse initiatives, and enabling business intelligence and analytics across the organization. The candidate will work closely with DBAs, application teams, business analysts, reporting teams, and other stakeholders to deliver scalable, reliable, and governed data solutions., * Design, develop, maintain, and optimize enterprise ETL/ELT pipelines using SQL Server Integration Services, Azure Data Factory, and Synapse Pipelines for batch and near real-time data ingestion from internal and external systems. * Migrate legacy SSIS workloads to cloud-native Azure solutions where appropriate, ensuring scalable, reliable, and supportable data integration patterns. * Develop and support data solutions within Azure Synapse Analytics, including dedicated SQL pools, serverless SQL workloads, orchestration processes, workload optimization, and integration with Azure Data Lake Storage Gen2. * Design, implement, and maintain dimensional and relational data warehouse models, including fact tables, dimension tables, Star/Snowflake schemas, data marts, stored procedures, views, functions, and SQL scripts. * Build data solutions that support enterprise reporting, business intelligence, analytics, and downstream data consumption needs across the organization. * Implement data quality validations, reconciliation processes, exception handling, logging, monitoring, and alerting frameworks to improve pipeline reliability and operational transparency. * Optimize SQL queries, indexing, data models, partitioning strategies, pipeline performance, and data warehouse workloads to meet scalability and performance requirements.ยท Troubleshoot production data pipeline failures, SQL performance issues, data quality issues, and data pipeline bottlenecks; perform root cause analysis and implement corrective and preventive solutions. * Collaborate with DBAs, application teams, business analysts, reporting teams, and other stakeholders to resolve data-related issues and deliver scalable, reliable, and governed data solutions. * Support enterprise data governance, metadata management, documentation, data lineage, operational procedures, knowledge sharing, and process discipline across data engineering initiatives. * Manage source control using Azure DevOps or Git, participate in CI/CD deployment processes, support release and environment migration activities, and automate recurring operational, deployment, and validation tasks.