Business Analyst IV

Azusa Solutions; New York (NY); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Generous PTO

Health, vision, and dental

Disability insurance

Life insurance

401(k) with match

Employee referral incentive

Remote or Hybrid telework available

Job summary

Azusa Solutions seeks a Business Analyst IV to support IT systems for NYC DSS/ITS and help optimize data reporting across multiple platforms. You will develop Power BI reports and dashboards, manage data imports, and deliver metrics-driven insights to stakeholders.

The role emphasizes on-site work near Brooklyn, NY, with potential for remote/hybrid arrangements for some positions. A strong background in Oracle/SQL and BI tooling is required.

Qualifications

• Proficiency with Oracle/SQL databases and PL/SQL.
• Experience building reports and dashboards with Microsoft Power BI.
• Strong MS Excel skills and scripting with VBScript.

Responsibilities

• Assist in managing project execution from start through completion.
• Create business reports summarizing metrics from data post-import.
• Import data points from multiple reporting sources including data warehouses.
• Create ad hoc reports based on data metrics.
• Develop finance reports with relevant metrics and trackers.
• Serve as Microsoft Power BI SME for reports, workspaces, and dashboards.

Skills

Oracle

MS SQL Server

SQL and PL/SQL

Power BI

MS Excel

VB Script

Education

Bachelor’s degree or higher

Tools

Power BI

Job description

Azusa Solutions is seeking a Business Analyst IV to join our team of talented consultants. This is an exciting opportunity to join a growing company comprised of highly qualified, highly impactful, and multi-talented individuals.

This position supports IT systems for the New York City Department of Social Services (DSS)/Information Technology Services (ITS). DSS has a constant increased need for the provision of full systems life cycle applications development on various computer platforms, including a variety of client eligibility and recertification systems, employment/work engagement services, claims systems, etc., that are critical to the operation and functioning of DSS programs, requiring periodic refinements to maintain the applications at optimum service levels. Having a project portfolio which properly reflects the user’s business needs and DSS’ workload is crucial. Therefore, there is a need for IT consulting resources for the expanding responsibilities at DSS.

Eligibility

• *Candidates must be legally authorized to work in the United States. Visa sponsorship is not available for this position at this time.
• *Candidates must live within commuting distance to the five Boroughs of New York City.
• *Candidates must be able to work on-site in or near the Brooklyn, NY area.
• *Candidates must be prepared to provide a minimum of 2 professional references and at least one within the last 24 months

Key Responsibilities

• Assist in managing project execution from start through completion
• Create business reports summarizing key metrics relevant to data post-import from reporting databases
• Import key data points on various key factors from multiple reporting sources including reporting databases, Enterprise data warehouse etc.
• Create adhoc reports based on data metrics
• Creating business reports for Finance including tracking with relevant metrics
• Fulfil role as Microsoft Power BI SME, advising on creation of business reports, workspace management etc. within the new Microsoft Power BI framework, as needed
• Create new business reports, datasets and dashboards in Power BI, including paginated reports as needed

Required Skills & Qualifications

• Oracle and MS SQL Server
• SQL and PL/SQL
• Microsoft Power BI, MS Excel, VB Script

Preferred Skills & Qualifications

• Bachelor’s degree or higher in related field

Benefit Information

• Generous paid time off
• Health, vision, and dental benefits
• Long term/short term disability
• Life insurance
• 401(k) plan with match available immediately
• Employee referral incentive
• Remote or Hybrid telework arrangements are available for some positions

About Azusa

Azusa Solutions (Azusa) helps clients solve their toughest challenges in the area Enterprise Application Development and Maintenance. Azusa is an equal opportunity employer. Find out more about Azusa at www.AzusaSolutions.com.