QuantumBricks

Data Engineer

📍
Canada
🧪
Mid-Senior level
Responsibilities

  • Design, develop, and maintain ELT pipelines using Python, Airflow, and SQL in an AWS environment.
  • Create and manage a data lake and data warehouse solutions on AWS.
  • Develop and maintain data-driven dashboards and reporting solutions in PowerBI.
  • Connect PowerBI to SQL Server and PostgreSQL Aurora databases using a gateway.
  • Perform data profiling and source system analysis to ensure data quality and integrity.
  • Collaborate with business stakeholders to capture and understand data requirements.
  • Implement industry best practices for data engineering and visualization.
  • Participate in architectural decisions and contribute to the continuous improvement of data solutions.
  • Follow agile practices and a Lean approach in project development.
  • Optimize SQL queries for performance and ensure efficient database operations.
  • Perform database tuning and optimization as needed.

Required Skills And Experience

  • Expert-level proficiency in SQL (TSQL, MS SQL) with a strong focus on optimizing SQL queries for performance.
  • At least 6 years of experience will be preferred.
  • Extensive experience with Python and Airflow for ELT processes.
  • Proven experience in designing and developing data warehousing solutions on the AWS cloud platform
  • Strong expertise in PowerBI for data visualization and dashboard creation.
  • Familiarity with connecting PowerBI to SQL Server and PostgreSQL Aurora databases.
  • Experience with REST APIs and JSON.
  • Agile development experience with a focus on continuous delivery and improvement.
  • Excellent problem-solving skills and a proactive “can-do” attitude.
  • Strong communication skills and the ability to work collaboratively in a team environment.
  • Curiosity and eagerness to learn and adapt to new technologies and methodologies.
  • Ability to perform database tuning and optimization to ensure efficient data operations.

Key informations

🧳
Contract
📅
Posted 4 months ago

Don’t miss out on new
Data & AI Jobs

Get curated job alerts weekly.

Other jobs at QuantumBricks

QuantumBricks does not currently have any open job positions in Data & Ai.
© 2023 | All Rights Reserved | Built with 🤍 in MontrealAll our data is gathered from publicly available sources or contributed by users