IT Data Analyst Sr (CDO)

JOIN THE CITY OF AUSTIN TEAM

At the City of Austin we are more than just an employerwe are a vibrant community dedicated to shaping one of the nations most dynamic and innovative cities. As we strive to fulfill our commitment as public servants it is important that we ground our efforts in a set of guiding principles Empathy Ethics Excellence Engagement and Equity anchors in delivering services that significantly impact the lives of Austinites. Joining the City of Austin means embarking on a purposeful career contributing to the community and being part of a forward-thinking organization that values every employee.

What Makes the City of Austin Special

• Make a Difference: Join a team driving meaningful change in one of the fastest-growing cities in the nation.

• Value and Innovation : Work in an environment where employees are valued and innovation thrives.

• Competitive Benefits: Enjoy a comprehensive compensation package that includes generous leave work-life balance programs and extensive benefits.

• Retirement Security: Plan for the future with the City of Austin Employees Retirement System.

• Sustainable Transportation Options: Commute easily with access to public transit and bike-friendly infrastructure.

• Focus on Wellness: Stay healthy through wellness programs on-site fitness centers and mental health support.

• Career Growth: Advance your skills and expertise with professional development and leadership opportunities.

• Modern Workspaces: Work in innovative and sustainable environments that foster collaboration and inspiration.

By joining us you become part of a community that values its people and is committed to making Austin the most thriving and resilient city in the country.

JOIN THE CITY OF AUSTIN TEAM

At the City of Austin we are more than just an employerwe are a vibrant community dedicated to shaping one of the nations most dynamic and innovative cities. Our guiding principlesEmpathy Ethics Excellence Engagement and Equity anchor our approach in delivering services that significantly impact the lives of Austin residents. Joining the City of Austin means embarking on a purposeful career contributing to the community and being part of a forward-thinking organization that values every employee.

What Makes the City of Austin Special

Make a Difference: Join a team driving meaningful change in one of the fastest-growing cities in the nation.

Diverse and Inclusive Workplace: Work in an environment where every voice is valued and Innovation thrives.

Competitive Benefits: Enjoy a comprehensive compensation package that includes generous leave work-life balance programs and extensive benefits.

Retirement Security: Plan for the future with the City of Austin Employees Retirement System.

Sustainable Transportation Options: Commute easily with access to public transit and bike-friendly infrastructure.

Focus on Wellness: Stay healthy through wellness programs on-site fitness centers and mental health support.

Career Growth: Advance your skills and expertise with professional development and leadership opportunities.

Modern Workspaces: Work in innovative and sustainable environments designed to foster collaboration and inspiration.

By joining us you become part of a community that values its people and is committed to making Austin the most thriving and resilient city in the country.

Job Description:

Purpose:

IT Data Analyst Seniors are responsible for leading identification capture analysis and management of City IT and department data. Through data conceptualization modeling and presentation IT Data Analyst Seniors lead City departments and leaderships to answer questions and solve pressing City problems. Additionally this position empowers end-users to use data in their decision-making process through education innovative dashboards relevant data representation and through development of new services / products / solutions for users.

Duties Functions and Responsibilities:

• 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 Citys 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 - Supervisor 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 XSDs.

• 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.

Minimum Qualifications:

• Graduation with a Bachelors 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.

Preferred Qualifications:

• Experience with relational and modern data systems.

• Knowledge of data governance and quality management.

• Hands-on experience using cloud-based platforms and services (e.g. Azure Data Lake AWS or Google Cloud) for scalable and secure data.

• Advanced skills in programming languages such as Python R or SQL.

• Strong ability using visualization platforms such as Power BI Tableau.

• Experience with data integration and ETL processes.

• Experience leading data-related projects.

• Advanced knowledge of data modeling tools such as Visio ER/Studio.

Notes to Candidate:

