Sr. Data Engineer

Insight Global; Irvine (CA); On-site; USD 150,000 - 190,000; Full time

Job summary

Insight Global is seeking a Senior Data Engineer to join a growing analytics and data platform team in Irvine, CA. You will own end-to-end data solutions from ingestion to reporting, collaborating with product owners and analysts to deliver scalable data models, pipelines, and dashboards.

The role focuses on Snowflake, ELT pipelines with Azure Data Factory or Fivetran, Power BI reporting, data governance, and mentoring peers.

Qualifications

• 7+ years of experience as a Data Engineer.
• Proficient in SQL, ETL/ELT development, and data modeling.
• Experience with Snowflake and data visualization tools.

Responsibilities

• Design and optimize data warehouses in Snowflake.
• Build and maintain ELT pipelines with Azure Data Factory and Fivetran.
• Develop dimensional models for enterprise reporting and analytics.
• Collaborate with stakeholders and mentor team members.
• Ensure data quality and governance across domains.

Skills

Strong SQL

Stakeholder communication

Mentoring/Code reviews

Tools

Azure Data Factory

Fivetran

Coalesce

Snowflake

Power BI

Sigma

Job description

Job Description

Insight Global is seeking a Senior Data Engineer to join a growing analytics and data engineering team focused on enterprise reporting, analytics, and modern data platform initiatives. This individual will sit within the Data Strategy group, but will part of a team that supports the Employee Benefits group. They will partner closely with business stakeholders, product owners, business analysts, and fellow engineers to deliver scalable data solutions and business insights. On a day-to-day basis, this person will design and optimize data warehouse solutions within Snowflake, build and maintain ELT pipelines utilizing technologies such as Azure Data Factory, Fivetran, and Coalesce, and develop dimensional data models that support enterprise reporting and analytics. They will troubleshoot and optimize complex SQL queries, analyze source systems, perform data mapping activities, and ensure data quality and reliability across multiple business domains. Additionally, this individual will support reporting initiatives through tools such as Sigma and Power BI, participate in data governance and engineering standards efforts, evaluate emerging technologies and AI-driven capabilities, and serve as a technical mentor by conducting code reviews and promoting data engineering best practices across the organization. The ideal candidate is comfortable owning data solutions from ingestion through reporting and has the ability to effectively communicate with both technical and business stakeholders.

Skills and Requirements

• 7+ years of experience as a Data Engineer
• Strong SQL experience with the ability to write, troubleshoot, and optimize complex queries
• Experience building and supporting ETL/ELT pipelines using Azure Data Factory or similar data orchestration tools
• Strong understanding of data modeling concepts, including:Star schema designFact and dimension tablesType 1 and Type 2 Slowly Changing DimensionsOLTP vs. OLAP data structures
• Experience building reports and dashboards in Power BI or a similar BI/reporting tool
• Experience working with Snowflake and/or Coalesce, including building tables, developing transformations, and troubleshooting query performance
• Experience partnering with business stakeholders to translate reporting and analytics requirements into technical solutions
• Experience deploying an AI project in Snowflake

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [e-mail].