Business Intelligence Architect

Role Description

Seize your opportunity to make a personal impact supporting the Case Management Modernization (CMM) Program. The CMM program is an initiative to support the Administrative Office of the US Courts (AO) in developing a modern cloud-based solution to support all 204+ federal courts across the United States.

The Business Intelligence (BI) Architect will be part of the CMM Data Modernization and Governance team responsible for delivering an integrated data governance, engineering, data platform, reporting, analytics, and Artificial Intelligence (AI)/Machine Learning (ML) capabilities that support operational decision-making and fulfill AO's data and analytics objectives in support of the CMM program.

The successful candidate will be responsible for delivering advanced reporting, analytics, visualizations, statistical modeling, and AI/ML capabilities that provide data-driven decision-support tools and actionable insights to users and stakeholders of the CMM application. This role oversees design, development, integration, and continuous enhancement of dashboards, reporting tools, predictive analytics, and AI/ML capabilities in alignment with strict federal compliance requirements.

The Business Intelligence (BI) Architect will execute the following responsibilities:

• Reporting & Analytics
  • Design the end-to-end BI & data architecture, develop, and integrate configurable dashboards, self-service reporting capabilities, and predictive analytics within the CMM application.
  • Architect intuitive, interactive dashboards and visualizations that communicate business insights effectively.
  • Coordinate and implement data replication or feeds required to support downstream stakeholders and external systems.
  • Continuously monitor system performance to ensure 95% or greater of analytical queries meet defined Service Level Agreement (SLA) response times monthly, including dashboard load times of five seconds or less.
  • Drive user adoption of dashboards and reporting tools, with monthly usage across targets users.
  • Collaborate with product owners, data engineers, and UX designers to ensure seamless integration of analytics features into the CMM user experience.
  • Partner with business leaders, data engineers, analysts, and program leadership to translate business requirements and KPIs into actionable technical designs and insights.
  • Build and enhance dashboards and reports in approved BI tools, ensuring performance and usability at scale.
  • Implement and validate SQL logic, calculations, and metric definitions across reporting products.
  • Coordinate with Data Engineering to resolve upstream data issues and curate data for reporting.
  • Apply visualization standards and documentation so reports are consistent, interpretable, and support adoption.
  • Ensure reporting artifacts comply with privacy, access control, and data handling requirements.
  • Establish and enforce data governance frameworks, standards, and best practices ensuring data accuracy, consistency, classification, and security.
  • Drive continuous improvement of BI platforms through performance tuning, automation, metadata management, and advanced analytics (predictive and self-service BI).
  • Support delivery of architecture design documents, governance artifacts, data lineage, and metadata catalog processes.
• AI/ML Capabilities
  • Support AI/ML solution architecture, design, and implementation with adherence to government compliance standards.
  • Establish, maintain, and oversee a master AI/ML Capability Register documenting all proposed, in-review, approved, and rejected capabilities, including status tracking, submission dates, and authorization history.
  • Support the implement of responsible AI/ML practices aligned with federal requirements, ensuring transparency, risk mitigation, fairness, and compliance.

Qualifications

• MA/MS degree with 10+ years of general experience in information systems and 8+ years of specialized experience.
• Experience may be considered in lieu of degree as follows: HS (16+ years), AA/AS (14+ years), BA/BS (12+ years), Doctorate Degree/Ph.D. (9+ years).
• Expertise in python, SQL and data transformations supporting large-scale analytical data systems.
• Strong hands-on experience with BI tools such as Power BI, Tableau, Qlik, or AWS QuickSight.
• Advanced SQL skills and experience working with analytical data models and semantic layers.
• Experience delivering reporting in regulated or high-sensitivity data environment.

Requirements

• Excellent presentation and communication (oral and written) skills.
• Consultant mindset with the ability to work with high level customer stakeholders and build excellent customer relationships.
• Experience identifying and applying industry tools, solutions, methods best practices, and emerging technologies.
• Strong analytical skills and problem-solving skills with the ability to formulate and communicate recommendations for improvement.
• Demonstrated ability to work effectively, independently, and as part of a team.

Certifications (Preferred)

• Data Visualization and Data Story Telling certifications
• Tableau Certified Data Analyst, Tableau Desktop Specialist
• Power BI Data Analyst
• Story Telling with Data
• Certified Data Management Professional (CDMP)
• Snowflake SnowPro Core
• Databricks Certified Data Professional
• AWS Certified Data Analytics - Specialty
• AWS Certified Solutions Architect - Professional
• AWS Certified Data Engineer

Benefits

• Variety of medical plan options, some with Health Savings Accounts.
• Dental plan options.
• Vision plan.
• 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match.
• Full flex work weeks where possible.
• Variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave.
• 15 days of paid leave per calendar year to be used for vacations, personal business, and illness.
• 10 paid holidays per year.
• Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees.
• Short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance are provided or available.