Lead Data Engineer - AWS/Snowflake
First seen by Alion on Oct 8, 2026.
We are hiring a Lead Data Engineer to design and deliver scalable data pipelines and data solutions on our modern data stack, centered on Snowflake on AWS, Snowflake Openflow (Apache NiFi), dbt, PostgreSQL, Python, and SQL. This is a senior hands-on engineering role responsible for translating business and data requirements into sound technical designs, building and optimizing pipelines, and delivering reliable data products.
The role leads Data Operations support and serves as a senior coordination point for India-based data colleagues, helping organize priorities, remove blockers, and maintain continuity across the broader Data team while working within established reporting lines. A key focus is maturing Data Operations through automated monitoring and proactive support.
Duties/Responsibilities :
- Lead the end-to-end design and delivery of scalable data pipelines and data solutions using Snowflake, Snowflake Openflow (Apache NiFi), and dbt.
- Translate business and data requirements into technical designs, data flows, integration patterns, data models, and delivery plans.
- Build and maintain ingestion and orchestration flows in Openflow, transformation models in dbt, and performant data structures and workloads in Snowflake.
- Design reusable patterns for batch, change data capture, API, and file-based ingestion, including validation, reconciliation, restartability, and recovery.
- Develop in advanced SQL and Python and remain hands-on through code reviews, troubleshooting, performance tuning, and resolution of complex engineering issues.
- Ensure solutions meet expectations for data quality, security, scalability, maintainability, observability, and cost efficiency.
- Collaborate with architecture, analytics, platform, security, application, and business teams to align designs, data contracts, dependencies, and delivery outcomes.
- Maintain clear technical documentation and contribute reusable engineering patterns and standards across the broader Data team.
Data Operations leadership and team coordination :
- Lead Data Operations support and coordinate priorities, handoffs, and issue resolution across India-based data colleagues, working within established reporting lines.
- Establish and reinforce engineering practices for source control, peer review, testing, CI/CD, deployment, documentation, and production readiness.
- Mentor colleagues through design and code reviews, promote cross-training, and help engineers independently deliver and support data solutions.
- Own and mature Data Operations, including support coverage, incident response, escalation paths, runbooks, recovery procedures, and service expectations.
- Drive automated monitoring, alerting, and recovery across Snowflake, Openflow, dbt, databases, and pipeline workloads to reduce manual checks and identify issues proactively.
- Track service health and incident trends, lead root-cause analysis, and maintain a prioritized plan to improve reliability and operational efficiency.
Experience & Education :
- 10+ years of hands-on data engineering experience, including at least 2 years leading technical delivery or production operations.
- Strong production experience with Cloud data technologies in one of Snowflake, AWS, Azure or GCP including solution design, data structures, performance tuning, workload management, security, and cost optimization.
- Strong hands-on experience with dbt, including model design, testing, documentation, dependencies, reusable macros, and deployment across environments.
- Experience with Git-based development, automated testing, CI/CD, Terraform, and repeatable environment-promotion practices.
- Advanced SQL skills with experience and a track record of building maintainable, testable production data pipelines and data products.
- Experience designing ETL/ELT solutions across batch, CDC, API, and file-based ingestion and applying sound data modeling, quality, validation, and recovery practices.
- Strong solution-design, communication, and technical-leadership skills, with the ability to guide decisions, mentor engineers, and work across business and technology teams.
Nice to have :
- Experience working with Snowflake and production data pipelines in AWS environments.
- Hands-on experience with Apache NiFi or Snowflake Openflow, including reusable flow design, orchestration, error handling, monitoring, and deployment.
- Experience with relational databases including RDS and PostgreSQL.
- Experience in financial services or another regulated environment, including auditability, reconciliation, privacy, and production-control expectations.
- Experience with automated observability, data-quality, metadata, lineage, or data-catalog tools.
- Certification in Snowflake, dbt, Apache NiFi, AWS, or data-management.
Our Core Values :
What Drives Us :
- Where Everybody is Somebody : We prioritize inclusivity and respect, ensuring that every team member's voice matters. We foster a collaborative environment where everyone can thrive.
- We Say "Yes" When Others Say "No" : Our team is friendly and compassionate, dedicated to delivering an uplifting customer experience. We go the extra mile to provide solutions that truly make a difference, no matter where our customers are on their financial journey.
- We Have a Passion for Our Purpose : We act with integrity and continually seek ways to grow and innovate. With the largest breadth of products in our industry and new offerings in development, we challenge the status quo to better serve our customers.
- We Win as a Team : We believe in the power of teamwork and diversity, celebrating the unique talents of every team member. Hard work is recognized and valued, creating an environment where everyone contributes to our collective success.
WHY JOIN MFSG TECHNOLOGIES INDIA?
Employee Benefits :
We're committed to supporting your health, well-being, and financial growth :
- Competitive Employee Benefits.
- Comprehensive Medical Coverage. Includes employee, spouse, two children, and two parents.
- Coverage Amount : 6 lakhs annually.
- 5 lakhs top-up is available if you would like to opt, with thousand rupees per month deduction.
- Provident Fund Contribution. Employer contribution of 1,800 per month to support long-term financial security.
- Performance-Based Incentives. Annual bonus of up to 5% of base salary, based on performance and company success.
Reward & Recognition :
- Bucketlist Rewards Platform. Recognizing outstanding contributions through a point-based rewards system. Redeem points for gift cards, experiences, and personalized perks that matter most to you.
- Culture of Appreciation. Celebrating milestones, achievements, and impact across teams.
Work-Life Balance & Flexibility :
- Flexible Work Model. Currently remote, with a future transition to a hybrid model.
- Paid Leave Entitlements. 15 Annual Leaves. 6 Casual Leaves. 12 Sick Leaves. If you're looking for a place where passion fuels purpose and where you can make a difference, we invite you to join us at MFSG Technologies (India) Private Limited. Together, let's win and empower our customers.
Learning & Career Growth :
- Continuous Learning Culture. Access to upskilling programs, mentorship, and professional development resources. Encouragement to learn, adapt, and innovate in a fast-growing financial services landscape.
- Career Growth Opportunities. Internal mobility programs to help employees advance in their careers. Support for leadership development, industry certifications, and specialized training.
- Collaborative Knowledge Sharing. Work with global teams, gaining exposure to international best practices. Encouragement to share ideas, experiment, and take ownership of impactful projects.
Skills
Data Engineering, Data Pipeline, Snowflake DB, Apache NiFi, Data Build Tool, SQL, Python, AWS, ETL