Business Intelligence Analyst

Talently; Irvine (CA); On-site; USD 85,000 - 125,000; Full time

Job summary

Talently is seeking a Business Intelligence Analyst to build and maintain dashboards and reports for finance and operations. You will write SQL queries, transform data from multiple systems, and analyze manufacturing and supply chain data to uncover trends and opportunities.

You will collaborate with operations and finance to define reporting needs, support budgeting and P&L reporting, and automate recurring analytics workflows for data accuracy and efficiency.

Qualifications

• Strong SQL skills and ability to query, extract and analyze data from relational databases.
• Experience building dashboards and reports in Power BI or Tableau.
• Proven ability to analyze complex datasets and communicate findings clearly to business stakeholders.
• Strong Excel and spreadsheet skills, including pivot tables and data validation.
• Understanding of financial and operational metrics, including budgeting, revenue, and P&L reporting.
• Excellent attention to detail and a commitment to data accuracy and quality.

Responsibilities

• Develop and maintain dashboards and reports using Power BI or Tableau to support financial and operational decision-making.
• Write, optimize, and maintain SQL queries to extract and transform data from multiple databases and systems.
• Analyze manufacturing, supply chain, revenue, and financial data to identify trends, risks, and opportunities.
• Partner with operations, finance, and other stakeholders to define reporting requirements and translate them into useful analytics.
• Support budgeting, forecasting, P&L, and three-statement reporting with accurate, well-documented data analysis.
• Automate recurring reports and spreadsheet-based workflows to improve efficiency and data consistency.
• Validate datasets, investigate discrepancies, and improve the quality and reliability of business reporting.
• Maintain and refine BI processes, data models, and documentation as business needs evolve.

Skills

SQL

Data analytics

Automation

Spreadsheets

P&L / Finance / Budgeting

Manufacturing

Supply chain / Defense / Aerospace

Power BI

Tableau

Excel

Pivot tables

Data quality

Tools

Power BI

Tableau

Job description

Job Title: Business Intelligence Analyst

Location: On Site - Irvine, California, United States

Skills: Business Intelligence Analyst, SQL, Power BI, Tableau, Data Analytics, Automation, Spreadsheets, Large Data Sets, P&L / Finance / Budgeting, Manufacturing, Supply Chain / Defense / Aerospace

About the Manufacturing Company / The Opportunity:

Join a company in the manufacturing industry where timely, accurate data helps teams improve operations, manage costs, and make informed business decisions. This opportunity places business intelligence at the center of financial and operational planning, turning complex datasets into clear, actionable insights. You will partner across the organization to strengthen reporting and help leaders understand performance across the business.

Responsibilities:

• Develop and maintain dashboards and reports using Power BI or Tableau to support financial and operational decision-making.
• Write, optimize, and maintain SQL queries to extract and transform data from multiple databases and systems.
• Analyze manufacturing, supply chain, revenue, and financial data to identify trends, risks, and opportunities.
• Partner with operations, finance, and other stakeholders to define reporting requirements and translate them into useful analytics.
• Support budgeting, forecasting, P&L, and three-statement reporting with accurate, well-documented data analysis.
• Automate recurring reports and spreadsheet-based workflows to improve efficiency and data consistency.
• Validate datasets, investigate discrepancies, and improve the quality and reliability of business reporting.
• Maintain and refine BI processes, data models, and documentation as business needs evolve.

Must-Have Skills:

• Strong SQL skills, including the ability to query, extract, and analyze data from relational databases.
• Experience building dashboards and reports in Power BI or Tableau.
• Proven ability to analyze complex datasets and communicate findings clearly to business stakeholders.
• Strong Excel and spreadsheet skills, including pivot tables and data validation.
• Understanding of financial and operational metrics, including budgeting, revenue, and P&L reporting.
• Excellent attention to detail and a commitment to data accuracy and quality.

Nice-to-Have Skills:

• Experience in manufacturing, aerospace, defense, or supply chain environments.
• Knowledge of Python for data analysis, automation, or workflow improvement.
• Familiarity with Azure or AWS data services.
• Experience supporting FP&A, forecasting, or three-statement financial modeling.
• Exposure to Adaptive Planning or similar planning and budgeting platforms.
• Experience refactoring reporting processes or automating recurring analytics workflows.