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

Estrada Consulting, Inc; Rancho Cordova (CA); Hybrid; USD 85,000 - 110,000; Full time

Job summary

Estrada Consulting, Inc. seeks a Business Intelligence Analyst to develop enterprise Power BI dashboards, integrate data from multiple systems, and support automated reporting. You will model data, maintain data dictionaries, and ensure data quality across reports for executives and operations.

The role emphasizes Power BI, Excel Power Pivot, and collaboration with stakeholders in an Agile environment. This contract position runs hybrid with defined start in January 2027.

Qualifications

• Minimum 2 years of experience in data analysis or related analytical or engineering disciplines.
• At least 6 months of experience developing business intelligence reports.
• Bachelor's degree in IT-related or Engineering field.
• 5 years of experience performing data integration and analytics.
• 3 years developing and maintaining Power BI and Excel Power Pivot dashboards.
• 3 years developing enterprise performance metrics and Agile reporting using Rally or ServiceNow.
• 3 years maintaining reporting logic, data dictionaries, and process documentation.

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 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.

Skills

Power BI

Excel Power Pivot

Data analysis

Data integration

Variance analysis

Statistical analysis

Reporting automation

Education

Bachelor's degree in IT-related or Engineering field

Tools

Rally

ServiceNow

Job description

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

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.

Mandatory 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.