Ian Jacobs
@ianjacobs
Senior Data & BI consultant specializing in Power BI, ETL, and analytics-driven reporting. Exploring projects in local ai deployment
What I'm looking for
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.
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.
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.
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.
Education
Degrees, certifications, and relevant coursework
University of Rochester
Bachelor of Science; Bachelor of Arts, Cell & Developmental Biology; Psychology
Completed a Bachelor of Science in Cell & Developmental Biology and a Bachelor of Arts in Psychology.
Tech stack
Software and tools used professionally
Availability
Location
Authorized to work in
Salary expectations
Social media
Job categories
Interested in hiring Ian?
You can contact Ian and 90k+ other talented remote workers on Himalayas.
Message IanFind your dream job
Sign up now and join over 100,000 remote workers who receive personalized job alerts, curated job matches, and more for free!
