Jobs
>
Toronto

    SQL Engineer - Ontario, Canada - Hour Consulting

    Hour Consulting
    Hour Consulting Ontario, Canada

    2 weeks ago

    Default job background
    Description

    Our client, a rapidly expanding global technology partner, is looking for a highly skilled Business Intelligence Engineer to join their exceptional Technology and Development team.

    With a strategic focus on finance, banking, and corporate verticals, they have earned a stellar reputation for their commitment to excellence in every project they undertake.

    Are you a highly motivated and seasoned Business Intelligence Engineer (BIE) with a remarkable track record in harnessing the capabilities of AWS Redshift, excelling in ETL processes, and mastering reporting tools within a serverless AWS cloud environment? This role offers a unique opportunity to have an immediate and lasting impact on internal and external customers by harnessing the power of data to drive key business insights.


    Data Modeling and Analysis:

    Develop and maintain multidimensional data models that enable complex analyses and reporting, utilizing AWS Redshift and other relevant technologies.

    Design, implement, and enhance ETL processes to ensure efficient data extraction, transformation, and loading from various sources into data warehouses.

    Create and maintain visually compelling dashboards, reports, and data visualizations to communicate key insights and performance metrics.

    Business Collaboration:
    Collaborate with business leaders to understand their data needs and provide analytical support in answering critical business questions.

    Roadmap and Vision:
    Define the long-term vision and roadmap for business intelligence solutions, aligning them with organizational goals and strategies.
    Develop and maintain automated processes for data extraction, transformation, and reporting to improve efficiency and accuracy.

    Data Quality Assurance:
    Implement data validation and quality checks to ensure data accuracy and consistency.

    Stakeholder Engagement:
    Engage with stakeholders across various departments to gather requirements, provide insights, and deliver data-driven solutions.

    Performance Optimization:
    Optimize queries, reports, and ETL processes for performance and scalability, ensuring timely access to data.
    Create and maintain documentation for data models, ETL processes, and reporting solutions to facilitate knowledge sharing.

    Bachelor's or Master's in Computer Science, Data Science, Business Analytics, or a related field.
    Proven experience as a Business Intelligence Engineer with expertise in AWS Redshift, ETL processes, and reporting tools.
    Proficiency in SQL and data modeling for analytics and reporting.
    Strong proficiency in business intelligence and data visualization tools (e.g., Tableau, Power BI).
    Excellent problem-solving and analytical skills, with the ability to translate complex data into actionable insights.
    Python) for process automation.
    Comfortable working in an agile, dynamic, and rapidly evolving environment.
    AWS Certified Data Analytics - Specialty) are a bonus
    After-work socials

    We encourage you to apply today if you're ready to take the reins of your career and be a driving force behind transformative data solutions—a chance to unlock the power of data to make a real difference.

    North York, Onsite 3/4 days a week
    Permanent, Full-time/ Contract
    #
  • RealSage

    SQL Engineer

    5 days ago

    RealSage Toronto, ON, Canada

    Company Description RealSage is a data intelligence platform that enables multi-family asset owners and operators to make better decisions using AI. Our team comprises professionals from various backgrounds who work collaboratively to bring positive change to real estate decision ...

  • RealSage

    SQL Engineer

    5 days ago

    RealSage Toronto, ON, Canada

    Company DescriptionRealSage is a data intelligence platform that enables multi-family asset owners and operators to make better decisions using AI. Our team comprises professionals from various backgrounds who work collaboratively to bring positive change to real estate decision- ...

  • Ernst & Young Advisory Services Sdn Bhd

    SQL Configuration Engineer

    5 days ago

    Ernst & Young Advisory Services Sdn Bhd Toronto, ON, Canada

    Press Tab to Move to Skip to Content Link · At EY, you'll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we're counting on your unique voice and perspective to help E ...

  • Tata Consultancy Services

    Data Engineer Python SQL

    5 days ago

    Tata Consultancy Services Toronto, ON, Canada

    TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and designed to offer businesses a single window into industry-specific solutions. Our ...

  • CI Financial

    Senior Sql Server Database Engineer

    1 week ago

    CI Financial Toronto, ON, Canada

    At CI, we see a great place to work as one that is a safe place for everyone to have a voice, where people are empowered to take ownership over meaningful work, where there is an opportunity to grow through stretching themselves, where they can work on innovative products and pro ...

  • Zortechsolutions

    Data Engineer-SQL, Python, ETL- Canada

    1 week ago

    Zortechsolutions Old Toronto, Canada

    Role: Data Engineer-SQL, Python, ETL · Location: Remote/CANADA · Duration: 6+ Months · Job Description · Key Skills required: · We are looking for Senior Data Engineering Candidates based out of the US/Canada. · Expertise in SQL, Python and ETL flows is a must have. Medium expert ...

  • Wipro Limited

    Technical Lead

    1 week ago

    Wipro Limited Toronto, Canada

    Overview: · Must-have skills · - Cloud certified in one of these categories · - Azure Data Engineer · - Azure Data Factory, Azure Data bricks Spark (PySpark or scala), SQL · - Experience in Azure ingestion from on-prem source, e.g. mainframe, SQL server, Oracle. · - Experience in ...

  • AlphaForce Technology Solutions

    Azure Synapse Specialist

    3 weeks ago

    AlphaForce Technology Solutions Toronto, Canada

    **Azure Data Engineer (Synapse Specialist)** · **Location: Toronto, ON (Hybrid)** · **Azure Data Engineer (Synapse specialist)** · - 6+ years of experience in Azure data platforms development · - Strong experience in Azure Synapse, Azure Data Bricks, Data Factory, ADLS · - Strong ...

  • Wipro Limited

    Technical Lead

    2 weeks ago

    Wipro Limited Toronto, Canada

    Overview: · **About Wipro** · Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading technology services and consulting company focused on building innovative solutions that address clients' most complex digital transformation needs. · We leverage our holistic portfolio ...

  • Wipro

    Technical Lead

    2 weeks ago

    Wipro Toronto, Canada

    Toronto, Canada · - Tech Hiring · **Job Description**: · **About Wipro** · - Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading technology services and consulting company focused on building innovative solutions that address clients' most complex digital transformati ...

  • Iron Systems

    Dai

    1 week ago

    Iron Systems Toronto, Canada

    **Date Posted**: · - 7/14/2023 · **Job Function**: · - Software Development · **Location**: · - Toronto ON - CAN · **Offered Salary**: · - Competitive · Iron Systems is an innovative, customer-focused provider of custom-built computing infrastructure platforms such as network ser ...

  • Vision

    Technical Systems Analyst

    3 weeks ago

    Vision Toronto, Canada

    **TSA** · **Job Duties**: · - Assist developers with Snowflake environment setup, including data flows from multiple systems · - Transform raw employee data, write data to tables, and build a business rules engine to compare two data sets using Python & SQL · - Work with business ...

  • Ample Insight Inc.

    Data Scientist

    2 weeks ago

    Ample Insight Inc. Toronto, Canada

    Company Description · - You will join a world-class team of engineers and data scientists from Facebook, Uber, Amazon and Google. We are a fast growing consulting firm based in Toronto with clients ranging from leading startups building impactful technologies to Fortune 500 compa ...

  • Scotiabank

    Business Systems Analyst, Capital Markets Technology

    2 weeks ago

    Scotiabank Toronto, Canada

    Requisition ID: 197617 · Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. · **The Team** · Global Banking and Markets Engineering (GBME) is the fast-moving, award-winning technology engine that powers Scotiabank's Corporate, I ...

  • Experfy Inc

    Principal Data Scientist

    1 week ago

    Experfy Inc Toronto, Canada

    **Opportunity Description** · We are seeking a Principal Data Scientist with strongly developed expertise in graph-based AI and related technologies to maximize utilization of data and knowledge in the client's data and digital transformation. · **ESSENTIAL EXPERIENCE**: · - Degr ...

  • INNOVER GLOBAL INC

    Business Intelligence Consultant

    2 weeks ago

    INNOVER GLOBAL INC Toronto, Canada

    **Responsibilities**: · - Lead the design and development of data warehouse solutions using SQL Server, ADF, and other ETL tools. · - Build and optimize databases, data warehouses, and data marts, with a focus on delta/incremental and full loads. · - Collaborate with cross-functi ...

  • Breakdown Services, Ltd.

    SQL Database Administrator

    2 weeks ago

    Breakdown Services, Ltd. Toronto, Canada

    **Internet Development Services,** a subsidiary of **Breakdown Services Ltd**, is seeking an experienced **SQL Database Administrator **to design, implement and maintain the database infrastructure (servers, clusters etc.) behind several high traffic, high availability web sites. ...

  • Scotiabank

    Technical Analyst

    1 week ago

    Scotiabank Toronto, Canada

    Requisition ID: 196098 · Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. · **The Team** · Global Banking and Markets Engineering (GBME) is the fast-moving, award-winning technology engine that powers Scotiabank's Corporate, I ...

  • Capgemini

    Qe Tester

    2 weeks ago

    Capgemini Toronto, Canada

    Location: Toronto, ON · Hybrid 3 Days per week · **Job Summary**: · As a Quality Engineer (QE) with expertise in Python, Robot Framework, SQL, and Unix, you will play a critical role in ensuring the quality and reliability of our software products. You will collaborate with cross ...

  • Scotiabank

    Business Systems Analyst, Capital Markets Technology

    3 weeks ago

    Scotiabank Toronto, Canada

    Requisition ID: 196435 · Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. · **The Team** · Global Banking and Markets Engineering (GBME) is the fast-moving, award-winning technology engine that powers Scotiabank's Corporate, I ...