-
Job Description
POSITION OVERVIEW
Applications accepted from: ALL PERSONS INTERESTED
Job Classification: SENIOR IT PROFESSIONAL - APPLICATIONS (Reporting Analyst)
Posting Number: 37059
Department: HOUSTON INFORMATION TECHNOLOGY SERVICES (HITS)
Division: ENTERPRISE APPLICATIONS SERVICES
Reporting Location: HOUSTON PERMITTING CENTER, 1002 Washington Avenue, Houston, TX 77002
Workdays & Hours: MONDAY 7:00AM- FRIDAY 5:00PM (on site)
DESCRIPTION OF DUTIES / ESSENTIAL FUNCTIONS
Houston, TX, is the fourth largest city in the country, with a budget of over 6 billion dollars, a strong workforce of 20,000 employees, and 23 departments comprising fascinating data and a wide range of questions. Houston promotes healthy and resilient communities through smart civic investments, dynamic partnerships, education, and innovation. It is a place where anyone can prosper and feel at home.
The city offers its employees various benefits , including healthcare, wellness, professional development, and a pension plan .
The Permitting Center of Excellence groups business, functional and technical resources to deliver a high-quality product management for the City’s implementations of Infor Public Sector (IPS) that spans multiple City departments.
The Reporting Analyst will be part of the Permitting Center of Excellence and support the end users’ analytics and reporting needs. The Analyst plays a vital role in bridging the gap between raw data and actionable insights, helping departments make informed decisions to drive success by designing, developing, and maintaining BI solutions. The Reporting Analyst regularly provides guidance and training to line of business team members.
The Reporting Analyst will:- Learn and understand the IPS data model
- Maintain a pool of several hundred SSRS reports
- Work with the business subject matter experts to understand expected outcomes, then write specifications, and create new SSRS reports based on user needs and priorities
- Discover insights by conducting data analysis to understand and uncover trends and patterns that can inform business decisions.
- Design and create interactive reports, dashboard, and data visualizations to convey insights to business stakeholders. Ensure that reports are user-friendly and accessible to non-technical users.
- Implement data governance policies and security measures to safeguard sensitive information.
- Understand data models, including dimensional models like star and snowflake schemas, to support efficient querying and reporting. Create, manage, and leverage data structures within data warehouses.
- Collect and integrate data from various sources, such as databases, data warehouses, APIs, and external data providers. Ensure data quality, consistency, and accuracy by cleaning and transforming data as needed.
- Monitor and optimize the performance of reporting solutions to ensure timely access to data and reports. Identify and resolve bottlenecks and inefficiencies.
- Collaborate with business analysts and other stakeholders to understand their requirements and provide data solutions.
- Maintain documentation for data sources, pipelines, models, and reports to facilitate knowledge sharing and troubleshooting.
- Stay updated with the latest BI technologies, best practices, and industry trends. Identify opportunities for process improvement and implement enhancements to BI systems.
- Provide training and support to end-users to help them effectively use reporting tools and understand the data provided.
- Perform other duties as assigned.
The ideal candidate possesses:- Significant experience with SQL Server Reporting Services (SSRS)
- Proficiency in working with databases and SQL (Structured Query Language) for writing high performing queries to retrieve and manipulate data.
- A real business acumen to understanding organizational objectives, an appetite to discover business processes, and an unyielding willingness to assist.
- Excellent written and verbal communication skills
- Proficiency with Power BI and data visualization tools in general, solid experience with DAX and M-Query.
- Exposure to Infor Public Sector
- Understanding of data warehousing concepts, data modeling, and using cloud data warehouses like Snowflake.
- Strong analytical thinking and problem-solving skills for extracting meaningful insights from data, investigating issues, and proposing solutions.
- Organizational skills to balance and prioritize projects and operational activities.
- The ability to successfully communicate technical concepts to business stakeholders and provide instructions to users.
- An aesthetic sense to create engaging and visually appealing reports that convey clarity and a coherent story to the audience.
*You must be eligible to validate contract work experience.
WORKING CONDITIONS
There are no major sources of discomfort, i.e., essentially normal office environment with acceptable lighting, temperature, and air conditioning. Significant time spent using computer displays, keyboard, and mouse.
MINIMUM REQUIREMENTS
EDUCATION
Requires a Bachelor's degree in Computer Science, Management and Information Systems (MIS) or aclosely related field.
Usually has advanced technical certifications that demonstrate mastery of aspecialized application.
EXPERIENCE
At least six (6) years of technology experience supporting applications.
Advanced certifications and/or greater than six (6) years applicable experience may be substituted for up to two (2) years of the education requirement.
LICENSE
None
PREFERENCES
**Preference shall be given to eligible veteran applicants provided such persons possess the qualifications necessary for competent discharge of the duties involved in the position applied for, such persons are among the most qualified candidates for the position, and all other factors in accordance with Executive Order 1-6. **
Preference will be given to candidates with the following skillsets:- Supported mission critical reporting.
- Experienced in DevOps environments or using an Agile Framework
- Contributed to a cloud-based data warehouse.
- Leveraged Microsoft Data Services as (Azure Data Lake, Azure Data Factory, Synapse, Fabric…)
- Foundational knowledge of SQL Server databases
- Understanding of the Software Development Life Cycle (SDLC) or the ITIL framework
- Related certifications
GENERAL INFORMATION
SELECTION / SKILLS TESTS REQUIRED
Department may administer skills assessment test.
SAFETY IMPACT POSITION NO
If yes, this position is subject to random drug testing and if a promotional position, candidate must pass an assignment drug test.
SALARY INFORMATION
Factors used in determining the salary offered include the candidate’s qualifications as well as the pay rates of other employees in this classification.
PAY GRADE: 29
APPLICATION PROCEDURES
Only online applications will be accepted for this City of Houston job and must be received by the Human Resources Department during active posting period. Applications must be submitted online at: www.houstontx.gov .
To view your detailed application status, please log-in to your online profile by visiting: http://agency.governmentjobs.com/houston/default.cfm or call (832/393-0204).
If you need special services or accommodations, call (832/393-0204). (TTY 7-1-1)
If you need login assistance or technical support call 855-524-5627.
Due to the high volume of applications received, the Hiring Department will contact you directly, should you be selected to advance in our recruitment process.
All new and rehires must pass a pre-employment drug test and are subject to a physical examination and verification of information provided.
EEO EQUAL EMPLOYMENT OPPORTUNITY
The City of Houston is committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, genetic information, veteran status, gender identity, or pregnancy.
The city offers a competitive benefits program, including competitively priced health coverage and a defined contribution pension plan. Benefits include:- Medical
- Dental
- Vision
- Wellness
- Supplemental Insurance
- Life insurance
- Long-term disability
- Retirement pension
- 457 deferred compensation plan
- Employee Assistance Program
- 10 days of vacation each year
- 11 city holidays, plus one floating holiday
- Compensable Sick Leave
- Personal Leave
- Flexible schedules
- Hybrid-Telework for eligible positions
- Professional development opportunities
- Transportation/parking plan
- Section 125 pretax deductions
- Dependent Care Reimbursement Plan
- Paid Prenatal, Parental and Infant Wellness Leaves
- Healthcare Flexible Spending Account
Closing Date/Time: 9/11/2025 11:59 PM Central -
ABOUT THE COMPANY
-
-
Houston Airport System
Show moreOUR STOREY | HOUSTON AIRPORT SYSTEM
The Houston Airport System provides a safe and dynamic air services network that fosters economic vitality for the transportation industry and facilitates a strong level of global connectivity for a diverse and growing population living throughout the greater Houston region.
OUR MISSION
We exist to connect the people, businesses, cultures and economies of the world to Houston.
OUR VISION
Establish the Houston Airport System as a five-star global air service gateway where the magic of flight is celebrated.
OUR HISTORY
In 1937, as Houston began its ascent to become the energy capital of the world, the city acquired the site of its first major commercial airport, William P. Hobby Airport.
As the City of Houston continued to grow so did the Houston Airport System, adding George Bush Intercontinental Airport in 1969 and Ellington Airport in 1984. Today, George Bush Intercontinental Airport serves as the premier long-haul international airport facility, while Ellington Airport supports both general aviation flights as well as a host of government/military operations. Hobby Airport opened an international concourse and welcomed back international service in October 2015, serving destinations in Latin American and the Caribbean.
-