Azure Data Engineer ETL, SQL
Share
Job Location:
Monthly Salary:
Experience Required:
Posted on:
1 hour ago
Vacancies:
1 Vacancy
Job Summary
Job Description
Experience Required
68 years (with minimum 8 years noted for several responsibilities)
Role Description
The Data Engineer will be responsible for designing developing and maintaining enterprise-level data solutions with a strong focus on cloud-based ETL workflows and large-scale SQL data marts. The ideal candidate will possess deep expertise in data extraction transformation and loading processes as well as advanced proficiency in Azure data technologies.
Key Responsibilities
Demonstrate strong knowledge of ETL (Extraction Transformation Loading) processes utilizing frameworks such as Azure Data Factory Azure Synapse or Databricks including establishing and managing cloud connectivity across systems such as ADLS ADF Synapse Databricks.
Develop and support T-SQL programming solutions leveraging Azure Data Factory frameworks and Python scripting.
Apply a minimum of 8 years of experience working with large SQL data marts showing expert-level relational database knowledge.
Navigate and analyze massive data volumes to deliver efficient and effective data extraction design loading and reporting solutions for business partners.
Provide at least 8 years of troubleshooting and support for large database environments including test planning and execution activities.
Identify report and manage database security issues including user access management.
Design and support database backup strategies archiving storage management performance tuning ETL processing and capacity planning including importing large volumes of data from multiple systems.
Experience within financial institution data marts is considered an asset.
Experience applications is considered an asset.
Experience and expertise in Tableau dashboard design is considered an asset.
Work effectively independently and within a team environment.
Demonstrate a proactive organized approach with excellent analytical and problem-solving skills.
Exhibit flexibility willingness to learn and a strong can-do attitude.
Display strong verbal and written communication skills.
Essential Skills
Data Engineer
Desirable Skills
Experience with Tableau
.NET applications
Financial data marts
Advanced ETL and Azure cloud capabilities
Technical Keywords
Azure Data Factory
Synapse
Databricks
ADLS
ETL
SQL Data Marts
Python
T-SQL
Database Security
Performance Tuning
Tableau (Asset)
.NET (Asset)
Skills (Digital)
Python
Experience Required
68 years (with minimum 8 years noted for several responsibilities)
Required Skills:
Experience (Years): 4-6 Essential Skills: Work with project teams throughout the organization to design implement and manage CDN infrastructure using Akamai to ensure high availability performance and scalability for customer facing applications and business processes. Handle multiple priorities and assignments with excellence and precision. Be a part of a 24/7/365 organization (some after hours support is expected as part of normal on-call rotation). Directly support line of business development teams provide guidance to them on implementation and changes for customer facing applications Develop and maintain security protocols and measures to protect CDN infrastructure from cyber threats. Monitor and analyze network performance identifying and resolving issues to optimize content delivery of critical applications. Collaborate with cross-functional teams to integrate Akamai CDN solutions with existing systems and applications. Collaborate with information security teams to implement DDoS protection strategies and other security measures in the CDN. Provide technical support and guidance to clients and internal teams regarding CDN and security best practices. Work closely with vendor and professional service teams on delivery related activities and strategy. Qualifications: Bachelors degree in Computer Science Information Technology or a related field. OR similar work experience. Strong understanding of network protocols (HTTP/HTTPS DNS TCP/IP). Proven experience as a CDN Engineer or similar role with a strong focus on -depth knowledge of Content Delivery Network technologies including caching load balancing and content optimization. Excellent problem-solving skills and attention to detail. Strong communication and teamwork abilities. Experience supporting 24/7/365 customer facing applications at enterprise scale. Awareness and experience with cybersecurity tools and practices such as firewalls intrusion detection/prevention systems and encryption. Proficiency in scripting and automation (e.g. Python Bash) a plus. Relevant certifications (e.g. CISSP CEH) are a plus but not required.
Company Industry
IT Services and IT Consulting
Key Skills
- Accomodation
- Database
- Information Technology Sales
- Insurance Paralegal
