> Markdown version of [/jobs/ext/3138055-bi-solution-analyst](https://www.wearedevelopers.com/jobs/ext/3138055-bi-solution-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# BI Solution Analyst

- **Company:** Pyramid Technology Solutions
- **Location:** Milwaukee, WI, United States
- **Experience:** Expert
- **Contract:** Temporary contract
- **Skills:** Data Analysis, Information Systems, Extract Transform Load (ETL), Data Warehousing, Relational Databases, Requirements Management, SQL Databases, Technical Data Management Systems, Sql Optimization, Information Technology, Data Lineage, Data Management
- **Published:** September 29, 2026
- **Apply:** https://www.dice.com/job-detail/5e981803-4b8e-42c5-908a-418fb3164789

## About the Role

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.

## Description

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.


## Related Videos

- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata)
- [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data)

## Related Articles

- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria)