Sr. Finance Manager - Business Intelligence & Analytics in Secaucus, NJ at Quest Diagnostics

Date Posted: 11/27/2022

Job Snapshot

  • Location:
    500 Plaza Drive
    Secaucus, NJ
  • Date Posted:
    11/27/2022
  • Function
    Finance
  • Job Family
    Financial Planning & Analysis
  • Remote
    Hybrid
  • Position Type
    Regular Full-Time
  • Shift
    Day

Job Description

As a development resource for financial analytics, revenue, and volume reporting, you will partner with key customers in the Finance, Commercial, and Franchise teams to understand the business needs and develop solutions to deliver reporting and analytics that are critical to measuring business performance and driving profitable growth. 

  • Model enterprise data to enable development of business analytics and ad hoc analysis
  • Manage efforts to modify, enhance and maintain Power BI/Tableau reporting models and implement new reports/dashboards
  • Improve and maintain existing dashboards and shared data sets
  • Ability to troubleshoot/optimize DAX code using tools like DAX Studio & Tabular Editor
  • Maintain and develop KNIME ETL workflows to pull data from Oracle which feed Power BI models
  • Define and develop processes to support required analytics outcomes which may include data gathering and preparation, extract transform and load processes, and database design
  • Gather and document customer requirements and develop design specifications
  • Coordinate efforts with various departments, including Database Administration, to troubleshoot issues, improve system performance, implement changes and publish new reports
  • Analyze and interpret business data and utilize the information to help identify opportunities to maintain and grow the business
  • Define and implement standard processes and best practices for reporting for the group
  • Develop and support deployment of key controls and SOPs for area of responsibility

Critical Know How and Skill – Selection Criteria

  • Experience with Power BI (Intermediate/Advanced)
  • Experience with Tableau (Intermediate/Advanced)
  • Experience with DAX/M (Intermediate)
  • Experience with DAX Studio, Tabular Editor, ALM Toolkit, and Zebra BI (preferred, but required)
  • Experience with Knime (preferred, but not required)
  • Experience with SQL with Oracle databases (Exadata 12C)/SSMS
  • Experience in BI database design, development and maintenance of Star Schema database models
  • Bachelor of Science or equivalent preferred                     
  • ~5 years of business experience in the finance/systems area
  • Technical prowess to learn new tools and be a self-starter in teaching new systems to team
  • Strong Customer Focus, Analytical Skills, Problem Solving            
  • Excellent interpersonal and communication skills
  • Ability to work effectively both independently and within a team