IT Data Analyst Senior (CDO)

  • City of Austin, TX
  • Austin, Texas
  • Jul 17, 2024
Full Time Information Technology and Communication Services

Job 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
This position is within Austin Energy’s Data Office. The Data Office is Austin Energy’s 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 utility’s 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 Energy’s data management capabilities and advance our organization’s 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.


IMPORTANT INFORMATION :

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 click HERE for more information.

WHEN COMPLETING THE CITY OF AUSTIN APPLICATION :

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.

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. www.austintexas.gov.

VETERAN INTERVIEW PREFERENCE :

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

CRIMINAL HISTORY BACKGROUND CHECK :
This position requires a criminal background investigation.

FAIR LABOR STANDARDS ACT :
This position is classified as EXEMPT and 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 Austin Driver 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.


ESSENTIAL :


This has been designated as an Essential Employee position. In the event of a City-designated emergency, Essential Employees provide services that impact the public health, safety, utility services, and welfare of members of the Austin community and other employees and ensure the continuity of essential operations. In such an emergency, Essential Employees may be called back in, may be required to modify their schedule, may be assigned to a City-designated work site, or may be retained on site to assist with operations and recovery.
Pay Range
$37.14 - $47.35 per hour.

Hours
Work Schedule Notes:
  • Monday - Friday; 8:00 a.m. - 5:00 p.m.
Job Close Date 08/06/2024 Type of Posting External Department Austin Energy Regular/Temporary Regular Grant Funded or Pooled Position Not Applicable Category Technical Location 4815 Mueller Blvd, Austin TX 78723 Preferred Qualifications
Preferred Qualifications:
Proficiency in designing / maintaining relational databases and systems. Knowledge of data management architectures such as Data Lakes. Knowledge of establishing quality expectations for central data stores. Proficiency in statistical software and programming languages. Skill in creating data visualizations and reports using BI analytics tools. Ability to implement data collection and management techniques. Experience leading data-related projects, providing guidance to others. Skill in data modeling, database design tools such as Visio, SQL .

Other:
Ability to travel to more than one work location.
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 has been approved for 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.

Supplemental Questions

Required fields are indicated with an asterisk (*).
* The minimum qualifications of this position are graduation with a Bachelor’s degree from an accredited college or university with major coursework in related field, plus four (4) years of experience in the assigned area of specialization. Experience may substitute for the education up to the maximum of four (4) years. Do you meet these minimum requirements?
  • Yes
  • No
* Do you have the ability to travel to multiple sites as part of the regular job duties?
  • Yes
  • No
* This position requires a criminal background investigation (CBI). By selecting the following, you are acknowledging that you understand if you are selected as a top candidate for this position, you will need a successful CBI to be hired.
  • I acknowledge and understand this position requires a Criminal Background Investigation.


Optional & Required Documents

Required Documents Optional Documents

Job Address

Austin, Texas United States View Map