Data Analyst

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

Are you passionate about data, technology, and solving real-world problems? Do you enjoy transforming complex information into meaningful insights that help organizations make smarter decisions? If so, we invite you to bring your analytical skills and technical expertise to our team!

The City of Carmel is seeking a motivated, innovative, and detail-oriented Data Analyst to help drive data-informed decision-making 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.

Working at the intersection of data analytics, business intelligence, and data engineering, you will collaborate with teams across the organization to develop solutions that improve efficiency, strengthen reporting capabilities, and support strategic planning. Your work will help city leaders and employees make informed decisions that positively impact City services and the community we serve.

What You’ll Do

• Transform Data Into Insights: Collect, clean, validate, and analyze data from multiple sources to identify trends, patterns, performance opportunities, and areas for improvement.
• Build Powerful Dashboards and Reports: Design, develop, and maintain interactive business intelligence dashboards, performance reports, and data visualizations using tools such as Microsoft Power BI or comparable platforms.
• Solve Business Challenges: Partner with city departments to understand operational needs, define reporting requirements, establish meaningful performance metrics, and develop data-driven solutions.
• Connect Systems and Data: Build and maintain automated data pipelines, ETL/ELT processes, and integrations that bring information together from enterprise applications, databases, APIs, cloud platforms, and external sources.
• Strengthen Data Quality and Governance: Identify data discrepancies, establish consistent data definitions, document analytical methods, and support data governance, security, and privacy practices.
• Make Data Accessible: Help employees understand and use reports, dashboards, and self-service analytics tools through training, documentation, and knowledge sharing.
• Support Innovation: Collaborate with IT team members, application owners, vendors, and departmental stakeholders to improve data management, reporting capabilities, and enterprise analytics solutions.
• Drive Continuous Improvement: Identify opportunities to automate processes, improve reporting efficiency, and turn complex technical information into clear, actionable recommendations.

What We’re Looking For

We are looking for a collaborative problem-solver who combines strong analytical thinking with technical expertise and excellent communication skills. The ideal candidate enjoys digging into data, building practical solutions, and helping others use information more effectively.

What you will need:

• A bachelor's degree in information technology, data science, statistics, or a related field, or an equivalent combination of education and experience.
• Three to five years of experience in data analysis, business intelligence, analytics development, or data engineering.
• Experience querying and analyzing relational databases using SQL, including Microsoft SQL Server, PostgreSQL, MySQL, or comparable platforms.
• Experience developing dashboards, semantic models, measures, and calculations using Microsoft Power BI, Tableau, or similar business intelligence tools.
• Experience working with data integration, automated workflows, and ETL/ELT processes using Microsoft Fabric, Azure Data Factory, or comparable technologies.
• Experience working with cloud platforms such as Microsoft Azure or Amazon Web Services (AWS).
• Experience with data modeling, data warehousing, data validation, data governance, and information security practices.
• A valid Indiana driver's license, which must be maintained throughout employment.
• Experience supporting enterprise applications, municipal business systems, or analytics solutions in a government environment is preferred.
• An equivalent combination of education, training, and experience that provides the required knowledge, skills, and abilities may be considered.

Why Join Our Team?

Make a Meaningful Difference. Your work will help city departments operate more efficiently, improve services, and make informed decisions that benefit the community.

Work Across the Organization. Collaborate with professionals from multiple departments to solve diverse business challenges and develop solutions with organization-wide impact.

Build and Innovate. Apply your technical skills to modern analytics platforms, data integration tools, dashboards, and emerging data management solutions.

Turn Complexity Into Clarity. Help transform disconnected information into reliable, accessible insights that empower employees and city leaders.

Be Part of Something Bigger. Put your expertise to work in an environment where technology and data help support the essential services residents rely on every day.

Foundational Elements

VisionBe the best run, most desirable city in the nation.

MissionCurate an environment where big dreams flourish, powered by a world-class environment that elevates quality of life.

Values

• Innovate Fearlessly – Embrace change and reach higher.
• Lead with Heart – Serve with purpose, authenticity and care.
• Empower Together – Build bridges that unite, inspire and lift each other.

The City of Carmel, Indiana, is an Equal Opportunity Employer. In compliance with the Americans with Disabilities Act, the City will provide reasonable accommodations to qualified individuals with disabilities.