Data Architect - DBT/Snowflake/SQL

Posted 17 Days Ago
Be an Early Applicant
Pune, Maharashtra
Expert/Leader
Cloud • Information Technology
The Role
The Data Engineer Manager will design, implement, and test modern analytic solutions, collaborate with client partners, and manage data models using DBT and Snowflake. Responsibilities include developing relationships with technical resources, optimizing data transformation processes, and ensuring effective project delivery in data analytics and business intelligence.
Summary Generated by Built In

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 Manager in Data Solutions, you’ll be responsible for designing, implementing, and testing proposed modern analytic solutions. Working closely with our client partners and architects, you’ll develop relationships with key technical resources while delivering tangible business outcomes. 

Qualifications:

· 10+ 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 5+ 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 Ridge’s Diversity, Equity & Inclusion (DEI) Commitment

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 DEI, 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 ([email protected]). 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.

Top Skills

SQL
The Company
HQ: Chicago, IL
550 Employees
On-site Workplace
Year Founded: 2018

What We Do

Spaulding Ridge designs, implements, and supports business technology solutions for companies in a wide range of industries, thinking beyond templated solutions to provide real competitive advantage. When we’re working on a project, we’re an extension of their team. We help the organizations we serve get maximum value from the work we deliver, now and through the life of the system.

As a company committed to social good, we’re a consulting firm that our clients can be proud to partner with—and a firm where they know every member of the team truly believes in the mission. We build personal relationships with the people we work with, and we work smart and hard to deliver total satisfaction with our work.

We help our clients through a variety of services and disciplines:
IT Strategy & Advisory
Cloud Implementation & Process Improvement
Business Transformation & Customer Engagement

To learn more, visit www.spauldingridge.com

Why Work With Us

At Spaulding Ridge, we believe all business is personal. Each interaction with clients and colleagues is an opportunity to connect and contribute to mutual success.  We prioritize our employees’ professional development through challenging and meaningful work, offering top-notch training, mentoring and ample opportunities for growth.

Gallery

Gallery

Similar Jobs

LRN Logo LRN

Data Architect

Edtech • Information Technology
Mumbai, Maharashtra, IND
780 Employees

Ensono Logo Ensono

Data Architect, Snowflake Data

Cloud • Information Technology
Easy Apply
Pune, Maharashtra, IND
3000 Employees

Pfizer Logo Pfizer

Senior Manager, Analytics Developer

Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Mumbai, Maharashtra, IND
121990 Employees

Pfizer Logo Pfizer

Director, Analytics Development

Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Hybrid
Mumbai, Maharashtra, IND
121990 Employees

Similar Companies Hiring

CrowdStrike Thumbnail
Security • Sales • Information Technology • Cybersecurity • Cloud
Austin, TX
10000 Employees
CDW Thumbnail
Internet of Things • Information Technology • eCommerce • Automation • Artificial Intelligence
Vernon Hills, IL
15100 Employees
MetLife Thumbnail
Insurance • Information Technology • Fintech • Financial Services • Big Data Analytics
New York, NY
43000 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account