North Texas Tollway Authority

Business Intelligence Analyst

North Texas Tollway Authority San Jose, California, United States

Government Administration · 501-1,000 employees

Sep 03
business-intelligence Senior (5-10 yrs) Full-time United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The Business Intelligence Analyst will design and maintain enterprise reporting solutions while partnering with stakeholders to transform complex data into actionable insights. This role involves optimizing SQL queries, managing data visualization tools, and ensuring data integrity across reporting environments.

What they look for

Business Intelligence SQL MicroStrategy Power BI Data Warehousing BigQuery Snowflake Redshift Azure Synapse Data Visualization Dashboard Development Data Governance GitHub Version Control Requirements Gathering Operational Analytics

Requirements

Candidates must possess a bachelor's degree in a quantitative field and at least five years of experience in business intelligence or data engineering. Proficiency in advanced SQL, cloud data warehouses, and BI reporting tools like MicroStrategy or Power BI is required.

Full description

Job Description

The Business Intelligence Analyst serves as a strategic partner to business leaders by transforming complex data into actionable insights that drive operational excellence, informed decision-making, and continuous improvement across the organization. This role is responsible for designing, developing, and maintaining enterprise reporting, dashboards, and analytical solutions while collaborating with stakeholders, subject matter experts, and technical teams to deliver scalable, high-quality business intelligence capabilities.

The position combines strong analytical thinking, advanced SQL expertise, and business acumen to identify trends, solve operational challenges, and support data-driven decision-making throughout NTTA.

Applicants are required to be eligible to lawfully work in the United States immediately. This position is not available for H1-B visa sponsorship.

RESPONSIBILITIES:

Essential duties and functions, pursuant to the Americans with Disabilities Act, may include the following. Other related duties may be assigned.

Partner with business stakeholders, operational leaders, and subject matter experts to gather requirements, define success metrics, and deliver business intelligence and analytics solutions that support strategic and operational decision-making. Design, develop, and maintain enterprise dashboards, reports, scorecards, visualizations, and scalable analytics solutions that provide actionable insights into business performance, operational trends, and key performance indicators (KPIs). Serve as the Operations subject matter expert for MicroStrategy and promote reporting best practices, data governance standards, and self-service analytics capabilities. Write, optimize, and troubleshoot complex SQL queries and leverage cloud-based data warehouses such as BigQuery, Snowflake, Redshift, or Azure Synapse to support reporting and analytical initiatives. Develop and maintain reporting solutions using MicroStrategy, Power BI, and other business intelligence platforms to meet evolving business needs. Collaborate with data engineers, architects, and technology teams to ensure data integrity, consistency, and quality across reporting environments. Identify and implement opportunities to automate manual processes, improve reporting efficiency, and increase accessibility of business data across the organization. Support the full reporting lifecycle, including requirements validation, testing, deployment, production support, and issue resolution to ensure reliable delivery of reporting solutions. Utilize GitHub and established development standards to support version control, collaboration, documentation, and release management processes. Document business requirements, technical specifications, and reporting solutions; perform root cause analysis and implement sustainable improvements that enhance performance, reliability, and user experience.

Minimum Qualifications:

Education:

Bachelor's degree in Business Analytics, Information Systems, Computer Science, Engineering, Finance, Mathematics, Statistics, or a related quantitative field.

Years of Experience:

Five (5) years of  progressively responsible experience in business intelligence, analytics, reporting, data engineering, or a closely related field. To include:

  • Developing enterprise reporting and business intelligence solutions.
  • Advanced SQL development and query optimization.
  • Cloud data warehouse technologies, including BigQuery, Snowflake, Amazon Redshift, Azure Synapse, or equivalent platforms.
  • Dashboard and report creating utilizing business intelligence tools such as MicroStrategy, Power BI, Tableau, or similar reporting and visualization solutions.
  • Business requirements gathering, documentation, analysis, and translation into technical solutions.
  • GitHub and version-control best practices.
  • Stakeholder engagement and cross-functional collaboration to deliver reporting and analytics solutions.

PREFERRED QUALIFICATIONS:

Master's degree

Seven (7) or more years of experience in business intelligence, analytics, reporting, or data engineering. To Include:

  • Tolling, transportation, public sector, or related operational environments.
  • Operational analytics and back-office systems within the tolling industry.
  • Creation of wireframes, prototypes, data models, and proof-of-concept reporting solutions.
  • Google Cloud Platform (GCP), Microsoft Azure, Amazon Web Services (AWS), or other cloud computing environments.
  • Enterprise reporting governance, data quality management, and continuous improvement initiatives.

NTTA is an Equal Opportunity Employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, age, national origin, disability or veteran status.

Similar roles