IT Data Analyst Sr (CDO)

City of Austin•Austin, TX

2d•Onsite

About The Position

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

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

Nice To Haves

Proficiency using visualization platforms such as Power BI, Tableau.
Knowledge of statistical models and principles.
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.
Experience with relational and modern databases.
Experience with data integration and ETL processes.
Experience leading data-related projects.
Strong experience in translating analysis findings into presentations for executive-level audiences.

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.
Perform advanced data analysis to extract actionable insights.
Utilize statistical analysis and data mining techniques.
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.