Sr. 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.

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

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

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

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

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

Ten years of experience optimizing data integration and interoperability.

Ten years of experience with MS SQL Server Integration Services.

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

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

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

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

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