Consultant, Data Engineer, Reference Data Management

What you'll do

• Translate business requirements into Semarchy platform models, including product and fund entities, attributes, and hierarchies.
• Configure validation rules, match/merge logic, and authoring workflows to ensure data follows agreed stewardship practices.
• Build and operate data loads and integrations to move reference data from source systems into Semarchy and Snowflake.
• Maintain views and APIs to provide governed access to approved data for downstream applications.
• Monitor data pipelines, investigate failures, and reconcile records to ensure accuracy, completeness, and timeliness.
• Document data definitions, lineage, and metadata to help users understand data origins and usage rules.
• Develop and maintain scalable data pipelines for both streaming and batch requirements using cloud technologies.
• Write and perform unit and integration tests to validate that data quality criteria are satisfied.

What we're looking for

• Undergraduate studies in computer science, management information systems, business, statistics, math, or a related field are 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, 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.
• One to three years of experience with 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.
• Work authorization.