Vendasta - Data Engineer - ETL/Data Warehousing

Role : Data Engineer

Location :

About The Job

Your Impact

• Design, implement, and maintain scalable ELT pipelines within a Kimball Architecture data warehouse.
• Ensure robustness against failures and data entry errors, managing data conformation, de-duplication, survivorship, and coercion.
• Manage historical and hierarchical data structures, ensuring usability for the Business Intelligence (BI) team and scalability for future growth.
• Partner with BI teams to prioritize and deliver data solutions while maintaining alignment with business objectives.
• Work closely with source system owners to extract, clean, and integrate data into the data warehouse.
• Advocate for and influence improvements in source data integrity.
• Champion best practices in data engineering, including governance, lineage tracking, and quality assurance.
• Collaborate with Site Reliability Engineering (SRE) teams to optimize cloud infrastructure usage.
• Operate within an Agile framework, contributing to team backlogs via Kanban or Scrum processes as appropriate.
• Balance short-term deliverables with long-term technical investments in collaboration with BI and engineering management.
  

What You Bring To The Table

• 5 8 years of proficiency in ETL, SQL and experience with cloud-based platforms like Google Cloud (BigQuery, DBT, Looker).
• In-depth understanding of Kimball data warehousing principles, including the 34-subsystems of ETL.
• Strong problem-solving skills for diagnosing and resolving data quality issues.
• Ability to engage with BI teams and source system owners to prioritize and deliver data solutions effectively.
• Eagerness to advocate for data integrity improvements while respecting the boundaries of data mesh principles.
• Ability to balance immediate needs with long-term technical investments.
• Understanding of cloud infrastructure for effective resource management in partnership with SRE teams.
  

About Vendasta

Perks

• Benefits of health insurance.
• Paid time off.
• Training & Career Development: Professional development plans, leadership workshops, mentorship programs, and more!.
• Free Snacks, hot beverages, and catered lunches on Fridays.
• Culture comprised of our core values: Drive, Innovation, Respect, and Agility.
• Night Shift Premium.
• Provident Fund.