BI Solution Analyst

BI Solution Analyst

Hybrid in Milwaukee, WI, US • Posted 9 hours ago • Updated 9 hours ago

Full Time

Hybrid

Depends on Experience

Pyramid Technology Solutions, Inc.

Summary

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

• Note: This description may have been assisted by artificial intelligence tools and has been reviewed for accuracy.