Data Engineer - Hybrid | ETL, SQL & Power BI

Ascot Group; New York (NY); Hybrid; USD 110,000 - 125,000; Full time

Benefits offered by this job

Health benefits

401k plan

Paid holidays

Job summary

Ascot Group is seeking a Data Engineer to support data warehousing initiatives for Ascot US. The role emphasizes building and maintaining data pipelines, ETL/ELT processes, and analytics assets while collaborating with underwriting, finance, and operations teams.

The ideal candidate has 3+ years of data analytics or engineering experience, strong SQL skills, and familiarity with Power BI. This hybrid role requires office presence with flexible scheduling and the use of AI-enabled tools to

Qualifications

• 3+ years of experience in data analytics, BI, or data engineering roles.
• Strong SQL development and data analysis skills.
• Experience with Power BI or similar BI tools preferred.
• Familiarity with data warehouse concepts, ETL/ELT processes, and dimensional modeling.
• Experience with enterprise data platforms, cloud data services, or modern analytics environments.
• Strong analytical, problem-solving, and stakeholder communication skills.
• Bachelor's degree in information systems, CS, data analytics, or related field (or equivalent).
• Experience in the insurance industry is highly preferred.

Responsibilities

• Partner with business stakeholders to understand data, reporting, and analytics requirements and translate them into actionable solutions.
• Design, develop, and maintain data pipelines, ETL/ELT processes, and data integrations supporting enterprise reporting and analytics.
• Develop and optimize SQL queries, datasets, and data models to support reporting, analysis, and operational decision-making.
• Some may build and maintain Power BI reports, dashboards, and semantic models that provide timely and meaningful business insights.
• Validate, reconcile, and monitor data to ensure accuracy, completeness, and consistency across source systems and reporting outputs.
• Collaborate with data engineers, business analysts, and subject matter experts to understand business processes, data structures, and reporting needs.
• Support the testing, deployment, and ongoing maintenance of data and reporting solutions, including issue resolution and enhancements.
• Participate in project planning, requirements gathering, estimation, and solution design activities for data-centric initiatives.
• Document business requirements, data transformations, reporting logic, and technical processes in accordance with established standards.
• Identify opportunities to improve data quality, automate manual processes, and enhance reporting capabilities across the organization.

Skills

SQL development

Data analysis

Stakeholder communication

Education

Bachelor's degree in information systems or CS or data analytics

Tools

Power BI

ETL/ELT

Job description

Ascot Group is seeking a Data Engineer to support data warehousing initiatives for Ascot US. The role emphasizes building and maintaining data pipelines, ETL/ELT processes, and analytics assets while collaborating with underwriting, finance, and operations teams.

The ideal candidate has 3+ years of data analytics or engineering experience, strong SQL skills, and familiarity with Power BI. This hybrid role requires office presence with flexible scheduling and the use of AI-enabled tools to