IT Data Analyst Senior (CDO) at City of Austin in Austin, TX

Apply for the IT Data Analyst Senior (CDO) position at City of Austin in Austin, TX. Find the best jobs for you effortlessly with InJob.AI, your ultimate solution for job search. Discover top job opportunities and streamline your job search process.

alert circle

Job Description

<div>
 <strong>
  Minimum Qualifications
  <br/>
  <br/>
 </strong>
 <strong>
  Education and/or Equivalent Experience:
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Graduation with a Bachelor&rsquo;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.
  </li>
  <li>
   Experience may substitute for education for up to (4) years.
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Licenses And Certifications Required
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   None.
   <br/>
   <br/>
  </li>
 </ul>
 Notes to Applicants
 <br/>
 <br/>
 This position is within Austin Energy&rsquo;s Data Office. The Data Office is Austin Energy&rsquo;s dedicated hub for advancing data management, analysis, and business intelligence strategies.
 <br/>
 <br/>
 By fostering a culture of data-driven decision-making, the Data Office empowers our organization to harness the full potential of our data assets.
 <br/>
 <br/>
 As a key component of our commitment to excellence, innovation, and operational efficiency, the Data Office plays a pivotal role in shaping the utility&rsquo;s future through the strategic collection, secure storage, insightful analysis, and effective utilization of data.
 <br/>
 <br/>
 The successful candidate will contribute their expertise and insights to further elevate Austin Energy&rsquo;s data management capabilities and advance our organization&rsquo;s data-driven initiatives.
 <br/>
 <br/>
 <strong>
  Essential duties / functions, may include (but not limited to) the following:
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Perform advanced data analysis to extract actionable insights.
  </li>
  <li>
   Utilize statistical analysis and data mining techniques.
  </li>
  <li>
   Design, create, and maintain relational databases and data systems.
  </li>
  <li>
   Develop and maintain data models to support data analysis.
  </li>
  <li>
   Create interactive data visualizations and dashboards BI using tools.
  </li>
  <li>
   Lead data profiling and cleansing efforts to ensure high data quality.
  </li>
  <li>
   Implement and use statistical models to identify data trends / patterns.
  </li>
  <li>
   Conduct predictive analysis to support strategic decision-making.
  </li>
  <li>
   Lead and manage data-related projects, ensuring timely project delivery.
  </li>
  <li>
   Create data visualizations and reports to present findings.
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Important Information
  <br/>
  <br/>
 </strong>
 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
 <strong>
  HERE
 </strong>
 for more information.
 <br/>
 <br/>
 <strong>
  When Completing The City Of Austin Application
  <br/>
  <br/>
 </strong>
 The City of Austin employment application is an official document; incomplete applications will not be considered.
 <strong>
  Please be sure that your application is a reflection of your entire work history.
 </strong>
 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 &ldquo;See Resume&rdquo; will not be accepted, and a resume alone will not be accepted in lieu of a complete online application.
 <br/>
 <br/>
 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.
 <br/>
 <br/>
 We reserve the right to verify high school and college education for top candidate(s).
 <br/>
 <br/>
 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.
 <br/>
 <br/>
 <strong>
  Veteran Interview Preference
  <br/>
  <br/>
 </strong>
 Military/Veterans must provide a copy of their DD214 verifying honorable discharge, at the time of initial interview to receive military/veteran interview preference.
 <br/>
 <br/>
 <strong>
  Criminal History Background Check
  <br/>
  <br/>
 </strong>
 This position requires a criminal background investigation.
 <br/>
 <br/>
 <strong>
  Fair Labor Standards Act
  <br/>
  <br/>
 </strong>
 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.
 <br/>
 <br/>
 <strong>
  Travel
  <br/>
  <br/>
 </strong>
 If you are selected for this position and meet the
 <strong>
  Driver Safety Standards
 </strong>
 in the City of Austin
 <strong>
  Driver Safety Program,
 </strong>
 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.
 <br/>
 <br/>
 <strong>
  Essential
  <br/>
  <br/>
 </strong>
 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.
 <br/>
 <br/>
 Pay Range
 <br/>
 <br/>
 $37.14 - $47.35 per hour.
 <br/>
 <br/>
 Hours
 <br/>
 <br/>
 <strong>
  Work Schedule Notes
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Monday - Friday; 8:00 a.m. - 5:00 p.m.
   <br/>
   <br/>
  </li>
 </ul>
 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
 <br/>
 <br/>
 <strong>
  Preferred Qualifications
  <br/>
  <br/>
 </strong>
 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 .
 <br/>
 <br/>
 <strong>
  Other
  <br/>
  <br/>
 </strong>
 Ability to travel to more than one work location.
 <br/>
 <br/>
 <strong>
  Duties, Functions And Responsibilities
  <br/>
  <br/>
 </strong>
 <strong>
  Essential duties and functions, pursuant to the Americans with Disabilities Act, may include the following. Other related duties may be assigned.
  <br/>
  <br/>
 </strong>
 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&rsquo;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.
 <br/>
 <br/>
 <strong>
  Responsibilities- Supervision And/or Leadership Exercised
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   May provide leadership, work assignments, evaluation, training, and guidance to others.
   <br/>
   <br/>
  </li>
 </ul>
 Knowledge, Skills and Abilities
 <br/>
 <br/>
 <strong>
  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.
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   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).
  </li>
  <li>
   Knowledge of analytics, visualization and business intelligence tools.
  </li>
  <li>
   Knowledge of data structures, patterns and data models and related industry-standard methodologies.
  </li>
  <li>
   Knowledge of Source-to-Target Mapping, Extract-Transform-Load ( ETL ) processing and Change Data Capture ( CDC ) concepts.
  </li>
  <li>
   Knowledge of statistical software, database queries and programming languages (e.g., Java, C++, Scala, SQL , Hive, Python and R), XML , JSON and XSD&rsquo;s.
  </li>
  <li>
   Knowledge of Big Data concepts, frameworks, products, and tools.
  </li>
  <li>
   Knowledge of data models and structures as well as database design tools (e.g., Visio, SQL , tec.)
  </li>
  <li>
   Skill in data modeling, database and data management, SQL coding, data warehousing, reporting, data warehousing, relational databases, and data integrity skills.
  </li>
  <li>
   Skill in data analysis, data visualization, data mining, reporting, and data integrity skills.
  </li>
  <li>
   Ability to clearly communicate technical concepts with clients to increase their understanding of their operations.
  </li>
  <li>
   Ability to consider and incorporate the implications of analysis into recommendations for business decisions.
  </li>
  <li>
   Ability to see the big picture and make decisions based on strategy and value delivered.
  </li>
  <li>
   Ability to turn data insights into recommendations for both clients and internal stakeholders based on context.
  </li>
  <li>
   Ability to adhere to required compliance to all change management policies and procedures.
  </li>
  <li>
   Ability to adhere to required compliance to all information security policies and procedures.
   <br/>
   <br/>
  </li>
 </ul>
 Criminal Background Investigation This position has been approved for a Criminal Background Investigation. EEO/ADA
 <br/>
 <br/>
 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.
 <br/>
 <br/>
 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&rsquo;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.
 <br/>
 <br/>
 <strong>
  Supplemental Questions
  <br/>
  <br/>
 </strong>
 Required fields are indicated with an asterisk (*). * Do you have the ability to travel to multiple sites as part of the regular job duties? * 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.
 <br/>
 <br/>
 <ul>
  <li>
   The minimum qualifications of this position are graduation with a Bachelor&rsquo;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?
  </li>
  <li>
   Yes
  </li>
  <li>
   No
  </li>
  <li>
   Yes
  </li>
  <li>
   No
  </li>
  <li>
   I acknowledge and understand this position requires a Criminal Background Investigation.
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Optional &amp; Required Documents
  <br/>
  <br/>
 </strong>
 <strong>
  Required Documents
 </strong>
 <strong>
  Optional Documents
 </strong>
