Business Intelligence Analyst

Summary

This Business Intelligence Analyst will play a crucial role within the Digital Experience Team by delivering dashboards and analytics that stakeholders across the business use to support informed decision-making and the continuous improvement of customer experience. This role will focus on analyzing engagement across websites and portal experiences, as well as broader business and customer data, to identify opportunities to increase awareness, advocacy, and demand for our client’s brands, products, and services while supporting channel excellence throughout the customer journey. This role is ideal for a highly analytical professional who enjoys cross-functional collaboration and leveraging data from multiple sources to drive meaningful business outcomes.

Responsibilities

• Design, develop, implement, and enhance dashboards.
• Develop data models in Power BI, establishing relationships between datasets from multiple data sources (Data warehouse, ERP, CRM, CMS, etc.) to enable comprehensive analysis.
• Build interactive dashboards and visualizations using a variety of chart types and geospatial maps to support data-driven decision-making.
• Translate stakeholder pain points, requirements, and feedback into analytics solutions that address business needs and are implemented efficiently.
• Utilize analytics tools to cleanse and transform data, ensuring large datasets meet stringent data quality standards.
• Leverage Microsoft Fabric Notebooks (Python) and Dataflows to perform advanced data transformation, analysis, and automation of data processes.
• Develop and deliver monthly KPI reporting to measure business performance and support data-driven decision-making.
• Define and document data assumptions, definitions, and transformation logic to ensure consistency, transparency, and trust in analytics outputs.
• Collaborate cross-functionally across departments to assist with data transformation or reporting needs.
• Troubleshoot, debug, and provide ongoing support for reports and Power BI dashboards.
• Provide training and support as needed on reporting and analytics.
  
  

Requirements

• Proficiency in leveraging SQL, Python, Excel (Power Query), and Power BI to analyze, transform, and visualize data for business insights.
• Experience with Microsoft Fabric including Dataflows, Notebooks (Python), and Power BI, for data transformation, analysis, and reporting.
• Proficiency in writing Data Analysis Expression (DAX) formulas.
• Proven experience creating and customizing Power BI visuals (bar charts, line charts, tables, etc.).
• Experience building geospatial visualizations in Power BI (e.g., ArcGIS maps and native map visuals).
• Solid understanding of database management systems and data warehousing concepts.
• Knowledge of data connection methods including API integrations and data source management.
• Strong problem-solving skills and ability to derive actionable insights from complex datasets.
• Ability to develop strong relationships and work effectively in cross-functional teams.
• Solid business acumen, management, communication skills, and ability to work independently.
• University degree or college diploma in business, Computer Science, Data Science, or equivalent.
• At least 5 years of progressive experience delivering business analytics and BI solutions using Power BI and enterprise data sources.
  
  

Preferred

• Experience leveraging AI or advanced analytics (e.g., predictive analytics, automation, or AI-assisted insights within BI platforms).
• Experience with enterprise systems including Salesforce, Oracle, or Microsoft Dynamics.
• Familiarity with housing, architecture, or manufacturing.
• Project Management experience.
• Experience with marketing, customer, or digital analytics.
  
  

This is a 6-month Contract-for-Hire remote opportunity for our Michigan-based client. Employee benefits include Medical/Dental Benefits, Paid time off, Paid Holidays, and 401(k) (with immediately vested company match) available with TriCom during the contract period. H1-B Visa sponsorship is not available for this position. No third-parties, please.