Returning Candidate?

Report Analyst

Report Analyst

Job ID 
2018-1791
Location 
US-TX-Houston
Metro Area 
..
Function 
Information Technology
Employment Status 
Full-Time

More information about this job

Overview

This is an exciting time to join USAP.  We’re a rapidly growing organization, currently with 3,500 team members serving 26 million people nationwide.

 

USAP is the nation’s leading provider of high-quality anesthesia and chronic pain management. First and foremost, we’re people. We’re a tight-knit team of pas

sionate, compassionate, caring people of all genders, ages, colors, cultures and creeds. We are a leading-edge, data-driven approach to continuous improvement with a full range of clinical and business infrastructure support services.

 

Responsibilities

Summary of Functions:

Financial Modeling, Data Management, SQL Reporting

Major Duties and Responsibilities:

  • Utilize TSQL to query database tables, create view, stored procedures and functions on Microsoft SQL Server 2013-2016.
  • Responsible for design, development, and maintenance of a data warehouse solution using the Microsoft BI Stack
  • Creating and maintaining ETL/data migration and transformation processes from various source into data warehouse using Microsoft SQL Server Integration Services (SSIS)
  • Creating and maintaining multi-dimensional data modeling in OLAP cubes/tabular using Microsoft SQL Server Analysis Services (SSAS)
  • Creating and Maintaining Reports in Report Manager using Microsoft SQL Server Reporting Services (SSRS)
  • Responsible for Reporting Manager and Data Warehouse administration
  • Correct, Validate and QA Data within data warehouse against the data source
  • Providing technical support and data analysis for users of SSAS
  • Creating, monitoring and troubleshooting of SQL Agent Jobs
  • Creating and maintaining internal financial revenue models for various companies
  • Creating reports and providing data analysis to multiple locations
  • Writing custom application using Report Subscription, Macro, C#, Web services, ASPX & HTML to automate and speed up the month end reporting process
  • Automate the report delivery process through the report subscription providing the management with accurate reports in a timely manner
  • Collaborating with various departments to gather reporting requirements and create custom reports for doctors and management team.
  • Knowledge of general accounting and financial analysis a plus
  • Healthcare Industry Experience and Healthcare terminology required
  • Revenue Cycle Experience
  • Project Oriented, Detail Oriented, Deadline oriented
  • Ability to do light travel
  • Ability to support numerous customers with varying reporting needs
  • Excellent listening skills and communicating skills

 

Qualifications

US Anesthesia Partners, Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics.

 

Experience:

5+ years experience working with Microsoft SQL Server

5+ years experience developing reports using SSRS

5+ years experience development using Visual Studio

3+ years experience developing and maintaining SSIS packages and SSAS

Education:

Masters in Computer Science

Need help finding the right job?

We can recommend jobs specifically for you! Click here to get started.