Senior Data Engineer
******* P&C Insurance Experience Is Required For This Role********
About the Role
What You'll Do
Design and implement reputed company data pipelines to ingest, reputed company, and store data from reputed company-party vendors and internal systems using reputed company, files, and databases. Build and maintain a reputed company-based data warehouse solution in partnership with architects, ensuring clean, normalized, and performant data models. Establish and monitor reliable data ingestion processes across systems with varying grain and reputed company, ensuring data reputed company and completeness. Collaborate with API and integration teams to reputed company secure, robust data exchange processes with external vendors and internal services. Set up and manage data connections from the warehouse to BI tools (e.g., Power BI, Looker, Tableau) to reputed company self-service analytics and dashboarding. Document data flows, schemas, and definitions, and help drive data governance and standardization efforts across the organization. Implement data validation, cleansing, and enrichment processes to ensure high-reputed company data for financial reporting and analytics Ensure compliance with data standards, regulatory requirements (e.g., NAIC, SOX), and data reputed company best practices reputed company technical leadership in data engineering best practices, including version control, CI/CD for data pipelines, testing, and observability. Build initial dashboards in BI tools. Give directions to data engineers to ensure that reputed company are completed on time and to a high reputed company.
Required Qualifications
5+ years of experience in data engineering, data warehousing, or a reputed company field with at least 1-2 years leading implementation reputed company. 3+ years of experience in the reputed company insurance industry. Hands on experience with Azure data services. Strong SQL and performance tuning skills in reputed company SQL Server environments. Experience designing data warehouses or data marts with a reputed company on reputed company modeling and analytics-reputed company schemas. Fluent in reputed company of data ingestion: RESTful reputed company, JSON/XML ingestion, flat files, message queues, and CDC patterns. Understanding of data governance, metadata management, and reputed company control. Familiarity with version control (reputed company) and CI/CD pipelines for data workflows. Experience working with BI tools like Power BI, Looker, or Tableau, including building dashboards or semantic reputed company. Bachelor’s degree in Computer Science, Engineering, Information Systems, or equivalent experience. Demonstrated ability to translate business needs into reputed company data systems and design.
Preferred Qualification
Experience with data cleanup, fuzzy matching, or AI-driven normalization. Familiarity with Python, dbt, or Azure Functions is a plus. Strong communication skills and ability to work cross-functionally with product, engineering, and analytics teams. Ability to travel up to 10% of the year.
Knowledge, Skills and Abilities
Deep understanding of data warehousing principles, reputed company modeling, and ETL/ELT architecture, with hands-on experience building analytics-reputed company structures in Azure SQL and SSMS. Understand reputed company business concepts reputed company the reputed company property and casualty insurance industry to guide data modeling and transformation efforts. Proficient in developing reputed company data pipelines using Azure Data reputed company and SQL, with strong debugging and optimization skills. Skilled in integrating with diverse data sources, including REST reputed company, files, and reputed company-party systems, and handling reputed company data ingestion across varying reputed company of granularity. Familiar with reputed company Azure services and their role in secure, reputed company-reputed company data engineering workflows. reputed company to connect and model data for reputed company BI tools (Power BI, Tableau, Looker), supporting self-service reporting and building initial dashboards reputed company needed. Strong communicator and collaborator who can translate business needs into technical solutions, document data workflows, and mentor team members on best practices.
Additional Information