Senior Data Engineering Analyst Job Listing at City of Edmonton in Edmonton, AB (Job ID 49531)

Description

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.

Your success will be measured by your ability to achieve timely results in the context of a respectful, inclusive and service-minded style. With a focus on the City of Edmonton's Cultural Commitments to Safe, Helpful, Accountable, Integrated and Excellent, you will:

• Work with internal and external customers to develop and analyze business intelligence needs
• Provide input into business requirements for the design of solutions
• Interpret business requirements and determine optimum Data Engineering solutions, such as data pipeline, data integration, extraction, warehousing and monitoring
• Identify and provide input into new technology opportunities that will impact enterprise-wide data BI systems
• Take minimal requirements, design and present a solution, then construct it to a successful conclusion
• Design corporate-wide views, custom dashboards and BI reports
• Perform analysis for a wide range of requests using data in different formats and from various platforms
• Research business problems and create models that help analyze them
• Support and mentor business users on self-service delivery of business intelligence solutions
• Mentor team members on BI business requirements gathering techniques, data modeling methodology including best practices, and on Tableau, Google Cloud Analytics, Business Objects and other related applications
• Design and build the data pipeline and data model, ensuring it can answer the business questions
• Lead work stream planning process including inception, technical design, development, testing and delivery of end-to-end business solutions
• Determine feasibility of projects
• Determine appropriate tools and methodologies for all phases of the project
• Lead the planning, designing and execution of user efforts
• Review test plans and monitor testing process to ensure business results are tested
• Resolve any issues that are discovered based on test results
• Ensure reporting solution requirements are complete, well-designed, built and tested
• Develop and implement ETL (Extract, Transform and Load) for data mart/warehouse environment using Python, Google Cloud Fusion, Data Services, FME, or other BI tools as required
• Participate in the maintenance of Data Engineering solutions or enhancements by completing tasks such as design, coding, testing of analytical solutions, end-user support, performance tuning, documentation, and troubleshooting
• Identify and address performance bottlenecks in data pipelines and web applications. This may involve optimizing SQL queries, improving ETL processes, or enhancing frontend performance
• Provide backup for DE team lead and other team members as required
• Provide specifications and guidelines to other analysts
• Perform other related duties as assigned