Business Intelligence Analyst – Power BI / Data Analytics (Ref: 5880)

Estrada Consulting, Inc; Rancho Cordova (CA); Hybrid; USD 95,000 - 125,000; Part time

Job summary

Estrada Consulting, Inc. in Rancho Cordova, CA seeks an experienced Business Intelligence Analyst to develop and maintain enterprise dashboards, performance metrics, and analytical reports.

The role emphasizes Power BI, Excel Power Pivot, data integration, reporting automation, and enterprise performance measurement. Responsibilities include building dashboards, consolidating data from multiple systems, creating data models, and supporting Agile reporting with Rally and ServiceNow, while

Qualifications

• 2+ years of data analysis experience in BI or related field.
• At least 6 months of BI reporting experience.
• Bachelor's degree in IT-related or engineering field; applicable experience may substitute.

Responsibilities

• Design, develop, and maintain interactive Power BI dashboards and reports.
• Collect, validate, consolidate, and analyze data from multiple enterprise systems.
• Develop executive and operational dashboards, charts, and performance metrics.
• Create and maintain analytical data models, reporting logic, and data dictionaries.
• Support Agile sprint, PI, and portfolio-level reporting.
• Integrate reporting data from Rally, ServiceNow, and other enterprise platforms.
• Perform statistical analysis, variance analysis, and data quality validation.
• Document reporting processes and develop sustainable, low-maintenance BI solutions.
• Collaborate with business and technical stakeholders to define reporting requirements.

Skills

Power BI

Excel Power Pivot

Data analysis

Data integration

Statistical analysis

Variance analysis

Data modeling

Reporting automation

Education

Bachelor's degree in IT/Engineering

Tools

Rally

ServiceNow

Job description

Location: Rancho Cordova, CA

Work Arrangement: Hybrid – Alternating 3 days onsite one week and 2 days onsite the following week

Duration: 24 months, with possible 12-month extension

Employment Type: Contract

Anticipated Start: January 2027

Position Overview

We are seeking an experienced Business Intelligence Analyst to develop and maintain enterprise dashboards, performance metrics, and analytical reports. The ideal candidate will have expertise in Power BI, Excel Power Pivot, data integration, reporting automation, and enterprise performance measurement.

Key Responsibilities

• Design, develop, and maintain interactive Power BI dashboards and reports.
• Collect, validate, consolidate, and analyze data from multiple enterprise systems.
• Develop executive and operational dashboards, charts, and performance metrics.
• Create and maintain analytical data models, reporting logic, and data dictionaries.
• Support Agile sprint, Program Increment (PI), and portfolio-level reporting.
• Integrate reporting data from tools such as Rally, ServiceNow, and other enterprise platforms.
• Perform statistical analysis, variance analysis, and data quality validation.
• Document reporting processes and develop sustainable, low-maintenance BI solutions.
• Collaborate with business and technical stakeholders to define reporting requirements.

Mandatory Qualifications

• Minimum 2 years of experience in data analysis or related analytical or engineering disciplines, such as BI Analyst, Data Engineer, or Researcher.
• At least 6 months of experience developing business intelligence reports.
• Bachelor's degree in an IT-related or Engineering field. Additional qualifying experience may substitute for education on a year-for-year basis.

Desired Qualifications

• 5 years of experience performing data integration and analytics, including data validation, consolidation, statistical analysis, variance analysis, and analytical data modeling.
• 3 years developing and maintaining interactive dashboards and reports using Power BI and Excel Power Pivot.
• 3 years developing enterprise performance metrics, reporting standards, validation routines, and Agile sprint, PI, and portfolio-level reporting using Rally, ServiceNow, or similar tools.
• 3 years maintaining reporting logic, data dictionaries, and process documentation.

Technical Environment

Power BI, Excel Power Pivot, data integration, data modeling, enterprise analytics, Rally, ServiceNow, Agile reporting, and dashboard development.