Envoy Global is a proven innovator in the global immigration space. Our mission combines our industry-leading tech platform with holistic service to streamline, simplify and expedite the immigration process for employers and individuals.
We are seeking a highly motivated Senior Data Engineer OR Data Engineer within Envoy Global's tech team to join us on a full time, permanent basis. This role is responsible for designing, developing, and documenting data pipelines and ETL jobs to enable data migration, data integration and data warehousing. That includes ETL jobs, reports, dashboards and data pipelines. The person in this role will work closely with Data Architect, BI & Analytics team and Engineering teams to deliver data assets for Data Security, DW and Analytics.
As our Senior Data Engineer OR Data Engineer, you will be required to:
- Design, build, test and maintain cloud-based data pipelines to acquire, profile, cleanse, consolidate, transform, integrate data
- Design and develop ETL processes for the Data Warehouse lifecycle (staging of data, ODS data integration, EDW and data marts) and Data Security (Data archival, Data obfuscation, etc.).
- Build complex SQL queries on large datasets and performance tune as needed
- Design and develop data pipelines and ETL jobs using SSIS and Azure Data Factory
- Maintain ETL packages and supporting data objects for our growing BI infrastructure
- Carry out monitoring, tuning, and database performance analysis
- Facilitate integration of our application with other systems by developing data pipelines
- Prepare key documentation to support the technical design in technical specifications
- Collaborate and work alongside with other technical professionals (BI Report developers, Data Analysts, Architect)
- Communicate clearly and effectively with stakeholders
To apply for this role, you should possess the following skills, experience and qualifications:
- Design, Develop, and Document Data Pipelines and ETL Jobs: Create and maintain robust data pipelines and ETL (Extract, Transform, Load) processes to support data migration, integration, and warehousing.
- Data Assets Delivery: Collaborate with Data Architects, BI & Analytics teams, and Engineering teams to deliver high-quality data assets for data security, data warehousing (DW), and analytics.
- ETL Jobs, Reports, Dashboards, and Data Pipelines: Develop and manage ETL jobs, generate reports, create dashboards, and ensure the smooth operation of data pipelines.
- 3+ years of experience as a SSIS ETL developer, Data Engineer or a related role
- 2+ years of experience using Azure Data Factory
- Knowledgeable in Data Modeling and Data warehouse concepts
- Experience working with Azure stack
- Demonstrated ability to write SQL/TSQL queries to retrieve/modify data
- Knowledge and know-how to troubleshoot potential issues, and experience with best practices around database operations
- Ability to work in an Agile environment
Should you have a deep passion for technology and a desire to thrive in a rapidly evolving and creative environment, we would be delighted to receive your application. Please provide your updated resume, highlighting your relevant experience and the reasons you believe you would be a valuable member of our team. We look forward to reviewing your submission.