Job Description:
IT Data Analyst Senior (City of Austin Employees Only)
Description
Minimum Qualifications
Education and/or Equivalent Experience: - Graduation with a Bachelor’s degree from an accredited college or university with major course work in a field related to the job plus four (4) years of experience.
- Experience may substitute for education for up to (4) years.
Licenses and Certifications Required:
None.
Notes to Applicants
Position Overview:The IT Data Analyst Senior is responsible for leading the identification, capture, analysis, and management of data across ATCEMS IT systems. This position involves conceptualizing, modeling, and presenting data to support ATCEMS and its leadership in addressing critical questions and solving key challenges. The IT Data Analyst Senior will also empower end-users by facilitating data-driven decision-making through education, the development of innovative dashboards, and effective data visualization. Additionally, the role involves creating new services, products, and solutions to meet evolving needs and enhance data utilization throughout the organization.
About EMS :The Emergency Medical Services department is responsible for managing critical time-sensitive life-threatening emergencies. While most of the assistance EMS gives to the community is medical in nature, everything we do is about service: service to our patients, their families and loved ones; service to our community; and service to the people who make up Austin-Travis County Emergency Medical Services.
Why work for the City of Austin?The City of Austin provides generous benefits including medical, retirement plans, paid time off, as well as hybrid work schedules for eligible positions. Joining our team means you will have access to a network of 17,000+ City of Austin employees and the opportunities for training and professional growth are many!
Regarding your Application: - A detailed, complete City of Austin employment application is required to evaluate your qualifications and, if selected as a top candidate for the position, will be used when determining salary.
- Statements like “see resume” will not count when determining experience. Please be thorough in completing the employment application and list all experience that is relevant to this position. The application and resume must include dates (month and year) for each job history entry. In addition, the resume information must match the information on the application.
- Please describe your specific experience as it relates to the minimum and preferred qualifications when responding to the supplemental questions on the application. The responses to the supplemental questions should reference the employment history listed in the employment history section.
- Incomplete applications will not be considered.
EMS reserves the right to close posted positions prior to the advertised close date, based on recruitment strategies and business needs.
VETERANS :Veterans, we thank you for your service and welcome your application. If you are selected as the top candidate for the position you will be required to provide your DD214.
Are you already a COA employee?Employees in Good Standing, who are candidates within the Department or division that the Position resides in, and who meet the minimum and preferred qualifications for the position will be included in the initial interview.
ATCEMS employee must remain in Good Standing through the Top Candidate Selection phase at which time the Good Standing status will be re-verified.
LANGUAGE :Must have the ability to read, write, and fluently speak English.
Pay Range
$37.63 - $47.98
Hours
Monday - Friday
8:00 a.m. - 5:00 p.m. (Flexible)
A hybrid work schedule is available for this position.
Job Close Date 02/11/2025 Type of Posting Reserved for City Employees Department Emergency Medical Services Regular/Temporary Regular Grant Funded or Pooled Position Not Applicable Category Technical Location 15 Waller Preferred Qualifications
Preferred Experience: - Experience working with data visualization platforms like Power BI, Tableau, or QlikView.
- Experience working with Public Safety data such as 911 dispatch or patient care information.
- Certified in Data analytics or business intelligence (e.g., Microsoft Certified: Data Analyst Associate, Google Data Analytics Professional Certificate), or ability to obtain certification withing the first six (6) months of hire.
Duties, Functions and Responsibilities
Essential duties and functions, pursuant to the Americans with Disabilities Act, may include the following. Other related duties may be assigned.Designs, creates, and maintains relational databases and data systems. Collaborates with City IT analysts to identify data issues and prioritize improvements. Informs solution design and improvements to meet data quality goals. Leads and oversees data classification and data-mining activities to enable more accurate analysis. Determines necessary actions required to generate and publishes open data on the City’s open data portal. Creates data visualizations and reports to present to audiences using presentation tools. Creates standards and patterns for data distribution and retention. Implements statistical models to identify and reveal trends, patterns, and relationships in data to provide guidance to others for decision making processes. Enables access to City and external data sources. Suggests analytics opportunities and best practices. Contributes to management of central data stores and metadata to establish quality expectations. Identifies opportunities to increase data quality, including automation and data entry procedural training. Creates and implements techniques for data collection, accuracy and management.
Responsibilities- Supervision and/or Leadership Exercised:
May provide leadership, work assignments, evaluation, training, and guidance to others.
Knowledge, Skills and Abilities
Must possess required knowledge, skills, abilities, and experience and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed. - Knowledge of data integration tools, data management architectures such as Data Warehouse, Data Lake, Data Hub Management, and data exploration techniques (binning, pivoting, summarizing, and finding correlations).
- Knowledge of analytics, visualization and business intelligence tools.
- Knowledge of data structures, patterns and data models and related industry-standard methodologies.
- Knowledge of Source-to-Target Mapping, Extract-Transform-Load ( ETL ) processing and Change Data Capture ( CDC ) concepts.
- Knowledge of statistical software, database queries and programming languages (e.g., Java, C++, Scala, SQL , Hive, Python and R), XML , JSON and XSD’s.
- Knowledge of Big Data concepts, frameworks, products, and tools.
- Knowledge of data models and structures as well as database design tools (e.g., Visio, SQL , tec.)
- Skill in data modeling, database and data management, SQL coding, data warehousing, reporting, data warehousing, relational databases, and data integrity skills.
- Skill in data analysis, data visualization, data mining, reporting, and data integrity skills.
- Ability to clearly communicate technical concepts with clients to increase their understanding of their operations.
- Ability to consider and incorporate the implications of analysis into recommendations for business decisions.
- Ability to see the big picture and make decisions based on strategy and value delivered.
- Ability to turn data insights into recommendations for both clients and internal stakeholders based on context.
- Ability to adhere to required compliance to all change management policies and procedures.
- Ability to adhere to required compliance to all information security policies and procedures.
Criminal Background Investigation This position does not require a Criminal Background Investigation EEO/ADA
City of Austin is committed to compliance with the Americans with Disabilities Act. If you require reasonable accommodation during the application process or have a question regarding an essential job function, please call (512) 974-3210 or Texas Relay by dialing 7-1-1.
The City of Austin will not discriminate against any applicant or employee based on race, creed, color, national origin, sex, gender identity, age, religion, veteran status, disability, or sexual orientation. In addition, the City will not discriminate in employment decisions on the basis of an individual’s AIDS , AIDS Related Complex, or HIV status; nor will the City discriminate against individuals who are perceived to be at risk of HIV infection, or who associate with individuals who are believed to be at risk.
Information For City Employees: If you are an employee within the department, are in good standing and meet both the minimum and preferred qualifications, then you will receive an initial interview.
Supplemental QuestionsRequired fields are indicated with an asterisk (*).
* The minimum qualifications for the IT Data Analyst Senior position are: Graduation with a Bachelor's degree from an accredited college or university with major course work in a field related to the job plus four (4) years' experience. Experience may substitute for education up to four (4) years. Do you meet these minimum qualifications?
* Are you a City of Austin Employee?
* Please describe your experience with data visualization platforms such as Power BI, Tableau, or QlikView or any similar data visualization tools.
(Open Ended Question)
* Please describe your experience working with Public Safety data such as 911 dispatch or patient care information. If no experience list N/A.
(Open Ended Question)
* Please list any certifications you may have relevant to this position.
(Open Ended Question)
Optional & Required DocumentsRequired Documents Resume
Optional Documents