BI and AI Data Modeler

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 : Benefits :

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.