Senior Data Engineer

The Enterprise Analytics Center of Excellence (CoE) is building the next-generation analytics stack centered on Snowflake (AWS) and Sigma. We are looking for a Sr Data Engineer who will play a critical role in shaping and operating this modern architecture. This role is not just about maintaining pipelines. It’s about helping lead the way in adopting cutting-edge analytics practices, scaling governed data models, and exploring new trends in the industry.

• Ingestion & Transformation 

• Design, build, and maintain scalable data pipelines in Snowflake OpenFlow and other Snowflake-native services. 

• Migrate existing Dataiku pipelines to Snowflake, reducing complexity and cost. 

• Continuously improve workflows for performance, reliability, and efficiency. 

• Semantic Modeling & Views 

• Create and maintain Snowflake semantic views that serve as the governed data layer for analytics. 

• Apply dimensional modeling best practices to ensure consistency and reusability across business domains. 

• Enable role-based semantic views for Finance, Operations, and other enterprise functions. 

• Governance & Security 

• Implement and maintain RBAC frameworks using Active Directory roles/groups. 

• Support metadata management and cataloging surfaced directly in Sigma. 

• Ensure pipelines and models comply with enterprise data governance standards. 

• Analytics Enablement 

• Deliver clean, governed data sets for Sigma dashboards, Ask Sigma (NLP), Write-Back, and embedded analytics. 

• Monitor and tune query performance to optimize cost and speed. 

• Provide technical depth to ensure analytics can scale securely and efficiently across the enterprise. 

• Innovation & Continuous Improvement 

• Stay on top of the latest trends in data engineering and analytics (semantic layers, LLM-powered BI, write-back, real-time pipelines, etc.). 

• Bring new ideas and emerging technologies to ALS for evaluation and potential adoption. 

• Automate testing, monitoring, and deployment processes to keep the stack modern and efficient. 

Education and Experience: 

Bachelor’s degree in computer science or related field, required.  Equivalent experience may be considered 

Skills and Abilities: 

• Snowflake expertise: SQL, OpenFlow, Tasks/Streams, performance tuning, semantic views. 

• Cloud experience: Strong hands-on with AWS (S3, IAM, Glue, Lambda a plus). 

• Data modeling: Dimensional modeling, facts/dimensions, semantic design. 

• ETL/ELT engineering: Proven ability to build and optimize large-scale pipelines. 

• Governance & Security: AD/LDAP integration, RBAC, cataloging. 

• Programming: SQL required; Python required 

• Curiosity and enthusiasm for cutting-edge analytics tools and approaches. 

Preferred Skills: 

• Experience migrating Power BI models/reports into Snowflake Sigma. 

• Familiarity with Sigma features: Ask Sigma, Write-Back, Embedded Analytics. 

• Exposure to Dataiku (to support migration away from it). 

• Interest in AI/ML-powered analytics and NLP-based BI interfaces. 

Travel: 

• Up to 25% travel 

Standard and Physical Requirements:  

• Position involves sitting long periods, standing, manual dexterity, stooping, bending and minimal lifting  

Alliance Team Members Demonstrate DRIVE:   

• Dedicated: Follows through on commitments. Strong say/do.  

• Respectful: Acts with integrity and values diverse perspective.   

• Innovative: Always looking for a better way; leads change.  

• Versatile: Adapts quickly to changing circumstances. Demonstrates agility.