Jobs
>
Edmonton

    Senior Data Engineering Analyst - Edmonton, Canada - City Of Edmonton

    City Of Edmonton
    City Of Edmonton Edmonton, Canada

    2 weeks ago

    Default job background
    TEMPORARY
    Description
    Job Number: 49531


    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

    Qualifications:
    Related Degree in a related discipline and 4+ years relevant experience, OR
    Related Diploma and 5 yrs related experience, OR
    1 yr related certificate and 7 yrs related experience
    A minimum of four (4) years progressively responsible experience in a BI technical role within a large, complex organization
    Demonstrated experience in business intelligence administration, security, analysis and design
    Experience in Google Cloud Analytic Software, Tableau Software, Business Intelligence suite of tools such as Web Intelligence, Data Services, Data modeling, and Crystal Reports or equivalent
    Familiarity with Linux (Ubuntu flavor) server environments
    Comfortable working in Windows, Linux and Cloud environments
    Understanding of backend APIs
    Strong knowledge of SQL and database management systems (e.g., PostgreSQL, MS SQL, MySQL, NoSQL databases)
    Proficiency in HTML5, CSS3, and responsive web design principles
    Familiar with Frontend frameworks such as React, and Angular development
    Proficiency in developing backend with Python frameworks e.g. Django, Flask or FastAPI
    Expertise in using SQL in RDBMS including Oracle, MSSQL and PostgreSQL
    Familiarity with data warehousing solutions (e.g., GCP BigQuery, Snowflake) and cloud platforms (e.g., GCP, AWS, Azure)
    Experience with ETL tools and data integration techniques
    Technology-specific certifications and diplomas related to the work would be considered an asset
    Ability to understand the business needs and translate those needs into operational support and reporting tasks
    Ability to analyze complex information and make timely decisions using solution based problem solving
    Fully understands the importance of security to own work and the operation of the organization
    Proven planning and organizational skills to manage project delivery
    Demonstrated skills in facilitation of groups with competing interests and priorities
    Strong conflict resolution and negotiation skills with experience in solving complex and sensitive issues
    Strong communication (speaking, writing, presenting, drawing, facilitating) skills, including report writing and presenting with an ability to articulate and translate technical language to non-technical customers
    Demonstrated ability and willingness to develop strong relationships and work in a collaborative, integrated manner

    Hire is dependent on a Criminal Records Check (CRC) security clearance that is satisfactory to the City of Edmonton and is a requirement of this position.

    There may be a cost associated with this requirement
    Demonstrate service excellence, embracing diversity and promoting inclusiveness

    Demonstrate alignment with the Cultural Commitments of Safe, Helpful, Accountable, Integrated and Excellent, fostering an environment for others to do the same.

    For more information on the City's Cultural Commitments, please visit

    Demonstrate the foundational competencies, key behaviors and attributes of the City's six leadership competencies: Courage, Inclusivity, Values-Based Influencer, Collaborative Networker, Systems Thinker and Creative Innovator.

    For more information on the City's leadership competencies, please visit
    Applicants may be tested

    The City of Edmonton is committed to inclusive, respectful and equitable workplaces that represent the communities we serve.

    We continuously improve our systems, policies and practices to remove barriers and ensure our employees, in all their diversity, can succeed.

    We value applicants with a diverse range of skills, experiences and competencies, and encourage you to apply.

    To learn more, see the Art of Inclusion:
    Our Diversity and Inclusion Framework here:

    The City of Edmonton strives to provide reasonable access and accommodations throughout the application and selection process. If you would like to request an accommodation at any stage of the process, please contact .

    Up to 1 permanent full-time position

    Hours of Work: 33.75 hours per week, Monday - Friday

    The 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 advance.


    Salary:
    $ $ Hourly); $84, $108, Annually)


    Talent Acquisition Consultant:
    RM/MZ

    IND123

    Classification Title:
    Application & Infra Analyst II

    Posting Date:
    Apr 25, 2024

    Closing Date:
    May 9, :59:00 PM (MDT)

    Number of Openings (up to): - Permanent Full-time

    Union :
    CSU 52


    Department:
    Service Innovation and Performance

    Work Location(s): Century Place, 17th Floor, A Avenue Edmonton T5J 3A3
  • City Of Edmonton

    Senior Data Engineering Analyst

    5 days ago

    City Of Edmonton Edmonton, AB, Canada

    Job Description - Senior Data Engineering Analyst · 49531 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 dat ...

  • City Of Edmonton

    Senior Data Engineering Analyst

    5 days ago

    City Of Edmonton Edmonton, AB, Canada

    Job Description - Senior Data Engineering Analyst · Job Description · Job Number Job Number · : 49531 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 strateg ...

  • ATCO Group

    Data Analyst

    2 days ago

    ATCO Group Edmonton, Canada

    **Division: ATCO Gas & Pipelines** · **Location: Edmonton AB** · **Position: Data Analyst** · **Position Summary**: · Reporting to the Senior Engineer, Project Services in ATCO's Gas & Pipelines division, the Data Analyst is pivotal in leveraging data and analytics to benefit eng ...

  • Flair Airlines Ltd.

    Data Analyst

    1 week ago

    Flair Airlines Ltd. Edmonton, Canada

    **Want to be part of a team that's changing the way Canada travels?** · As Canada's largest independent ultra-low-cost airline, that's exactly what we're doing at Flair Airlines. By consistently offering airfares that are a fraction of the ticket prices of "those other airlines", ...

  • The Little Potato Company

    Junior Business Analyst

    3 days ago

    The Little Potato Company Edmonton, Canada

    PRIMARY FOCUS: · The primary focus of this position is to work with a high degree of collaboration with the key stakeholders at The Little Potato Company to contribute to the development and sustainment of the organization's business systems. Reporting to the Business Analyst Man ...

  • Enbridge Contingent Talent Community

    Project Manager

    5 days ago

    Enbridge Contingent Talent Community Edmonton, Canada

    **Work options**: Hybrid · - 1 Year Contract · - Hybrid: st NW, Edmonton, Alberta, T5J 0H3 · At Enbridge, our goal is to be the first-choice energy delivery company in North America and beyond—for customers, communities, investors, regulators and policymakers, and employees. · To ...

  • Iron Systems

    Technical Analyst

    1 week ago

    Iron Systems Edmonton, Canada

    Iron Systems is an innovative, customer-focused provider of custom-built computing infrastructure platforms such as network servers, storage, OEM/ODM appliances & embedded systems. For more than 15 years, customer have trusted us for our innovative problem solving combined with h ...

  • Gateway Mechanical Services

    Business Analyst

    13 hours ago

    Gateway Mechanical Services Edmonton, Canada

    Gateway Mechanical has an exciting opportunity for a Business Analyst in Edmonton · At Gateway Mechanical, we are focused on providing the best possible customer service in safe, effective, and innovative ways. · Founded in 1968, Gateway Mechanical is a privately owned company th ...

  • EPCOR

    Analyst, Project Risk

    1 week ago

    EPCOR Edmonton, Canada

    Highlights of the job · We are hiring one (1) Full Time, Permanent **Analyst, Project Risk** position working out of Edmonton, AB. · Analyst, Project Risk will play a crucial role in EPCOR Water Services by overseeing project/program risk management. Analyst, Project Risk respons ...

  • University of Alberta

    Business Analyst

    1 week ago

    University of Alberta Edmonton, Canada

    **RO Enrolment Systems & Service Innovation**: · - Competition No. · **S ** · - Posting Date · **Feb 12, 2024** · - Closing Date · **Will remain open until filled.** · - Position Type · **Full Time - Operating Funded** · - Salary Range · **$73,849 to $102,918 per year** · - Grade ...

  • Government of Alberta

    Petrochemical Program Advisor

    13 hours ago

    Government of Alberta Edmonton, Canada

    **Job Information**: · Senior Petrochemical Advisor (PS5 - 1 position) · Job Requisition ID: 42734 · Ministry: Energy · Location: Edmonton · Full or Part-Time: Full Time · Hours of Work: 36.25 hours per week · Regular/Temporary: Regular · Scope: Open Competition · Closing Date: M ...

  • Atco Ltd.

    Product and Master Data Analyst

    6 days ago

    Atco Ltd. Edmonton, Canada

    Always there. Anywhere. That's us A team committed to delivering inspired solutions for a better world. We care for our communities and each other, and we are committed to showing up for those who need us. We value and encourage diversity, and we have the courage to do the right ...

  • ATCO Group

    Product and Master Data Analyst

    1 week ago

    ATCO Group Edmonton, Canada

    Always there. Anywhere. That's us A team committed to delivering inspired solutions for a better world. We care for our communities and each other, and we are committed to showing up for those who need us. We value and encourage diversity, and we have the courage to do the right ...

  • Finning Canada

    Condition Monitoring Analyst, Mining

    13 hours ago

    Finning Canada Edmonton, Canada

    Company: · Finning Canada · Number of Openings: · 1 · Worker Type: · Permanent · Position Overview: · The Condition Monitoring Analyst (CMA), Mining - I works under the guidance of senior condition monitoring analysts to develop his/ her knowledge of mining equipment, data analyt ...

  • PCL Construction

    Technology Analyst Student

    2 days ago

    PCL Construction Edmonton, Canada

    **The future you want is within reach.** · At PCL, we build the places where life happens and find camaraderie in the process. We're a community of builders committed to building better communities. That's why we're always looking ahead, and not just to the next project or what's ...

  • Lorneville Mechanical Contractors Ltd

    Project Controls Analyst

    13 hours ago

    Lorneville Mechanical Contractors Ltd Edmonton, Canada

    Lorneville is a trusted partner with a proven track record in successfully and safely completing major projects across Canada. Our success is built on a foundation of senior on-site leadership, accountability to our customers' success and a commitment to safety. We are one of the ...

  • City of Edmonton

    Safe Mobility Analyst

    6 days ago

    City of Edmonton Edmonton, Canada

    **Safe Mobility Analyst** · **Job Number***: · **47393** · Put your superior analytical skills to work with the City of Edmonton's Safe Mobility Section The Safe Mobility Section provides leadership toward the City of Edmonton's efforts to achieve Vision Zero, zero traffic-relate ...

  • EPCOR

    Systems Analyst

    5 days ago

    EPCOR Edmonton, Canada

    Highlights of the job · We are hiring a full-time permanent · ** Systems Analyst** position working out of Edmonton, AB. · This position may be eligible for EPCOR's hybrid work program. · What you'd be responsible for · - Employing open communication and analytical skills to reso ...

  • Government of Alberta

    Capital Planning Analyst

    1 week ago

    Government of Alberta Edmonton, Canada

    **Job Information**: · Job Requisition ID: 46051 · Ministry: Treasury Board & Finance · Location: Edmonton · Full or Part-Time: Full Time · Hours of Work: 36.25 hours per week · Regular/Temporary: Regular · Scope: Open Competition · Closing Date: August 15, 2023 · Classification: ...

  • EPCOR

    Analyst, Energy Pricing

    6 days ago

    EPCOR Edmonton, Canada

    Highlights of the job · We are hiring one (1) Permanent, Full-Time · **Analyst, Energy Pricing** position within our Operations Services team in Energy Services. · Energy Services provides the regulated rate option (RRO) electricity for consumers within Edmonton and parts of Albe ...