Consulting Manager – Data Analyst, Cognizant Consulting
Banking & Financial Services
San Fransisco, CA
ABOUT US
Cognizant is one of the world's leading professional services companies, transforming clients' business, operating, and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build, and run more innovative and efficient businesses. Headquartered in the U.S., Cognizant, a member of the NASDAQ-100, is ranked 195 on the Fortune 500 and is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital at www.cognizant.com.
COGNIZANT CONSULTING
Within Cognizant is Cognizant Consulting, a global consulting organization delivering strategic and domain consulting through industry and technology expertise. With over 6,000 consultants worldwide, Cognizant offers high-value consulting services that improve business performance and operational productivity, lower operational expenses and enhance overall performance. Clients draw upon our deep industry expertise, program and change management capabilities, and analytical objectivity to help improve business productivity, drive technology-enabled business transformation and increase shareholder value. We provide a number of Business/IT Consulting Services including Business Strategy, IT Strategy & Roadmap Development, Process Re-Engineering & Transformation, Enterprise Architecture & Technology Selection, and Domain Solutions. The Cognizant Consulting team is a high performing organization that is continually expanding our client base and increasingly being recommended by analysts such as Forrester and Gartner. And we’re growing!
The Role
Our banking and financial services group is looking for a 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 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
- 7 + 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 Francisco, 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 $110,000 - $149,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 salary, 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.
コグニザントのコミュニティ
コグニザントは、クライアントのビジネス、運営、技術モデルをデジタル時代に合わせて変革する、世界有数のプロフェッショナルサービス企業の一つです。私たちの独自の業界ベースのコンサルティングアプローチは、クライアントがより革新的で効率的なビジネスを構想し、構築し、運営するのを支援します。米国に本社を置くコグニザント（NASDAQ-100のメンバーであり、Forbesの2024年世界最高の雇用者の一つ）は、常に世界で最も称賛される企業の一つに挙げられています。コグニザントがどのようにしてクライアントがデジタルでリードするのを支援しているかについては、www.cognizant.comをご覧ください。
- コグニザントは世界中に300,000+上の社員を擁するグローバルな会社会社です。
- 私たちはより良い方法を考えるだけでなく、それを実現していきます。
- 私たちは正しいことを行うことで、社員、顧客、会社、地域社会に貢献します。
- キャリアを築いていくことができる革新的な環境を育んでいきます。
コグニザントについて
コグニザント（Nasdaq-100: CTSH）は世界有数のプロフェッショナル・サービス企業であり、企業がテクノロジーの近代化、プロセスの再構築、エクスペリエンスの変革を実現し、変化の激しい世界で優位に立てるよう支援しています。
コグニザントは機会均等雇用を実践しています。応募および候補者としての選考は、人種、肌の色、性別、宗教、信条、性的指向、性自認、国籍、障がい、遺伝情報、妊娠、退役軍人としての地位、または連邦法、州法、もしくは地方自治体の法律で保護されているその他の特性に基づいて行われることはありません。
求人情報の検索や応募書類の提出に配慮を必要とする障害をお持ちの方は、[email protected] までご要望と連絡先をお知らせください。
免責事項
報酬情報は、この掲載日現在のものです。コグニザントは、適用される法律に従い、いつでもこの情報を修正する権利を有します。
応募者は面接に直接またはビデオ会議で出席する必要がある場合があります。また、各面接時に身分証明書の提示を求められる場合があります。