Lead Power BI Architect

Denver, CO, United States

Denver, United States | Posted on 18/10/2022

The Sr. Enterprise Data Architect will work as part of the Enterprise Solution Delivery (ESD) team under the direction of the Manager of Enterprise Solutions Architecture. The position will play a key role in the ESD department and across the business. The Sr. Enterprise Data Architect will work with business groups and IT Leaders to develop and mature the enterprise data strategy, Master Data Management strategy, and incorporate governed and reference data management into the data strategy. The Sr. Architect will incorporate data security patterns and best practices into the enterprise data strategy. This role will be an active stakeholder in the Enterprise Data Governance Council. 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 ESD data strategy across the enterprise.

This position may work independently, but will be called upon to provide architectural direction to various ESD teams, mission critical work streams and Agile iterations. The role will be responsible for building and maintaining an Enterprise Data Services capability roadmap. This position will be responsible for researching industry trends related to enterprise data and incorporating best practices into the roadmap. This role will ensure the roadmap adheres to the strategic direction of the enterprise architecture.

The ideal candidate for the Sr. Enterprise Data Architect has a technical background and has experience architecting and   developing scalable and comprehensive enterprise solutions to extract data from source systems or models, transform data according to Business Rules and MDM, and load data into operational and presentation models. The candidate must have a strong understanding MS Cloud Data Systems/Strategy, Service Oriented Architecture (SOA) and the application of Azure Cloud Data platforms to Big Data and processes. The role must have strong understanding of database methodology , data analysis and advanced SQL and their business intelligence application. The role is required to design appropriate solutions.  The role will be required to provide mentoring to Enterprise Data Management (EDM) Architects as appropriate to increase knowledge sharing. The ideal candidate will have experience in establishing sound technical best practices . The role also influences others in IT through sharing of specialized business and technical knowledge.

Requirements Work Experience, Education, Certification / Training Required:

Bachelor’s degree or equivalent certifications / experience required

6 + years Data Warehouse, Data Analytics, Database Modeling experience required

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

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

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

Primary Job Functions:

Develop Enterprise Cloud Data 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 data solutions and maintain consistent development functions.

Architect Enterprise Cloud Data Access Patterns

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

Ability to work independently or as a part of team.

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

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

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

Ability to combine data from multiple sources when needed for analysis

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

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

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.

Performance-Based Compensation: This position is eligible for an annual incentive based on individual and Company performance.

This position also offers additional incentive opportunities through an annual incentive based on individual and Company performance as well as a 401k match and a pension plan.

#J-18808-Ljbffr