Data Management Specialist SQL Python

About Capgemini

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.

Job Location

NYC NY (Day One Onsite - Hybrid)

Roles and Responsibilities

• Understand data and data systems including IT tools and technology.
• Document and identify key controls within data lifecycle.
• Gather and document process and business requirements, able to provide scope and project planning.
• Conduct interviews, surveys, and workshops to gather data needs.
• Present insights clearly and concisely to nontechnical audiences.
• Identify opportunities for process improvements through workshopping sessions and process flows.
• Understanding of data controls and data management (SOX, RCSA, etc.) for Regulatory, FCC, Sanctions related business processes.
• Create gap assessments on the current state of business processes and design/implement target state in alignment with regulatory reporting policies.
• Ensure all processes are aligned with both internal policy and external regulatory requirements.
• Track and document process changes and ensure alignment with evolving regulatory standards.

Required Skills

• Python, SQL, Data modelling, Data engineering, Snowflake, AWS Databricks, Apache, Druid, Tableau, Alteryx

Primary Skills

• Basic understanding of liquidity regulatory frameworks (e.g., Basel III, LCR, NSFR).
• Proficiency in data analysis tools (e.g., Excel, SQL, or Python).
• Knowledge of financial systems and the flow of data for liquidity calculations and reporting.
• Experience in documenting business processes and creating process flow diagrams using BPMN.
• Familiarity with project management methodologies (e.g., Agile, Waterfall).
• 4-6 years of relevant experience covering data management and data governance.
• Must have worked in a consulting background.
• Strong client-facing skills and ability to work independently.
• Knowledge of data concepts, ADS processes, and ADS methodology.

Life At Capgemini

Capgemini Supports All Aspects Of Your Well-being Throughout The Changing Stages Of Your Life And Career. For Eligible Employees, We Offer:

• Flexible work.
• Healthcare including dental, vision, mental health, and well-being programs.
• Financial well-being programs such as 401(k) and Employee Share Ownership Plan.
• Paid time off and paid holidays.
• Paid parental leave.
• Family building benefits like adoption assistance, surrogacy, and cryopreservation.
• Social well-being benefits like subsidized back-up child/elder care and tutoring.
• Mentoring, coaching, and learning programs.
• Employee Resource Groups.
• Disaster Relief.

Key skills/competency

• Data Management
• SQL
• Python
• Data Modeling
• Data Engineering
• Snowflake
• AWS
• Regulatory Reporting
• Process Improvement
• Client Facing Skills