Data Management - SQL & Python
Capgemini · New York, United States
- On site
- Full-time
- $87,556 / year
- New York, United States
Job highlights
- Manage data systems and document data lifecycle controls.
- Gather business requirements and plan projects.
- Analyze data, identify improvements, and present insights.
- Ensure regulatory compliance for financial processes.
- Requires 4-6 years' consulting experience with client skills.
About the role
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
Skills & topics
- Data Management
- SQL
- Python
- Data Modeling
- Data Engineering
- Snowflake
- AWS
- Regulatory Reporting
- Process Improvement
- Consulting
- Hybrid
- NYC
How to get hired
- Tailor your resume: Highlight your experience with Python, SQL, data modeling, and data engineering, especially within a consulting context.
- Showcase client-facing skills: Emphasize your ability to present insights to non-technical audiences and work independently.
- Demonstrate regulatory knowledge: Mention experience with SOX, RCSA, FCC, and financial regulatory frameworks like Basel III.
- Prepare for hybrid interviews: Be ready to discuss your technical skills and problem-solving approach for data management challenges.
Technical preparation
Practice complex SQL queries and data manipulation.,Build Python scripts for data engineering tasks.,Model data structures for Snowflake or similar platforms.,Review AWS services for data management.
Behavioral questions
Describe a complex data problem you solved.,How do you present technical data to non-experts?,Share an experience documenting business processes.,How do you manage client expectations and deadlines?
Frequently asked questions
- What is the work arrangement for the Data Management Specialist role at Capgemini in NYC?
- The Data Management Specialist role in NYC is a hybrid position. While it requires day one onsite presence, it offers a hybrid work arrangement, allowing for a balance between in-office and remote work.
- What specific technical skills are most critical for this Data Management Specialist position?
- Proficiency in Python and SQL is essential. Additionally, strong skills in data modeling, data engineering, and experience with platforms like Snowflake, AWS Databricks, Apache, and Druid are highly valued for this role.
- What kind of experience is required for the Data Management Specialist job at Capgemini?
- We are looking for candidates with 4-6 years of relevant experience in data management and data governance, preferably within a consulting background. Strong client-facing skills and a solid understanding of regulatory frameworks are also key.
- How does Capgemini support employee well-being for this Data Management Specialist role?
- Capgemini offers comprehensive support for employee well-being, including flexible work options, extensive healthcare benefits (dental, vision, mental health), financial wellness programs, generous paid time off, and family-building benefits.
- What is the expected compensation range for the Data Management Specialist role in NYC?
- The base compensation range for this role in NYC is between $56,186 and $87,556 annually. Actual compensation will depend on factors such as experience, qualifications, and geographic location.
- Does Capgemini offer opportunities for professional development for a Data Management Specialist?
- Yes, Capgemini provides robust mentoring, coaching, and learning programs designed to support career growth and development for all employees, including those in data management roles.