Senior BI Data Modeler

Overview

We are seeking a highly skilled Data Modeler / BI Developer to join our team. This role will focus on designing and implementing enterprise-level data models, ensuring data security, and enabling advanced analytics capabilities within our Primoris BI platforms. The ideal candidate will have strong technical expertise, excellent problem-solving skills, and the ability to collaborate effectively with cross-functional teams.

Key Responsibilities

• Collaborate with the Data Ingestion team to design and develop the “Gold” layer within a Medallion Architecture.
• Design and implement data security and masking standards, processes, and solutions across various data stores and reporting layers.
• Build and execute enterprise-level data models using multiple data sources for business analytics and reporting in Power BI.
• Partner with business leaders to identify and prioritize data analysis and platform enhancement needs.
• Work with analytics teams and business leaders to determine requirements for composite data models.
• Communicate data model structures to visualization and analytics teams.
• Develop and optimize complex DAX expressions and SQL queries for data manipulation.
• Troubleshoot and resolve issues, identifying root causes to prevent recurrence.
• Escalate critical issues when appropriate and ensure timely resolution.
• Contribute to the evolution of Machine Learning (ML) and AI model development processes.

Qualifications

• Bachelor’s degree in Business Administration, Information Technology, or a related field.
• 2 years experience ensuring data quality (completeness, validity, consistency, timeliness, accuracy).
• 2 years experience organizing and preparing data models for analysis using systematic approaches.
• Demonstrated experience with AI-enabled platforms for data modernization.
• Experience delivering work using Agile/Scrum practices and software release cycles.
• Proficient in Azure, Databricks, SQL, Python, Power BI, and DAX.
• Good knowledge of CI/CD and deployment processes.
• 3 years experience working with clients and delivering under tight deadlines.
• Prior experience with projects of similar size and scope.
• Ability to work independently and collaboratively in a team environment.

Skills & Competencies

• Exceptional organizational and time management skills.
• Ability to manage stakeholder expectations and influence decisions.
• High attention to detail and commitment to quality.
• Strong leadership and team-building capabilities.
• Ability to adapt to changing priorities and work under pressure.