Data Analyst II

DeKalb Health; Newark (NJ); Hybrid; USD 80,000 - 95,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

401(k) with employer match

FSA/HSA

Group life insurance

AD&D

LTD

Hybrid work model

2 days onsite weekly

Job summary

NJII is seeking a Data Analyst in Newark, NJ with a minimum of two years of experience in data analytics, BI, and data manipulation tools. The role focuses on designing analytics solutions, sourcing data from multiple systems, and producing actionable dashboards for internal and external customers.

Responsibilities include developing reports, writing SQL queries, and collaborating with business partners to identify opportunities for process improvement.

Qualifications

• Education: Bachelor's degree required.
• Minimum two years of experience as a data analyst with BI and data manipulation experience.
• Strong analytical skills to work with large data sets and derive insights.

Responsibilities

• Design and deploy analytics and visualization solutions.
• Obtain and analyze data from multiple sources to support internal/external customers.
• Develop reports and analytics per requester requirements.
• Summarize analytical exercises and define recommendations and next steps.
• Write SQL queries to analyze and extract data from databases and warehouses.
• Create flowcharts/diagrams to illustrate data modeling, sourcing, and presentation.
• Compile/analyze data, interpret trends and fluctuations.
• Contribute to BI and data warehouse environment design, including data sources, security, and metadata.
• Collaborate with business partners to challenge processes and identify reporting opportunities.
• Unearth insights from large datasets to tell stories via dashboards and visuals for strategic decisions.
• Self-track and manage projects in agile tools.
• Improve data models for actionable insights and process improvement.
• Assist in finding and implementing technology solutions with requirements docs and use cases.

Skills

Analytical thinking

SQL

Data visualization

Education

Bachelor's Degree

Tools

BI tools

Data manipulation tools

Data warehouse

Job description

• Job Category Data Analyst
• Employee Type Exempt - FT
• Required Degree 4 Year Degree
• Manage Others No

Essential Functions -

• Design and deploy analytics and visualization solutions.
• Obtain and analyze raw data from multiple disparate sources to perform core job duties and to answer questions posed by internal or external customers.
• Develop reports and analytics according to requestor requirements.
• Develop concise summaries of analytical exercises and clearly define recommendations and next steps
• Ability to write SQL queries to analyze and extract data from database and warehouse.
• Ability to create flowcharts and diagrams to illustrate how the data will be modeled, sourced, transformed, stored, and presented.
• Compile and analyze data, interpret trends, fluctuations, and other changes.
• Contribute to the management and design of the business intelligence and data warehouse environments, including data sources, security, and metadata.
• Consult with business partners and their teams to challenge current processes by asking targeted questions and interpreting ambiguity through deepened knowledge of business function needs and reporting opportunities.
• Unearth insights from large and diverse sets of data to tell compelling stories through dashboards and visualizations, guiding strategic decision-making.
• Ability to self-track and manage projects and tasks in agile tools.
• Continuously improve modeling data for actionable insights and processes improvement.
• Participate in finding and implementing technology solutions and business processes by providing requirements documentation, use cases, subject matter expertise, and design input.

Prerequisite Qualifications -

• Education/Degree Required-Bachelor's Degree at College or University is required.
• Years of Experience Required- Requires minimum (2) two years of experience as a data analyst with proven experience with business intelligence, and data manipulation tools.
• Knowledge/Skills Required- Analytical Skills: Data analysts work with large amounts of data: facts, figures, and number crunching. You will need to see through the data and analyze it to find conclusions.

Salary Information:

In compliance with the NJ Pay Transparency law, the annual salary range for this position is $80,000.00 to $95,000.00 (USD). NJII considers factors like, but not limited to, job scope, experience, education, skills, internal equity, and market conditions when making offers. This pay range covers base pay only and excludes bonuses or other incentives.

NJII provides a comprehensive package of benefits to their full-time employees which includes Medical, Dental, Vision, 401(k) with Employer Match, FSA and HSA. We also provide Company Paid Group Term Life Insurance, AD&D and LTD. In addition, we offer a hybrid work model with an expectation for this role to work a minimum of 2 days weekly onsite at our Newark, NJ office.

Final candidates will be subject to a background screening. Employment or continued employment is contingent upon NJII's acceptance of the results of the background screening.