Senior Data Analyst

W2 Candidates Only who have experience with Fabric, Tableau and Power BI is required Senior Data Analyst Overview: This role is focused on standardization, data curation, and design of business intelligence endpoints that support business activities and decision-making. This individual will report to the Director of Business Intelligence and work closely with the Sr. Data Engineer to design, optimize, and model data for Underwriting, Accounting, Claims, IT, and Operations. One’s ability to be creative, highly communicative, open minded, and knowledgeable in data visualization is key in this role. Our BI technology is a data warehouse and semantic modelling in Microsoft Fabric. Strong expertise in PowerBI, Tableau, and Excel are essential. Success in this role requires someone who aspires to be a great colleague and has polished endpoint design experience in reporting technologies. Key Responsibilities: • Systematizes solutions for recurring reports and data in response to internal and external requests. Triages, queries data for, and presents information in response to ad-hoc data inquiries. • Triages new information / report requests and considers the existing reports portfolio. The Analyst documents report inventory, seeks opportunities for reports consolidation, and automates BI solutions for operational efficiency. • Organizes and standardizes data processes, designs data output and delivery of information in response to regulatory data filings from the data warehouse. • Partners with Underwriting to design endpoint solutions for agency audit data from the data warehouse. • Leads and trains the organization on technology engagement within PowerBI and our shared model in MS Excel. Assists others in developing a comfort level with technology for data exploration. • Leads modernization of data delivery, transitioning the organization and our wholesale agents from BI Team distribution of recurring reports to comfort with self-service reports in an online portal (PowerBI Embedded for external users). • Leads migration of existing data visualization and reports from Tableau into PowerBI and the Excel shared model. Automates delivery of recurring (monthly) exposure and wholesale agent reports. • Manages and maintains Microsoft Purview data definitions and governance documentation. • Works closely with the business to understand informational needs, designs scorecards and dashboards, and assists the Data Engineer to model information in MS Fabric. • Coordinates planning with Data Engineer for new data sources to be ingested into warehouse, determines what reporting impacts there are, and resolves those impacts. • Assists in business research initiatives with expertise in data analysis, chooses the best data visualization to illustrate findings. • Takes a continuous learner’s approach to maintaining industry knowledge and technical skillset. • Journals work assignments for the benefit of team knowledge management. • Upholds data governance by journaling all data asset and definitional information within Microsoft Purview. • Assists with executing and delivery of operational reporting as needed. Position Requirements: • A curious data collector obsessed with data quality assurance and reliability. • An enthusiastic initiative-taker and team player who can work collaboratively. • A strong technical, analytical, and organized problem-solver. • A patient communicator who enjoys data visualization and analysis. • Experienced professional who prototypes and designs creative BI solutions. • Understands the critical role of documentation and journaling work performed. Qualifications: • E&S Insurance experience a plus (homeowners & commercial insurance) • Bachelor’s degree in Statistics, Data Analytics, Business Intelligence, or a STEM related field; related work experience can be substituted for educational requirements. • Clear understanding and engineering in Fabric database (ETL, pipelines, staging tables, dimension & fact tables, schema design). • 5+ years in PowerBI (including DAX and Power Query), Tableau, MS Excel (Strong PowerBI development skillset essential). • 5+ years in Power Automate for data ingestion and processing • 5+ years writing complex T-SQL queries for SQL Server • Design experience with Microsoft Fabric architecture is preferred. • Experience detailing business process and data flow process diagrams in MS Visio, identifying opportunities, and recommending solutions for opportunities identified. • Strong documentation and journaling of work.