Senior Consulting Manager, Data Analyst

Cognizant; California (MO); On-site; USD 134,000 - 180,000; Full time

Job summary

An established industry player in banking and financial services is seeking a Senior Consulting Manager, Data Analyst. This role involves leading data migration projects, ensuring data integrity, and leveraging your expertise in ETL and SQL. You will collaborate with clients and stakeholders to solve core business challenges, while also developing practice capabilities and brand recognition. If you are passionate about data analysis and want to grow your career in a dynamic environment, this opportunity is perfect for you.

Benefits

Medical/Dental/Vision Insurance

Paid Time Off

401(k) plan

Long-term/Short-term Disability

Paid Parental Leave

Employee Stock Purchase Plan

Qualifications

• 10+ years in banking/financial services with proven data analysis skills.
• Experience with data migration projects focusing on data integrity.

Responsibilities

• Manage project workstreams, ensuring budget and timelines are met.
• Analyze legacy bank data and design data migration strategies.

Skills

Data Analysis

ETL

SQL Queries

Agile Methodologies

Data Migration

Education

Bachelor's Degree in a relevant field

10+ years of experience in technology or consulting

Tools

Jira

Job description

The Role

Our banking and financial services group is looking for a Senior Consulting Manager, Data Analyst to join our journey. We’re looking for someone who excels in data analysis, including ETL and SQL queries.

We’re looking for Senior Consulting Managers who can deliver within Cognizant’s Five Pillars of Consulting Excellence: 1) Project Execution, 2) Expertise, 3) Business Development, 4) Practice Development, & 5) People Development. As a Senior Consultant, this means partnering with clients and project stakeholders, and colleagues. In addition to enabling consulting excellence through the Five Pillars of Consulting, the specific requirements for this position are below.

Our solutions are in demand and we’re passionate about making a difference. If you have experience with the above, are a selfless leader, and are committed to client-facing environment; if you want to grow your career with a team that wants to build something great together, we want to hear from you! Apply now!

Responsibilities

· Based on experience, support or own and manage one or more project workstream(s), including deliverables, while adhering to budget, timelines, and client engagement guidelines;

· Partner with clients and project stakeholders and apply technical and domain expertise to solve core client business challenges or inefficiencies; this may include leading and managing small solutioning teams to accomplish the above

· Understanding various financial risk and compliance related data associated with the business line and various upstream/downstream IT systems.

· Performing data gap analysis, systems, processes, and procedures as required for the project.

· Documenting functional, data mapping, reporting logic and other requirements.

· Analyze legacy AFS bank data, design and execute a comprehensive data migration strategy to ACBS, ensuring data integrity.

· Develop detailed Source-to-Target Mapping (STTM) and utilize SQL for ETL processes.

· Perform rigorous data quality checks and collaborate with development teams to ensure a successful migration.

· Design and execute the complete data migration strategy, ensuring data integrity and accuracy throughout the process.

· Develop a comprehensive Source-to-Target Mapping (STTM) document, detailing how all relevant AFS data fields will be transformed and mapped to corresponding ACBS fields.

· Write and optimize SQL queries for data extraction, transformation, and loading (ETL).

· Perform rigorous data quality checks and validation, reconciling data between AFS and ACBS.

· Collaborate effectively with the development team to implement the data migration plan, addressing any data-related issues.

· Document data migration processes, including the STTM.

· Develop practice capabilities and brand recognition by exercising thought leadership, establishing a consultative presence within Cognizant and the wider consulting community, and participating in professional organizations;

Qualifications

• 10 + years working in technology, consulting, professional services, or solution development within the banking/financial services industry
• Proven experience in data analysis, ETL, and SQL queries
• Experience working with data migration projects, especially when related to data integrity and accuracy.
• Experience working in agile projects, using Jira, creating user stories, and overall knowledge of the agile framework.

· Onsite Requirements: 3 days onsite at client location in San Jose, CA.

· Personal leadership and a desire to create a culture that enables exceptional outcomes

· The embodiment of Cognizant’s Core Values of: Start with a point of view; Seek data, build knowledge; Always strive, never settle; Work as one; Create conditions for everyone to thrive; Do the right thing, the right way.

Work Authorization

· Cognizant will only consider applicants for this position who are legally authorized to work in the United States without company sponsorship (H-1B, L-1B, L-1A, etc.)

Salary and Other Compensation:

The annual salary for this position is between $134,000 - $180,000 depending on experience and other qualifications of the successful candidate.

This position is also eligible for Cognizant’s discretionary annual incentive program, based on performance and subject to the terms of Cognizant’s applicable plans.

Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:

• Medical/Dental/Vision/Life Insurance
• Paid holidays plus Paid Time Off
• 401(k) plan and contributions
• Long-term/Short-term Disability
• Paid Parental Leave
• Employee Stock Purchase Plan

Disclaimer: The hourly rate, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.