Responsible for acquiring, curating, and publishing data both on prem and in the cloud for analytical or operational uses for simple and basic scenarios. Ensures the data is in a ready-to-use form that creates a single version of the truth across all data consumers, including business/technology users, reporting and visualization specialists and data scientists with significant coaching and support. Utilizes skills to translate business analytic requests/requirements into design, development, testing, deployment, and production maintenance tasks. Utilizes knowledge of various technologies from big data, relational and non-relational databases, cloud environments, different programming languages and various reporting tools but requires training as needed.

Essential Job Functions

Consults on data projects of limited complexity, with coaching and guidance, to understand design requirement and existing business processes to lead in the design, development, and implementation of data products. Practices code management and integration with current architectural and data governance guidelines with oversight by leadership. Produces data building blocks, data models, and data flows for varying client requests such as dimensional data, standard and ad hoc reporting, data feeds, dashboard reporting, and data science research & exploration with assistance and coaching. Creates business user access methods to structured and unstructured data. Utilizes techniques such as mapping data to a common data model, natural language processing, transforming data as necessary to satisfy business rules, AI, statistical computations, and validation of data content. Translates business data stories into a technical story breakdown structure and work estimate for a schedule or planned agile sprint. Projects are basic in nature and require coaching and assistance from leadership. Develops and maintains simple scalable data pipelines for both streaming and batch requirements and builds out new API integrations to support increased demands of data volume and complexity. Preps/cleanses data to optimize for downstream reporting via Farmers standard visualization or AI/ML tools with significant coaching and feedback. Applies basic knowledge of data governance concepts with little to no experience in application. Executes on mid size projects within timelines. Executes on defined projects with some guidance. Performs other duties as assigned

Requirements

Stakeholder Management & Communication - Intermediate
Solution Design & Data Architecture - Intermediate
Data Modeling & Data Analysis - Intermediate
Technical Leadership & Mentoring - Intermediate

Software / Tool Skills

Python - Intermediate (4-6 Years)
AWS Glue / PySpark - Intermediate (4-6 Years)
SQL & Query Performance Tuning - Intermediate (4-6 Years)
Data Warehousing & Dimensional Modeling - Intermediate (4-6 Years)
REST API Integration - Intermediate (4-6 Years)

Benefits

Competitive compensation and benefits package:

1. Competitive salary and performance-based bonuses
2. Comprehensive benefits package
3. Career development and training opportunities
4. Flexible work arrangements (remote and/or office-based)
5. Dynamic and inclusive work culture within a globally renowned group
6. Private Health Insurance
7. Pension Plan
8. Paid Time Off
9. Training & Development

Note: Benefits differ based on employee level.

About Capgemini

Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology. The Group is guided everyday by its purpose of unleashing human energy through technology for an inclusive and sustainable future. It is a responsible and diverse organization of over 340,000 team members in more than 50 countries. With its strong 55-year heritage and deep industry expertise, Capgemini is trusted by its clients to address the entire breadth of their business needs, from strategy and design to operations, fueled by the fast evolving and innovative world of cloud, data, AI, connectivity, software, digital engineering and platforms. The Group €22.5 billion in revenues in 2023.

https://www.capgemini.com/us-en/about-us/who-we-are/