Senior Data Engineer

About the job

About Leapfrog

Leapfrog is on a mission to be a role model technology company. Since 2010, we have relentlessly worked on crafting better digital products with our team of superior engineers. We’re a full-stack company specializing in SaaS products and have served over 100 clients with our mastery of emerging technologies.

We’re thinkers and doers, creatives and coders, makers and builders— but most importantly, we are trusted partners with world-class engineers. Hundreds of companies in Boston, Seattle, Silicon Valley, and San Francisco choose us to gain speed, agility, quality, and stability, giving them an edge over their competitors.

About the role

We are seeking a Data Engineer to design, build, and optimize scalable data platforms, ETL/ELT pipelines, and data warehouses that power analytics, AI, and business applications. The ideal candidate has strong software engineering and database fundamentals, cloud experience, and expertise in data modeling, orchestration, and automation, with a passion for delivering reliable, secure, and high-quality data solutions.

Key Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines to ingest, process, and transform data from diverse sources into data warehouses and data lakes.
• Build and optimize data models, database schemas, and storage solutions to support high-performance data processing.
• Manage relational and NoSQL databases, ensuring performance, scalability, security, and data integrity.
• Develop SQL objects including stored procedures, functions, triggers, views, and optimized queries for efficient data processing.
• Design and maintain OLTP and OLAP data systems, including dimensional modelling and data warehouse architectures.
• Implement data validation, monitoring, and quality assurance processes to ensure data accuracy and reliability.
• Develop and integrate REST APIs for data ingestion, distribution, and retrieval.
• Automate workflows and orchestrate complex data pipelines using Apache Airflow and other ETL automation tools.
• Collaborate with Software Engineers, Product Managers, and business stakeholders to deliver scalable data solutions.
• Contribute to data governance, security, documentation, and engineering best practices.
• Participate in code reviews, CI/CD processes, and Git-based collaborative development workflows.
• Continuously evaluate and adopt modern technologies, cloud services, and AI-powered development practices.

• Strong proficiency in Python and SQL. Experience with PL/SQL and/or T-SQL is preferred.
• Well-versed in at least one programming language such as Python, JavaScript, or similar.
• Experience with relational databases such as PostgreSQL, MySQL, SQL Server, Oracle, or similar. Familiarity with NoSQL databases such as MongoDB or Elasticsearch.
• Experience with cloud platforms such as AWS, Azure, or Google Cloud Platform (GCP). Familiarity with cloud services including S3, Redshift, Glue, Athena, RDS, Lambda, BigQuery, or equivalent.
• Experience with OLTP and OLAP database architecture, best practices, dimensional modelling, and data warehouse design.
• Working knowledge of Docker, containers, Kubernetes, and cloud-native infrastructure.

• Experience with Apache Airflow for workflow orchestration.
• Familiarity with DBT (Data Build Tool).
• Strong understanding of programming fundamentals, object-oriented programming, data structures, algorithms, and software engineering principles.
• Strong computing foundation with excellent analytical and problem-solving skills.

• End-to-end understanding of software architecture and application layers, including Frontend, Backend, REST APIs,
• Knowledge of Power BI, Tableau, or other BI/visualization tools is an advantage.
• Proficient working knowledge of Git and Git-based development workflows.
  

Preferable Skills:

• Experience with Prompt Engineering and Retrieval-Augmented Generation (RAG).
• Familiarity with GenAI orchestration frameworks such as LangChain, LlamaIndex, or similar tools for building and integrating AI-powered applications.
• Understanding of Large Language Models (LLMs), embeddings, vector databases, AI APIs, and AI-assisted development workflows is an added advantage.
• Fundamentals of Artificial Intelligence (AI) and practical exposure to Generative AI technologies are a plus.

Education & Experience:

• Bachelor's degree in Computer Science, Information Technology, Software Engineering, Data Science, or a related discipline is preferred.
• 5+ years of professional experience in Data Engineering, Software Engineering, Database Development, or a related technical role.
• Relevant internships, open-source contributions, and personal projects demonstrating practical expertise are valued.
• Professional certifications are a plus, including but not limited to:
• AWS Certified Data Engineer – Associate
• Google Cloud Professional Data Engineer
• Microsoft Azure Data Engineer Associate

🌞 Life at Leapfrog:

• Work with talented engineers and remarkable professionals in Nepal, the US, and Europe, building state-of-the-art digital health products.
• Have an amazing career growth plan with support from experienced mentors and unlimited learning opportunities.
• Be a part of an experienced team—apply the best industry practices, get mentored by experienced professionals, and be ready to mentor the new ones.
• Get exposure to clients who are leading entrepreneurs and startups from Silicon Valley.
• Your work will be at the cutting edge of healthcare innovation and make a difference in the lives of thousands of people worldwide.
• You will get the flexibility to work remotely or in the office— we value accountable freedom.
• Get growth opportunities, not just in your work. We organize various internal initiatives where you can be a part of a bigger learning community with webinars, knowledge-sharing sessions (KSS), and internal conferences.
• Be a part of a safe workplace where it’s okay to fail fast— get constructive feedback and grow as you move ahead.
• Receive recognition for your contributions and the positive impact you create. We always look for opportunities to celebrate our efforts, play games, and have fun together!
• You will have a lot of fun at Leapfrog— there’ll never be a dull day.

🎁 Benefits and perks:

We believe our people are our greatest strength. With perks and benefits, we intend to offer everything our people need to do their best while maintaining a healthy balance between work and personal life.

Daily Work Support

• 🏠 Hybrid work: Work from office or home, depending on our flexible roster
• 💻 Support for resources: Receive a monthly internet and laptop allowance, and request resources for convenient WFH.
• 📆 5-day workweek: Enjoy weekends off and return refreshed on Mondays.
• 🍔 Food: Access to healthy meals while on-site.

Professional Growth

• 📚 'Growth mindset' fund: Investment in your post-grad degree, learning opportunities, and career growth.
• 👶 Child scholarship: Scholarships for your child in selected schools.
• 📈 Bi-annual bonus: Get timely festival and company bonuses.
• 💸 Advance salary: Request salary in advance.

Work/Life Balance

• ✈️ Paid time-offs: Annual, sick, compensation, and bereavement leaves.
• 🍼 Maternity leave: 3 months of paid leave, 1 month of unpaid leave, and 90 days of reduced workload.
• 🐣 Paternity leave: 11 days of paid paternity leave and reduced workload after.
• 💊 Menstruation leave: 6 days of paid menstruation leave annually.

We take care of you

• 🌿 Your well-being: Company-funded counseling services from certified therapists as well as COVID care services.
• 💰 Retirement fund: Social security fund with health and accidental insurance.

Celebrating your efforts

• 🎉 Engagement and Events: Team lunch/dinner, company outings, and festival celebrations with your favorite co-workers!
• 😎 Exposure: Visit and work in the States and build better client rapport.
• 💖 Recognition: In-house awards, appreciation platforms, and 5th-anniversary gifts!