Consultant, Data Engineer - Reference Data Management
Job Description
Nationwide is seeking a Consultant, Data Engineer focused on reference data management. The role configures, integrates, and operates the Semarchy reference data management platform to support governed product and fund reference data, delivery to enterprise consumption paths, and extension of data strategy into additional domains.
Responsibilities
- Partner with business data owners and stewards to understand reference data needs, then translate decisions into Semarchy models including product and fund entities, attributes, relationships, and hierarchies.
- Configure validation and match/merge rules and author approval workflows to ensure updates follow agreed business rules and stewardship practices.
- Recommend role and access patterns for contributors, reviewers, and approvers; support adoption for new domains and users.
- Build and operate data loads and integrations that bring product and fund reference data from source systems into Semarchy, and deliver approved outputs to Snowflake as the primary downstream consumption path, while supporting other required integrations.
- Maintain governed views and APIs so consumers do not need coupling to Semarchy internal tables, including support for applications that retrieve current, approved fund codes.
- Monitor pipelines, investigate failures, and reconcile records across sources, Semarchy, and destinations, adding checks for accuracy, completeness, and timeliness.
- Break requirements into technical tasks, estimate delivery timelines, and apply secure engineering practices as data flows and integrations are built and maintained.
- Work with data owners and stewards to document definitions and identify critical data elements, such as clarifying what product and fund codes represent and the rules they must meet.
- Support quality profiling, lineage, metadata, and documentation so users can understand data origin, meaning, and intended usage.
- Embed governance standards into Semarchy workflows and quality checks, partnering with governance teams to address data issues and support adoption.
- Consult on complex data product efforts by analyzing moderate to complex end-to-end data product requirements and existing business processes to lead design, development, and implementation.
- Produce data building blocks, data models, and data flows for client needs including dimensional data, standard and ad hoc reporting, data feeds, dashboard reporting, and data science research and exploration.
- Translate business data stories into a technical breakdown structure and work estimates to evaluate value, fit, and delivery for schedules or sprints.
- Apply secure software and systems engineering practices throughout the delivery lifecycle to protect data and technology solutions from threats and vulnerabilities.
- Create business user access methods to structured and unstructured data using techniques such as mapping data to a common data model, NLP, transforming data to satisfy business rules, AI, statistical computations, and validation of data content.
- Build data cleansing, imputation, and standardization routines by using data profiling and source data change monitoring, extraction, ingestion, and curation data flows.
- Facilitate medium- to large-scale data engineering using cloud technologies including Azure and AWS (for example, Redshift, S3, EC2, Data-pipeline, and other big data technologies).
- Collaborate with the enterprise DevSecOps team and other internal organizations on CI/CD best practices using tools such as JIRA, Jenkins, and Confluence.
- Implement production processes and systems to monitor data quality, ensuring production data remains accurate and available for key stakeholders and dependent business processes.
- Develop and maintain scalable pipelines for streaming and batch requirements, including new API integrations to support growing data volume and complexity.
- Write and execute data unit and integration tests focused on data quality, creating test data and scripts based on business requirements and stories, and building automated and reusable testing programs.
- Use code management and integrate with engineering Git repositories and practices.
- Serve as an expert and leader in team activities related to data analysis, architecture, application design, coding, and testing.
- Lead design decisions for complex data pipelines, integration patterns, and reusable engineering components across products, platforms, or domains.
Requirements
- Undergraduate studies in computer science, management information systems, business, statistics, math, a related field, or comparable experience and education strongly preferred.
- Graduate studies in business, statistics, math, computer science, or a related field are a plus.
- Six to ten years of relevant experience with data quality rules and data management organization standards and practices.
- Solid software development experience on large and/or concurrent projects.
- Experience in data warehousing, statistical analysis, data models, and queries.
- One to three years of experience developing compelling stories and distinctive visualizations.
- Advanced skills with modern programming and scripting languages such as 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 not required but encouraged.
- Insurance and 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, and vision coverage
- Life insurance
- Short and long term disability coverage
- Paid time off (minimum 18 days per 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 principal and essential functions; specific circumstances may allow or require some people assigned to perform a somewhat different combination of duties.
Location and Experience
- Location: Columbus, OH (hybrid)
- Minimum Experience: 6 years