Company description
Emma Infotech Pvt Ltd helps businesses turn scattered data into reliable reporting and analytics. We design cloud data platforms, build pipelines, and prepare datasets that teams can trust for day-to-day decisions.
About the role
We’re looking for an early-career data engineer who can take a dataset from ingestion through to a reporting-ready model. You’ll build and support pipelines in BigQuery, use dbt to transform and test data, and work with the team to translate reporting needs into clear warehouse models. We welcome practical experience from work, internships, coursework, or substantial personal projects.
Key responsibilities
- Build and maintain ETL and ELT pipelines that ingest data from files, APIs, and operational systems into BigQuery.
- Develop dbt staging and reporting models, define sources, add data quality tests, and document transformations.
- Design fact and dimension tables at a clear grain and use them to support analytics and reporting.
- Investigate failed loads and mismatched metrics, validate results against source data, and document fixes and backfills.
Required skills
- SQL skills including joins, aggregations, and window functions, with hands-on practice querying and loading data in BigQuery.
- Practical familiarity with dbt models, sources, tests, and how to run and troubleshoot a transformation.
- Understanding of ETL and ELT, cloud data warehousing, dimensional modelling, and the role of analytics in validating data.
- Ability to explain a project you worked on, the decisions you made, and how you checked that the results were correct.
Nice to have
Python for ingestion or automation, Git, scheduling tools, or Tableau and similar BI tools.
Role details and how to apply
This is a full-time, work-from-home role for candidates based in India. Submit your résumé and describe a relevant project, including your own contribution and experience with BigQuery and dbt.
Apply now →