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

Company Overview  

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 SecOps - 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.

Role Overview

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.

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.

Data Analysis & Reporting Solutions

• 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.

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.

Communication & Stakeholder Collaboration

• 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.

Ideal Candidate Profile

• 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.

Preferred Qualifications

• 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.

Why choose Trianz?

• Personal Growth: Startup agility with enterprise impact. Experience rapid innovation cycles while working on Fortune 500 transformations.
• AI-First Future: Where humans and AI revolutionize business. Lead the charge in implementing AI-driven transformation at scale.
• Global Impact: Shape transformation across continents. Work with diverse teams and clients spanning Americas, Europe, Asia, and beyond.
• Executive Access: Direct impact on Fortune 500 strategies. Work alongside C-suite leaders and influence major business decisions.
• Ownership & Entrepreneurial Spirit: Your ideas, our platform, global impact. Zero bureaucracy culture with decision-making autonomy and rapid execution.

Equal Employment Opportunity

Trianz is an Equal Opportunity Employer and does not discriminate based on race, color, creed, national or ethnic origin, gender, religion, disability, age, political affiliation or belief, special needs veteran, veteran of the Vietnam Era, or citizenship status (except in those special circumstances permitted or mandated by law). We comply with all state and federal laws and regulations protecting employees and applicants against illegal discrimination, retaliation, and harassment. Our policy is available upon request. We consider qualified applicants with criminal histories, consistent with applicable federal, state, and local law. Trianz participates in the E-Verify program in certain locations, as required by law. We are committed to providing reasonable accommodation for all qualified individuals with a disability or other reasons protected by applicable laws. If you require assistance or accommodation due to a disability or special needs to search for a job opening or apply, please email [email protected] with your request and contact information.

Trianz Privacy Notice

Trianz respects your privacy and wants to ensure we comply with applicable Data Privacy Regulations as per local regulator laws. Please review our privacy policy at https://www.trianz.com/privacy-policy for more..