BI Architect / Reporting Architect
Artius Solutions
McKinley Township, United States of America
18 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Compensation
$ 177KJob location
Remote
McKinley Township, United States of America
Tech stack
Data analysis
Azure
Business Intelligence
Big Data
Information Engineering
Data Files
Data Governance
ETL
Python
Power BI
SQL Databases
Data Streaming
Star Schema
Data Lakehouse
Data Pipelines
Custom Reports
Databricks
Job description
We are looking for an experienced BI Architect / Reporting Architect with strong communication skills to lead reporting initiatives and design scalable BI solutions. The candidate will work closely with business stakeholders, data engineering teams, and BI developers to define reporting requirements and support Power BI reporting., * Gather and document reporting requirements
- Define KPIs, metrics, filters, and report logic
- Conduct stakeholder meetings and requirement sessions
- Perform gap analysis between current and future reporting needs
- Design reporting data models (Gold / Reporting DB layer)
- Work with upstream data sources (Silver layer)
- Ensure scalable and optimized reporting structures
- Guide Power BI dataset, dashboard, and report design
- Support data flow from Silver to Gold layers
- Collaborate with data engineers on pipelines
- Support testing, validation, and UAT
- Coordinate deployments to TEST and PROD environments
- Document reporting logic and data sources
Requirements
Do you have experience in Stakeholder management?, * Strong experience in BI Architecture and Reporting Design
- Hands-on experience with Power BI (DAX, datasets, dashboards)
- Strong knowledge of data modeling (fact/dimension, star schema)
- Experience with SQL and data analysis
- Experience working with ETL/ELT pipelines
- Strong communication and stakeholder management skills
Preferred Skills
- Experience with Azure / Databricks / Data Lakehouse
- Knowledge of data governance and security
- Experience with large datasets (SQL/Python)
- Domain experience in Retail / Finance / POS is a plus
Benefits & conditions
5.05.0 out of 5 stars Minnesota Remote $75 - $85 an hour