Principal Lead - Data Engineer

Highly skilled Data Delivery Developer with expertise in SQL, Snowflake, and AWS infrastructure. The ideal candidate will have hands-on experience in complex data migration projects, particularly migrating from SSIS/SQL Server to Snowflake, and a strong understanding of cloud resource management on AWS. Define challenges of large and complex migration projects to best practices and have aptitude of high-level design thinking to build scalable solutions.

Key Responsibilities

Design, develop, and maintain scalable data pipelines using Snowflake and AWS services.

Write complex and optimized SQL queries for data extraction, transformation, and reporting.

Automate data workflows and delivery processes using Python.

Collaborate with data architects, analysts, and business stakeholders to understand data requirements.

Monitor and troubleshoot data delivery issues and ensure data quality and integrity.

Implement best practices for data governance, security, and performance optimization

Drive the optimization of technology operations though automation and solution delivery, system/services performance monitoring.

Develop, enhance and troubleshoot database objects such as stored procedures, functions, tables and views.

Create and maintain data dictionaries, data model and change management documentation.

Conduct data profiling to understand data relationship and quality of data through AWS Athena.

Participate in all phases of the software development life cycle (SDLC), including requirements, technical design, development, testing and implementation.

Working with column-oriented data storage formats such as Parquet, interactive query service such as Athena/SnowFlake and event-driven computing cloud service Lambda.

Preferred Qualifications

5+ years of strong experience in data delivery projects with strong exposure to writing complex SQL queries, perform SQL optimization and worked on complex data migrations assignments.

Experience in SnowFlake, AWS data suite of services like S3, Athena, Glue etc.

Experience on AWS infra using CI/CD deployments.

Experience with any one of ETL tool like Informatica, SSIS etc..

Should have thorough understanding of ITSM process and aptitude to understand the technology infrastructure and cost.

Demonstrated ability to manage multiple and varied assignments.

Ability to quickly perform critical analysis and use creative approaches for solving complex problems.

Strong Academic background.

Excellent written and verbal communication skills.

About Our Company

Ameriprise India LLP has been providing client based financial solutions to help clients plan and achieve their financial objectives for 125 years. We are a U.S. based financial planning company headquartered in Minneapolis with a global presence. The firm’s focus areas include Asset Management and Advice, Retirement Planning and Insurance Protection. Be part of an inclusive, collaborative culture that rewards you for your contributions and work with other talented individuals who share your passion for doing great work. You’ll also have plenty of opportunities to make your mark at the office and a difference in your community. So if you're talented, driven and want to work for a strong ethical company that cares, take the next step and create a career at Ameriprise India LLP.

Ameriprise India LLP is an equal opportunity employer. We consider all qualified applicants without regard to race, color, religion, sex, genetic information, age, sexual orientation, gender identity, disability, veteran status, marital status, family status or any other basis prohibited by law.

Full-Time/Part-Time

Full time

Timings

(2:00p-10:30p)

India Business Unit

AWMPO AWMP&S President's Office

Job Family Group

Technology