Analytics Engineer – SnowflakeDBT
Spring, TX - USA
Job Summary
12-Month Contract
On-siteat Spring TX
ExxonMobil has been a leader in the energy sector for over 140 years. As ExxonMobil adapts to meet the increasing global demand for oil natural gas and refined products it is committed to playing a pivotal role in energy transition. ExxonMobils mission to fuel the world safely and responsibly has never been more important.
Together Raise and ExxonMobil are building teams that are rising to meet the worlds growing energy needs through the ExxonMobil Contingent Communitywhere skilled workers and unique contract opportunities meet.
Raise is taking applications for current openings like this one while building a diverse group of talent for future openings. When you apply for this role youll also be considered for upcoming positions that align with your skills and qualifications.
Note: Successful applicants will be employees of Raise Limited working at ExxonMobil facilities with both ExxonMobil employees and other contractors.
Overview:
We are looking for a hands-on Analytics Engineer with strong experience in DBT Snowflake and dimensional data modeling to build and maintain the analytical foundation that supports enterprise reporting and analytics. This role owns the design and delivery of trusted analytics-ready datasets partnering closely with Data Engineering BI and business stakeholders to translate requirements into scalable analytical solutions.
Responsibilities:
- Design develop and maintain star-schema data models including fact and dimension tables
- Build and support DBT models and testing frameworks to deliver trusted analytics-ready datasets
- Develop optimize and troubleshoot data structures and SQL workloads in Snowflake
- Apply data modeling best practices making informed decisions on dimensional design normalization and denormalization
- Partner with Data Engineers BI Developers Product Owners and business stakeholders to translate requirements into scalable analytical solutions
- Participate in design discussions knowledge sharing and peer reviews to promote consistent modeling standards across the team
- Support data delivery from ingestion through transformation and into the semantic layer for reporting and analytics
- Document modeling decisions and collaborate with the team to continuously improve data architecture and engineering practices
- Manage version control and collaborative development workflows using GitHub
Qualifications:
Required:
- Strong hands-on experience with DBT development and testing
- Strong experience with Snowflake and SQL optimization
- Proven experience designing and implementing star-schema dimensional models
- Working proficiency with GitHub for version control and collaborative development
- Deep understanding of fact and dimension modeling and analytical data warehouse concepts
- Ability to work effectively in a collaborative cross-functional team environment and communicate technical concepts to both technical and non-technical stakeholders
Preferred:
- Azure Data Factory (ADF)
- Python or Power Query
- DP-203 or SnowPro certification
Ideal Candidate:
- A collaborative analytics engineer who enjoys working with teammates and stakeholders to transform complex source data into well-designed star-schema models using DBT and Snowflake while contributing to a strong engineering culture and data modeling best practices.
Looking for meaningful work We can help
Raise is an established hiring firm with over 65 years of experience. We believe strongly in making the world a better place through work which is why were a certified B Corporation and donate 10% of our profits to charity.
We strive to build teams that reflect the diversity of the communities we work in. We encourage all qualified applicants to apply including people from traditionally underrepresented groups such as women visible minorities Indigenous peoples people identifying as LGBTQ2SI veterans and people with visible/nonvisible disabilities.
We have a dedicated webpage for accommodations where you can learn more about what we offer and request accommodation: order to submit candidates for roles our clients will sometimes require personal information to confirm the identity of applicants and their legal status to work. Raise will never ask you for personal or banking information unless you have been selected for a job. If you are ever unsure about the legitimacy of this or another job posting by Raise (or have any other questions) please contact us at 1 or
#EMTC25
Required Experience:
IC