Logo for Weekday (YC W21)

FDE (Data Heavy)

Role overview

Summary

This role focuses on designing, building, and maintaining data pipelines and database solutions that support critical business insights. You will collaborate with data scientists and product engineers to optimize data processes and ensure data integrity, enabling stakeholders to make informed decisions.

Qualifications

  • 3+ years of hands-on experience with SQL, PostgreSQL, and MySQL in production environments.
  • Strong proficiency in writing optimized queries, indexing strategies, and performance tuning techniques.
  • Experience designing and maintaining complex data models and ETL workflows.
  • Ability to troubleshoot performance issues and demonstrate deep problem-solving skills.
  • Excellent communication skills and the ability to translate technical concepts to non-technical stakeholders.

Responsibilities

  • Design and implement efficient data schemas in PostgreSQL and MySQL to support large-scale analytics workloads.
  • Write complex SQL queries and stored procedures for data extraction, transformation, and reporting.
  • Optimize database performance through indexing, query tuning, and resource allocation strategies.
  • Monitor database performance metrics and proactively address bottlenecks or scalability issues.

Key facts

Hard skills

Key skills for this role

Other skills

  • Problem Solving
  • Mentorship
  • Communication
  • Collaboration
  • Analytical Thinking

About the company

Weekday (YC W21) logo

Weekday (YC W21)

  • Staffing & Recruiting
  • 11โ€“50
Hire engineers vouched by other techies

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

๐—ง๐—ต๐—ถ๐˜€ ๐—ฟ๐—ผ๐—น๐—ฒ ๐—ถ๐˜€ ๐—ณ๐—ผ๐—ฟ ๐—ผ๐—ป๐—ฒ ๐—ผ๐—ณ ๐˜๐—ต๐—ฒ ๐—ช๐—ฒ๐—ฒ๐—ธ๐—ฑ๐—ฎ๐˜†'๐˜€ ๐—ฐ๐—น๐—ถ๐—ฒ๐—ป๐˜๐˜€

๐—ฆ๐—ฎ๐—น๐—ฎ๐—ฟ๐˜† ๐—ฟ๐—ฎ๐—ป๐—ด๐—ฒ: ๐—ฅ๐˜€ ๐Ÿฏ๐Ÿฌ๐Ÿฌ๐Ÿฌ๐Ÿฌ๐Ÿฌ๐Ÿฌ - ๐—ฅ๐˜€ ๐Ÿณ๐Ÿฌ๐Ÿฌ๐Ÿฌ๐Ÿฌ๐Ÿฌ๐Ÿฌ (๐—ถ๐—ฒ ๐—œ๐—ก๐—ฅ ๐Ÿฏ๐Ÿฌ-๐Ÿณ๐Ÿฌ ๐—Ÿ๐—ฃ๐—”)

Experience: 3+ yrs

Location: Remote (India)

As a FDE (Data Heavy), you will be a key player in designing, building, and maintaining high-performance data pipelines and database solutions that power critical business insights. You will collaborate closely with data scientists and product engineers to translate complex analytical requirements into clean, efficient SQL queries and robust database schemas. Your work will involve optimizing query performance, ensuring data integrity, and implementing scalable storage solutions across PostgreSQL and MySQL platforms. You will also monitor data quality, troubleshoot issues, and continuously refine processes to support growing data volumes and real-time analytics demands. Your role will be integral to delivering reliable, high-velocity data services that enable customers and stakeholders to make informed decisions swiftly and accurately.

Requirements

๐—ž๐—ฒ๐˜† ๐—ฅ๐—ฒ๐˜€๐—ฝ๐—ผ๐—ป๐˜€๐—ถ๐—ฏ๐—ถ๐—น๐—ถ๐˜๐—ถ๐—ฒ๐˜€

โ€ข Design and implement efficient data schemas in PostgreSQL and MySQL to support large-scale analytics workloads.

โ€ข Write complex SQL queries and stored procedures for data extraction, transformation, and reporting.

โ€ข Optimize database performance through indexing, query tuning, and resource allocation strategies.

โ€ข Collaborate with data engineers and data scientists to translate business requirements into technical specifications.

โ€ข Develop and maintain ETL pipelines utilizing SQL and scripting languages to ensure data consistency across systems.

โ€ข Monitor database performance metrics and proactively address bottlenecks or scalability issues.

โ€ข Ensure data security and compliance by configuring appropriate access controls and audit trails.

โ€ข Create documentation for database architecture, design decisions, and best practices for future maintenance.

โ€ข Provide technical mentorship to junior database developers and support cross-functional teams with data expertise.

โ€ข Stay current with emerging database technologies and industry trends to continuously improve data infrastructure.

๐—ช๐—ต๐—ฎ๐˜ ๐— ๐—ฎ๐—ธ๐—ฒ๐˜€ ๐—ฌ๐—ผ๐˜‚ ๐—ฎ ๐—š๐—ฟ๐—ฒ๐—ฎ๐˜ ๐—™๐—ถ๐˜

โ€ข 3+ years of hands-on experience with SQL, PostgreSQL, and MySQL in production environments.

โ€ข Strong proficiency in writing optimized queries, indexing strategies, and performance tuning techniques.

โ€ข Experience designing and maintaining complex data models and ETL workflows.

โ€ข Ability to troubleshoot performance issues and demonstrate deep problem-solving skills.

โ€ข Familiarity with database monitoring tools and metrics-driven optimization practices.

โ€ข Excellent communication skills and the ability to translate technical concepts to non-technical stakeholders.

โ€ข Proven track record of delivering high-quality, robust database solutions on time.

โ€ข An analytical mindset with a passion for clean, maintainable code and documentation.

โ€ข Demonstrated ability to work effectively in a remote, collaborative environment.

โ€ข Continuous learner who keeps up-to-date with the latest database technologies and industry best practices.

Related jobs

See all jobs

Other jobs at Weekday (YC W21)