Data Engineer Associate - Snowflake/DBT
Data Engineer Associate - Snowflake/DBT
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Spaulding Ridge is an advisory and IT implementation firm. We help global organizations get financial clarity into the complex daily sales and operational decisions that impact profitable revenue generations efficient operational performance and reliable financial management.
At Spaulding Ridge we believe all business is personal. Core to our values is our relationships with our clients our business partners our team and the global community. Our employees dedicate their time to helping our clients transform their business from strategy through implementation and business transformation.
What You Will Do and Learn
As a Data Engineer in Data Solutions youll be responsible for designing implementing and testing proposed modern analytic solutions. Working closely with our client partners and architects youll develop relationships with key technical resources while delivering tangible business outcomes.
Qualifications:
5 years experience developing industry leading business intelligence and analytic solutions
Must have thorough knowledge of data warehouse concepts and dimensional modelling
Must have experience in writing advanced SQL
Must have at least 2 years of hands-on experience on DBT (Data Build Tool). Mandatory to have most recent hands-on experience on DBT.
Must have experience working with DBT on one or more of the modern databases like Snowflake / Amazon Redshift / BigQuery / Databricks / etc.
Hands-on experience with Snowflake would carry higher weightage
Snowflake SnowPro Core certification would carry higher weightage
Experience working in AWS Azure GCP or similar cloud data platform would be an added advantage
Hands-on experience on Azure would carry higher weightage
Must have experience in setting up DBT projects
Must have experience in understanding / creating / modifying & optimizing YML files within DBT
Must have experience in implementing and managing data models using DBT ensuring efficient and scalable data transformations
Must have experience with various materialization techniques within DBT
Must have experience in writing & executing DBT Test cases
Must have experience in setting up DBT environments
Must have experience in setting up DBT Jobs
Must have experience with writing DBT Jinja and Macros
Must have experience in creating DBT Snapshots
Must have experience in creating & managing incremental models using DBT
Must have experience with DBT Docs
Should have a good understanding of DBT Seeds
Must have experience with DBT Deployment
Must Experience with architecting data pipelines using DBT utilizing advanced DBT features
Proficiency in version control systems and CI/CD
Must have hands-on experience configuring DBT with one or more version control systems like Azure DevOps / Github / Gitlab / etc.
Must have experience in PR approval workflow
Participate in code reviews and best practices for SQL and DBT development
Experience working with visualization tools such as Tableau PowerBI Looker and other similar analytic tools would be an added advantage
2 years of Business Data Analyst experience
2 years of experience writing Business requirements Use cases and/or user stories for data warehouse or data mart initiatives.
Understanding and experience on ETL/ELT is an added advantage
2 years of consulting experience working on project-based delivery using Software Development Life Cycle (SDLC)
2 years of years of experience with relational databases (Postgres MySQL SQL Server Oracle Teradata etc.)
2 years of experience creating functional test cases and supporting user acceptance testing
2 years of experience in Agile/Kanban/DevOps Delivery
Outstanding analytical communication and interpersonal skills
Ability to manage projects and teams against planned work
Responsible for managing the day-to-day client relationship on projects
Manage the Data engineering lifecycle including research proof of concepts architecture design development test deployment and maintenance
Collaborate with team members to design and implement technology that aligns with client business objectives
Build proof of concepts for a modern analytics stack supporting a variety of Cloud-based Business Systems for potential clients
Team management experience and ability to manage mentor and develop talent of assigned junior resources
Create actionable recommendations based on identified platform structural and/or logic problems
Communicate and demonstrate a clear understanding of client business needs goals and objectives
Collaborate with other architects on solution designs and recommendations.
Spaulding Ridges Commitment to an Inclusive Workplace
When we engage the expertise insights and creativity of people from all walks of life we become a better organization we deliver superior services to clients and we transform our communities and world for the better.
At Spaulding Ridge we believe our team should reflect the rich diversity of society and we take seriously the responsibility to cultivate a workplace where every bandmate feels accepted respected and valued for who they are. We do this by creating a culture of trust and belonging through practices and policies that support inclusion and through our employee led Employee Resource Groups (ERGs): CRE (Cultural Race and Ethnicity) Women Elevate PROUD and Mental Wellness Alliance.
The company is committed to offering Equal Employment Opportunity and to providing reasonable accommodation to applicants with physical and/or mental disabilities. If you are interested in applying for employment with Spaulding Ridge and are in need of accommodation or special assistance to navigate our website or to complete your application please send an e-mail with your request to our VP of Human Resources Cara Halladay (). Requests for reasonable accommodation will be considered on a case-by-case basis.
Qualified applicants will receive consideration for employment without regard to their age race religion national origin gender sexual orientation gender identity protected veteran status or disability.
Required Experience:
IC
Employment Type
Full Time
