BI Solution Analyst

Trianz • Pleasant Prairie, WI

2d • Hybrid

About The Position

The Business Intelligence Solution Analyst is responsible for partnering with business stakeholders and technical teams to gather, analyze, and translate business reporting and data requirements into scalable analytics and reporting solutions. This role requires strong analytical thinking, SQL expertise, data warehousing knowledge, and the ability to navigate complex data ecosystems.
The ideal candidate will be a self-driven professional who can independently analyze business needs, document requirements, trace data lineage, and provide effective solutions that support enterprise reporting and decision-making capabilities.

Requirements

• 5+ 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 collaborating with business users, technical teams, and project stakeholders.
• Ability to work independently with minimal supervision.
• Excellent written and verbal communication skills.

Nice To Haves

• Experience with dimensional data modeling.
• Hands-on experience with ETL processes and tools.
• Experience with Informatica.

Responsibilities

• 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.
• Analyze complex datasets and reporting requirements to deliver effective BI solutions.
• Trace data from source systems through transformation layers to reporting and analytics platforms.
• Perform data lineage analysis to validate data accuracy and integrity.
• Support reporting modernization initiatives by reverse engineering existing business logic and legacy reporting processes.
• Partner with development teams to ensure successful delivery of reporting and analytics solutions.
• 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.
• Effectively communicate findings, risks, recommendations, and priorities to both technical and non-technical stakeholders.
• Demonstrate critical thinking when evaluating requirements and proposed solutions.
• Challenge assumptions and recommend alternative approaches when appropriate.
• Proactively identify and escalate risks, dependencies, and project roadblocks.
• Build strong working relationships across business and technology teams.

Benefits

• Startup agility with enterprise impact.
• Experience rapid innovation cycles while working on Fortune 500 transformations.
• Lead the charge in implementing AI-driven transformation at scale.
• Shape transformation across continents.
• Work with diverse teams and clients spanning Americas, Europe, Asia, and beyond.
• Direct impact on Fortune 500 strategies.
• Work alongside C-suite leaders and influence major business decisions.
• Zero bureaucracy culture with decision-making autonomy and rapid execution.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level