IT Data Analyst Sr (CDO)

City of Austin

2d•Onsite

About The Position

JOIN THE CITY OF AUSTIN TEAM At the City of Austin, we are more than just an employer—we are a vibrant community dedicated to shaping one of the nation's 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 employer—we are a vibrant community dedicated to shaping one of the nation's most dynamic and innovative cities. Our guiding principles—Empathy, 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.

Requirements

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

Nice To Haves

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.

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 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.
May provide leadership, work assignments, evaluation, training, and guidance to others.

Benefits

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.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume