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
