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
$ 177K

Job 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

Apply for this position