Data Analyst III

About the role

We are seeking an experienced data warehouse administrator to be a part of one of the most highly regarded park systems in the country. Under limited supervision of the IT Program Manager, serves as the senior developer and administrator for the Park Authority’s data warehouse.

Responsibilities

Defines requirements, designs, develops, tests, debugs, and maintains the agency’s data warehouse, associated system interfaces, and business intelligence solutions. Ensures data integrity, availability, security, and reliable backups are performed. Facilitates data sharing with remote systems and agency transactional systems.

• Manages database and data architecture by designing, implementing, and optimizing storage solutions, including schemas, partitioning, indexing, and data modeling to balance performance, scalability, and cost for transactional and analytical workloads.
• Designs, builds, and maintains ETL (Extract, Transform, Load) pipelines using orchestration tools and big data frameworks to transport raw data from multiple sources into a centralized data warehouse.
• Collaborates with business analysts, data analysts, GIS analysts, and subject matter experts to design and provide optimized datasets to meet agency business needs and enable data-informed decision making.
• Creates and maintains data governance policies and best practices in accordance with the Department of Information Technology (DIT) to ensure consistency across agencies.
• Ensures data quality and adherence to data governance and security policies through validation rules, monitoring, and database design.

Requirements

Any combination of education, experience, and training equivalent to graduation from an accredited four-year college or university with a degree in Information Technology, Information Systems, Computer Science, Business Administration, or related field and coursework in analytics, biosystematics, biology, information architecture, engineering, library science, statistics, sociology, demographics, and/or marketing, Plus five years analysis of data and information experience in an academic, data administration, or business data analytics environment.

• Considerable knowledge of information systems and the components that process data.
• Considerable knowledge of the principles, practices, and methods related to information architecture.
• Considerable knowledge of data administration areas such as policies and standards, data definition, modeling and logical design, database design, and quality control.
• Knowledge of business intelligence solutions or data-related CASE and modeling tools.

Qualifications

Preferred qualifications include 3–5+ years working in data warehousing or database development and maintenance, strong experience with ETL tools, experience with transactional database platforms, and experience with cloud data warehousing platforms.

• Strong experience with ETL tools and experience building and optimizing data pipelines.
• Experience with governance frameworks, lineage, and metadata management.
• Proven collaboration skills with analytics/AI teams, including query optimization and dataset preparation.
• Excellent technical communication, problem-solving, and organizational skills.

Skills

• Skill in brainstorming, presenting, sharing, discussing, and defending ideas.
• Skill in problem-solving, with appreciation and respect for diversity of differing professional views.
• Skill in leading meeting participants toward consensus.
• Skill in designing and presenting conforming, efficient, and unambiguous models and diagrams of complex reporting and information systems.