Job Description
The Senior Data Engineer will be responsible for designing, governing, and evolving a centralized data platform in Snowflake by ingesting large volumes of both structured and unstructured data from multiple internal source systems. On a day‑to‑day basis, this role works closely with other data engineers, providing hands‑on technical guidance, architectural direction, and best‑practice recommendations to ensure data is modeled, streamed, and organized correctly within Snowflake. The engineer leverages Azure Data Factory to orchestrate batch and streaming pipelines, establishes a more structured and scalable approach to data ingestion, and ensures performance, reliability, and cost efficiency across Snowflake workloads. They partner with analytics and reporting stakeholders to support highly customized Power BI reports and semantic models, while also advising on modern Snowflake capabilities, such as AI/Cortex features where appropriate. This role serves as the on‑site subject matter expert, spending significant time reviewing designs, explaining recommended approaches, documenting standards, and translating business requirements into scalable data models to support enterprise analytics and decision‑making.
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 opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their 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 recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
• 7+ years of experience in data engineering with strong hands-on expertise in Snowflake and Power BI
• Ability to design analytics-ready data models and enterprise BI solutions and dashboards
• Strong background in Snowflake architecture design, including multi-cluster warehouses, workload isolation, and scaling strategies
• Experience with Azure Data Factory and well-versed in working with large-scale structured/unstructured datasets
• Deep understanding of ELT/ETL patterns, data warehousing concepts, and performance tuning
• Strong Snowflake experience across ingestion, optimization, governance/security, and large-scale data platform design, including hands-on use of native features and cost-efficient architecture
• Hands-on experience with Snowflake-native development and AI capabilities (Snowpark, Native Apps/Snowlit, unstructured data handling, and ML integrations)
• Advanced SQL and Python skills for data transformation, automation, and analytics enablement
Nice to Have Skills & Experience
Experience with Snowflake Cortex / AI & “super intelligence” capabilities
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.