Subject matter expert

4 weeks ago

Kanpur, Uttar Pradesh, India DigiFocal IT Solutions Pvt Ltd Full time

Job Opening: Senior Data Engineer- SME

Location: Remote

Type: Contract / Freelance – specify

About the Role:

We are seeking a highly skilled Senior Data Engineer SME to design, build, and maintain our modern data platform. This role is perfect for someone with deep technical expertise in ETL pipeline design, data modeling, and data infrastructure who thrives in a fast-paced, engineering-driven environment.

You'll work across the full data stack—from ingestion and transformation to orchestration and delivery—playing a key role in scaling our analytics and reporting capabilities.

Responsibilities:

  • Design and implement efficient, scalable ETL/ELT pipelines and data flows
  • Develop transformation models using dbt and orchestrate pipelines via Airflow
  • Optimize large-scale processing jobs in Apache Spark
  • Tune and manage relational and analytical databases (PostgreSQL, Snowflake)
  • Architect and maintain schemas using Star Schema, 3NF, and SCD2 methodologies
  • Design and support lakehouse architectures and scalable storage solutions
  • Implement and enforce data governance, validation, and quality control mechanisms
  • Maintain DevOps standards using CI/CD, GitFlow, and containerization tools like Docker and Ansible

Requirements

  • Advanced proficiency in SQL and ETL/ELT design
  • Strong experience with dbt, Airflow, and Spark
  • Deep understanding of data modeling techniques (Star Schema, 3NF, SCD2)
  • Proven ability to optimize and tune PostgreSQL and Snowflake for performance
  • Familiarity with lakehouse architecture principles and tools
  • Solid experience in data governance, validation frameworks, and pipeline monitoring
  • Strong grasp of GitFlow, CI/CD pipelines, and containerization (Docker/Ansible)
  • Ability to work independently and collaborate across teams in a dynamic environment

Preferred Qualifications

  • Hands-on experience with cloud platforms (AWS, GCP, Azure)
  • Familiarity with IaC tools and DevOps best practices
  • Experience working in regulated or enterprise environments with strict data governance policies

What We Offer

  • Competitive salary and performance-based incentives
  • Flexible working hours and remote-first culture
  • Opportunity to shape and scale a modern data platform
  • A collaborative, engineering-led environment where your voice matters
  • [Include benefits like healthcare, equity, learning budgets, etc.]

Interested candidates kindly share your resumes on shikha@digifocal.in

  • Senior Building Surveyor – Technical Specialist

    2 days ago

    Kanpur, Uttar Pradesh, India Planned Resources Full time ₹ 1,65,000 per year

    Acting as trusted support to the MBS and Deputies, this exceptionally busy council is seeking a subject matter expert whose role will be to act as an expert to your designated team (around 6 people) in all matters Building Surveying. You will be providing advice on both legislation, technical requirements and procedures around proactive audits, occupancy...

  • Career & International Admissions Profile Building Expert

    2 days ago

    Kanpur, Uttar Pradesh, India EDUGUIDE Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    About the Role: We're on the lookout for a seasoned, academically rooted Career & Profile Building Expert to join our student success team. If your experience goes beyond just filling out applications and handling visas—and you truly understand global higher education, career pathways, and personalized student profile building strategy to crack leading...

  • Learning And Development Specialist

    2 weeks ago

    Kanpur, Uttar Pradesh, India Paras Health Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Roles and Responsibilities* Design and deliver training programs to meet the learning needs of employees in the medical services industry, focusing on NABH compliance.* Conduct Training Need Analysis (TNA) to identify gaps in employee skills and knowledge, and develop training plans accordingly.* Manage the Learning Management System (LMS) to track employee...

  • Training Course

    2 weeks ago

    Kanpur, Uttar Pradesh, India LawSikho Full time

    Job Title: Course Anchor - IBBI ExaminationJob Summary:We are seeking a highly skilled and experienced professional to serve as a Course Anchor for the Insolvency and Bankruptcy Board of India (IBBI) Examination.The Course Anchor will be responsible for delivering high-quality training programs, guiding candidates, and ensuring successful outcomes in the...

  • Privacy and Data Protection Counsel upto 40LPA

    3 weeks ago

    Kanpur, Uttar Pradesh, India Talentiser Full time

    We are hiring for Privacy and Data Protection Counsel for an established Edtech organisation, Head quartered in the US. Summary: The Privacy and Data Protection Counsel supports the Company's global operations and advises on data protection matters, including AI governance, with emphasis on U.S. laws. The Counsel will serve as the key point of contact on...

  • SAP Consultant

    4 days ago

    Kanpur, Uttar Pradesh, India Vastika Inc Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    We're Hiring: SAP MDG Technical ConsultantLocation: Mumbai , Noida , Gurugram , Bangalore ,Hyderabad , ChennaiExperience Required:5+ YearsKey Responsibilities:Act as the SAP MDG Technical SME, supporting MDG projects and DevOps squads in their daily activities.Configure and customize MDG BP/Customer/Vendor objects (data modeling, process modeling, key...

  • Corporate Yoga Instructor – Wellness Program

    3 weeks ago

    Kanpur, Uttar Pradesh, India Thatlifestylecoach Full time

    About the RoleWe are looking for a dynamic and driven Corporate Yoga Instructor to lead and grow the yoga vertical of our corporate wellness program in Gurgaon. This is not just a teaching role — you'll be the subject matter expert (SME) and point person for yoga within our wellness ecosystem, responsible for delivering engaging sessions and ensuring...

  • Network Architect

    1 week ago

    Kanpur, Uttar Pradesh, India Bharti Airtel Limited Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Job DescriptionNetwork & Security Architect will be a key member of the Systems Engineering team which will be focused on evaluating and solution in the area of Cloud – compute, network, storage and database infrastructure. The architect will serve as a primary technical advisor and will be responsible for adopting new technologies, design scalable,...

  • Assistant Vice President – Practice SME-Agentic AI

    3 weeks ago

    Kanpur, Uttar Pradesh, India Genpact Full time

    Ready to build the future with AI? At Genpact, we don't just keep up with technology—we set the pace. AI and digital innovation are redefining industries, and we're leading the charge. Genpact's AI Gigafactory, our industry-first accelerator, is an example of how we're scaling advanced technology solutions to help global enterprises work smarter, grow...

  • Science Expert

    4 days ago

    Kanpur, Uttar Pradesh, India NCR Eduservices Pvt Ltd Full time ₹ 1,04,000 - ₹ 3,12,000 per year

    Job Roles and Responsibilities:Conduct one-on-one online tutoring sessions in Science.Teach Physics, Chemistry and Biology fundamentals for school-level students.Provide clear explanations and demonstrate concepts and problem-solving strategies.Prepare and deliver interactive lesson plans aligned with curriculum standards.Use engaging methods such as...