DeveloperJobs.io
← Back to all jobs

Job Description

Nationwide is seeking a Consultant, Data Engineer to configure, integrate, and operate the Semarchy reference data management platform for governed product and fund reference data. This hybrid role in Columbus, OH focuses on data stewardship enablement, governance-ready implementations, and delivery of approved reference data to enterprise consumption.

Role Overview

You will translate reference data decisions into Semarchy models, implement validation and stewardship workflows, and maintain governed views and APIs used by downstream applications. The role includes building and operating data loads and integrations, monitoring and reconciling data quality across sources and destinations, and supporting enterprise data strategy expansion into additional domains.

Responsibilities

  • Partner with business data owners and stewards to capture reference data needs and convert outcomes into Semarchy models, including product and fund entities, attributes, relationships, and hierarchies.
  • Configure validation and match/merge rules, and implement authoring and approval workflows that reflect agreed business rules and stewardship practices.
  • Recommend practical role and access patterns for data creators, reviewers, and approvers, and support onboarding for new domains and users adopting the platform.
  • Build and operate data loads and integrations to bring product and fund reference data from source systems into Semarchy and deliver approved data to Snowflake as a primary consumption path, while supporting other required integrations.
  • Maintain governed views and APIs to provide access without exposing consumers to Semarchy internal tables, including support for applications retrieving current, approved fund codes.
  • Monitor pipelines, investigate failures, and reconcile records across sources, Semarchy, and destinations, with checks for accuracy, completeness, and timeliness.
  • Decompose requirements into technical work, estimate delivery, and apply secure engineering practices throughout build and maintenance of data flows and integrations.
  • Work with data owners and stewards to document definitions and identify critical data elements, such as clarifying meaning and rules for product or fund codes.
  • Support quality profiling, lineage, metadata, and documentation so users can understand origin, meaning, and proper usage of reference data.
  • Embed governance standards in Semarchy workflows and quality checks, partnering with governance teams to address issues and support adoption.
  • Consult on complex data product projects by analyzing moderate to complex end-to-end requirements and existing business processes to lead design, development, and implementation.
  • Produce data building blocks, data models, and data flows for client demands including dimensional data, standard and ad hoc reporting, data feeds, dashboard reporting, and data science research and exploration.
  • Translate business data stories into technical story breakdown structures and work estimates to assess value and fit for a schedule or sprint.
  • Apply secure software and systems engineering practices across the delivery lifecycle to protect data and technology solutions from threats and vulnerabilities.
  • Create business user access methods to structured and unstructured data by mapping data to a common data model, applying transformations as needed to satisfy business rules, and supporting AI, statistical computations, and data validation.
  • Build data cleansing, imputation, and standardization routines by understanding business and source system data practices, using profiling and source change monitoring, and designing extraction, ingestion, and curation flows.
  • Facilitate medium- to large-scale data engineering using cloud technologies including Azure and AWS (e.g., Redshift, S3, EC2, Data-pipeline and other big data technologies).
  • Collaborate with the enterprise DevSecOps team and internal organizations on CI/CD best practices, including experience with JIRA, Jenkins, and Confluence.
  • Implement production processes and systems to monitor data quality so production data remains accurate and available for key stakeholders and dependent business processes.
  • Develop and maintain scalable data pipelines for streaming and batch requirements, and build new API integrations to support growth in data volume and complexity.
  • Write and run data unit and integration tests for data quality by creating and executing test data and scripts aligned to business requirements, with automation for reusable test components and future code changes.
  • Practice code management and integration using engineering Git principle and practice repositories.
  • Participate as an expert, leader, and learner in team tasks across data analysis, architecture, application design, coding, and testing practices.
  • Lead design decisions for complex data pipelines, integration patterns, and reusable engineering components within a product, platform, or domain.

Minimum Requirements

  • Undergraduate studies in computer science, management information systems, business, statistics, math, a related field, or comparable experience and education strongly preferred.
  • Six to ten years of relevant experience with data quality rules, data management organization, standards, and practices.
  • Solid experience with software development on large and/or concurrent projects.
  • Experience in data warehousing, statistical analysis, data models, and queries.
  • Advanced programming and scripting skills (e.g., SQL, R, Python, Spark, UNIX Shell scripting, Perl, or Ruby).
  • Strong problem-solving and verbal and written communication skills.
  • Ability to influence, build relationships, negotiate, and present to senior leaders.
  • Certifications are not required but encouraged.

Preferred Qualifications

  • Graduate studies in business, statistics, math, computer science, or a related field are a plus.
  • One to three years’ experience developing compelling stories and distinctive visualizations.
  • Insurance/financial services industry knowledge is a plus.

Technologies

  • Semarchy, Snowflake, SQL
  • R, Python, Spark
  • UNIX Shell scripting, Perl, Ruby
  • Azure, AWS, Redshift, S3, EC2, Data-pipeline
  • NLP, AI
  • JIRA, Jenkins, Confluence
  • Git

Benefits

  • Medical/dental/vision
  • Life insurance
  • Short and long term disability coverage
  • Paid time off (minimum of 18 days paid time off each full calendar year pro-rated quarterly based on hire date)
  • Nine paid holidays
  • 8 hours of Lifetime paid time off
  • 8 hours of Unity Day paid time off
  • 401(k) with company match
  • Company-paid pension plan
  • Business casual attire

Job Conditions

  • Working Conditions: Hybrid to normal office environment.
  • Overtime Eligibility: Exempt (Not Eligible).
  • ADA: Statements cover generally believed principal and essential functions; specific circumstances may allow or require some people to perform a somewhat different combination of duties.

Similar Jobs