BI Solution Analyst

Role: BI Solution Analyst

Location:

Pleasant Prairie, WI

Work Model:
Hybrid, 2 days per week at Pleasant Prairie office location

Employment Type:

Contract or Fulltime (Visa sponsorship is not available for this job)

Duration: 12 months

Trianz is an applied AI solutions company that accelerates customer business transformation through AI powered "Transformation Services as a Software Model". With 25+ years of transforming enterprises, we've evolved to a product-led, platform-driven organization serving global enterprises across Financial Services, Insurance, Healthcare, Hi-Tech, Manufacturing, and other industries.

With global presence across 4 continents, our platform portfolio under the unified Concierto brand delivers end-to-end transformations including solutions for Migrate, Manage, Maximize, Modernize, Insights & Agentic AI, and Sec Ops - delivered through strategic partnerships with leading hyperscalers.

We're building the premier innovation-led organization in the digital transformation space through AI-first methodologies and data-driven excellence - RevolutionAIzing Transformations.

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.

• 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 elevate risks, dependencies, and project roadblocks.
• Build…