BI Analyst
Troy, MI
Ready to level up your career? Join a data-driven organization where your expertise in analytics and visualization will directly shape business decisions and elevate the digital customer experience.
- Work hands-on with modern tools like Power BI, SQL, Python, and Microsoft Fabric to build advanced dashboards and data models that influence real business outcomes
- Partner cross-functionally with teams across the organization to solve complex problems and enhance the end-to-end customer journey through data insights
- Own and evolve analytics solutions—from data transformation to KPI reporting—giving you visibility, impact, and autonomy in a growing digital environment
Responsibilities
The Business Intelligence Analyst plays a crucial role within the Digital Experience team by delivering dashboards and analytics leveraged by stakeholders across the business to enable informed decision-making and continuous improvement of the customer experience. This role focuses on analyzing engagement across websites and portal experiences, along with broader business and customer data, to identify opportunities to increase awareness, advocacy, and demand for our brands, products, and services, while supporting channel excellence across 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.
What You Will Do
- 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 DAX (Data Analysis Expressions) formulas
- Proven experience creating and customizing PowerBI visuals (bar charts, line charts, tables, etc.)
- Experience building geospatial visualizations in Power BI (e.g., ArcGIS Maps and native map visuals)
- Strong 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
- Dashboards: Design, develop, implement, and enhance dashboards
- Data Models: Develop data models in PowerBI, establishing relationships between datasets from multiple data sources (Data Warehouse, ERP, CRM, CMS, etc.) to enable comprehensive analysis
- Build interactive dashboards and visualizations using diverse chart types and geospatial maps to support data-driven decisions
- Translate stakeholder pain points, requirements, and feedback into analytics solutions that address business needs and can be efficiently implemented
- 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 PowerBI dashboards
- Provide training and support as needed on reporting and analytics
What You Will Need
- 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
- Experience leveraging AI or advanced analytics (e.g., predictive analytics, automation, or AI-assisted insights within BI platforms) is a plus
- Experience with enterprise systems such as Salesforce, Oracle, or Microsoft Dynamics is preferred
- Familiarity with housing, architecture, or manufacturing is beneficial
- Project Management experience is a plus
- Experience with marketing, customer, or digital analytics is a plus
[RogueSearch]