Reporting & BI Analyst: Power BI, Crystal & Cognos

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

Job summary

CEdge Inc. in Saint Louis, MO seeks a Reporting & BI Analyst to maintain and expand the TMS reporting layer, including 420+ Crystal Reports, 97 Cognos reports, and a growing Power BI dashboard portfolio.

The role diagnoses and resolves report-layer errors, supports annual batch reporting cycles, and leads Power BI integration as MoDOT expands its BI capability. Strong SQL and Oracle skills are required to build accurate, high-performance reports.

Qualifications

• Minimum 3 years of reporting and business intelligence experience.
• Minimum 1 year of experience with Crystal Reports and Microsoft Power BI.
• Strong SQL and Oracle query skills; ability to write and tune complex queries against a large Oracle schema.
• Experience with Cognos reporting (version 10.2 or higher) preferred or equivalent enterprise reporting platform.
• Ability to pass MoDOT background check.

Responsibilities

• Maintain and update all existing TMS reports in Crystal Reports, Cognos, and Power BI.
• 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 as needed; support year-end and monthly SQL data resets.
• Execute and maintain annual batch reporting processes: Safety, Traffic, Striping, SIMS draft/final save-down processes.
• Lead Power BI dashboard development as MoDOT expands its BI capability; build dashboards from Oracle data sources.
• Support the TMS Reporting System spatial reporting; expose ArcGIS data as needed; support the Web Location Book and spatial map report products.
• Create and maintain Cognos report definitions; ensure compatibility with Cognos upgrades.
• 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.

Skills

Power BI

SQL

Oracle

Data analysis

Crystal Reports

Cognos

ArcGIS

25%?

Tools

Crystal Reports

Cognos

Power BI

Oracle

Job description

CEdge Inc. in Saint Louis, MO seeks a Reporting & BI Analyst to maintain and expand the TMS reporting layer, including 420+ Crystal Reports, 97 Cognos reports, and a growing Power BI dashboard portfolio.

The role diagnoses and resolves report-layer errors, supports annual batch reporting cycles, and leads Power BI integration as MoDOT expands its BI capability. Strong SQL and Oracle skills are required to build accurate, high-performance reports.