- 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