Senior Data Engineer

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

As a Senior Data Engineer, you will closely work with to build data processing, data warehousing infrastructure, and data visualization systems. You will be part of a learning culture where teamwork and collaboration are encouraged, excellence is rewarded, and diversity is respected and valued.

• Follow software development best practices and industry standards to deliver a robust system
• Write analytical queries based on business requirements
• Database schema design based on the product requirements
• Database query optimization, maintain ETL workflows and SQL scripts for data transformation and analysis
• Engage and participate in all stages of the Software Development life cycle process: Planning, design, development, testing and deployment.
• Prepare flow diagram and technical documentation
• Work and collaborate independently or in a team

• At least 4 years of experience in Software development using relational databases & SQL (PL/SQL, T-SQL is preferred)
• Well-versed and experienced with at least one of the programming languages (Preferred: Python, JavaScript, etc)
• Strong knowledge of OLTP and OLAP database design, best practices and database architecture with experience in Data Warehouse design and data analysis. 
• Must have hands on experience in ETL, data transformation, functions, stored procedures, triggers etc
• Strong computing foundation and fundamentals
• End to end understanding of Software components and architectural layers - Frontend, Backend, REST APIs, OLTP, OLAP databases etc.
• Strong analytical and problem solving skills and well-versed with fundamental programming concepts and/or data-structures and algorithms
• Familiarity with Linux systems and the command line interface
• Proficient working knowledge of GIT and GIT based development workflows
• Willingness to learn, contribute, lead and grow with us.

Preferable Skills:

• Knowledge of Power BI, Tableau, and any other BI/visualization tool.
• Experience with database administration.
• Working knowledge of Docker, containers, and cloud-native infrastructure.
• Familiarity with ETL automation tools like Apache Airflow, Pentaho DI, SSIS, etc.
• Familiarity with cloud services and platforms like AWS.
• Good command in spoken and written communication (in English).

🌞 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!