Dan Magee

Results-driven Data Analyst with 5 years of progressive experience leveraging SQL, Power BI, DAX, and Tabular Editor to provide actionable insights and drive data-informed decision-making. Proven expertise in developing robust semantic models, creating interactive dashboards, and optimizing reporting processes to enhance data accessibility and quality. Adept at translating complex data into strategic recommendations for decision support analysis and collaborating effectively with cross-functional teams.

Eager to contribute highly effective data solutions and analytical support within a collaborative environment.

Business Integration Analyst at Assurant (2021-01 – 2026-01)

• Developed and maintained Power BI Semantic Models to enhance reporting capabilities.
• Created and implemented reporting solutions utilizing Power BI Semantic Models, improving data accessibility and decision-making.
• Presented key insights and actionable recommendations to stakeholders, facilitating informed business decisions.

Student Intern at Assurant (2020-01 – 2020-12)

• Assisted in writing SQL queries and developing Power BI Semantic Models, contributing to data-driven projects.
• Built reporting solutions and maintained Power BI Semantic Models, supporting the team's data analysis efforts.
• Presented insights to stakeholders, aiding in the visualization and interpretation of data.

Purchasing and Inventory Specialist at ATNE (2017-01 – 2019-12)

• Managed a 2-week inventory of cellphone parts, ensuring optimal stock levels and minimizing downtime.
• Negotiated pricing with vendors to achieve cost savings and maintain budgetary controls.
• Returned defective or unneeded parts to vendors, securing refunds and managing inventory costs.

Electronics Engineering Technologist at Bittele Electronics (2016-01 – 2017-12)

• Priced Bills of Materials (BOMs) for clients, ensuring accurate cost estimations for electronic components.
• Negotiated component pricing with vendors, optimizing procurement processes.
• Procured electronic components for contract manufacturing, ensuring timely delivery and quality standards.

Cellphone Repair Technician at ATNE (2015-01 – 2016-12)

• Diagnosed and validated device complaints, ensuring accurate and efficient repairs.
• Updated device software to the latest versions, enhancing device performance and user experience.
• Performed hardware repairs, restoring devices to operational condition.

Material Handler at Hallmark (2006-01 – 2011-12)

• Replenished stock in filling bins, maintaining inventory levels and workflow efficiency.
• Unloaded and sorted containers for receiving, ensuring accurate and timely stock management.
• Sorted and weighed boxes for shipping, supporting logistics and distribution processes.

Certificate in Business Analytics – St.

Lawrence

College (2020-01)

Diploma with honours in Electronics Engineering Technology – Humber College (2011-01 – 2015-01)

Diploma with honours in Sound Technology – Toronto Film School (2005-01 – 2006-01)

Ontario Secondary School Diploma (OSSD) – Dr. John M. Denison S.S. (2000-01 – 2005-01)