Data Engineer: AI-Driven Data Pipelines (Hybrid)

Ascot Group; Woodbridge Township (NJ); Hybrid; USD 110,000 - 125,000; Full time

Benefits offered by this job

Health and welfare benefits

Paid holidays

401k retirement plan

Job summary

Ascot Group is seeking a Data Engineer to support data warehousing projects, ETL/ELT pipelines, and analytics assets. You will design, develop, test, and maintain data pipelines and may build Power BI reports to deliver timely insights for underwriting, operations, and finance.

The role emphasizes SQL, Power BI, data modeling, and cloud data services; 3+ years of experience and a Bachelor’s in a related field preferred. This is a hybrid role based in New Jersey.

Qualifications

• 3+ years in data analytics, BI, reporting, or data engineering.
• 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.
• Excellent analytical, problem-solving, and stakeholder communication skills.
• Bachelor’s degree in information systems, Computer Science, Data Analytics, or related field (or equivalent).
• Insurance industry experience is highly preferred (policy, claims, underwriting, finance, or regulatory reporting).

Responsibilities

• Partner with stakeholders to translate data, reporting, and analytics requirements into solutions.
• Design, develop, and maintain data pipelines and data integrations for enterprise reporting and analytics.
• Develop and optimize SQL queries, datasets, and data models for reporting and decision-making.
• Build and maintain Power BI reports, dashboards, and semantic models for insights.
• Validate and monitor data for accuracy and consistency across sources.
• Collaborate with data engineers, analysts, and SMEs to understand processes and data structures.
• Support testing, deployment, and maintenance of data and reporting solutions; resolve issues and enhancements.
• Participate in project planning, requirements gathering, estimation, and design for data initiatives.
• Document data transformations, reporting logic, and technical processes to established standards.
• Identify opportunities to improve data quality and automate manual processes.

Skills

SQL development

Power BI

Data warehousing concepts

Cloud data services

Data analytics

Stakeholder communication

Education

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

Tools

Power BI

Job description

Ascot Group is seeking a Data Engineer to support data warehousing projects, ETL/ELT pipelines, and analytics assets. You will design, develop, test, and maintain data pipelines and may build Power BI reports to deliver timely insights for underwriting, operations, and finance.

The role emphasizes SQL, Power BI, data modeling, and cloud data services; 3+ years of experience and a Bachelor’s in a related field preferred. This is a hybrid role based in New Jersey.