Allan MacLean
Senior BI & Data Analyst | SQL, Python, Power BI | Real-Time Insights | Experienced in Retail, Finance, and Healthcare Analytics
- Role
- Senior Business Intelligence Analyst at Acer
- Location
- Dallas-Fort Worth, TX, US
- LinkedIn followers
- 500 followers
About Allan MacLean
I am a top-performing analyst with extensive experience in Business Intelligence, Data…
Experience
Senior Business Intelligence Analyst
Jan 2025 — Present
Spearheaded migration of legacy BI infrastructure to Azure Synapse, Snowflake, and a Databricks Lakehouse (Delta Lake) stack orchestrated with Apache Spark/PySpark, containerized via Docker/Kubernetes, and deployed via GitHub Actions CI/CD and Terraform IaC, boosting pipeline reliability and enabling real-time analytics for faster decision-making.• Implemented automated reporting workflows with Alteryx, Power BI Dataflows, Paginated Reports, and Power Automate Desktop RPA, embedding Great Expectations data-quality tests that eliminated repetitive tasks and freed 30% analyst capacity for deep-dive analysis.• Led the design and implementation of end-to-end BI solutions in Power BI Service and Tableau, building governed Semantic Models, a dbt Semantic Layer, and a reusable Metrics Layer that delivered 25+ dashboards and cut report turnaround time by 40%.• Containerized Python ETL jobs with Apache Airflow and monitored data health via Monte Carlo Data Observability, enforcing DataOps best practices across 60+ production pipelines.• Developed and optimized complex SQL queries and stored procedures to extract, transform, and load (ETL) large volumes of data from disparate sources, reducing data processing time by 35%.• Performed advanced data mining and statistical analysis using Python and R to identify trends, forecast sales, and uncover performance bottlenecks, supporting leadership with strategic insights.• Mentored junior analysts on dashboard development, stakeholder communication, and analytical thinking to build team capability and consistency.
Skills
- Warehouse Management
- Microsoft Office
- Sales
- Supply Chain
- Leadership
- Fundraising
- Data Analysis
- Oracle
- Data Mining
- Powerpoint
- Microsoft Excel
- Inventory Management
- Sap
- Forecasting
- Contract Negotiation
- Demand Forecasting
- Visio
- Spend Analysis
- Logistics
- Microsoft Word
- Supply Chain Management
- Jda
- Procurement
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.