Business Data Analyst

Urban-Engineers; Mount Laurel Township (NJ); On-site; USD 156,000 - 187,000; Full time

Benefits offered by this job

Medical/Prescription

Dental

Vision

Life Insurance

Short/Long Term Disability

Flexible Spending Accounts

401K and company match

Employee Stock Ownership Plan (ESOP)

Vacation, Holiday, and Personal Days

Tuition Reimbursement

Professional Development

Certification Bonus

Job summary

Urban Engineers in the greater New Jersey area is seeking a seasoned Business Data Analyst to manage, analyze, and report project data and performance indicators for capital transit projects. You will maintain project management data and develop insights to track progress and outcomes.

The role requires 10+ years in accounting/financial controls, a finance-related bachelor, and strong Power BI, SQL Server, and Excel skills.

Qualifications

• Bachelor degree with major coursework in finance or related field.
• Minimum of 10 years accounting, budget and/or financial controls experience.
• Proficient with Microsoft Office software; strong Excel skills.
• Experience with Power BI, SQL Server and data reporting.
• Understanding of capital project data in transit sector is a plus.

Responsibilities

• Develop and upgrade reports that centralize budget, expenditures, and schedule data.
• Develop ad-hoc reports and analysis based on stakeholders’ requests.
• Perform quality control over published reports.
• Support Capital Delivery developing cash flows, expenditure plans and schedule using multiple data sources.
• Apply Project Management best practices that support project plan validation (schedule consistency, availability of funds, procurement control, etc.).
• Provide solutions for performance indicators, intuitive and interactive display of complex data, and bridge data analysis and business requirements.

Skills

Power BI

DAX

SQL (T-SQL)

Excel

Python

SharePoint

MS Office

Education

Bachelor's Degree in Finance

Tools

SQL Server

Job description

Urban Engineers is seeking a Business Data Analyst to support the management, analysis, and reporting of project data and performance indicators for capital projects within the transit industry. This role is responsible for maintaining project management data, developing meaningful insights, and tracking key metrics to monitor project activities, progress, and outcomes.Duties include:Develop and upgrade reports that centralize budget, expenditures, and schedule data.Develop ad-hoc reports and analysis based on multiple stakeholders’ requests.Perform quality control over published reports.Support Capital Delivery developing cash flows, expenditure plans and schedule using multiple data sources.Apply Project Management best practices that support project plan validation (schedule consistency, availability of funds, procurement control, etc.).Provide solutions for performance indicators, intuitive and interactive display of complex data, and bridge data analysis and business requirements.Bachelor Degree with major coursework in finance or a related field.Working knowledge of accounting systems and financial control for large organizations.Minimum of 10 years relevant accounting, budget and/or financial controls experience.Proficient with Microsoft Office software.Stack:Power BI / DAXSQL Server (T-SQL)Advanced user of MS ExcelAdditional Preferred qualifications:Experience with transit Capital ProjectsUnderstanding of accounting and financial industry best practicesPython for data analysis (e.g.: Pandas, Matplotlib, Jupyter Lab)SharePoint user managementBenefits Of Working At UrbanMedical/PrescriptionDentalVisionLife InsuranceShort/Long Term DisabilityFlexible Spending Accounts401K and company matchEmployee Stock Ownership Plan (ESOP)Vacation, Holiday, and Personal DaysTuition ReimbursementProfessional DevelopmentCertification BonusApply today!Salary: $156,000-$187,000Location(s): Mount Laurel, NJ or Newark, NJAbout Urban:Our culture is built around our people. Voted a Top Workplace in the Philadelphia region by our employees, we are committed to advancing careers and providing a foundation for professional growth. Urban offers a wide range of health, welfare, and financial benefits to our employees, as well as career development through tuition assistance program, and certification incentives. Founded in 1960, Urban provides services for buildings, ports, transit, railroads, airports, bridges, and highways. We specialize in engineering design, environmental, planning, construction services, and program management. By providing innovation, technical excellence, and on-time performance, we create value for our Clients.Equal Employment Opportunity/M/F/disability/protected veteran status