Business Intelligence Architect (PowerBI)

Location: It will be mostly remote – but require someone to work onsite 2 days/month in either Boston, MA or Wakefield, MA- Locals or nearby only

Visa: USC, GC, EAD

Exp level: 15+ Years 

The Business Intelligence (BI) Architect is responsible for designing, implementing, and supporting scalable, enterprise Power BI solutions and administering the Power BI service for our internal customers. The BI Architect must possess deep expertise in Power BI, data modeling, BI architecture, desire to enable data-driven decision making and self-service analytics. The architect will be responsible for applying the necessary controls to ensure data integrity, performance and privacy of bank data.

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.

Skills/Knowledge:

• Exceptional analytical, conceptual, and problem-solving skills.

• Strong ability to analyze user requirements and build front-end BI applications according to specifications.

• Strong knowledge that demonstrates database technical functionality such as performance, security, and reliability.

• Should understand and be able to contribute to all phases of the software development life cycle.

• Strong ability to collaborate in the development of necessary processes, technologies, and standards.

• Self-directed and comfortable working in a face-paced environment where priorities can change with limited notice.

• Strong and effective inter-personal and communication skills and the ability to interact professionally with a diverse group of users and staff. Ability to clearly articulate process requirements and expected outcomes.