Associate Data Modeler en PCCA

What We're Looking For

What You Will Do

• 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.

Who You Are

Qualifications

• 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).

Core Skill Requirements

• 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.

Preferred Skills (Strongly Desired)

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).

Success Profile

The ideal candidate is…

Detail-oriented: Ensures models accurately represent requirements and are well-documented.

Growth-driven: Eager to learn and advance toward mid-level responsibilities with formal training and mentorship.

Collaborative: Works effectively on a team, seeks feedback, and contributes ideas.

Analytical: Applies critical thinking to spot inconsistencies and suggest improvements.

Strategic Note: This position is designed to support candidates with strong Microsoft experience and practical BI implementation backgrounds who want to deepen their formal dimensional modeling knowledge

Who We Are

PCCA helps pharmacists and prescribers create personalized medicine that makes a difference in patients’ lives. As a complete resource for independent and health system compounding pharmacists, PCCA provides high-quality products, education, and support to more than 3,000 pharmacies throughout the United States, Canada, Australia and other countries around the world. Incorporated in 1981 by a network of pharmacists, PCCA has supported pharmacy compounding for more than 40 years. Learn more at www.pccarx.com.