ETL & Data Warehouse Engineer

PRIMARY DUTIES/RESPONSIBILITIES :

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

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

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

- Architect solutions that support data scientist and business stakeholders.

- Conduct ETL testing and data transformation testing.

- Develop data models for data science team that can be utilized 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

EXPERIENCE :

- Relevant hands-on work experience in a Datawarehouse testing role.

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

- MS SQL Server

- Commercial Real Estate experience preferred.

EDUCATION :

- Bachelors degree in Computer Science or Information Technology from an accredited institution

SKILLS :

- ETL Tools : SSIS 5+ years, Azure Data Factory (ADF) 3+ year, ZappySys 1yr, 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.

- Data Testing : 3+ years

- Fundamental knowledge of data warehouse concepts

- Data Warehouse testing : 2+ year.

- Javascript 1+ years, C# 2+ Years

- Experience in data duality, source systems analysis, and business rules validation.

- Ability to write and understand Source to Target documentation.

- Detail oriented and meticulous approach to duties.

- Keep our data separated and secure. Familiarity with data and cybersecurity.

- Good analytical skills.

- A knack for independent and group work.

- Capacity to successfully manage a pipeline of duties with minimal supervision.