BI Architect

Location: Remote

Job type: Lead BI Architect

Top languages: MUST HAVE architect experience with Power BI, Enterprise Data Reporting, Data Warehousing, Azure Cloud Data platforms

Job Description:

The Lead Business Intelligence Architect will work as part of the Enterprise Solution Delivery team under the direction of the Manager of Enterprise Solutions Architecture. The position will play a key role in the Enterprise Solutions department and across Protective. The Lead Business Intelligence Architect will work with business groups and IT Leaders to develop and mature the Business Intelligence and Data Analytics strategy at Protective. This role will be an active stakeholder in the Enterprise Data Governance Council. This person will incorporate data security patterns and best practices into Protective's Enterprise Business Intelligence and Data Analytics strategy. This position will collaborate with other Enterprise Information and Application Architects to develop standard access patterns to enterprise data, and design meta layer patterns able to support varied analytical, reporting and operational capabilities across the enterprise. This role will be a champion of the Business Intelligence and Data Analytics strategy at Protective.

This position will work alongside an active Architecture team and will assist in providing enterprise architectural strategy and direction to various teams, mission critical work streams in an agile environment. This role will be responsible for architecting, designing and developing end-to-end business intelligence solutions based on the Microsoft Power BI platform. They will also assist in building a capability roadmap for Microsoft Power BI at Protective. They will ensure this roadmap adheres to the strategic direction of the overall enterprise architecture. This person will research industry trends and best practices incorporating these into the enterprise data roadmap.

The ideal candidate for this Lead Business Intelligence Architect has experience architecting and developing scalable and comprehensive enterprise Business Intelligence solutions on the Microsoft Power BI platform. They have proven experience working with clients to define user requirements for web analytics, dashboards and reports. They can analyze user requirements and, based on findings, design functional specifications for BI front-end applications. They can define BI framework models, semantic layers and Metadata repositories to support reporting and administration. They can design and manage BI end user presentation layer training and documentation. Candidates must have a strong understanding of database methodology, data analysis, advanced SQL and the Power BI business intelligence platform. The role will be required to provide mentoringto all levels of Power BI users as well as other business and technical professionals as appropriate to increase platform engagement and knowledge sharing. The ideal candidate should have a firm grasp of BI implementation methodologies and will have had in-depth experience with Microsoft Power BI stack. The role also influences others in IT through sharing specialized business and technical knowledge.

Primary Job Functions: (Standard percentages are provided which are typical for this position. Percentages must add to 100%)

STD %

%

Function

1

Develop Enterprise Microsoft Power BI Strategy

2

Collaborate with Business areas and cross functional Enterprise Architects to fully understand business needs and provide strategic consultation and translate requirements into solution architecture and design roadmap.

3

Actively participate in Data Governance Council

4

Partner with developers, architects, other technical team members and database administrators to design and develop high performing Business Intelligence and Data Analytics solutions and maintain consistent development functions.

5

Architect Enterprise Cloud Data Access Patterns

Additional Duties:

1

Consult with ESD teams as needed to provide architecture considerations on legacy solutions.

2

Contribute to the development of a mature data stewardship process

Work Experience, Education, Certification / Training Required:

1

Bachelor's degree or equivalent certifications / experience required

2

6 + years Data Analytics, Database Modeling experience required

3

5 + years of Business Intelligence application delivery - Experience in Microsoft Business Intelligence stack (SSIS, SSAS, SSRS, SQL Server) required

4

Experience with Microsoft Azure Platform - Emphasis on Power Platform (specifically Power BI), Azure Data Services (SQL Server, Data Lake, DataVerse, etc...)

5

Azure Architecture Certification Preferred

6

Experience working in an Agile environment preferred

7

Experience in relational and dimensional data modeling required

8

Experience in the Insurance industry and/or LOMA coursework preferred; FLMI certification a plus

9

Experience working in a multi-tier data delivery environment required

Knowledge, Skills and Abilities Required:

1

Ability to lead, influence and modify behaviors on a team comprised of IT and Business partners in support of data strategy

2

Ability to work independently or as a part of team.

3

Knowledge of Power BI, Enterprise Data Reporting, Data Warehousing, Azure Cloud Data platforms

4

Knowledge of structured data, such as entities, classes, hierarchies, relationships and metadata

5

Knowledge of database management system (DBMS) including tables, joins and SQL querying

6

Ability to combine data from multiple sources when needed for analysis

7

Familiarity with and ability to document the use cases, business purposes and quality of the data

8

Understanding of data quality concepts, best practices and tools, with strong experience with data analysis techniques

9

Strong analytical and problem solving skills. Ability to quickly understand how various elements relate to one another, having an end to end perspective of decisions and anticipating issues/roadblocks.

---