Municipal Data Analyst: Dashboards & ETL

City of Carmel, Indiana; Carmel (IN); On-site; USD 60,000 - 90,000; Full time

Job summary

City of Carmel, Indiana is seeking a Data Analyst to turn data into insights, develop dashboards, and improve operational performance across city departments.

In this role, you will turn data into actionable insights, develop interactive dashboards and reports, streamline data integration processes, and help departments better understand and use the information that supports their daily operations and long-term goals.

Qualifications

• Bachelor's degree in information technology, data science, statistics, or related field.
• 3–5 years of data analysis, BI, analytics development, or data engineering.
• Experience with SQL on MS SQL Server, PostgreSQL, MySQL, or equivalents.
• Experience building dashboards in Power BI or Tableau; data integration and ETL/ELT experience.

Responsibilities

• Transform data into insights by collecting, cleaning, and analyzing sources to identify trends and opportunities.
• Build and maintain interactive BI dashboards, reports, and data visualizations using Power BI or Tableau.
• Partner with departments to define reporting requirements and performance metrics for data-driven solutions.
• Connect systems and data by building automated pipelines, ETL/ELT processes, and integrations across applications and cloud platforms.
• Strengthen data quality and governance by defining data definitions and documenting analytical methods.
• Make data accessible through training, documentation, and self-service analytics tools.
• Support innovation by collaborating with IT, vendors, and stakeholders on analytics solutions.
• Drive continuous improvement by identifying automation and reporting efficiency opportunities.

Skills

SQL querying

Power BI

Tableau

ETL/ELT

Data Visualization

Data Modeling

Azure/AWS cloud

Data Governance

Government analytics

Education

Bachelor's degree in information technology, data science, statistics, or related field

Tools

Microsoft Power BI

Tableau

Microsoft SQL Server

PostgreSQL

MySQL

Microsoft Fabric

Azure Data Factory

AWS

Job description

City of Carmel, Indiana is seeking a Data Analyst to turn data into insights, develop dashboards, and improve operational performance across city departments.

In this role, you will turn data into actionable insights, develop interactive dashboards and reports, streamline data integration processes, and help departments better understand and use the information that supports their daily operations and long-term goals.