Senior Data Analyst

As a City, we are powered by a dedicated workforce of approximately 2,600 employees committed to excellence in public service and making Chattanooga the best community in the country. Our team ensures our city thrives through a wide range of municipal services, including:

• Public Safety: Chattanooga Police and Fire Departments.
• Infrastructure & Utilities: Public Works, Waste Resources, and specialized Stormwater management.
• Quality of Life: Award-winning Parks and Outdoors and Community Development systems and the Chattanooga Public Library.
• Transportation: The Chattanooga Metropolitan Airport (CHA) and citywide transit and pedestrian friendly initiatives.
• Innovation: Leading-edge smart-city programs with a commitment to cutting edge workforce development policies to ensure all our residents can get ahead., Incumbents in this classification will improve citizen-focused service delivery within the city through departmental performance coaching, in-depth evaluation of city operations, continuous improvement projects, and operational analysis with modern data science tools. This includes measuring aspects of operational functions, citizen and user experiences, and community impact and desired outcomes. Responsible for analyzing data and performance results to develop insights and formulate recommendations to effectively communicate solutions and approaches to decision-making. Incumbents will be responsible for opening city data from various departmental data systems and community empowerment around the open data program and datasets. Work requires limited supervision and the use of independent judgment and discretion., ESSENTIAL FUNCTIONS: (The following duties ARE NOT intended to serve as a comprehensive list of all duties performed by all employees in this classification, only a representative summary of the primary duties and responsibilities. Incumbent(s) may not be required to perform all duties listed and may be required to perform additional, position-specific duties.)

Serves as a key resource to departments by developing, reporting, and visualizing metrics to guide strategic and operational decisions.

Leads non-technical stakeholders through complex analytical processes, translating data findings into accessible insights, structured training, and actionable guidance.

Manages data and AI projects through Jira, Bitbucket, and Confluence-organizing timelines, documentation, and cross-functional team workflows.

Maintains and collaborates on designing the technology platform to allow for the effective monitoring of key performance indicators.

Ensures the regular collection of data and subsequent reporting of data for the city within the organization and to external stakeholders.

Develops and recommends operational strategies based on results of data analysis activities. Compiles data and statistics using quantitative and qualitative methodology.

Employs principles and applications of mathematics and statistics, which may require knowledge of research methodology and techniques.

Builds and maintains scalable data pipelines and ETL workflows using Python, Dataform, APIs, and Google BigQuery.

Develops and deploys modern AI workflows (including Gemini integration) to automate data extraction, streamline reporting, and enhance operational insights.

Works with representatives from city government and external organizations to coordinate contributions of data. Performs onsite data reviews to understand the business processes and data capture methods in order to understand the data structure and value of the data being opened.

Oversees monitoring of data quality and identifies methods for improving the quality of data being published.

Supports third-party intermediaries wishing to access data and makes data accessible to different users through tools and applications.

Manages the city’s open data platform, ensuring datasets are accurate, useful, accessible, and integrated with core cloud infrastructure.

Conducts operational data reviews to evaluate business processes, analyze root causes, improve data quality, and monitor service delivery metrics.

Facilitates the impactful use of open data by collaborating with communities and ensuring all data added to the open data portal is useful, usable, and accessible.

Must meet regular attendance requirements.

Must be able to maintain good interpersonal relationships with staff, co-workers, managers, and citizens.

Must accomplish the essential functions of the job, with or without reasonable accommodations, in a timely manner.

Performs other duties as assigned., Sedentary Work: Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull, or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.

Bachelor’s degree from an accredited college or university with major coursework in business management, computer science, public administration, finance, information systems, mathematics, statistics, or any related fields with three (3) years of experience in utilizing data for operational or financial analysis; or any combination of equivalent experience and education.

LICENSING AND CERTIFICATIONS:

Valid Driver’s License

KNOWLEDGE AND SKILLS:

Knowledge of Google Cloud data platforms and processes, like BigQuery, Looker, Looker Studio, Google Workspace, or similar tools, with the ability to learn new tools. Proficient with Jira, Bitbucket (version control), and Confluence for documentation, tracking tasks, managing repositories, and driving agile projects. Knowledge of professional collection development principles; programming languages; creative problem-solving; and open data concepts.

Hands-on experience with Google Cloud Platform (GCP), BigQuery, Python (or similar scripting languages), SQL, Dataform, and Web API, or ability to learn quickly. Experience with Airbyte & Airflow or similar, Cloud Run, Gemini Enterprise, ADK, and/or Gemini Enterprise Agent platform is preferred. Experience using and developing generative AI workflows (e.g., Google Gemini, LLMs, prompt engineering) to streamline analytics pipelines and workplace efficiency.

Ability to research and provide formal analyses and recommendations. Ability to analyze data to evaluate effectiveness and make recommendations based upon insights. Ability to understand both qualitative and quantitative aspects of data and performance measurement. Works collaboratively and maintains positive interdepartmental partnerships. Demonstrated capacity for innovation, self-motivation, self-learning, self- learning and goal achievement; Strong critical and creative thinking skills to assess and resolve problems or issues by gathering and assessing information and using independent, professional judgment. Skilled in working with a variety of internal and external stakeholders. Skilled in effective written and oral communications that articulate complex information and issues clearly and simply. Skilled in gaining insight from quantitative and qualitative data.

• Competitive Compensation: Robust pay scales that reflect our commitment to our staff.
• Work-Life Balance: Generous paid time off and flexible scheduling where possible.
• Exceptional Wellness: Comprehensive health benefits and wellness programs designed for you and your family that deliver savings to you beyond your paycheck, featuring a centralized health clinic and pharmacy for all City employees. .
• Growth: A focus on professional development and upward mobility within the organization.
• The Great Outdoors: Your Backyard Playground: Chattanooga isn’t just near nature, it’s immersed in it. As one of the most biodiverse cities in North America, the “Scenic City” offers an ecological richness that few places on earth can claim. Whether you are an adrenaline junkie or a weekend wanderer, world-class adventure is always less than an hour away.
• Vertical Adventures: Scale legendary sandstone cliffs in what is widely considered the premier rock climbing hub of the Southeast.
• Water & Rapids: From the high-octane whitewater kayaking of the Ocoee River to world-class bass fishing and peaceful paddling on the Tennessee River.
• Trails for Miles: Explore a massive network of mountain biking and hiking trails that wind through lush ridges, hidden waterfalls, and deep river gorges.

In Chattanooga, “work-life balance” means you can finish your shift and be at a trailhead or on the water before the sun sets.

Our mission is to work together to build a safe, vibrant, and sustainable city for all Chattanoogans. To do that, it takes a team of skilled and passionate individuals. So, if you’d like to call Chattanooga home - or maybe you already do! - and want to further your career through meaningful work that makes a true impact where you live, we’d love to talk to you.

Salary: $60,088- $72,593 annually (GS.11)

Work Hours: Monday - Friday, 8:00 A.M. - 4:30 P.M. (EST) Hours may vary due to work assignments or projects.

Chattanooga, a vibrant and growing community of over 190,000 residents within a metropolitan area of nearly 600,000 is known as the “Scenic City” for a reason. Nestled along the Tennessee River and surrounded by the foothills of the Appalachian Mountains, we are a hub of outdoor adventure and innovation. Home to the University of Tennessee at Chattanooga (UTC) and Chattanooga State Community College, our city blends a rich industrial history with a tech-forward future-famously powered by the nation’s first community-wide “Gig” fiber-optic network. The City of Chattanooga was also recently designated as a “National Park City,” the first of its kind in the United States.