Data Engineer

5 years of experience in Data Engineering

Must Have Skills:

• Minimum 4 years of experience in

  SQL

  , including query optimization and complex joins
• Strong hands-on experience in

  PostgreSQL

  and

  SQL Server

• Minimum 4 years of experience in

  Snowflake

  (data modeling, performance tuning, and development)
• Minimum 4 years of experience in

  Azure Data Factory

  ,

  Azure Cloud Services

  , and building

  ETL/ELT pipelines

• Hands-on experience with

  DBT

  for data transformation and modeling
• Knowledge and exposure to

  Tableau

  for data visualization and dashboarding
• Familiarity with version control systems like

  Git

Responsibilities:

• Collaborate with the business and other functions across the company by building custom analytical objects, reports and dashboards with useful analysis and data insights
• Explain trends across data sources, potential opportunities for growth or improvement, and data caveats for descriptive, diagnostic data analysis.
• Develop deep understanding of how the data flows through different systems and transformed at various stages
• Understand and document the full lifecycle of data and our common data framework so that all data can be integrated, modeled for easy analysis, and analyzed for data insights
• Document every action in either issue/MR templates, the handbook, or the DBT documentation so your learnings turn into repeatable actions and then into automation
• Expand our database with clean data (ready for analysis) by implementing data quality tests while continuously reviewing, optimizing, and refactoring existing data models
• Craft code that meets our internal standards for style, maintainability, and best practices for a high-scale database environment. Maintain and advocate for these standards through code review
• Provide data modeling expertise through code reviews, pairing, and training to help deliver optimal, DRY, and scalable database designs and queries in Snowflake and in DBT
• Become code-owner of specific database and data model schemas
• Own the end-to-end process of building data models, data pipelines & analytical models (containing advanced transformations) as well as providing data support as and when needed by the Analytics/Engineering/Operations team
• Contribute to and implement data warehouse and data modeling best practices, keeping reliability, performance, scalability, security, automation, and version control in mind
• Follow and improve our processes and workflows for maintaining high quality data and reporting while ensuring the Data-led Operations philosophy in everything you do