Reporting & BI Analyst job id 008

POSITION SUMMARY

The Reporting & BI Analyst maintains and evolves the TMS reporting layer: 420 Crystal Reports 97 Cognos reports and a growing Power BI dashboard portfolio MoDOT anticipates expanding in the coming contract period. This individual resolves report-layer errors modifies report templates as business processes change supports the annual and recurring batch reporting cycles (Safety Traffic Striping Outdoor Advertising) and leads the Power BI integration work that MoDOT has identified as a near-term priority. The analyst has strong SQL and Oracle query skills and understands the TMS data model well enough to build accurate performant reports without assistance from the DBA.

KEY RESPONSIBILITIES

Maintain and update all existing TMS reports in Crystal Reports (420) Cognos (97) and Power BI (2.3.1)

Diagnose and resolve report-layer errors and malfunctions within the 2-business-day SLA; deliver corrected reports with documentation

Modify Crystal Report correspondence templates for Outdoor Advertising (ODA) as needed; support ODA year-end and monthly SQL data resets (2.3.9)

Execute and maintain annual batch reporting processes: Safety (Statewide Average Accident Rates Intersection Expected Values Accident Statistics Manual) Traffic (AADT projections) Striping and SIMS draft/final save-down processes (2.3.92.3.11)

Lead Power BI dashboard development as MoDOT expands its BI capability; build new dashboards from Oracle data sources aligned to TMS data model

Support the TMS Reporting System spatial reporting: expose ArcGIS data as needed; support the Web Location Book and spatial map report products (2.3.10)

Create and maintain Cognos report definitions; ensure compatibility with Cognos 10.2 upgrades

Support SIMS reporting: maintain the SIMS draft and final annual save-down process (2.3.11)

Document all report modifications in Technical Records; version-control report definitions in GIT

Advise Program Manager on reporting scope in SOW estimates; provide LOE inputs for any new reporting development

REQUIRED QUALIFICATIONS

Minimum 3 years of reporting and business intelligence experience

Minimum 1 year of experience with Crystal Reports and Microsoft Power BI (2.2.3)

Strong SQL and Oracle query skills; ability to write and tune complex queries against a large Oracle schema (3000 tables)

Minimum 1 year of experience similar to MoDOTs current computer technical architecture

Experience with Cognos reporting (version 10.2 or higher) preferred or equivalent enterprise reporting platform

Ability to pass MoDOT background check

PREFERRED QUALIFICATIONS

Minimum 1 year of experience with transportation-related applications (2.2.3)

Experience with location referencing or spatial data in a reporting context

Experience with Power BI connecting to Oracle data sources via ODBC or Oracle connector

Familiarity with Crystal 25 and its compatibility with Oracle 19c

Experience with Cognos Framework Manager or Cognos Analytics data modeling

Missouri residency or St. Louis metro area location

Experience creating ArcGIS-connected Power BI visuals or ArcGIS Maps for Power BI.