Business Analyst IV

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

Benefits offered by this job

Generous paid time off

Health, vision, and dental benefits

Long term/short term disability

Life insurance

401(k) plan with match

Job summary

Azusa Solutions is seeking a Business Analyst IV to join our team of consultants in Brooklyn, NY, supporting IT systems for DSS/ITS. The role focuses on delivering full lifecycle reporting solutions using Power BI and SQL databases.

You will manage projects, create dashboards, and develop reports for finance, leveraging Oracle, SQL Server, and Excel. On-site work and local commuting distance to NYC are required, with some remote options for select positions.

Qualifications

• Experience with Oracle and MS SQL Server.
• Proficient in SQL and PL/SQL.
• Proficient with Microsoft Power BI, Excel, and VB Script.

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.

Education

Bachelor’s degree or higher in related field

Tools

Oracle

MS SQL Server

SQL

PL/SQL

Microsoft Power BI

MS Excel

VB Script

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.