Analyze transactional and operational data, develop clear reports and dashboards, and translate findings into actionable business insights for non-technical stakeholders. Extract raw transactional data from relational databases using intermediate SQL queries.
Numbers & Facts
Location
Rancho Cordova, CA
Description
Business Analyst Job Summary
Analyze transactional and operational data, develop clear reports and dashboards, and translate findings into actionable business insights for non-technical stakeholders.
Responsibilities
Extract raw transactional data from relational databases using intermediate SQL queries.
Import large query outputs into Microsoft Excel for detailed analysis.
Summarize complex operational metrics using Excel PivotTables and Power Query.
Design clear charts and dashboards to highlight historical performance trends.
Translate data into actionable insights through concise reporting.
Requirements
Bachelor s degree or equivalent professional experience.
Intermediate SQL skills.
Strong Microsoft Excel skills, including formulas and PivotTables.
Experience using DBeaver or Oracle SQL Developer.
Demonstrated ability to analyze data and communicate findings clearly.
Skill
SQL
Microsoft Excel
Data analysis and reporting
Excel PivotTables and Power Query
Dashboard and data visualization
DBeaver or Oracle SQL Developer
Summary Qualification
Experience extracting and analyzing data from relational databases.
Ability to work with large datasets and identify meaningful trends.
Strong analytical, reporting, and data visualization capabilities.
Ability to present complex information clearly to non-technical stakeholders.
Candidates without SQL and Microsoft Excel experience may not be considered.
Wollborg Michelson Recruiting is an Equal Opportunity Employer and prohibits discrimination of any kind. We ensure job offers are made based of one s employment experience, skills, and qualifications, regardless of race, gender, ethnic origin, or any other classification protected by law. All applicants must furnish proper identification to prove their legal right to work in the US upon a job offer. We participate in E-Verify to confirm one s right to work in the US. Wollborg Michelson Recruiting does not provide sponsorship for an employment-based visa status.