Data Engineer - (Snowflake and DBT)

India

Full Time Senior-level / Expert USD 58K - 109K * ^est.

Zensar

Zensar is a global organization which conceptualizes, builds, and manages digital products through experience design, data engineering, and advanced analytics for over 200 leading companies. Our solutions leverage industry-leading platforms to...

View all jobs at Zensar

Apply now Apply later

Posted 22 hours ago

Roles & Responsibilities:

Engage with stakeholders, analyze the requirements and interpret them and build foundation
models, dashboards & reports
Design, build and maintain data pipelines for collecting and processing sales data
Integrate data from various sources such as CRM, ERP & other custom sources into centralized
systems for analysis
Build transformations specific to any of Sales marketing, ARR/NRR, Revenue, Renewal.,etc
Work with cross functional teams, collaborating with team and ensure to follow architectural
standards & guidelines
Ensure data accuracy, consistency and integrity across systems
Implement data integrity, security and governance within the data warehouse

Qualifications:

At least 6-8 years of experience in one of the functional areas of Sales and Marketing
Strong reporting skills with Tableau desktop
Strong skills with Snowflake SQL or any other data platforms
Expertise in using DbT Framework and building foundation models
Strong SQL skills with any RDMS database
Expertise in real time data warehouse model design, star & snowflake modeling, Slowly
changing dimensions, snapshotting etc.,
Experience with Shell scripting, Python scripting & API framework is a plus
Experience with GitHub, JIRA, Agile methodologies & other productivity tools
Experience with CI/CD DevOps including using tools such as: GitHub, Jira
Experience working directly with product owners and business partners
Comfortable with ambiguity and effective with minimal guidance