Business Intelligence & Data Automation Analyst

Business Intelligence & Data Automation Analyst

Location: Eden Prairie, MN (Hybrid - 3 Days Onsite)

Employment Type: Direct Hire

Compensation: $80,000 - $90,000

Hiring Timeline: Hiring Immediately

Position Overview

We are seeking a Business Intelligence & Data Automation Analyst to transform enterprise data into actionable insights that drive strategic, operational, and tactical decision-making. This role combines technical expertise with business analysis capabilities to design, develop, and maintain reporting solutions, data models, dashboards, integrations, and automation workflows.

The ideal candidate will have experience working across modern data and automation platforms, leveraging tools such as Microsoft Fabric, Power BI, Power Apps, Power Automate, Snowflake, APIs, RPA, and AI-driven technologies. This individual will collaborate closely with business stakeholders to improve data accessibility, streamline processes, and ensure data quality, governance, and usability across the organization.

Key Responsibilities

• Design, develop, and maintain interactive dashboards, reports, and analytics solutions to support executive and departmental reporting needs.
• Gather business requirements and translate them into KPIs, scorecards, and self-service reporting solutions.
• Optimize reporting performance and implement data security best practices, including row-level security.
• Develop and support automation solutions using Microsoft Fabric, Power Platform technologies, and related tools to streamline business processes and workflows.
• Create automations supporting data ingestion, validation, approvals, notifications, and system integrations.
• Design, build, and maintain data models that support reporting, analytics, and business intelligence initiatives.
• Perform data cleansing, transformation, validation, and quality assurance activities.
• Develop and maintain data dictionaries, metadata documentation, and governance standards.
• Write, optimize, and maintain SQL queries, views, stored procedures, and database objects within cloud and relational database en

  All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, Los Angeles County Fair Chance Ordinance, and San Francisco Fair Chance Ordinance.