Role: AWS Data Engineer
Location: Toronto-ON
Nature: Day one On-Site (No exceptions)
Job Type: Fulltime
Experience: 7+ years

*Candidates with Career gap can also apply*

Job description

We are seeking an experienced Data Engineer to join our team of passionate professionals working on Triunity Software Inc. In this role, you will be responsible for the ELT of Canibuild data using Python, Airflow, and SQL within an AWS environment. Additionally, you will create and maintain data visualizations and dashboards using PowerBI, connecting to our SQL Server and PostgreSQL Aurora database through a gateway. This position offers a unique opportunity to influence architectural decisions and contribute to the development of a data warehouse in a cloud-native environment.

Responsibilities:
Design, develop, and maintain ELT pipelines using Python, Airflow, Snowflake and SQL in an AWS environment.

Create and manage a data lake and data warehouse solutions on AWS or Snowflake.
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.

Experience:
Expert-level proficiency in SQL (TSQL, MS SQL) with a strong focus on optimizing SQL queries for performance.

At least 7 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.

For more information, please get in touch with

Krishna |Sr. Talent Acquisition Specialist| Triunity Software Inc.
Phone: 732-784-3793, Extension No:-1005
Email: krishna@triunitysoft.com
W: www.triunitysoft.com

Compensation: $80,000.00 - $140,000.00 per year

About Us

Triunity is a Product Development, Staff Augmentation, and Consulting Services company providing solutions and services in North America. We provide IT services and technology solutions to various business verticals like Healthcare, Pharma, Banking, Finance, etc. Our goal is to develop a long-term partnership with businesses and help them get a competitive advantage by providing IT infrastructure and software platforms.

Lead by experts in the IT industry with a proven record of delivering software solutions, consulting, and staffing services, we have expertise in fulfilling client needs in terms of customized business solutions as well as IT consulting. At Triunity, we always try to bring the right mix of skills, technologies, and experts together which helps our clients to stay ahead in the competition. Our goal is to make our clients empower with cutting-edge technologies and take care of all their IT needs so they can focus more on their core business.

Triunity Culture

Our core value is our people and our teams . We believe the real mantra of success is like minded people with right mix of technical and analytical skills. Our strength lies in bringing right set of people and delivering work as a team. Be it expert or intern Triunity always always value its own people and give them platform to excel in their career.

At Triunity you can expect

Challenging & Friendly
Work on new edge technologies & tools
Work with industry experts
Solving complex client problems and delivering solutions
Working on projects lasting from six months to several years

Careers & Growth Model

At Triunity people are motivated by the complexity and challenges they face when working on client projects . We always motivate our people to keep learning new technologies and also give them platform where they can get chance to show their technical and analytical skills . We help our people in adding latest technologies ,tools, methodologies and certifications to their resume by arranging trainings , seminars and knowledge sharing sessions.

(if you already have a resume on Indeed)