Enterprise Power BI Architect

1 Month ago • 3-5 Years

Job Summary

Job Description

The Enterprise Power BI Architect will be responsible for maintaining, developing, and modernizing the Analytics platform. This role involves creating data-rich dashboards, developing complex models, writing DAX expressions, and implementing row-level security. The architect will design and optimize Power BI dashboards, reports, and scorecards. They will also work with data integration, data modeling, and documentation. The candidate should have experience with data visualization, DAX, SQL, and cloud platforms like Azure and Snowflake. A strong understanding of the Power BI Service and the full suite of Power BI products is essential. Experience in the P&C Insurance domain or Financial Services is preferred.

Must have:

Power BI architecting, designing, and developing dashboards.
Expert level experience with Power BI.
Strong SQL and DAX ability.
Experience with Azure and Snowflake.

Good to have:

Knowledge of scripting languages such as R and Python.
Experience with Big Data platforms.
Experience in the P&C Insurance or Financial Services domain.
Knowledge of Cognos and SSAS.

9 skills required

9 skills required for this role

Add these skills to join the top 1% applicants for this job

azure

python

sql

power-bi

data-analytics

excel

software-development-lifecycle-sdlc

agile-development

team-management

Job Details

Seeking a highly skilled hands on Power BI Architect who will work closely with our Enterprise Data team to maintain, develop, and modernize our Analytics platform. The ideal candidate will understand business and technical requirements, translating these into data integration designs and deliverables by working with the Enterprise Data Team and Architect. The position requires experience in creating data-rich dashboards, creation of complex models which support visualizations and Analyze in Excel, writing DAX expressions, and implementing row-level security. Knowledge of scripting languages such as R and Python a plus. Ability to convert data into stories that help establish data-driven decision making across the organization. Familiarity with the P&C Insurance domain with strong background in financial analytics is preferred.

Essential RESPONSIBILITIES and ACCOUNTABILITIES

Architect, design, develop, update and optimize Power BI dashboards, reports and scorecards to meet business requirements.
Utilize effectively the navigation features in Power BI to guide users through a compelling data-driven story.
Design, publish and maintain Power BI data models with multiple interrelated tables which support both the visualization and analyze in Excel features Document solutions and work with analysts to flesh out details of user stories.
Develop calculations in DAX Able to work with analysts and product managers to discuss with internal customers and stakeholders to formulate requirements for their analytical problems Integrate existing data sources with Power BI – including but not limited to Snowflake, Azure, SQL Server.
Efficiently handle large sets of data and confidently process them into required formats Implement row-level security on data along with an understanding of application security layer models in Power BI
Responsible for design methodology and product documentation. Should be able to develop tabular and multidimensional models compatible with data warehouse standards.

Knowledge & Skills

Highly experienced in Power BI architecting, designing, developing, updating and optimizing Power BI dashboards, reports and scorecards to meet business requirements.
Expert level experience with Power BI
Advanced knowledge in Microsoft BI stack Strong data analysis skills
Strong SQL, DAX ability required, scripting languages such as R, Python a plus Experience with Cloud platform, especially Azure Experience with Big Data platforms, especially Snowflake
Competent in developing engaging and effective data visualizations In-depth understanding of how the Power BI Service works
Understanding of the full suite of Power BI products work is essential (Report Builder, Reporting Services, etc)
Knowledge of Cognos, SSAS is good to have Communicating with stakeholders of all levels including executives, including ability to advise and support
Track record of working in Agile environment Self-starter, ability to work independently Experience in working in all stages of the SDLC
Experience in the P&C Insurance domain preferred, else Financial Services industry is preferred
Experience with custom visuals, dynamic reporting, best practices data modeling, row-level security, Analyze in Excel Experience with Power BI Admin functions

Education & Experience

Required knowledge & skills would typically be acquired through a Bachelor’s degree.
15+ years of work experience and last 3-5 years of related experience in software development & architecture design is required.