</div>

AI Powered Job Insights

IT Data Analyst Senior (CDO) just opened up at the City of Austin! They are seeking a skilled individual to enhance their data management capabilities and support strategic data-driven initiatives within Austin Energy's Data Office.

📍 Location: Austin, TX  
đź’Ľ Position: Full-time  
⏰ Type: Regular  
đź“… Date Posted: 2024-07-18  
đź“… Job Close Date: 08/06/2024  

Role Summary:  
- Analyze data to extract actionable insights.  
- Maintain relational databases and design data systems.  
- Create visualizations and reports using BI tools.  
- Lead data projects ensuring quality and timely delivery.  

What You'll Do:  
- Perform advanced data analysis and employ statistical techniques.  
- Develop and maintain data models for analytical support.  
- Lead efforts in data profiling and cleansing to ensure high-quality data.  
- Conduct predictive analysis to influence strategic decisions.  
- Create interactive dashboards for clear data presentation.  

What's Needed:  
- Bachelor’s degree with 4 years of relevant experience or equivalent experience.  
- Proficiency in database design, data management architectures, and data mining techniques.  
- Strong skills in statistical software, SQL, and BI tools.  
- Ability to communicate complex data concepts to various stakeholders.  
- Experience in managing full-cycle data projects.  

They offer competitive health and welfare benefits, a supportive work environment focused on innovation, and opportunities for career development.

