Reporting & BI Analyst

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., · 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.9-2.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

· 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 (3,000+ tables)

· Minimum 1 year of experience similar to MoDOT’s 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.

CEdge has an opportunity for a Reporting & BI Analyst , located in Saint Louis, MO (remote/on-site when required). If you are ready to work alongside World Renowned Technology experts, and carry the skills below, this is the opportunity that will inevitably take your career to unbelievable levels!