What are the responsibilities and job description for the BI Solution Analyst position at Pyramid Technology Solutions?
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.