power BI Architect

Job : Power BI Architect

Location : Raleigh NC Hartford CT or Jersey City NJ Hybrid

Job Summary

A highly skilled handson Data Analytics and Visualization Manager (Power BI Expert) 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 datarich dashboards creation of complex models that support visualizations and Analysing in Excel writing DAX expressions and implementing rowlevel security. Knowledge of scripting languages such as R and Python a plus. Ability to convert data into stories that help establish datadriven decisionmaking across the organization. Familiarity with the P&C Insurance domain with a strong background in financial analytics.

*This is a hybrid (twiceaweek) role in Raleigh NC Hartford CT or Jersey City NJ.

Essential RESPONSIBILITIES and ACCOUNTABILITIES

Architect Design develop update and optimize Power BI dashboards reports and scorecards to meet business requirements.

Effectively utilize the navigation features in Power BI to guide users through a compelling datadriven story.

Design publish and maintain Power BI data models with multiple interrelated tables which support both the visualization and analysis 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 rowlevel 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

Expert level experience with BI tools and systems such as Power BI and Snow sight

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 Indepth 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 Selfstarter 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

Experience with custom visuals dynamic reporting best practices data modelling rowlevel security Analyse in Excel Experience with Power BI Admin functions

Education & Experience

Required knowledge & skills would typically be acquired through a bachelors degree.

46 years of related experience in software development & architecture design is required.