Senior Business Intelligence Analyst

Plona Partners; Los Angeles (CA); On-site; USD 150,000 - 180,000; Full time

Job summary

A leading consulting firm in California seeks a skilled professional to develop and maintain Power BI data models and data warehousing solutions. The role involves designing ETL pipelines and building automation workflows with Microsoft technologies, highly focused on data governance and implementing AI tools to enhance business operations. Ideal candidates will have experience with Power BI and related automation services, within a dynamic team environment.

Qualifications

• Experience with Power BI to create data models and dashboards.
• Proven skills in ETL processes and managing data warehouses.
• Familiarity with Microsoft Azure AI and automation tools.

Responsibilities

• Design and maintain Power BI data models and dashboards.
• Develop data warehouse environment using Microsoft Fabric.
• Create ETL pipelines to streamline data operations.
• Build and manage Power Automate workflows.
• Prototype solutions using Microsoft Azure AI Services.

Skills

Power BI

Data Warehousing

ETL Processes

AI Services

Data Governance

Automation

Tools

Microsoft Fabric

Power Query

Power Automate

Microsoft Azure

Job description

Compensation: $150,000 - $180,000 Base Salary with OT & Bonus

Ranking: Top 10 Midsize Firm

Logistics: NY, DC, LA

Responsibilities

• Work closely with the Chief Information Officer and department leaders to design, build, and maintain Power BI data models, dataflows and dashboards.
• Develop and maintain a data warehouse environment using Microsoft Fabric and Power BI.
• Create ETL pipeline using Power Query and related tools.
• Build and manage Power Automate workflows to support business process automation.
• Develop document automation solutions to reduce manual administration work.
• Prototype and deploy solutions using Microsoft Azure AI Services, AI Apps, and AI Agents.
• Assist in researching, testing, and evaluating new technologies for business operations and legal services needed.
• Collaborate with business stakeholders to document requirements and develop scalable solutions.
• Define and implement best practices for data governance, automation standards, and AI tool usage.
• Provide guidance and knowledge transfer to IT team members.