Data Modeler Senior (Business Intelligence/BI)

About the Role

We are a forward-thinking organization that leverages data to drive strategic decision-making and operational excellence. Our Business Intelligence (BI) team plays a pivotal role in transforming complex data into actionable insights, and we are expanding our capabilities with a dedicated Data Modeler.

Responsibilities

As a Data Modeler on our BI team, you will design, build, and optimize data models that power our reporting and analytics solutions. You'll collaborate closely with analysts, engineers, and business stakeholders to ensure data is structured for efficiency, scalability, and clarity.

Duties Include

Design, implement, and maintain data models that support business intelligence solutions in Power BI.
• Write, optimize, and maintain advanced DAX calculations for performance and usability.
• Develop and optimize SQL queries for data extraction, transformation, and analysis.
• Partner with BI developers and business analysts to translate requirements into efficient data structures.
• Ensure data quality, consistency, and accuracy across reporting layers.
• Collaborate on version control and deployment processes using GitHub and Visual Studio.
• Support integration with tools such as SQL Developer for database exploration and query performance tuning.

Required

• High School Diploma or G.E.D. equivalency
• 4+ years of experience as a Data Modeler or Data Architect, using data modeling software (i.e. Visual Studio, MS SQL Server, SSMS, Alteryx)
• Strong understanding of relational databases and data modeling best practices
• Experience building and optimizing tabular models
• Proven ability to collaborate with both technical and non-technical stakeholders

Preferred

• 3+ years of experience with Power BI
• Proficiency in Visual Studio, MS SQL Server, SSMS
• Proficiency in Power BI, DAX, and SQL
• Familiarity with GitHub and Visual Studio for source control and solution management
• Experience with SQL Developer or other database tools
• Exposure to ETL processes and data warehouse concepts

• Ability to communicate effectively with technical and non-technical personnel
• Desire to mentor team members
• Excellent problem solving skills
• Capable of working in a fast paced, dynamic and team oriented environment
• Ability to multitask and still stay focused on release priorities