FBS Sr Data Engineer (SQL, Informatica) (Remote)

Capgemini; United States; Hybrid; USD 110,000 - 160,000; Full time

Benefits offered by this job

Competitive salary

Bonuses based on performance

Comprehensive benefits

Flexible remote/office options

Inclusive, dynamic culture

Private health insurance

Paid time off

Training & development opportunities

Job summary

Capgemini, operating as Employer of Record for Farmers operations, seeks a data-focused professional to acquire, curate, and publish data across on‑premises and cloud environments. You will translate business analytics requests into design, develop scalable data pipelines, data models, and data flows, and support AI/ML initiatives with strong governance and collaboration.

You will build data products for dashboards, reporting, and data science exploration, while coaching junior teammates and

Qualifications

• Experience translating business analytics requests into design and development tasks.
• Ability to build scalable data pipelines for streaming and batch data.
• Knowledge of data governance concepts and compliance guidelines.

Responsibilities

• Consult on data projects to understand design requirements and lead data product implementation.
• Develop advanced data blocks, models, and data flows for reporting and data science use.
• Create data access methods for structured and unstructured data and support API integrations.
• Coach junior associates and collaborate across dependencies to meet project timelines.
• Manage data projects from design to deployment with limited supervision.

Skills

Data pipelines

Data governance

Big data

APIs

AI/ML concepts

Natural language processing

Data modeling

Data visualization

Job description

FBS - Farmer Business Services is part of Farmers operations with the purpose of building a global approach to identifying, recruiting, hiring, and retaining top talent. By combining international reach with US expertise, we build diverse and high-performing teams that are equipped to thrive in today’s competitive marketplace.

We believe that the foundation of every successful business lies in having the right people with the right skills. That is where we come in- helping Farmers build a winning team that delivers consistent and sustainable results.

Since we don't have a local legal entity, we've partnered with Capgemini, which acts as the Employer of Record. Capgemini is responsible for managing local payroll and benefits.

What to expect on your journey with us:

• A solid and innovative company with a strong market presence

• A dynamic, diverse, and multicultural work environment

• Leaders with deep market knowledge and strategic vision

• Continuous learning and development

Summary:

Responsible for acquiring, curating, and publishing data both on prem and in the cloud for analytical or operational uses for moderate 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. Utilizes skills to translate business analytic requests/requirements into design, development, testing, deployment, and production maintenance tasks. Works independently with various technologies from big data, relational and non-relational databases, cloud environments, different programming languages and various reporting tools. Is beginning to provide coaching to junior associates.

Responsibilities:

Consults on data projects of varying complexity, with minimal 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 minimal oversight. Produces advanced 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 independently. 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 advanced with interaction across multiple dependencies. Coaching and assistance required on an as needed basis. Develops and maintains advanced to complex 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 coaching and assistance as requested. Applies extensive knowledge of data governance concepts and applies them across multiple scenarios. Delivers on complex projects with some vague timelines. Develops data project plans and executes independently. Performs other duties as assigned.

This position comes with a competitive compensation and benefits package.

• A competitive salary and performance-based bonuses.

• Comprehensive benefits package.

• Flexible work arrangements (remote and/or office-based).

• You will also enjoy a dynamic and inclusive work culture within a globally renowned group.

• Private Health Insurance.

• Paid Time Off.

• Training & Development opportunities in partnership with renowned companies.