This position is within Austin Energys Data Office. The Data Office is Austin Energys dedicated hub for advancing data management analysis and business intelligence strategies. By fostering a culture of data-driven decision-making the Data Office empowers our organization to harness the full potential of our data assets. As a key component of our commitment to excellence innovation and operational efficiency the Data Office plays a pivotal role in shaping the utilitys future through the strategic collection secure storage insightful analysis and effective utilization of data. The successful candidate will contribute their expertise and insights to further elevate Austin Energys data management capabilities and advance our organizations data-driven initiatives.

Essential duties / functions may include (but not limited to) the following:

• Perform advanced data analysis to extract actionable insights.

• Utilize statistical analysis and data mining techniques.

• Design create and maintain relational databases and data systems.

• Develop and maintain data models to support data analysis.

• Create interactive data visualizations and dashboards BI using tools.

• Lead data profiling and cleansing efforts to ensure high data quality.

• Implement and use statistical models to identify data trends / patterns.

• Conduct predictive analysis to support strategic decision-making.

• Lead and manage data-related projects ensuring timely project delivery.

• Create data visualizations and reports to present findings.

Pay Range: Entry: $80490.00 - Mid: $102200.00

Schedule: Monday - Friday: 8:00AM - 5:00PM - 40 Hour Work Week (Additional work hours may be required to support the 24-hour Utility operations which may include evenings weekends holidays inclement weather and emergency closures).

Location: 4815 Mueller Blvd. Austin Texas 78723

IMPORTANTINFORMATION:

Working with Austin Energy provides a number of health and welfare benefits such as low-cost medical dental vision paid leave time a highly competitive retirement plan career development opportunities and more. Please clickHEREfor more information.

WHENCOMPLETINGTHECITYOFAUSTINAPPLICATION:

The City of Austin employment application is an official document; incomplete applications will not be considered.Please be sure that your application is a reflection of your entire work history.A detailed complete application is required and applicants must include on their Employment Record all experience (work and/or volunteer) related to this job posting up to 10 years or more; this will be used to determine your base compensation. Employment Record dates must include month and year. Verification of employment history dates on resume should match online Employment Application. Statements such as See Resume will not be accepted and a resume alone will not be accepted in lieu of a complete online application.

Please note that Austin Energy may close the job posting at any timeafter 7 daysfrom the date of the initial advertisement. Once the job posting has closed applications cannot be changed.

Important Note to Applicants:
Please be aware that the Job Posting Close Date reflects the final day to apply but the posting will close at 11:59 PM the day before the date listed. All application steps including attachments and submission must be fully completed before that time.

We also recommend that you save or print a copy of the job posting for your records. Once a posting has closed it will no longer be viewable in the system.

The responses to the supplemental questions must reference the employment history listed in the employment history section. Once the requisition has closed the application cannot be changed to update work history supplemental questions or any other information.

We reserve the right to verify high school and college education for top candidate(s).

If you have any questions regarding your City of Austin employment application please use the official website of the City of Austin as reference. .

VETERANINTERVIEWPREFERENCE:

Military/Veterans must provide a copy of their DD214 verifying honorable discharge at the time of initial interview to receive military/veteran interview preference.

CRIMINALHISTORYBACKGROUNDCHECK:
This position requires a criminal andNERCbackground investigation.

FAIRLABORSTANDARDSACT:
This position is classified asEXEMPTand may require to work additional hours outside of the normal schedule to include nights weekends and /or holidays.

TRAVEL:
If you are selected for this position and meet the Driver Safety Standards in the City of AustinDriver Safety Program you may drive when necessary to multiple locations as part of your regular job duties. Otherwise you are responsible for getting to and from these locations.

EEO Statement for City of Austin:

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 addition the City will not discriminate in employment decisions on the basis of an individuals 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.

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 or Texas Relay by dialing 7-1-1.

EEO Statement for City of Austin:

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 addition the City will not discriminate in employment decisions on the basis of an individuals 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.

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 or Texas Relay by dialing 7-1-1.