Top Interview Questions

  • Q: Can you describe your experience in developing and maintaining relational databases and data systems?

    A: I have over five years of experience in designing, creating, and managing relational databases using SQL Server and PostgreSQL. In my previous role, I developed a customer data management system that streamlined data collection and reporting. I implemented normalization practices to reduce data redundancy, and utilized indexing to improve query performance, ensuring easy access for analysts.

  • Q: How do you ensure data quality during the data profiling and cleansing process?

    A: To ensure data quality, I adopt a systematic approach starting with data profiling to identify anomalies and inconsistencies. I use tools such as Talend and Python scripts to automate the cleansing process, applying transformations to convert data into the desired format. I also establish quality metrics and perform regular audits to maintain data integrity and document the process to continuously improve our practices.

  • Q: Describe a project where you utilized predictive analysis for strategic decision-making.

    A: In a previous project, I developed a predictive model using Python and statistical techniques to forecast energy consumption patterns. By analyzing historical data, we identified peak usage times and customer behavior trends. The insights helped the management team devise targeted marketing strategies and optimize resource allocation, ultimately leading to a 15% reduction in operational costs.

  • Q: What is your approach to creating data visualizations and reports for different audiences?

    A: I tailor my data visualizations based on the audience's needs and expertise. For non-technical stakeholders, I focus on clear and intuitive dashboards using tools like Tableau and Power BI, ensuring that I highlight key insights without overwhelming them with data. For technical audiences, I provide detailed reports with granular data and contextual analysis, including insights on methodology and implications for decision-making.

  • Q: How do you stay updated on the latest trends in data management and analytics?

    A: I stay current by actively participating in professional groups and forums such as LinkedIn and local meetups. I subscribe to relevant industry publications and take online courses on platforms like Coursera and edX. This continuous learning helps me incorporate the latest data management architectures and analytics tools into my work, such as recent advancements in data lakes and machine learning applications.

People Faces

200+ professionals have found their dream job with InJob.ai this week.

salary

Salary Benefits

$37 - $47 /year

application process

Want to apply directly?

Apply for the IT Data Analyst Senior (CDO) position at City of Austin in Austin, TX using https://www.linkedin.com/jobs/view/3979381185

Get StartedGet Started

Similar Jobs found by InJob.AI


Scroll To Top
Get Started

Frequently asked Questions

Still have a question? Check out our FAQ section below.

FAQ Section

InJob searches for the best jobs, based on your profile and automatically generates customized cover letters for you. It saves a lot of hours in your job hunting time.

InJob creates your profile by having a conversation with you to learn about your skills and requirements. It also scans your resume to gather information about your experiences, skills, and achievements. This information is used to craft your profile in the backend which is further used to match jobs and gives you a personalized cover letter for each job opportunity.

InJob searches for job opportunities across a wide range of sources, including LinkedIn, Indeed, and hundreds of other job boards to find hidden gems. Its search is not limited, ensuring it covers as many potential job listings as possible. It also searches the career pages of individual companies that suit your target industry and location and you get applied there.

InJob is constantly active, scanning for fresh job opportunities every single minute. This ensures that you are the first person to apply to new job listings that align with your profile.

InJob plays matchmaker by comparing your profile and resume with job listings. Each job receives a score from 1-10, indicating how well you match with it.

In the upcoming update, Yes, this will be included and this will be the main differentiator. InJob will apply for jobs on your behalf. It will target top matches and craft custom cover letters for each job, ensuring your application stands out. InJob will also handle the application process, including visiting company websites and filling out forms.

In the upcoming update, Yes, InJob will provide an interactive dashboard that serves as mission control for your job search. It will display all the jobs InJob has applied for you and their current status. You will also be able to track which companies have shown interest in your profile and view the feedback they provided.

In an upcoming feature, Yes, InJob will collect all feedback, including positive and constructive feedback, and presents it to you. This will allow you to know exactly where you stand in the job market and provides insights on how to improve your skills.