Looking for a job

Ian Jacobs

@ianjacobs

Senior Data & BI consultant specializing in Power BI, ETL, and analytics-driven reporting. Exploring projects in local ai deployment

United States

Message

What I'm looking for

I seek a role where I can design end-to-end BI solutions, lead ETL and analytics efforts, collaborate cross-functionally, and drive data-driven decisions in a growth-oriented team.

I am a Senior Data & BI consultant with proven experience designing end-to-end Power BI reporting solutions, building scalable data models with DAX and Power Query, and developing ETL pipelines using Azure Data Factory and SSIS. I have delivered finance, operations, and marketing dashboards that enable self-service analytics, automated reporting, and better decision-making for clients.

I collaborate with cross-functional teams to define KPIs, streamline reporting workflows, and maintain data quality and documentation using version control and agile practices. My background includes ownership of accounting and revenue reporting systems, migration of legacy reports into centralized BI platforms, and measurable reductions in manual reporting through automation.

Experience

Work history, roles, and key accomplishments

Senior Data & BI Consultant

Praesto Consulting

Feb 2022 - May 2025 (3 years 3 months)

Designed and delivered end-to-end Power BI reporting solutions and scalable data models, and developed ETL pipelines using Azure Data Factory and SSIS to integrate cloud and on-premise sources, improving self-service analytics and reporting automation.

Power BI DAX Azure Data Factory SSIS Data Modeling ETL Microsoft Fabric SQL Dashboard Design

Business Intelligence Consultant

Professional Advantage

Jun 2021 - Feb 2022 (8 months)

Created and maintained financial and operational Power BI dashboards and migrated legacy Excel and SSRS reports into centralized BI platforms to improve reporting efficiency for internal and client stakeholders.

Power BI SQL Excel Data Migration Dashboard Design Financial Reporting ETL

BI Analyst

Patterson Belknap Webb & Tyler

Jul 2019 - Jun 2021 (1 year 11 months)

Owned accounting and revenue reporting systems and implemented automated SQL Server/SSRS reporting pipelines, reducing manual report time by 60% and supporting monthly close and forecasts.

SQL Server SQL Financial Reporting Automation Data Warehousing Forecasting Excel

Data Analyst

Opus Global

Jun 2017 - Jul 2019 (2 years 1 month)

Developed SQL scripts and Excel-based reports for international finance and compliance clients and collaborated with developers and project managers to scope and deliver client-facing data solutions.

SQL Excel Reporting Data Analysis Compliance Reporting ETL