As a Data Engineer, you will design scalable ELT pipelines, manage data integrity, partner with BI teams, and advocate for best practices in data governance while supporting business intelligence efforts.
Data Engineer,
Chennai, India
About the job:
The Data Engineer is a cornerstone of Vendasta’s R&D team, driving the efficient processing, organization, and delivery of clean, structured data in support of business intelligence and decision-making. By developing and maintaining scalable ELT pipelines, they ensure data reliability and scalability, adhering to Vendasta’s commitment to delivering data solutions aligned with evolving business needs.
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.
- Use AI-enhanced coding assistants to generate, refactor, or document SQL transformations efficiently under guided team workflows.
- Apply AI tools (e.g., lineage visualizers, column profiling bots) to improve structure navigation and documentation accuracy.
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.
- Begins suggesting repetitive workflow steps that could be automated or templated using low-code/AI solutions.
- Uses AI assistants (e.g., GitHub Copilot, SQL generators, prompt-based data profilers) with guidance to accelerate workflow.
About Vendasta:
So what do we actually do? Vendasta is a SaaS company composed of a company of global brands including MatchCraft, Yesware, and Broadly, that builds and sells software and services to help small businesses operate more efficiently as a team, meet more client needs, and provide incredible client experiences. We have offices in Saskatoon, Saskatchewan, Boston and Boca Raton, Florida, and Chennai, India.
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
Top Skills
BigQuery
Dbt
ETL
GCP
Looker
SQL
Vendasta Chennai, Tamil Nadu, IND Office
First Floor, Np28, near Puthiya thalaimurai, SIDCO, Thiru Vi Ka Industrial Estate, Ekkatuthangal, , Chennai, Tamil Nadu, India, 600032
Similar Jobs
Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
As a Big Data Engineer, you will create ETL data pipelines, develop data models, optimize data storage, and provide technical support.
Top Skills:
AthenaAWSDbtEmrETLGlueMulesoftPythonRedshiftS3SnowflakeSparkSQLTalend
Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
Collaborate with teams to implement technology solutions for business problems, develop technical designs, manage project deliveries, and mentor junior members.
Top Skills:
AthenaAWSDbtEmrETLGlueMulesoftPythonRedshiftS3SnowflakeSparkSQLTalend
Information Technology
The Data Engineer will develop machine learning models, design data pipelines, and integrate solutions into production environments on AWS, collaborating with various stakeholders.
Top Skills:
AWSJupyter NotebooksKedroLangchainPandasPythonScikit-LearnSQL
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
