Business Intelligence Architect

Harrison-County-Sheriff-S-Office; Houston (TX); On-site; USD 110,000 - 160,000; Full time

Job summary

The Harris County Sheriff's Office is seeking a Business Intelligence Architect to lead the design and implementation of the enterprise BI environment. This role converts governed data into dashboards, reports, and visualizations to support executive decision-making and public safety.

You will collaborate with Data Platforms, Governance, and business stakeholders to establish enterprise reporting standards, semantic data models, and analytics capabilities while ensuring security, scalability,

Qualifications

• Bachelor’s degree required in CS/IS or related field.
• Minimum 5 years designing enterprise BI solutions.
• Experience with enterprise reporting and analytics governance.

Responsibilities

• Designs and maintains the enterprise BI architecture and reporting strategy.
• Develops scalable semantic data models and certified datasets.
• Builds executive dashboards and operational reports using Power BI.
• Establishes visualization standards, governance, and analytics best practices.
• Implements security and access controls across reporting.
• Optimizes dashboard performance and data models.
• Collaborates with business units to translate analytics needs into insights.
• Supports real-time analytics and AI-enabled reporting initiatives.

Skills

Power BI

SQL

DAX

Dimensional Modeling

Executive Reporting

BI Governance

Data Warehousing

Stakeholder Communication

Education

Bachelor's degree in Computer Science, Information Systems, or related field

Tools

Microsoft Fabric

Snowflake

Azure Data Factory

Azure Synapse

Microsoft Purview

Job description

The Business Intelligence Architect leads the design and implementation of the Sheriff’s Office enterprise business intelligence and analytics environment. This role transforms governed enterprise data into dashboards, reports, and visualizations that support executive decision-making, operational performance, and public safety. Working closely with Data Platforms, Technology Governance, and business stakeholders, the BI Architect establishes enterprise reporting standards, semantic data models, and analytics capabilities while ensuring security, scalability, and data integrity.

Key Responsibilities

• Designs and maintains the enterprise business intelligence architecture and reporting strategy
• Develops scalable semantic data models, key performance indicators, and certified enterprise datasets
• Builds executive dashboards and operational reports using Microsoft Power BI and related technologies
• Establishes visualization standards, reporting governance, and analytics best practices
• Implements security and access controls across the reporting landscape
• Optimizes dashboard performance, data models, and reporting infrastructure
• Collaborates with business units to identify analytics needs and translate them into actionable insights
• Supports emerging capabilities including real-time analytics, AI-enabled reporting, and predictive analytics

This job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this position. Management may, at its discretion, assign or reassign duties and responsibilities to this job at any time.

• Bachelor’s degree in Computer Science, Information Systems, or a related field
• Five (5) or more years of experience designing enterprise business intelligence and analytics solutions

Knowledge, Skills, and Abilities

• Strong experience with Microsoft Power BI, SQL, DAX, and dimensional data modeling
• Experience developing enterprise dashboards, KPIs, and executive reporting. Knowledge of data warehousing, semantic modeling, and BI governance
• Ability to communicate technical concepts effectively to business and executive stakeholders

• Experience with Microsoft Fabric, Snowflake, Azure Data Factory, Azure Synapse, or Microsoft Purview
• Experience supporting public sector or public safety organizations
• Familiarity with CJIS security requirements and enterprise data governance
• Familiarity with AI tools affecting business intelligence reporting

Work Environment & Physical Demands

• This position operates primarily in a professional office setting.
• Standard use of computers, phones, printers, and related technical equipment.
• The ability to lift and carry up to 10 pounds is occasionally necessary.

Position Type and Typical Hours of Work

Position Type: Professional Staff, Full-time, Exempt
Work Schedule: Typically Monday – Friday, 8:00 AM – 5:00 PM. Hours may vary based on the department's business needs.

Equal Opportunity Statement

Harris County is an Equal Opportunity Employer and is committed to providing equal employment opportunities to all employees and applicants without regard to race, color, religion, sex, national origin, age, pregnancy, disability, genetic information, or any other protected class in accordance with applicable federal and state laws.