We are looking for a savvy ETL Developer/ Data Engineer to join our team. The hire will be responsible for expanding and optimising our data and data pipeline architecture, as well as optimising data flow and collection. The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimising existing data systems and building them from the ground up.

Responsibilities :

- Maintain and provide enhancements to data architecture within new/existing systems, including the Data Warehouse.

- Recommend and implement processes to improve data quality, data reliability, and database performance.

- Employ a variety of ETL and integration tools for system and data integrations.

- Architect solutions that support data scientists and business stakeholders.

- Conduct ETL testing and data transformation testing.

- Develop data models for the data science team that can be utilised for data mining.

- Maintain source to target documentation and process flow documentation.

- Take on DBMS responsibilities and wear multiple hats, such as ETLs, serve as SQL Server DBA

- Processes/Job/Error Handling/Troubleshooting/Scheduling, etc.

- Proactively monitor ETL Processes / Jobs.

Requirements :

- 6-12 years of experience.

- Relevant hands-on work experience in a Data warehouse testing role.

- ETL (Extract, Transform, Load)/ODS (Operational Data Store) experience.

- Experience in MS SQL Server.

- Commercial Real Estate experience preferred.

- Bachelor's degree in Computer Science or Information Technology from an accredited institution.

- ETL Tools: SSIS 5+ years, Azure Data Factory (ADF) 3+ years, ZappySys 1 year, APIs 2+ years.

- Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL), as well as working familiarity with a variety of databases. (4+ years of SQL), and working knowledge of Azure.

- Proficient in MS SQL Server database, including setting indexes, database security, and backups.