Data Architect

CONTRACTOR QUALIFICATIONS AND EXPERIENCE:

Bachelor’s or Master’s degree in Computer Science, Information Systems, or other related field. Equivalent work experience may be substituted for the educational requirements at a rate of one year of experience for one year of education.

Five years of experience in Data Administration, Data Warehouse architecture, and the Data Lakehouse development.

Five years of experience in data architecture, modelling, data standardization, and data quality assurance.

Five years of experience with SQL programming inclusive of stored procedures, functions, triggers, Data Transformation Services (DTS) packages, scheduled jobs, and linked servers.

Five years of experience with SQL relational databases, Online Transactional Processing (OLTP), or Decision Support System (DSS).

Five years of experience importing data into a large-scale data warehouse environment utilizing SQL Server Integration Services or Data Import functionality.

Five years of experience optimizing data integration and interoperability.

Five years of experience with MS SQL Server Integration Services.

Five years of experience implementing cloud architecture patterns and cloud platforms like Azure or AWS.

Five years of experience with source control systems such as Azure DevOps.

Five years of experience with integrated development environments (IDEs) like Business Intelligence Development Studio and Visual Studio.

Five years of MS SQL Stored procedures, triggers, scheduling and performance tuning.

Five years of experience working with data visualization tools (e.g., Tableau, D3.js and R).