Data Warehouse Administrator

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?

We are seeking an exceptional Data Warehouse Administrator to join our dynamic team, responsible for maintaining and optimizing our data infrastructure. The successful candidate will have expertise in database management, business intelligence tools, and data analytics. The Data Warehouse Administrator will work closely with cross-functional teams to ensure data integrity and support business intelligence initiatives. The candidate will build, maintain, and administer the data cloud environment.

Key Qualifications

• Database Management: Design, implement, and maintain reliable and scalable database systems to support business operations. Optimize database performance through indexing, query tuning, and data modeling.
• Data Integration: Integrate data from various sources, ensuring accurate and efficient data processing and storage. Collaborate with data engineers to establish ETL processes and workflows.
• Business Intelligence: Develop and maintain BI dashboards and reports using tools such as Microsoft Power BI, Tableau, or similar platforms. Provide actionable insights and recommendations to stakeholders based on data analysis.
• Collaboration: Work with internal teams to gather requirements and understand business needs. Facilitate training sessions and provide support for end-users regarding BI tools and database queries.
• Security and Compliance: Implement and enforce security protocols to protect sensitive data and ensure compliance with relevant regulations. Monitor database access and performance to uphold data integrity and security.
• Continuous Learning: Stay current with emerging technologies and best practices in database management and business intelligence. Participate in training, workshops, and professional development opportunities.
• Testing and Validation: Develop and execute tests to validate AI/ML model performance, accuracy, and reliability. Ensure model bias and fairness are addressed.
• Code Quality: Write clean, modular, and well-documented code. Follow coding standards, best practices, and version control (Github).

Technical Skills:

• Proficiency in SQL and experience with relational databases like MySQL, PostgreSQL, or Microsoft SQL Server.
• Familiarity with data visualization tools (e.g., Power BI, Tableau) and data modeling concepts.
• Deep Knowledge of ETL processes and data warehousing solutions.

Soft Skills:

• Excellent problem-solving skills, with the ability to break down complex problems into manageable parts.
• Strong communication and collaboration skills, with experience working with cross-functional teams.
• Ability to adapt to changing priorities and deadlines.

Do you have…

• Bachelor’s or master’s degree in computer science, Mathematics, Statistics, or related fields.
• Experience working with local government, nonprofit programs, school or in job related duties
• 5 years of experience in database administration development, software development, or related fields

Preferred qualifications

• Experience with computer vision, natural language processing, or reinforcement learning.
• Knowledge of DevOps practices, CI/CD pipelines, and version control systems.
• Experience with cloud native applications, microservices architecture, and APIs.
• Certifications in BI, cloud computing, or related fields.
• Experience in Airia.ai platform
• Certifications in database management, BI tools, or data analysis.