Ledgent Technology

Business Intelligence Data Analyst

Company: Ledgent Technology

Location: Portland - Oregon - USA

Posted on: September 23

Role:Business Intelligence Data Analyst...Direct Hire Full Time100% RemoteCome 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 AnalystThe 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 dataPrepare 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 preferredCollect and analyze geo fields - key attributes - and industry & general economic data to support longer-term strategic planningPassion 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 requireAdvanced/Expert-level Excel skills and demonstrable ability to efficiently create advanced/dynamic data modelingMicrosoft SQL Server - SQL - MS Access - and Power BI considered a mustData Modeling ExperienceAdvanced SQL skillsMicrosoft SQL Server Expert - 2016 & AboveAzure SQL (cloud based) - PreferredSQL Server Management Studio (SSMS) (minimum requirement)SQL Server Reporting Services (SSRS)SQL Server Integration Services (SSIS)Performance TuningAutomation of Report GenerationAdvanced Power BIWe 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