ETL Developer
at Arch Capital Group Ltd
Brockville, ON, Canada -
Start Date | Expiry Date | Salary | Posted On | Experience | Skills | Telecommute | Sponsor Visa |
---|---|---|---|---|---|---|---|
Immediate | 01 Sep, 2024 | Not Specified | 01 Jun, 2024 | 10 year(s) or above | Information Technology,Dimensional Modeling,Communication Skills,Vault,Etl Tools,Power Bi | 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:
With a company culture rooted in collaboration, expertise and innovation, we aim to promote progress and inspire our clients, employees, investors and communities to achieve their greatest potential. Our work is the catalyst that helps others achieve their goals. In short, We Enable Possibility℠.
Job Summary
The Senior ETL developer will work with the Corporate IT team to maintain and develop data integration solutions to support our Analytics platform. The solutions must align with data vault, data mart, dimensional modeling, and ETL standards and guidelines. The data modeling and data integration solutions will be based on Matillion with Snowflake data warehouses/databases & Power BI for reporting platform.
The ideal candidate will need to understand business and technical requirements and translate this into data integration designs and deliverables by working with the Corporate Data Architect. The position also requires supporting the Agile process in terms of Development, testing, deployment and post-production support.
Responsibilities
- 10+ years of experience in implementation of BI projects in a large-scale enterprise data warehouse environment and at least one Successful implementation Matillion with Snowflake
- Handle multiple projects in parallel, participate and deliver solution design while working closely with the architecture
- Design and Develop/Review ETL programs primarily using modern ETL tools like ADF, Matillion, DBT , SnowPipe and Python
- Coach and guide the technical team in terms development of ETL jobs
- Provide performance improvement and tuning of data pipeline.
- Perform technical reviews, data validation, and end to end testing of ETL objects, source data analysis and data profiling
- Create necessary documentation as per the standards and update the project documentation
- Support QE on end-to-end testing and provide daily/weekly project status to the project manager
- Work with deployment team in the code migration across the environments
- Triage the Production issues and work on the code fixes
Required Knowledge/ Skills
- Experience with Matillion configuration/administration and security setup will be added advantage
Desired Knowledge/Skills
- A team player with excellent verbal and written communication skills
- Experience with other ETL tools like ADF, Streamsets,
- Advance SQL knowledge and familiar with relational, Vault, and dimensional modeling
- knowledge of Power BI
Education
- Required knowledge and skills would typically be a acquired through a bachelor’s degree in information technology or related field
LH-LH1
Do you like solving complex business problems, working with talented colleagues and have an innovative mindset? Arch may be a great fit for you. If this job isn’t the right fit but you’re interested in working for Arch, create a job alert! Simply create an account and opt in to receive emails when we have job openings that meet your criteria. Join our
talent community
to share your preferences directly with Arch’s Talent Acquisition team.
How To Apply:
Incase you would like to apply to this job directly from the source, please click here
Responsibilities:
- 10+ years of experience in implementation of BI projects in a large-scale enterprise data warehouse environment and at least one Successful implementation Matillion with Snowflake
- Handle multiple projects in parallel, participate and deliver solution design while working closely with the architecture
- Design and Develop/Review ETL programs primarily using modern ETL tools like ADF, Matillion, DBT , SnowPipe and Python
- Coach and guide the technical team in terms development of ETL jobs
- Provide performance improvement and tuning of data pipeline.
- Perform technical reviews, data validation, and end to end testing of ETL objects, source data analysis and data profiling
- Create necessary documentation as per the standards and update the project documentation
- Support QE on end-to-end testing and provide daily/weekly project status to the project manager
- Work with deployment team in the code migration across the environments
- Triage the Production issues and work on the code fixe
REQUIREMENT SUMMARY
Min:10.0Max:15.0 year(s)
Information Technology/IT
IT Software - DBA / Datawarehousing
Software Engineering
Graduate
Information technology or related field
Proficient
1
Brockville, ON, Canada