Principal Data Analyst

About 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. 

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