BI and AI Data Modeler

Primoris Services; Dallas (TX); On-site; USD 95,000 - 145,000; Full time

Job summary

An established industry player is seeking a dynamic BI Data Modeler to enhance their data analytics capabilities. This role involves collaborating with various departments to develop and optimize enterprise data models that meet organizational reporting needs. The ideal candidate will possess strong skills in data modeling, SQL, and Python, and will be instrumental in driving data-driven decisions. Join a forward-thinking company that values innovation and offers a collaborative environment where your contributions will make a significant impact on critical infrastructure projects across the United States.

Benefits

401k w/employer match

Health/Dental/Vision insurance plans

Paid time off

10 paid holidays

Stock purchase plan

Qualifications

• 2+ years of experience ensuring data quality and accuracy.
• Experience with AI platforms for data modernization work.
• Strong background in data modeling and analytics.

Responsibilities

• Collaborate with teams to design and develop enterprise data models.
• Implement data security and masking standards across data stores.
• Build enterprise-level data models for business analytics.

Skills

Data Modeling

Communication

SQL

Python

DAX

Power BI

Azure

Agile/Scrum

Education

Bachelor’s degree in business administration

Bachelor’s degree in Information Technology

Tools

Databricks

Power BI

SQL

Python

Azure

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

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

Salary Range: $95,000-$145,000 annually

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, contactHR.

#LI-RM2

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.