Lead Data Modeler

Job Overview: Job Details Description Job Description: We are seeking a dynamic and detail-oriented BI Data Modeler to join our team. The ideal candidate will be responsible for working closely with various departments to scope and drive enterprise data models to meeting organization reporting and analytics needs. This role requires a proactive individual with strong data modeling skills, excellent communication abilities, and a deep understanding of business processes. You will work with key business representatives, data owners, end users, application designers and data architects to ensure current and new data is modeled and optimized to meet business goals. You will need to understand various source systems and how the data support key business processes. You will help develop new and modify existing data models to support data engineering activities and conduct business process analysis and requirements gathering to develop formal data structures. You should have a strong background in Databricks, Power BI Semantic Models, DAX, SQL and Python. Experience and/or ability to develop ML and AI Models is preferred Key Responsibilities: Collaborate with Data Ingestion team to design and develop “Gold” layer within a Medallion Architecture. Design and implement proper data security and data masking standards, processes and solutions across the various data stores and reporting layers within the Primoris BI platforms. Build and execution of enterprise level data models using various data sources as needed for reporting business analytics in Power BI. Collaborate with business leaders to identify and prioritize data analysis and platform enhancement needs. Collaborate with business analytics teams and business leaders to determine need for composite data models to fulfill business needs/requirements. Communicate structure of models to visualization and business analytics team. Ability to write complex DAX code and SQL queries for data manipulation. Resolve and/or facilitate resolution of problems including identifying cause to prevent re-occurrence. Identify and resolve business issues, escalate issues when appropriate. Assist in evolution of ML and AI Model development processes and responsibilities. Demonstrated experience leading technical code reviews for DAX and SQL, and facilitating elaboration or design review discussions Proven ability to drive and implement end‑to‑end process improvements that strengthen data modeling practices, governance, and delivery efficiency Qualifications: Bachelor’s degree in business administration, Information Technology, or a related field. 2+ years of experience using methods and tools to ensure data quality, producing data that has the correct state of completeness, validity, consistency, timeliness and accuracy. 2+ years of experience using systematic approaches to organize, structure and prepare data models for analysis Demonstrated experience using artificial intelligence and AI enabled platforms for data modernization work AI LLM use cases including CoPilot, ChatGPT and Gemini. Experience delivering work with Agile/Scrum practices & software release cycle Proficient in Azure, Databricks, SQL, Python, Power BI and DAX Good knowledge on CICD, deployment process 3+ years of experience working with clients and client deliverables on tight deadlines Prior experience working on projects of similar size and scope Ability to work independently and as part of a team Skills and Competencies: Exceptional organizational and time management skills. Ability to manage stakeholders’ expectations and influence decisions. High attention to detail and a commitment to quality. Strong leadership and team-building capabilities. Ability to adapt to changing priorities and work under pressure. Working Conditions: This position may require occasional travel. Flexible work hours may be necessary to accommodate project deadlines. Company Overview: For nearly six decades, Primoris has built a reputation for taking on challenges that others will not – setting the bar ever higher for ourselves and our industry with each project. Now, as we build a sustainable infrastructure that supports the growing needs of the nation – and the world – we reaffirm innovation, quality, service, and safety as our core values. And we remind ourselves that the pioneering spirit of yesteryear fuels the imagination of today. Primoris Services Corporation (Primoris) is ranked in the top 10% of the prestigious Top 400 Contractors List by Engineering News Record (ENR), having built projects throughout the United States as well as Latin America, South and Central America, and South East Asia. We build great projects because we have built a great company – and insist on great performance. And that’s a product of our people, passion, and partners. Agency Statement: We are not accepting resumes from Third Party Recruiting Firms for this position. If you are an Agency or Search firm representative, contact the Primoris Talent Acquisition Manager directly for consideration. Primoris or its subsidiaries will not be responsible for any fees arising from the use of resumes and online response forms through this source. In addition, Primoris or its subsidiaries will not be responsible for any fees on unsolicited resumes that are submitted to any member of the Staffing or Operations team. Primoris has established an approved vendor program for this service and will only consider accepting submissions from those approved firms. Company Overview: Primoris Services Corporation is a premier specialty contractor providing critical infrastructure services to the utility, energy, and renewables markets throughout the United States and Canada. Built on a foundation of trust, we deliver a range of engineering, construction, and maintenance services that power, connect, and enhance society. On projects spanning utility-scale solar, renewables, power delivery, communications, and transportation infrastructure, we offer unmatched value to our clients, a safe and entrepreneurial culture to our employees, and innovation and excellence to our communities. To learn more, visit www.prim.com and follow us on social media at @PrimorisServicesCorporation. Benefits: 401k w/employer match Health/Dental/Vision insurance plans Paid time off 10 paid holidays Stock purchase plan EEO Statement We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law. Agency Statement We are not accepting resumes from Third Party Recruiting Firms for this position. If you are an Agency or Search firm representative, contact the Primoris Talent Acquisition Manager directly for consideration. Primoris or its subsidiaries will not be responsible for any fees arising from the use of resumes and online response forms through this source. In addition, Primoris or its subsidiaries will not be responsible for any fees on unsolicited resumes that are submitted to any member of the Staffing or Operations team. Primoris has established an approved vendor program for this service and will only consider accepting submissions from those approved firms. For consideration in becoming an approved vendor, contact HR. Equal Opportunity Employer This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.