Responsibilities
- Data Engineering Design, implement, and maintain data processing workflows within the data warehouse.
- Develop and optimize data models that support reporting and business requirements.
- Develop and maintain data collection, integration, or ingestion process for agency and digital data sources as assigned.
- Support implementation and maintenance of data tracking, tagging, or event collection frameworks for approved digital platforms when applicable.
- Establish monitoring, testing, and validation practices, including automated quality checks and controls.
- Optimize data processing, storage, and reporting performance.
- Troubleshoot and resolve issues affecting assigned data products and solutions.
- Enterprise Reporting & Stakeholder Collaboration Partner with business stakeholders to design and deliver reports, dashboards, and analytical solutions.
- Develop and publish data visualization and reporting products tailored to stakeholder needs, including operational, customer, and digital performance reporting where assigned.
- Analyze data and communicate findings, trends, and recommendations.
- Explore complex datasets to identify patterns and actionable business insights.
- Apply analytical, statistical, and programming techniques to support decision-making.
- Data Governance Follow established governance standards and data stewardship practices.
- Implement data quality controls and validation procedures.
- Support the integrity, consistency, and documentation of agency and digital data assets, including business definitions, metadata, and data lineage where applicable.
- Ensure solution is aligned with organizational architecture, security, and compliance standards.
- Monitor and maintain reporting and analytical products to ensure continued business value.
- Document code, processes, data lineage, business rules, and reporting logic.
- Support data access management in accordance with established policies and procedures.
- Influence Enable, support, and encourage the use of data in decision-making.
- Integrate with teams across the enterprise to understand subject matter and improve data maturity and culture change.
- Provide technical guidance on assigned analytical solutions and promote consistent data practices across operational and digital business domains
- Perform other duties of a similar nature or level.
Requirements
- Demonstrated proficiency in implementing, configuring, and administering Google Analytics 4 (GA4) and Google Tag Manager (GTM), including digital tagging, event tracking, and data validation.
- Three years of experience managing and querying data in a relational database environment (Snowflake, SQL Server, Oracle etc.).
- Three years of experience in data analysis using advanced tools (R, Python etc.).
- Two years of experience in developing business intelligence solutions using Microsoft Power BI, Microsoft Fabric, or comparable reporting and analytics platforms.
- Two years of experience modeling data in Star Schema.
- Experience working with structured, semi-structured or digital data sources.
- Bachelor’s degree in statistics, computer science, mathematics, engineering, or a similar field.
- An equivalent combination of education and experience to successfully perform the job duties is also accepted.
Benefits
- Employees (and their families) are covered by medical, dental, vision, basic life and disability insurance.
- Employees participate in the Public Employees Retirement System (PERS) and have the option to enroll in the agency’s deferred compensation plan.
- In addition to WA Paid Sick Leave, employees in this position, accrue of 24 days of Paid Time off (192 hours) in their first year and ten (10) paid holidays throughout the calendar year.
Work Arrangement
Hybrid
Additional Information
- Hybrid telework may be available. Availability is at management discretion and may not be available for this position based on the nature of the work.
- Work is performed in an office environment and requires the use of office equipment and technology.
- You will be required to move throughout and between different office buildings and may need to complete tasks in noisy environments.
- You may also be required to lift and carry materials up to 10 pounds occasionally.
- Some travel required less than 10% of the time.
- Only on-line applications accepted.
- Applicants for this job may be considered for other openings up to six months after the date this position is filled.
- Applicants who meet the minimum requirements may be scheduled for an interview as well as a variety of tests to demonstrate knowledge, and skills for the position.
- The evaluation process may include interviews, background check, reference checks and various performance tests.
- If you are related to or share the same living quarters of a current Community Transit employee, please let your Recruiter know as your eligibility for this position may be affected.
- Community Transit provides a tobacco-free and drug-free work environment.
- As a recipient of federal funds, Community Transit is an Equal Opportunity Employer and does not unlawfully discriminate on a basis prohibited by Federal, State or Local law.
- We value and encourage diversity in our workforce.
- EOE AA M/F/Vet/Disability.
- Qualified applicants will receive consideration for employment without regard to their race, color, religion, national origin, sex, protected veteran status or disability.
