Business Data Analyst

Aston Carter•New Providence, NJ

37d•$39 - $51•Onsite

About The Position

Essential Functions: • Develops comprehensive and insightful reports, dashboards, and data visualizations tailored and relevant to organ/tissue donation. • Collaborates with various departments to understand and identify their data-related needs and translate into report solutions. • Conceptualizes, designs, creates, and supports reports, dashboards, and visualizations in both SSRS and Power BI. • Extracts, transforms, and integrates data from both Relational and Key-Value Databases. • Creates and edits SQL queries against various databases. • Provides data for ad-hoc requests. • Develops and implements processes including but not limited to audits to ensure data integrity and consistency of critical data. • Administers and maintains Reporting Services and Power BI by controlling security on all reports, adding/removing users to current reports, maintaining schedules that trigger automated reports, and maintaining distribution lists. • Reconciles daily activities with Quality Assurance and Data Compliance. • Complies with Organ Procurement Transplant Network (OPTN) data requirements including processing, reporting, and follow-up. • Participates in continuous process-improvement. • Performs other duties as assigned.

Requirements

Bachelor’s degree (B.A. /B.S.) in a field such as Data Analytics, Information Systems, related discipline, or equivalent experience in a health-related field preferred.
Requires an excellent understanding of SSRS, SQL and Power BI.
Two to four years data management experience in records, systems and procedures preferred; working knowledge of computers and software systems.
Experience with database programs and statistical software (i.e. SQL, Power BI, Databases, Access, Excel, SPSS, etc.) is preferred.
SQL, SSRS, Power BI, Data Transformation, Data Warehouse.
Significant SQL experience with the ability to query and transform data using complex datasets from both Relational and Key-Value Databases.
Strong analytical and problem-solving skills, which enables ability to understand business challenges and develop strong data-driven solutions.
Must have basic knowledge of statistics and health care records systems.
Strong computer skills with knowledge of database, spreadsheets, word processing and presentation software applications.
Must be competent in the use of Internet and modem devices to access information, spreadsheets, and graphics.
Excellent statistical, analytical, verbal, written, interpersonal and training skills.
Ability to maintain confidential information.
Ability to provide leadership and direction to staff.
Ability to organize and prioritize work, meet deadlines.
Continuous learning mindset to keep up with advancements in reporting and data analytics

Responsibilities

Develops comprehensive and insightful reports, dashboards, and data visualizations tailored and relevant to organ/tissue donation.
Collaborates with various departments to understand and identify their data-related needs and translate into report solutions.
Conceptualizes, designs, creates, and supports reports, dashboards, and visualizations in both SSRS and Power BI.
Extracts, transforms, and integrates data from both Relational and Key-Value Databases.
Creates and edits SQL queries against various databases.
Provides data for ad-hoc requests.
Develops and implements processes including but not limited to audits to ensure data integrity and consistency of critical data.
Administers and maintains Reporting Services and Power BI by controlling security on all reports, adding/removing users to current reports, maintaining schedules that trigger automated reports, and maintaining distribution lists.
Reconciles daily activities with Quality Assurance and Data Compliance.
Complies with Organ Procurement Transplant Network (OPTN) data requirements including processing, reporting, and follow-up.
Participates in continuous process-improvement.
Performs other duties as assigned.