Data Relationship Analyst (Entry Level) (Remote)

Job_Summary:

R.W. Mercer Co. is seeking a Remote Data Relationship Analyst to identify, analyze, and manage relationships between data entities across systems and business domains. The role involves collaborating with various teams to ensure data accuracy and facilitate high-quality decision-making.

Responsibilities:

• Analyze data structures and define entity relationships across platforms (e.g., customer, product, transaction, vendor, or compliance data)

• Create and maintain data dictionaries, ERDs (entity relationship diagrams), and metadata documentation

• Collaborate with data engineers, analysts, and business users to ensure accurate and consistent relationships between datasets

• Map data flows and dependencies across systems and databases (e.g., ERP, CRM, data warehouse, cloud platforms)

• Support data governance efforts by defining and enforcing relationship integrity rules (e.g., referential integrity, cardinality)

• Participate in master data management (MDM), data lineage tracking, and data quality initiatives

• Conduct impact analyses when data structures change or when new systems are introduced

• Facilitate data integration and transformation logic for reporting and analytics use cases

• Recommend improvements to data models and reporting structures to enhance relational consistency

• Ensure documentation is up-to-date, accessible, and aligned with organizational data governance standards

Qualifications:

-Required:

• Bachelors degree in Information Systems, Data Science, Computer Science, Business Analytics, or related field

• 2 years of experience in data analysis, data modeling, or business systems analysis

• Proficiency in SQL and experience querying relational databases (e.g., MySQL, SQL Server, Oracle, PostgreSQL)

• Strong understanding of data relationships, primary/foreign keys, joins, normalization, and dimensional modeling

• Experience with data visualization or mapping tools (e.g., ER/Studio, Lucidchart, dbt, Power BI, Tableau)

• Excellent analytical, communication, and documentation skills

• Comfortable working remotely with cross-functional, distributed teams

Company:

R.W.