RishiWrites Header

Rishi Writes

Lead Data Engineer — Remote | 12+ Years

  • Contract
  • Remote

CENTSTONE SERVICES

Lead Data Engineer remote Snowflake Azure advanced SQL data modeling ETL

Role summary for Lead Data Engineer

We are hiring a senior Lead Data Engineer for a fully remote role. This position requires a minimum of 12 years of relevant experience and eligibility to work in the US with USC status or H4 EAD. You will lead a team, design and implement large scale data solutions, own data modeling and ETL or ELT development, and ensure best practices for testing and performance are followed. Interviews will be virtual.

Key responsibilities for Lead Data Engineer

As the Lead Data Engineer you will:

  • Lead a team on research and implementation of large projects involving multiple data models, maps and workflows

  • Act as the primary contact for your team and participate in prioritization and execution of work

  • Serve as subject matter expert and own deep understanding of data, its usage and business meaning

  • Deliver robust end to end integration solutions that follow data engineering best practices and leverage test driven development

  • Translate technical requirements into code based solutions and develop ETL or ELT processes from any source to any target

  • Ensure unit testing and automation are embedded in development practices

  • Design and implement data models including dimensional data stores, operational data stores and data vault patterns

  • Oversee data warehousing efforts including application of Kimball and Inmon techniques and support BI data flows from source to target to BI tools

  • Mentor engineers and conduct design reviews to ensure quality and performance

Required skills and experience

  • Minimum 12 years of hands on data engineering experience with progressive leadership responsibilities

  • Advanced SQL skills with deep knowledge of DDL and DML, normalization to third normal form, ACID transactions and basic performance and security considerations

  • Senior Snowflake experience with data modeling, warehouse design and performance tuning

  • Strong experience with Azure cloud technologies and related data services

  • Proficiency with JavaScript at senior level for data processing, automation and integration tasks

  • Experience with non relational or NoSQL data stores and designing hybrid data architectures

  • Practical knowledge of CAP theorem and how it impacts distributed data systems

  • Demonstrated experience applying Kimball and Inmon methodologies including slowly changing dimensions and star schemas

  • Proven track record implementing ETL or ELT pipelines and unit testing strategies

  • Self starter with excellent communication skills to work across technical and business stakeholders

Preferred qualifications

  • Experience designing data vault models in large enterprises

  • Prior experience leading distributed teams and coordinating with BI, analytics and product groups

  • Familiarity with CI CD for data pipelines and infrastructure as code practices

Work model and interview process

This is a remote role with virtual interviews. Candidates must be authorized to work in the US as USC or hold H4 EAD. The role includes hands on leadership, occasional synchronous meetings aligned to project needs and collaboration across time zones.

Why this role matters

You will shape reliable data infrastructure that enables analytics and business decisions at scale. This is an opportunity to lead technical strategy, mentor engineers and deliver high quality data products used by business and analytics teams.

Ready to Apply?

If you are an experienced Lead Data Engineer looking for a senior remote opportunity, we want to hear from you.
Check out other positions
Let’s discuss your next career move


FAQs for Lead Data Engineer

  1. What is the required experience level for the Lead Data Engineer?
    Minimum 12 years of data engineering experience with leadership or senior technical ownership.

  2. What visa or work authorization is accepted?
    This role requires USC status or H4 EAD.

  3. Is the role fully remote?
    Yes, the position is remote with virtual interviews and collaboration.

  4. What cloud platform is most important for this role?
    Azure cloud technologies are required, along with experience in cloud data services.

  5. Which data warehouse technology is expected?
    Senior level Snowflake experience is required.

  6. How important is SQL for this role?
    Advanced SQL is mandatory including DDL, DML, normalization practices and understanding ACID transactions.

  7. Do I need NoSQL experience?
    Yes. Experience with non relational NoSQL stores and hybrid architectures is expected.

  8. What data modeling techniques should I know?
    Kimball and Inmon methodologies, star schemas, slowly changing dimensions and data vault patterns.

  9. Will I be building ETL or ELT pipelines?
    Yes. You will design and implement new ETL or ELT pipelines from any source to any target.

  10. Are unit tests required for data pipelines?
    Unit testing is required and test driven development practices are expected.

  11. What programming languages are needed?
    JavaScript at senior level is listed. Other languages may be used depending on project needs.

  12. Will I manage people?
    Yes. You will lead a team and act as the main point of contact for prioritization and execution.

  13. What is the interview process like?
    Interviews will be virtual and include technical design sessions, coding or SQL exercises and leadership discussions.

  14. How is success measured in this role?
    Success is measured by delivery of robust data solutions, pipeline performance, data quality and team outcomes.

  15. How do I apply?
    Submit your resume via the job application link or contact the LinkedIn link above to discuss your next step.

To apply for this job email your details to venkatesh.kulkarni@centstone.com

Scroll to Top