Lead Power BI Architect

TheSr. Enterprise Data Architectwill 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 theSr. Enterprise Data Architecthas a technical background and has experiencearchitecting anddeveloping scalable and comprehensive enterprise solutionsto 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 havestrong understanding of database methodology, data analysis and advanced SQL and their business intelligence application. The role is required todesign appropriate solutions.The role will be required to providementoringto Enterprise Data Management (EDM) Architects as appropriate to increase knowledge sharing. The ideal candidate will have experience in establishing soundtechnical best practices. The role alsoinfluences othersin 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 )
  
• 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
  

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 consultationand translate requirements intosolution 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.
  

Benefits

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.

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 ) 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 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.