Successful individual will design and build multi-dimensional models that highlight opportunities for business improvement and drive business change.? This person will lead and manage projects, drive and gather business requirements, analyze data, design models, make updates to existing models, work and gain consensus with business partners, transform business needs into technical solutions, create mapping tables, design and implement ETL processes, create cubes, create financial reports and present results to business partners. The ideal candidate will also have experience with financial data and reporting.
This position is responsible for ETL design and implementation of the organization's financial, operational, and analytical data assets. The role requires the ability to analyze unknown data sources, transforming the data to fit the target model, implementation of data auditing practices, and mentor on best practices for reporting teams and functional teams in their acceptance of BI solutions.
General
Bachelor's in Computer Science or related field, minor in Business, Finance, or Accounting helpful
Five years of financial analysis or related experience
At least 2 years of experience developing ETL or database solutions
Superior analytical and critical thinking skills
Detail oriented
Self-starter/Driver
Strong interpersonal skills/Gets along well with others
Positive can-do attitude
Excellent communication
Ability to present financial and technical information to business partners tailored to the audience (high level and/or detailed depending on audience)
Ability to write documentation
Financial
Experience creating P&Ls and other financial reports
Ability to understand and interpret financial statements
Power User in Excel with knowledge of formulas, pivots & vlookups
Experience working with cubes or multi-dimensional data sources
Some knowledge of performance management, profitability management, cost management or activity-based-costing desired
Have experience with multi-dimensional cube-based reporting tools in helpful
?
Technical
Deep technical experience to successfully extract, transform and load staging tables
Ability to create mapping tables to transform source data into usable data
Experience creating tables, loading data and writing queries in MS Access
Experience analyzing and manipulating large enterprise data sets, identifying patterns and data gaps
Experience developing database solutions using SQL Server, MS Access and/or other database tools
Some experience with data modeling and analytics
Any experience with SAS Tools, SAS Data Integration Studio, or SAS Cost & Profitability Management
location: Rancho Cordova, California
job type: Contract
salary: $40 - 45 per hour
work hours: 8am to 5pm
education: Bachelors
responsibilities:
Successful individual will design and build multi-dimensional models that highlight opportunities for business improvement and drive business change. This person will drive and gather business requirements, analyze data, design models or make updates to existing models, gain consensus with business partners, transform business needs into technical solutions, create mapping tables, design and implement ETL processes, create cubes, create financial reports and present results to business partners.
qualifications:
Experience level: Experienced
Minimum 2 years of experience
Education: Bachelors
skills:
Successful individual will design and build multi-dimensional models that highlight opportunities for business improvement and drive business change. This person will drive and gather business requirements, analyze data, design models or make updates to existing models, gain consensus with business partners, transform business needs into technical solutions, create mapping tables, design and implement ETL processes, create cubes, create financial reports and present results to business partners.
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance.
We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.
