Reporting & BI Analyst with Security Clearance

About the role

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.

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.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
• Advises Program Manager on reporting scope in SOW estimates; provides LOE inputs for any new reporting development

Requirements

• 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

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 creating ArcGIS-connected Power BI visuals or ArcGIS Maps for Power BI