Business Intelligence Developer
Current• Design, build, and maintain over 30 production-level Power BI reports and dashboards, including reports that track safety visits and consultant performance for the safety and risk control team, improving decision-making for sales, and safety risk teams, and reducing Reduced Steps in Data Retrieval, Cutting Task Completion Time by 20%• Develop and maintain database data models following the Kimball method, along with automated ETL processes for the sales and safety risk control departments, reducing time-to-insight by 30% and ensuring 99.9% data accuracy. Build fact and dimension tables directly within the data warehouse, enabling teams to independently create visualizations in Power BI using a structured and reliable data source for data-driven decision-making• Automate data extraction and transformation using SQL Server tools across multiple database locations, optimizing data delivery for business-critical functions and reducing manual workflows by 80% through automated Power BI report refreshes, enabling reliable data exports for internal and external reporting• Provide tailored Power BI training and support to over 100 users in sales and safety risk control teams, boosting Power BI engagement by 30% and reducing support queries by 40% through workshops and hands-on sessions. Deliver critical data to support the company website and inform business owners. Extract and transform data from source datasets, automating daily updates with stored procedures and SQL Server Agent, and replicate this process across departments to meet diverse data needs• Collaborate closely with the safety and risk control team and sales departments to understand data needs, deliver targeted insights, fulfill ad hoc requests and improving compliance support response times by 15% to ensure no past due responses to regulators
