Business Intelligence Architect

Saxon Global; Wakefield (MA); Hybrid; USD 100,000 - 130,000; Full time

Job summary

A technology services company seeks a Business Intelligence Architect for a 12-month contract based in Wakefield, MA. This role requires extensive experience in Power BI, ETL processes, and data architecture. The successful candidate will drive the expansion and adoption of Power BI, design enterprise datasets, and collaborate with various teams to enhance data-driven decision-making. The position is full-time and offers potential hybrid work options.

Qualifications

• 7+ years of experience in Business Intelligence architecture and data modelling.
• 5+ years of experience with Power BI development.
• Demonstrated experience with SDLC, agile scrum methodology.

Responsibilities

• Define the plan and execute to expand the use of Power BI.
• Design and model enterprise datasets for better performance.
• Collaborate with teams to prioritize datasets for deployment.

Skills

Business Intelligence architecture

Power BI development

ETL Processes

DAX and Power Query

Relational data warehouse design

Education

Bachelor’s degree or equivalent

Tools

SSIS

Azure Data Factory

Microsoft SQL Server

Power BI

Business Objects

MicroStrategy

Job description

Overview

Location: 2 days/month in either Boston, MA or Wakefield, MA

Duration: 12 Months Contract

Responsibilities

The Business Intelligence Architect will define the plan and execute to expand and improve adoption of Power BI throughout the organization. The resource will design and model enterprise datasets to facilitate re-use and improve delivery performance of datasets presented through Power BI. They will collaborate with data management peers to drive and prioritize the build of ETLs to feed Power BI datasets. They will partner with various teams to build rapport, establish partnerships, and prioritize datasets to be deployed moving the organization forward along the journey towards data-driven decision making. Additionally, they will research and troubleshoot issues with existing reports and dashboards and capture business requirements and develop innovative solutions meeting those requirements.

Education and Experience

• Bachelor’s degree or equivalent combination of training and experience
• 7+ years of experience in Business Intelligence architecture and data modelling.
• 5+ years of experience with Power BI development experience.
• Experience with ETL Processes and data integration tools (SSIS, Azure Data Factory)
• 4+ years of experience with Microsoft SQL server or other SQL
• Expert level proficiency with at least two BI tools (e.g., Power BI, Business Objects, MicroStrategy, etc.).
• Proficiency in DAX and Power Query (M Language)
• Demonstrated experience with relational data warehouse design and management.
• Demonstrated experience with SDLC, agile scrum methodology, software tools and practices.
• Experience securing and managing reporting including PII data a plus.

Seniority level

Mid-Senior level

Employment type

Full-time

Job function

• Information Technology

Industries

• Information Services

Get notified about new Business Intelligence Architect jobs in Wakefield, MA.