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

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