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