We are seeking a highly skilled and motivated ETL (Extract Transform Load) Analyst to join the Edmonton Transit Service (ETS), Transit Service Development Team. As a key member of our team, you will play a crucial role in developing and delivering high quality data products to inform planning transit service. The primary responsibility is to develop ETL processes for organizing and extracting data from large and complex sources, with a focus on deriving actionable insights. This work will call upon you to apply cutting-edge techniques in data engineering and advanced analytics. What will you do: Develop, implement and maintain scalable ETL processes using SQL, Python along with other programming languages and tools to extract, transform and load structured data from various sources Implement data quality checks, validation rules and error handling mechanisms to ensure data reliability, accuracy and completeness throughout the ETL process Create and optimize SQL queries / ETL workflows for performance, scalability and efficiency, taking into consideration large data volume and resource limitations Lead the analysis of transit-related data sets, providing advanced statistical information to ETS Transit Service Development and branch leadership Organize extensive datasets and create models that discern trends and cause-effect relationships, resulting in recommendations that measurably maximize operational efficiency Analyze ridership, on-time performance, schedule adherence, and other operational aspects to inform actionable decisions Develop dashboards and reports using tools such as Tableau, Crystal Reports, etc. for application in operational settings Ensure high confidence interval calculations (95%25 CI) for ETS ridership calculations through statistically reliable processes Transform data into actionable insights to drive innovation and modernization Implement robust data governance processes to ensure transit data integrity Provide technical guidance and support, including mentoring junior data analyst(s), as well as collaborate with analysts across ETS and cross-functional teams Evaluate technologies and contribute to technology procurement projects University Degree in Computer Science, Industrial Engineering, Applied Statistics, Operations Research/Management Science, Business Administration, or Management Information Systems. A Masters Degree in a relevant field would be an asset Minimum four (4) years of directly related working experience in advanced analytics, data engineering, and data visualization Assets: Experience in data warehouse management, cloud data services, and process automation would be an asset Skills required for success: Proficiency in relational databases (e.g., Oracle, MS SQL Server), cloud data platforms (BigQuery, Snowflake, Databricks), reporting tools (e.g., FME, MS Reporting Services, Crystal Report), SQL, Python, KNIME, R, Tableau, and Google Applications Strong project management skills and with the ability to manage multiple priorities within tight deadlines Excellent written and verbal communication skills, including presentation abilities Demonstrated leadership, critical thinking, consensus building, and influencing skills Ability to work independently and thrive in a fast-paced, challenging environment Alignment to our Cultural Commitments and Leadership Competencies (https://bit.ly/4brRrXm) Embracing a culture of equity, diversity, reconciliation and inclusion. Conditions of Employment: Applicants may be tested The 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 employment@edmonton.ca. Learn more about our benefits https://bit.ly/COEbenefits Up to 1 permanent full time position Hours of Work: 33.75 hours per week; Monday- Friday Salary: $50.108 - $63.318 (Hourly); $88,277.770 - $111,550.490 (Annually) Talent Acquisition Consultant: AG/VH Edmonton rests in the heart of Treaty Six territory in Alberta and the homelands of the Metis Nation. IND123