Reporting & BI Analyst with Security Clearance

CEdge Inc.; St. Louis (MO); Hybrid; USD 85,000 - 110,000; Full time

Job summary

CEdge Inc. in Saint Louis, MO, seeks a Reporting & BI Analyst to maintain and evolve the TMS reporting layer, including Crystal Reports, Cognos, and Power BI dashboards. You will resolve report issues, support annual batch cycles, and lead Power BI integration across Oracle data sources.

The role requires strong SQL/Oracle skills, experience with MoDOT-like architecture, and the ability to pass a background check. Remote/on-site as needed, hybrid work model.

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.
• Experience similar to MoDOT's current computer technical architecture.
• Experience with Cognos reporting (10.2+) preferred or equivalent platform.
• Ability to pass MoDOT background check.

Responsibilities

• Maintain and update TMS reports in Crystal Reports, Cognos, and Power BI.
• Diagnose and resolve report-layer errors within a two-business-day SLA.
• Modify report templates for Outdoor Advertising and SQL data resets.
• Execute and maintain annual batch reporting processes for Safety, Traffic, and more.
• Lead Power BI dashboard development and Oracle data source integration.
• Support spatial reporting and ArcGIS data exposure as needed.
• Create and maintain Cognos report definitions and upgrades compatibility.
• Support SIMS reporting and annual save-down processes.
• Document report modifications and version-control definitions in GIT.
• Advise Program Manager on reporting scope and LOE for new work.

Skills

BI reporting

SQL proficiency

Data analysis

Tools

Crystal Reports

Power BI

SQL

Oracle

Cognos

Job description

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! Clearance Required: None; MoDOT MACHS background check required.

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

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