Senior Data Engineering Analyst

at  City of Edmonton

Job Number: 51038
If you have an analytical background and are looking to be part of the Business Intelligence Analytics team, then we would love to hear from you! Your success will be measured by your ability to achieve results in a respectful, inclusive and service-minded way.
Reporting to the Data Engineering team lead within the Data Analytics program, the Senior Data Engineering Analyst will play a pivotal role in our organization’s data strategy by designing, developing, and maintaining data pipelines, databases, and infrastructure. You will collaborate closely with cross-functional teams to ensure data is collected, processed, and made available for analysis and reporting. This role is essential in supporting data-driven
decision-making and the overall success of our business.

SKILLS REQUIRED FOR SUCCESS:

• Proficient in both frontend (HTML5, CSS3, React, Angular) and backend (Python frameworks like Django, Flask, FastAPI) technologies, enabling end-to-end development of applications
• Strong knowledge of SQL and experience with various database systems (PostgreSQL, MS SQL, MySQL, NoSQL), including data warehousing solutions like GCP BigQuery and Snowflake
• Comfortable working across Windows, Linux, and cloud environments (GCP, AWS, Azure) with familiarity in deploying and managing applications in these settings
• Experienced in ETL tools and data integration techniques, capable of building and maintaining data pipelines
• Able to translate business needs into technical solutions, analyze complex information, and effectively communicate findings to both technical and non-technical audiences
• Alignment to our Cultural Commitments and Leadership Competencies (https://bit.ly/4brRrXm)
• Embracing a culture of equity, diversity, reconciliation and inclusion. Alignment with the goals of the City Plan (https://bit.ly/3RZcCaA)

Qualifications:

• Related Degree in a related discipline and 4+ years relevant experience, OR
• Related Diploma and 5 years related experience, OR
• 1 yr related certificate and 7 years related experience
• Demonstrated experience in business intelligence administration, security, analysis and desig

• Work with internal and external customers to understand their business intelligence needs and translate them into technical solutions
• Design, build, and implement data engineering solutions, including data pipelines, data integration, extraction, warehousing, and monitoring
• Take minimal requirements, design comprehensive solutions, and manage the project through to successful completion
• Develop corporate-wide views, custom dashboards, and BI reports to provide insights and support decision-making. Perform in-depth analysis using data from various sources and formats
• Identify and evaluate new technology opportunities that can enhance enterprise-wide data BI systems
• Provide support and mentorship to business users on self-service BI tools and guide team members on data modeling, best practices, and BI tools (Tableau, Google cloud Analytics, etc.)
• Design and build robust data pipelines and data models to ensure they effectively address business questions
• Lead work stream planning, including technical design, development, testing, and delivery of end-to-end business solutions. Determine project feasibility and select appropriate tools and methodologies
• Identify and address performance bottlenecks in data pipelines and web applications by optimizing SQL queries, ETL processes, and frontend performance
• Develop and implement ETL processes for data marts and warehouses using tools like Python, Google Cloud, Fusion, and FME
• Perform other related duties as assigned to you

Qualifications:

• Related Degree in a related discipline and 4+ years relevant experience, OR
• Related Diploma and 5 years related experience, OR
• 1 yr related certificate and 7 years related experience
• Demonstrated experience in business intelligence administration, security, analysis and design