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 EngineerStrong SQL experience with the ability to write, troubleshoot, and optimize complex queriesExperience building and supporting ETL/ELT pipelines using Azure Data Factory or similar data orchestration toolsStrong understanding of data modeling concepts, including:
Star schema designFact and dimension tablesType 1 and Type 2 Slowly Changing DimensionsOLTP vs. OLAP data structuresExperience building reports and dashboards in Power BI or a similar BI/reporting toolExperience working with Snowflake and/or Coalesce, including building tables, developing transformations, and troubleshooting query performanceExperience partnering with business stakeholders to translate reporting and analytics requirements into technical solutionsExperience 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 HR@insightglobal.com.