Senior Power BI Data Analyst - Santander Bank
(2025-07)
Serve as a remote Senior Power BI Data Analyst across Finance, Risk, Operations, and IT, collaborating cross-functionally to gather analytics requirements and modernize enterprise reporting.
- Architect, design, and maintain enterprise Power BI dashboards and semantic models in Microsoft Fabric, converting large financial and operational datasets into real-time visual insights.
- Write, optimize, and execute complex T-SQL queries against Azure SQL Database and Snowflake data lakes to extract, aggregate, and validate reporting data.
- Build scalable star-schema data models using DAX and Power Query (M) while establishing strict data governance and Row-Level Security (RLS) protocols to maintain high data integrity.
- Identify data quality anomalies across enterprise reporting systems, partnering with data engineering teams to remediate upstream inconsistencies and automate manual workflows.
- Tune Power BI report performance by refactoring DAX logic, optimizing semantic model refresh schedules, and utilizing DAX Studio for query plan analysis.
- Support self-service analytics expansion by establishing standardized visual templates, administering workspace environments, and training business users on Power BI features.
- Maintain comprehensive technical specifications, KPI definitions, and data lineage documentation to uphold corporate governance standards.
Senior Power BI Data Analyst - Ford Motor Company (Epitec - Contract) - MI
(2017-10 - 2025-06)
Embedded within cross-functional manufacturing, plant operations, supply chain, and finance teams in a hybrid/remote setup to identify analytics gaps and deliver automated reporting solutions. Extracted and transformed complex operational data from SAP ERP, MES, warranty, and logistics databases using T-SQL, SSIS, and Alteryx to power manufacturing intelligence dashboards.
- Designed and built intuitive Power BI dashboards tracking plant throughput, downtime drivers, scrap rates, Overall Equipment Effectiveness (OEE), and vendor performance metrics.
- Established systematic data validation and source-to-report reconciliation processes, creating automated data quality tracking mechanisms that flagged operational errors in real time.
- Integrated automated Alteryx and data pipeline workflows with Power BI semantic models, streamlining spreadsheet-heavy reporting routines and saving hundreds of operational hours annually.
- Standardized manufacturing and operational KPIs across multi-site production facilities, ensuring uniform reporting standards during major data infrastructure upgrades.
- Optimized large relational queries and Power BI Import/DirectQuery models handling multi-million row datasets to maintain fast dashboard responsiveness for plant leadership.
- Championed data transparency by providing remote technical support, user guides, and training to plant analysts while maintaining version control via Git and Azure DevOps.
Senior BI Consultant - Point 72 Asset Management - CT
(2016-01 - 2017-09)
Partnered directly with portfolio managers, quantitative analysts, and financial controllers to gather reporting criteria, document business logic, and design interactive dashboards.
- Authored complex SQL and T-SQL queries against SQL Server and Oracle databases to retrieve and reconcile portfolio performance, asset exposure, and market benchmark data.
- Developed interactive Power BI dashboards and advanced Excel analytical models, enabling investment teams to drill into asset performance, portfolio risk, and historical trends.
- Built star-schema dimensional data models to organize financial datasets, ensuring consistent calculation logic across analytical tools.
- Executed rigorous source-to-dashboard data reconciliations to ensure 100% data integrity for executive performance reporting.
- Diagnosed and resolved reporting errors by debugging underlying data models, stored procedures, and DAX measures.
- Streamlined dashboard performance by tuning database queries, indexing target tables, and optimizing in-memory Power BI calculations.
- Created detailed technical documentation, metric mapping guides, and data dictionaries for ongoing system support.
Data Analyst / SQL Developer - LexisNexis - OH
(2015-06 - 2015-12)
Supported internal analytics initiatives by querying enterprise relational databases and building foundational Power BI operational reports.
- Authored and tuned T-SQL queries, views, and stored procedures to aggregate operational data for business performance tracking.
- Collaborated with cross-functional teams to define baseline performance indicators, translate findings into visual charts, and document business rules.
- Conducted systematic data auditing and source-to-report reconciliation to verify dataset integrity before deploying reports.
- Maintained technical documentation, data mapping references, and user guides to support reporting maintenance and team onboarding.
