BI Solution Analyst

Title:- BI Solution Analyst

Location Milwaukee, WI

Duration 12 months

Key Responsibilities

Business Analysis & Requirements Management

Gather, analyze, and document business and technical data requirements.

Translate business reporting needs into actionable solution designs and technical specifications.

Develop comprehensive analysis documentation including scope definitions, business requirements, functional specifications, and source-to-target mappings.

Collaborate with business stakeholders to understand reporting objectives and identify opportunities for process improvement.

Ensure alignment between business requirements and technical implementation strategies.

Technical & Data Warehousing

Utilize advanced SQL skills to perform data analysis, troubleshooting, validation, and reporting support.

Apply data warehousing concepts and best practices to support enterprise reporting solutions.

Support data modeling and ETL initiatives to improve data accessibility and usability.

Analyze data structures, relationships, and transformations to support reporting requirements.

Investigate and resolve data-related issues across reporting environments.

Ideal Candidate Profile

9+ years of experience in Business Intelligence, Data Analysis, Solution Analysis, or related disciplines.

Strong expertise in SQL and relational database concepts.

Solid understanding of data warehousing principles and reporting architectures.

Experience gathering and documenting business and technical requirements.

Experience creating source-to-target mappings and data lineage documentation.

Strong analytical and problem-solving capabilities with the ability to think beyond immediate requests.

Experience with dimensional data modeling.

Hands-on experience with ETL processes and tools.

Experience with Informatica.

Education

Bachelor’s degree in Computer Science, Engineering, Information Systems, or equivalent experience.