Data Analyst/Data Engineer

Seeking a dedicated Data Analyst/Engineer to support our Data Governance objectives including Data Modeling, Data Dictionary build out, Data Profiling, Violation tracking, and Data Steward Organization engagement.

Key Responsibilities

1. Product Data Modeling and Profiling Support

The Data Analyst will support the development of Data Sub Models and Tableau Physical Data Models for assigned product areas. Responsibilities include:

Review Mendix Pro data models for assigned products.

Review related Postgres tables and identify relevant data structures.

Reverse engineer Product Data Sub Models in ER Studio Pro.

Meet with SAT teams, Process Owners, Business SMEs, Data Stewards, and Data Custodians to clarify data definitions, relationships, usage, and business rules.

Publish ER Studio data models and supporting documentation.

Work independently and collaboratively with other Data Governance stakeholders on Tableau Physical Data Models.

Create high-level profiling visualizations for each assigned product area. Profiling reports are intended to summarize issues and provide detail on data violations so Data Stewards and Data Custodians can act on remediation.

1. Product Violation Identification and Tracking

The Data Analyst will support the identification, documentation, and tracking of Product Violations.

Responsibilities include:

Identify and document product-level business rules.

Document data violations and related business impacts.

Specify queries needed to identify violations in the Business Rules and Specification document.

Support creation and maintenance of Business Rules and Specification documents for each DSO and its profiling reports.

Assist with logging and tracking data violations through the Issue Tracking Ledger.

Support preparation of violation and status reporting before monthly DSO review meetings.

1. Data Steward Organization Support and Socialization

The Data Analyst will help stand up new Data Steward Organizations and support ongoing engagement with Business Units. Responsibilities include:

Support DSO meetings focused on business rules, pain points, violations, and requests for information.

Support remediation planning. TRS s DSO model defines Business Owners as final decisionmakers on business rules, violation assignments, and parameters.

Help ensure issues are reviewed, updated, and closed through recurring DSO meetings. TRS procedures state that DSOs meet monthly to discuss, review, and close recorded issues, add

new issues, and review data quality metrics.

Promote business engagement and shared accountability for data quality across product areas.

At least 10+ years experience with solid data analysis, data migration and data analytics skills

Strong experience in data analysis, data profiling, and data quality assessment.

Experience reviewing and interpreting logical and physical data models.

Proficiency with relational databases, SQL, and PostgreSQL.

Experience with data modeling tools; ER/Studio Pro preferred.

Experience with Tableau or similar BI and reporting platforms.

Ability to translate business rules and requirements into data quality checks, SQL queries, and reporting specifications.

Strong documentation skills, including business rules, data definitions, functional specifications, and issue documentation.

Ability to facilitate and communicate effectively with technical teams, Business SMEs, Process Owners, Data Stewards, and Data Custodians.

Working knowledge of data governance, data quality, data stewardship, and issue remediation practices.

Experience supporting enterprise-level Data Governance programs.

Experience with product-based data modeling, application modernization, or data transformation initiatives.

Familiarity with Mendix Pro data models.

Experience developing data quality dashboards, KPI reporting, and data profiling reports.

Experience using issue tracking and workflow management tools, such as Microsoft Azure DevOps or similar platforms.