Senior Data Analytics Engineer

Job Summary Our client, a leading Energy & Utilities provider, is seeking a Senior Data Analytics Engineer to lead the design and implementation of enterprise-scale dimensional data models within a modern analytics environment. This role focuses on data modeling best practices, star schema design, DBT development, and Snowflake optimization, while providing technical leadership to deliver scalable, high-performing analytical solutions. Core Responsibilities Design, develop, and lead implementation of complex star-schema data models, including fact, dimension, bridge, and aggregate tables Build, optimize, and govern DBT frameworks, models, testing strategies, and reusable development patterns Architect, optimize, and troubleshoot large-scale Snowflake data structures, pipelines, and SQL workloads Define and enforce enterprise data modeling standards, best practices, and design patterns Lead architectural decisions related to dimensional modeling, normalization, denormalization, and analytical data structures Partner with Data Engineers, BI Developers, Product Owners, Architects, and business stakeholders to deliver scalable analytical solutions Mentor team members, conduct design reviews, and provide technical leadership across analytics engineering initiatives Drive data quality, performance, governance, documentation, and continuous improvement of the analytics platform Required Skills/Experience (Must-Haves) Data modeling experience, focused on modeling best practices and star schema design rather than heavy engineering Expert-level hands‑on experience with DBT development, testing, and deployment practices Expert-level experience with Snowflake architecture, performance tuning, and SQL optimization Proven experience designing and implementing enterprise-scale dimensional data models Deep understanding of data warehousing, analytical modeling, and modern analytics engineering principles Experience leading technical design decisions and influencing data architecture strategy Strong communication and stakeholder management skills with the ability to translate complex technical concepts into business value Preferred Skills/Experience (Nice-to-Haves) DP-203, SnowPro, or equivalent cloud data certifications Azure Data Factory (ADF), Synapse, or Microsoft Fabric Python for data engineering, automation, and analytics Data Vault or advanced data modeling methodologies Key Competencies & Behaviors Strong data modeling and analytical thinking capabilities Curious and continuous learner Self-motivated and highly independent Collaborative team player who enjoys knowledge sharing Strong attention to detail and commitment to data quality Ability to balance technical excellence with business objectives Comfortable working in evolving environments and organizational changes Solution-oriented mindset with strong troubleshooting abilities Passion for best practices in data modeling and analytics engineering Work Environment Location: Spring, TX Work Model: Onsite Compensation & Benefits Pay Range: The approximate pay range for this position is between $52.00 and $75.00. Please note that the pay range provided is a good faith estimate. Final compensation may vary based on factors including but not limited to background, knowledge, skills, and location. We comply with local wage minimums. Medical, Dental, & Vision Insurance Plans Employee-Owned Profit Sharing (ESOP) 401K offered About KellyMitchell At KellyMitchell, our culture is world class. We’re movers and shakers! We don’t mind a bit of friendly competition, and we reward hard work with unlimited potential for growth. This is an exciting opportunity to join a company known for innovative solutions and unsurpassed customer service. We're passionate about helping companies solve their biggest IT staffing & project solutions challenges. As an employee-owned, women-led organization serving Fortune 500 companies nationwide, we deliver expert service at a moment's notice. #J-18808-Ljbffr KellyMitchell Group