Senior Business Analyst & Power BI SME

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 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.