The organization needs to transform complex data into actionable insights to drive strategic decision-making and operational excellence, and is expanding its capabilities with a dedicated Data Modeler to support its Business Intelligence (BI) team.
Requirements
- 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
- 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
Responsibilities
- 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.
Other
- High School Diploma or G.E.D. equivalency
- Proven ability to collaborate with both technical and non-technical stakeholders
- Ability to communicate effectively with technical and non-technical personnel
- Desire to mentor team members
- Excellent problem solving skills