Job Details

ID #45927729
State Oregon
City Portland
Job type Permanent
Salary USD Competitive Competitive
Source Ledgent Technology
Showed 2022-09-23
Date 2022-09-22
Deadline 2022-11-20
Category Et cetera
Create resume

Business Intelligence Data Analyst

Oregon, Portland, 97214 Portland USA

Vacancy expired!

Role: Business Intelligence Data Analyst

Direct Hire Full Time100% Remote

Come join a team where People make the difference! Ledgent Technology has partnered once again with a top client in the Portland market for a killer opportunity as a Business Intelligence Data Analyst!
  • The

    Business Intelligence Data Analyst (BIDA) will be an integral member of the worldwide FP&A team and will support the Global Senior Finance Director.
  • This position will support the existing reporting structure for Sales, Finance and Accounting, assist with the transitions/architect/document to an EDW environment and develop advanced MS Excel/Power BI reporting within the finance function.

Duties & Responsibilities:
  • Create new Power BI reporting dashboards mirroring existing reporting and identified reporting from senior leadership.
  • Review/validate data for accuracy and consistency and work with any other teams necessary to improve accuracy and reliability of data
  • Prepare internal management daily/weekly/monthly/quarterly reporting and analysis to support senior leadership and sales - such as the Daily Sales Report, ABC Customer analysis, Logistical Heat Maps and Key Customer reporting.
  • Assist with the budget and forecasting analysis/templates for FP&A by leveraging trend analysis. Load the final approved Volume, Revenue, and Cost budgets into SAP.
  • Experience with SAP (ERP system) and the ability to query and directly access transactional level data tables strongly preferred
  • Collect and analyze geo fields, key attributes, and industry & general economic data to support longer-term strategic planning
  • Passion for reporting excellence thru process improvements, technological efficiencies, and transparency.

Qualifications:
  • Bachelor's degree in Finance, Accounting, Economics, Mathematics, Statistics, Computer Science, or Data Analytics require
  • Advanced/Expert-level Excel skills and demonstrable ability to efficiently create advanced/dynamic data modeling
  • Microsoft SQL Server, SQL, MS Access, and Power BI considered a must
  • Data Modeling Experience
  • Advanced SQL skills
  • Microsoft SQL Server Expert - 2016 & Above
  • Azure SQL (cloud based) - Preferred
  • SQL Server Management Studio (SSMS) (minimum requirement)
  • SQL Server Reporting Services (SSRS)
  • SQL Server Integration Services (SSIS)
  • Performance Tuning
  • Automation of Report Generation
  • Advanced Power BI
We are an equal opportunity employer and make hiring decisions based on merit. Recruitment, hiring, training, and job assignments are made without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, or any other protected classification. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

We are an equal opportunity employer and make hiring decisions based on merit. Recruitment, hiring, training, and job assignments are made without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, or any other protected classification. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

Vacancy expired!

Subscribe Report job