Job Number: 55798Are you passionate about leveraging modern cloud data architecture and artificial intelligence to make a tangible impact on public transit?Edmonton Transit Service (ETS) is looking for an innovative and collaborative Cloud Data Analyst to act as the cloud infrastructure expert of our team. In this pivotal role, you will architect and scale end-to-end data pipelines (ETL/ELT) on the Google Cloud Platform, transforming over million rows of complex and raw transit telemetry daily into actionable insights and advanced AI models. Your technical expertise will directly support daily transit operations, optimize workforce scheduling for over 2,000 transit operators, and continuously improve the transit experience across our city. If you are driven by cloud computing efficiency, pipeline reliability, and writing scalable production code, this is your opportunity to build upon our existing enterprise architecture and scale it for the AI era!What will you do?Build & Scale Data Architecture: Design, maintain, and optimize robust ETL/ELT pipelines in Google Cloud Platform (GCP) and BigQuery to process over a million rows of transit data dailyOptimize Cloud Costs & Performance: Continuously evaluate data compute environments using advanced SQL, table partitioning, and clustering techniques to ensure fiscal responsibility and performance efficiencyAutomate Data Quality: Create automated validation framework rules to systematically clean data anomalies such as duplicate bus pings, corrupted data payloads and logical outliers - before data feeds AI agents and downstream applicationsEnable Data-Driven Decision Making: Leverage applied statistics and predictive analytics to solve complex transit business problems. Transform the outputs of massive data pipelines into clear, enterprise-grade dashboards (using tools like Tableau or Looker) that empower cross-functional leadership to make strategic, data-informed decisionsOperational Support: Facilitate the Annual Operator Vacation Sign-Up process for nearly 2,000 transit operators, balancing operational needs with collective agreement parametersEnable AI & Predictive Analytics: Structure and provision clean, reliable enterprise data feeds that serve as the foundational truth. In future phases of the roadmap, build, configure and deploy the AI micro-agents and predictive models that utilize this dataCross-Functional Collaboration:



Actively partner with analysts across Edmonton Transit Service (ETS) to ensure enterprise pipelines align with diverse operational workflows and municipal requirementsQualifications:University Degree in Computer Science, Software Engineering, Management Information Systems, Data Science/Analytics, Applied Statistics, Operations Research, or a directly related technical fieldMinimum of four (4) years of directly related hands-on experience in programmatic data engineering, cloud data architecture, and enterprise ETL/ELT pipeline developmentAssets:Google Cloud Professional Data Engineer or Google Cloud Professional Machine Learning Engineer certificationsFormal credentials or demonstrated experience in contemporary Generative AI, Large Language Models (LLMs), or agentic AI frameworksExperience or training in modern data orchestration tools (e.g., Apache Airflow, dbt)Skills required for success:Technical Mastery: Deep proficiency in programmatic data manipulation using Python and advanced analytical SQL. Highly capable of writing complex time-series logic utilizing Common Table Expression (CTEs) and Window FunctionsCloud & Orchestration Expertise: Demonstrated ability to manage cloud data warehouses and implement structural optimizations like table partitioning and clustering in Google BigQuery. Proven experience orchestrating complex production pipelines using Apache Airflow or dbt / Dataform, while adhering to software delivery best practices including Git and CI/CDPipeline Reliability: Proven track record of designing highly scalable, idempotent ETL/ELT pipelines that can process massive daily data volumes and safely recover from automated failures without duplicating recordsAnalytics & Visualization: Strong proficiency in applied statistics, enterprise BI tools (Tableau, Looker, PowerBI), and advanced data analytics (descriptive, diagnostic, and predictive). Demonstrated ability to go beyond basic reporting by transforming massive pipeline outputs into strategic,



actionable insights that solve operational transit problemsCommunication & Collaboration: Clear communication skills with proven ability to translate complex ETL/AI technical concepts into accessible insights for diverse non-technical team members and collaboratorsProblem Solving & Time Management: Exceptional ability to independently navigate and process massive, high-velocity data streams under tight deadlines while balancing short-term operational demands with long-term architecture goalsStrict adherence to fiscal responsibility, demonstrating the ability to proactively balance scalable data architecture with rigid cloud compute budgets to prevent cost overrunsAlignment to our Cultural Commitments and Leadership Competencies (https://bit.ly/4brRrXm)Embracing a culture of equity, diversity, reconciliation and inclusionConditions of Employment:Satisfactory completion of relevant background checks prior to commencementWork Environment:This role primarily operates in a standard, modern office setting with options for hybrid working arrangements in accordance with City of Edmonton policies. Physical demands are minimal and typical of a computer-focused administrative positionThe weekly hours of work for this position are currently under review and may change at a future time. Any changes will be made in accordance with the City of Edmonton/Civic Service Union 52 collective agreement, and the incumbent will be notified in advanceThe City of Edmonton values applicants with a diverse range of skills, experiences and competencies, and encourages you to apply. We strive to provide reasonable access and accommodations throughout the recruitment process. To request an accommodation, please contact [email protected]. Learn more about our benefits https://bit.ly/COEbenefitsHours of Work: 40 hours per weekSalary Range: $48.774 - $61.628 (Hourly) $101,840.110 - $128,679.260 (Annually)Recruitment Consultant: AG/SOEdmonton rests in the heart of Treaty Six territory in Alberta and the homelands of the Métis Nation.IND123Classification Title: Methods Analyst II - 8hrsPosting Date: Jul 31, 2026Closing Date: Aug 14, 2026 11:59:00 PM (MDT)Number of Openings (up to): 1 - Permanent Full-timeUnion : CSU 52Department: Edmonton Transit ServiceWork Location(s): Ferrier Garage, 8620 - 58 Ave Edmonton T6E 5G3
#J-18808-Ljbffr

📌 Cloud Data Analyst (Methods Analyst II) (Alberta)
🏢 City of Edmonton
📍 Alberta