Principal Data Analyst

Houston-Galveston Area Council; Houston (TX); On-site; USD 84,182 - 110,000; Full time

Job summary

A regional planning organization in Houston, Texas is seeking a Principal Data Analyst to gather, analyze, and visualize data to support decision-making processes. The ideal candidate will possess strong SQL and Power BI skills, with experience in task automation and data analysis. This role offers a base salary range of $84,182 to $110,000 per year, with a focus on improving organizational processes and insights.

Qualifications

• 5 years of experience working with local government, nonprofit programs, or in related duties.
• Strong ability to analyze large datasets and extract actionable insights.
• Ability to translate complex business problems into data solutions.

Responsibilities

• Gather, clean, and validate data from various sources.
• Perform detailed statistical analysis to identify trends.
• Develop reports and visualizations using Power BI.
• Collaborate with business units to provide analytical support.
• Write and maintain SQL queries and data pipelines.
• Track key performance indicators and assist in dashboard development.
• Help define data standards and ensure governance compliance.
• Automate repetitive tasks using Microsoft Power Automate and Python.
• Provide training and support for analytical tools.
• Integrate automation workflows with existing systems.
• Stay up-to-date on new data analysis methods.

Skills

SQL

Excel

Power BI

Python

R

Data Analysis

Task Automation

Communication Skills

Problem-Solving

Collaboration

Education

Bachelor’s degree in applicable academic discipline

Tools

Microsoft 365

Asana

Microsoft Power Automate

Job description

Join to apply for the Principal Data Analyst role at Houston-Galveston Area Council

The Houston-Galveston Area Council is one of the largest regional planning commissions in the country with a diverse service area of 13 counties and more than 7 million people. We are the pulse of our region addressing issues that cross city limits and county lines every single day.

We make decisions that affect our transportation system, ensure the safety and well-being of our seniors, connect people to jobs, help families recover from natural disasters, preserve water quality for our children, and so much more. We work to make the region a great place to live, work, and thrive.

Houston-Galveston Area Council provided pay range

This range is provided by Houston-Galveston Area Council. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$84,182.00/yr - $110,000.00/yr

Direct message the job poster from Houston-Galveston Area Council

What will I be doing?

• Data Collection & Integrity: Gather, clean, and validate data from a variety of sources to ensure its accuracy and integrity.
• Data Analysis & Insights: Perform detailed statistical analysis to identify trends, patterns, and insights that inform business decisions.
• Reporting & Visualization: Develop reports, dashboards, and visualizations using Power BI to present findings to both technical and non-technical stakeholders.
• Collaboration: Work with business units to understand data needs and provide analytical support to improve organizational processes.
• SQL & Data Management: Write and maintain SQL queries, scripts, and data pipelines to automate reporting and data extraction tasks.
• Performance Monitoring: Track key performance indicators and assist in the development of performance dashboards aligned with agency goals.
• Data Governance & Documentation: Help define data standards, ensure governance compliance, and document data processes.
• Task Automation: Automate repetitive tasks using tools like Microsoft Power Automate, PowerShell, Python, and other technologies.
• Training & Support: Provide training and support for staff on analytical tools and automation workflows.
• System Integration: Work on integrating automation and analytics workflows with existing systems like Microsoft 365, Asana, and other business applications.
• Continuous Learning: Stay up-to-date on new data analysis methods, automation tools, and industry best practices to continuously improve processes and tools.

Key Qualifications

• Technical Expertise: Proficiency in SQL, Excel, and data visualization tools such as Power BI.
• Data Analysis: Strong ability to analyze large datasets and extract actionable insights.
• Programming Skills: Familiarity with statistical programming languages such as Python or R is a plus.
• Business Insight: Ability to translate complex business problems into data solutions and communicate findings to a broad audience.
• Data Infrastructure: Experience with data warehousing and ETL (Extract, Transform, Load) processes is preferred.
• Automation Tools: Experience with task automation platforms (e.g., Microsoft Power Automate, PowerShell, or Python) is a plus.
• Collaboration: Ability to work effectively in cross-functional teams, providing data-driven support to meet business needs.
• Communication Skills: Strong written and verbal communication skills, with the ability to present data in an easily digestible format.
• Problem-Solving: Strong analytical thinking with a proactive approach to identifying issues and implementing solutions.
• Teamwork & Independence: Ability to work both collaboratively within a team and independently, ensuring progress and deadlines are met efficiently.

Do you have…

• Bachelor’s degree in an applicable academic discipline or related field of study
• 5 years of experience working with local government, nonprofit programs, school or in job related duties

Preferred Qualifications

• Training experience
• Project management