Lead a two-month project to assess the current data environment and design, build, and optimize a scalable cloud data warehouse. Deliver automated ETL/ELT pipelines, dimensional models, analytics-ready datasets, documentation, and handover while partnering with analysts and stakeholders for BI and reporting.
LearnTastic is looking for an experienced Data Engineer to lead a two-month project to assess our current data environment and design, build, and optimize a scalable cloud data warehouse. This role will be responsible for recommending the overall data architecture, building reliable ETL/ELT data pipelines, and creating analytics ready data sets that enable business intelligence and reporting. You will work closely with data analysts, and business stakeholders, and the CEO to establish and deliver a scalable foundation for future data and analytic initiatives.Responsibilities:
- Assess the current data environment and recommend a scalable cloud data warehouse architecture.
- Design, build, and optimize a cloud data warehouse and supporting data models.
- Build and maintain automated ETL/ELT pipelines from multiple data sources.
- Develop analytics ready data sets using dimensional modeling (star/snowflake schemas).
- Ensure data quality, integrity, and performance, and governance.
- Optimize SQL queries and database performance.
- Partner with data analytics and business stakeholders to support business intelligence and reporting.
- Document the data architecture, pipelines, and data models, and provide recommendations for future scalability.
- Provide regular project updates and recommendations to the CEO.
- 5+ years of experience in Data Warehouse Engineering or Data Engineering, or a similar role.
- Strong SQL skills with experience optimizing complex queries and database performance.
- Hands-on experience with ETL/ELT pipelines.
- Experience designing and implementing cloud data warehouse solutions (e.g., Snowflake, Amazon Redshift, Google BigQuery, or Azure Synapse).
- Solid understanding of dimensional data modeling (e.g. star and snowflake schemas).
- Experience with Git and version control.
- Experience designing scalable data architectures.
- Experience with Python.
- Knowledge of dbt and data orchestration tools such as Apache Airflow, Azure Data Factory, or AWS Glue.
- Experience with AWS, Azure, or Google Cloud.
- Familiarity with BI tools such as Power BI, Tableau, QuickSight or Looker.
- Experience integrating data from APIs, SaaS applications, and relational databases.
- Strong analytical, problem-solving, and communication skills.
Expected Deliverables:
- Production-ready cloud data warehouse
- Automated ETL/ELT pipelines for agreed upon data sources
- Documented data models
- Optimised reporting datasets
- Technical architecture diagrams and documentation
- Data dictionary and pipeline documentation
- Knowledge transfer and handover
- Recommendations for future scalability
Location: Remote
Contract Duration: 2 months
Reporting Line: CEO
Contract Duration: 2 months
Reporting Line: CEO
Similar Jobs
Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
Coordinate and execute regional capability-building programs for Manufacturing & Supply Chain across AMEA. Manage logistics, learning platforms (Workday Learning, SharePoint), training calendars, audits (SMETA), KPI tracking, vendor/PO administration, reporting (Excel/Power BI), and stakeholder engagement. Support digital learning deployment and drive continuous improvement toward strategic capability objectives.
Top Skills:
E-Learning PlatformsExcelLearning Management SystemsMarcoPower BISharepointWorkday Learning
Financial Services
Design, prototype, and deploy production-ready machine learning and generative AI solutions and agentic workflows. Own end-to-end model delivery, data and feature engineering, evaluation, deployment, monitoring, retraining, and governance. Collaborate with product, engineering, and risk stakeholders and contribute reusable patterns and services to accelerate adoption and ensure responsible AI practices.
Top Skills:
Amazon Web ServicesGoogle Cloud PlatformGraph Machine LearningKnowledge GraphsKubernetesLarge Language ModelsAzurePythonPyTorchRetrieval-Augmented GenerationScikit-LearnTensorFlow
Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
Lead a client-facing fund accounting team for global hedge, private equity and debt funds. Manage complex fund structures, NAV preparation, investor capital processing, fee and carried interest calculations, investor and fund reporting, and accounting for structured instruments. Supervise, mentor, allocate work, and liaise with clients across global shifts.
Top Skills:
Excel
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
