Analytics Data Modeler

Department: Enterprise Analytics Department

Reports To: Enterprise Analytics Manager

Classification: Exempt

About Rogue Credit Union:

Rogue Credit Union is a member-owned, not-for-profit financial cooperative headquartered in the Rogue Valley located in beautiful southern Oregon. Providing services to our members in select Oregon and Idaho counties. We strive to make an impact in the communities we serve by living, giving, and supporting local. Our mission is to provide exceptional member experiences that build mutually beneficial relationships to create the most loyal members in the nation. Here at Rogue, we believe in having a culture of happy team members who feel supported, have the chance to grow their careers, and LOVE where they work!

Role:

The Analytics Data Modeler is responsible for designing and maintaining the semantic data layer and analytics catalog that support governed, scalable, and business-aligned reporting and analytics across Rogue Credit Union. This role serves as the product owner of the semantic layer and data/analytics catalog, translating business definitions into technical requirements and enabling trusted, self-service insights. The Data Modeler collaborates closely with Analytics Engineers, BI Analysts, and business stakeholders to ensure consistent terminology, validated metrics, and high-quality data models that support strategic decision-making.

Essential Functions & Responsibilities:

30% Design, build, and maintain semantic models that support enterprise reporting and analytics. Define KPIs, measures, hierarchies, and dimensions with clear business logic that aligns with governance-approved definitions. Optimize models for scalability, query performance, and ease of use in BI tools such as Tableau Server, Tableau Cloud and Power BI. Continuously refine models based on stakeholder feedback and evolving business needs.

25% Engage directly with business stakeholders to validate terminology, definitions, and reporting logic. Document business requirements in a way that can be translated into technical specifications for Analytics Engineers to develop master data. Act as a bridge between technical and non-technical teams, ensuring semantic models accurately reflect the business use case.

15% Administer and curate the enterprise analytics catalog, ensuring all semantic models and datasets include complete metadata (definitions, lineage, and usage notes). Maintain glossary entries and steward assignments. Manage certification workflows so users can distinguish between exploratory data sources and trusted, production-ready models.

10% Contribute to data governance efforts by aligning semantic models with enterprise data definitions and quality standards. Support impact analysis by documenting dependencies across datasets, models, and reports. Partner with stewards and governance bodies to ensure data quality, consistent reporting logic, and alignment in terminology across the credit union.

10% Collaborate with the Data Architect and Analytics Engineers to integrate semantic models into the enterprise data platform. Ensure compatibility with Microsoft Fabric, Lakehouse/OneLake, Tableau Cloud, and Power BI. Participate in architecture testing, deployment, and versioning processes to ensure smooth adoption of future platform enhancements.

5% Assist with configuration of analytics tools to support metadata and governance needs. Contribute to metadata alignment efforts across Tableau’s Data Management Add-On, Microsoft Purview, and related tools. Ensure metadata in these systems remains synchronized with the analytics catalog and semantic models.

5% Proactively performs other duties as needed or assigned.

Knowledge & Skills:

Experience: The role requires three to five years of experience in data modeling, metadata management, or analytics engineering, with a proven ability to translate business requirements into technical specifications. It involves designing and managing semantic data models in Microsoft Fabric or a similar platform, including building semantic layers and collaborating with business stakeholders to ensure alignment on terms, definitions, and reporting logic. Familiarity with BI tools such as Tableau and Power BI, SQL-based environments like SQL Server and Oracle SQL Developer, and data cataloging platforms such as Alation, Collibra, or Atlan is essential. Experience in financial services is preferred.

Education: (1) A bachelor's degree, or (2) achievement of formal certifications recognized in the industry as equivalent to a bachelor's degree (e.g., information technology certifications in lieu of a degree).

Interpersonal Skills: Work involves much personal contact with others inside and/or outside the organization for the purpose of first-level conflict resolution, building relationships, and soliciting cooperation. Discussions involve a higher degree of confidentiality and discretion, requiring diplomacy and tact in communication.

Other Skills: The role requires strong SQL skills with experience in relational databases such as SQL Server and Oracle, along with proficiency in Tableau (including the data management add-on), Knime, and metadata tools. Familiarity with Microsoft Fabric, Lakehouse/OneLake, and Purview is important, as well as an understanding of data governance, cataloging, and semantic modeling best practices. Experience with data modeling tools like dbt, or similar is expected, combined with excellent communication, documentation, and stakeholder engagement skills.

Physical Requirements: Some lifting required (up to 30 pounds), continuous sitting, occasional standing and occasional walking. Finger dexterity while using computer. Occasional talking and hearing in person and on the telephone. Continuous clarity of vision at 20 inches or less and continuous clarity of vision at 20 feet or more.

Work Environment: This job is an exempt position that requires flexibility in scheduling tasks and projects. The employee must independently monitor hours and judge the time needed to be spent on applicable duties. Employee must be capable of adjusting to unpredictable schedules proactively. As a direct representative of the Credit Union, the employee must conduct and present themselves courteously and professionally. Exposed to potentially hazardous conditions, i.e., robbery.

Disclaimer:

Rogue Credit Union is a drug free workplace and requires a drug screening test within 48 hours of employment offer.

Rogue Credit Union is an Equal Opportunity Employer and makes employment decisions without regard to race, color, national origin, religion, sex, age, disability, veteran status, or any other protected class. If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process or are limited in the ability or unable to access or use this online application process and need an alternative method, please call (541) 622-7295.

This Job Description is not a complete statement of all duties and responsibilities comprising the position.