Job Details

Title: Digital Analyst II
Location: 2312 W. Casino Road • Everett, WA 98204 (Local candidates are preferred; however, remote candidates may be considered if they are legally authorized to work in the United States, reside within the U.S., and are available during standard Pacific Time business hours.)
Duration: 12 weeks

Job Summary:
Maintain and collect digital data collection and analytics for web, social, apps, and campaigns by defining tracking requirements, administering tools (e.g., GA4/GTM), and maintaining tags, conversions, and metrics. Analyzes and visualizes performance data to deliver insights, lead business reviews, and recommend strategic actions. Gathers reporting needs, translates them into user stories, and builds interactive dashboards/reports in Looker and Power BI using SQL/Excel, while ensuring data quality, governance, and compliance.

Job Duties:
Digital Data Architect
Maintain a structured approach for collecting, managing, and leveraging digital data to meet business objectives. Define what data needs to be captured to support analysis of the agency's digital platforms (e.g., websites, social, apps, campaigns, etc.). Set up and manage analytics software (e.g., GA4, Google Tag Manager, etc.). Implement new tracking tags for marketing campaigns or UX events. Update filters, conversions, or custom dimensions/metrics when business needs change.

Business Review
Proactively explore and analyze business data to uncover insights, trends and opportunities for improvement and strategic direction. Translate analytical findings into clear narratives using visualizations and storytelling. Lead and facilitate business review meetings with stakeholders to understand business priorities, to share findings, and to recommend strategic actions. Enable, support, and encourage the use of data in decision-making.

Report Curation
Identify, collect, and document business needs from stakeholders. Translate these needs into clear, actionable user stories and tasks that guide data architects, data engineers and analysts to collaboratively develop reporting products. Develop and publish interactive reports in Looker and Power BI for business stakeholders. Create visualizations, such as charts, graphs, and dashboards.

Data Analysis
Collect, clean, and analyze data to derive insights and inform decision-making. Analyze complex datasets to identify trends, patterns, and actionable insights. Use statistical and analytical techniques to interpret data trends. Use languages and tools like SQL, Looker, Power BI, and Excel.

Data Governance
Ensure data consistency, integrity, and accuracy. Perform systematic data quality checks on digital analytics software collection and preexisting reporting products to ensure data continue to be fit for use. Document processes, data definitions, and access controls. Enforce compliance and security requirements.

Minimum Qualifications:
• Three (3) years of experience in digital / web analytics (e.g., Google Analytics, Google Tag Manager, HTML, etc.).
• Three (3) years of experience querying data in a relational database environment (e.g., Snowflake, SQL Server, Oracle etc.).
• Three (3) years of experience in data analysis (e.g., Excel, R, Python, etc.).
• Two (2) years of experience in building dashboards or reports (e.g., Looker, Power BI, etc.).
• One (1) year of experience facilitating meetings and presenting analytical findings.
• A bachelor's degree in Marketing, Business Analytics, Information Systems, or a similar field.

Knowledge Requirements:
• Basic understanding of how digital data is collected (e.g., events, pixels, cookies, etc.).
• Familiar with digital analytic tools (e.g., Google Analytics, Google Tag Manager, etc.).
• Basic understanding of website development and processes (HTML, CSS, Javascript, etc.).
• Familiar with data validation techniques.

Skill Requirements:
• Fostering an inclusive workplace by upholding Community Transit's core values in support of the organization's vision and mission. Inspiring team commitment, pride, and trust while promoting cooperation and motivating members to achieve shared goals. Demonstrating courtesy, sensitivity, and respect in all interactions.
• Ability to frame business questions into data analysis problems and develop solutions.
• Proficient in configuring Google Analytics, Google Tag Manager and similar digital tools.
• Proficient in intermediate data manipulation (data validation, window or custom functions, pivot/unpivot) and analysis using Excel, SQL, Dax, and Python/R.
• Strong skills in Looker and Power BI report creation.
• Data cleaning, validation, and review techniques.
• Strong problem-solving skills and critical thinking abilities.
• Ability to work with limited supervision.
• Ability to write technical documentation for standard processes.
• Ability to communicate complex technical information to various audiences through reports and presentations.
• Willingness to stay updated with the latest developments in the field of digital data analysis and to continue learning and improving skills.
• Strong organization and prioritization skills for handling multiple tasks and projects.
• Team player: encouraging, communicative, supporting, contributing, and enthusiastic.