AWS Data Engineer
at Triunity Software
Toronto, ON, Canada -
Start Date | Expiry Date | Salary | Posted On | Experience | Skills | Telecommute | Sponsor Visa |
---|---|---|---|---|---|---|---|
Immediate | 13 Sep, 2024 | USD 80000 Annual | 15 Jun, 2024 | 7 year(s) or above | Communication Skills,Python,Email,Optimization,Json,Data Visualization,Sql Server,Sql,Continuous Delivery,Data Operations | No | No |
Required Visa Status:
Citizen | GC |
US Citizen | Student Visa |
H1B | CPT |
OPT | H4 Spouse of H1B |
GC Green Card |
Employment Type:
Full Time | Part Time |
Permanent | Independent - 1099 |
Contract – W2 | C2H Independent |
C2H W2 | Contract – Corp 2 Corp |
Contract to Hire – Corp 2 Corp |
Description:
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.
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.co
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.
REQUIREMENT SUMMARY
Min:7.0Max:12.0 year(s)
Information Technology/IT
IT Software - DBA / Datawarehousing
Software Engineering
Graduate
Proficient
1
Toronto, ON, Canada