Job description

Must-Haves

1. Proven ability to architect, design and develop end-to-end business intelligence solutions based on Microsoft Power BI platform

2. Ability to work with clients to define user requirements for web systems, dashboards and reports. Can also analyze user requirements and, based on findings, design functional specifications for BI front-end applications

3. Proven experience with the MS BI Stack - cloud and on-premise

4. Proven experience with MS Power Apps

5. Possesses strong knowledge that demonstrates Business Intelligence technical functionality such as performance, security, and reliability

Nice-To-Haves

1. Ability to influence and collaborate with others, from business leaders to technical specialists.

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 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 mentoring to 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 of specialized business and technical knowledge.

Primary Job Functions:

Develop Enterprise Microsoft Power BI Strategy.

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.

Actively participate in Data Governance Council.

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.

Architect Enterprise Cloud Data Access Patterns.

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

Contribute to the development of a mature data stewardship process.

Work Experience, Education, Certification/Training Required

Bachelor’s degree or equivalent certifications / experience required

6 + years Data Analytics, Database Modeling experience required

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

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

Azure Architecture Certification Preferred

Experience working in an Agile environment preferred

Experience in relational and dimensional data modeling required

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

Experience working in a multi-tier data delivery environment required

Job Type: Full-time

Pay: $110,000.00 - $145,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Health insurance
• Life insurance
• Paid time off
• Vision insurance

Schedule:

• Monday to Friday
• Night shift
• Weekend availability

Application Question(s):

• Ability to combine data from multiple sources when needed for analysis

Experience:

• Data Analytics, Database Modeling: 6 years (Required)
• Business Intelligence application delivery -SSIS,SSAS, SSRS: 5 years (Required)
• MS BI Stack - cloud and on-premise: 5 years (Required)
• Microsoft Azure Platform - Power Platform, Data Services: 5 years (Required)

License/Certification:

• Azure Architecture Certification (Required)

Work Location: Remote

arclintfl.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, arclintfl.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, arclintfl.com is the ideal place to find your next job.