Associate Data Modeler

PCCA • Houston, TX

74d

About The Position

We are seeking an Associate Data Modeler to join our data management and analytics team. This role is ideal for professionals with strong practical experience in the Microsoft ecosystem who are ready to grow in formal data modeling theory and dimensional design. The Associate Data Modeler will bridge business requirements with technical implementation, ensuring data structures are well-designed, documented, and aligned with organizational goals. Structured mentorship and training in advanced dimensional modeling will be provided.

Requirements

• Education: Bachelor's degree in Computer Science, Information Systems, or related discipline (or equivalent experience).
• Experience: Typically 3 years in a data-focused role (e.g., data analyst, BI developer, junior modeler, ETL developer).
• Foundational understanding of data modeling principles, with willingness to develop full conceptual → logical → physical modeling skills.
• Proficient in SQL with the ability to query, validate, and troubleshoot datasets.
• Experience with Power BI data modeling and eagerness to learn formal dimensional modeling (star/snowflake schemas, fact/dimension tables, slowly changing dimensions).
• Working knowledge of at least one major RDBMS (SQL Server, Oracle, PostgreSQL, MySQL, etc.).
• Experience using or learning a modeling tool such as ERwin, ER/Studio, PowerDesigner, Lucidchart, dbt semantic layer, Power BI Model View, Tabular Editor, or similar.
• Ability to document data entities and business rules clearly for both technical and non-technical audiences.
• Strong collaboration skills with the ability to work under guidance and incorporate feedback.

Nice To Haves

• Extensive experience with Microsoft ecosystem, including Power BI (semantic modeling, DAX optimization, dataflows, relationships, measures).
• Power Platform tools.
• Azure Services (Fabric Lakehouse, Fabric Warehouse, integration with OneLake).
• Familiarity with data governance frameworks, data lineage, and stewardship.
• Basic knowledge of performance optimization for semantic models (DAX best practices, partitioning strategies).

Responsibilities

• Assist in the design and maintenance of conceptual, logical, and physical data models, building skills through mentorship and structured training.
• Participate in formal data modeling training programs to strengthen theoretical foundations.
• Normalize and denormalize data structures where appropriate.
• Support the creation of data dictionaries, entity-relationship diagrams, and metadata.
• Collaborate with business analysts, developers, and data engineers to translate business requirements into draft Power BI and database models.
• Validate models by writing and running SQL queries and participating in peer design reviews.
• Ensure models adhere to naming standards, data governance policies, and version control practices.
• Contribute to documenting business rules and attribute definitions for key subject areas.
• Provide input on data integration and ETL/ELT design needs.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Industry: Health and Personal Care Retailers
• Education Level: Bachelor's degree
• Number of Employees: 251-500 employees