Minimum Technical Qualifications 1. At least ten (10) years of working experience in the Information Technology or Information System (IT/IS) fields with extensive experience in the positions of enterprise data architect, data scientist, database architect/developer/administrator, database lead, or database designer/modeler, report designer, etc. 2. At least five (5) years of experience incorporating an industry’s open and non-proprietary Software Development Life Cycle (SDLC) methodology to lead and/or create data architectures, conceptual/ logical/physical data models for software development projects, while collaborating closely with an organization’s enterprise database unit and following all applicable enterprise IT standards, policies, processes, procedures, and best practices, etc. 3. At least five (5) years of experience participating in data testing, developing data strategies and associated polices and best practices to promote data security, integrity, quality, governance and consistency. 4. At least five (5) years of experience, as a Data Architect, with large organizations leading or participating in the technical implementation of BI and DW solutions for a wide variety of complex business processes and data including analytic platforms such as Power BI, Tableau, Amazon QuickSight and Azure Analysis Services. 5. At least five (5) years of experience designing and implementing highly available and fault tolerant databases including complex multi-node clustering and disaster recovery. 6. At least five (5) years of experience architecting and reviewing Extract Transform and Load (ETL) and/or Change Data Capture (CDC) processes using tools such as SQL Server Integration Services (SSIS), Amazon AWS Glue, and Azure Data Factory in an Enterprise environment. Desirable Technical Qualifications 1. Experience providing enterprise level data architecture and/or data modeling services at a public sector entity such as local, State or Federal agency. 2. Experience as a Data Architect leading or participating in the technical implementation of pension / retirement, or financial related software development projects. 3. Experience working with Data Tools, Business Intelligence Studio, and SQL Server Management Studio. 4. Experience in optimizing and reviewing Microsoft Structured Query Language (MSSQL) database processes including performance tuning of SQL query, trigger, stored procedures & DB engine. 5. Ability to effectively communicate and document designs, processes and work as well as develop, document and institute best practices. 6. Strong knowledge of Online Transaction Processing (OLTP) environments, design, modeling, performance considerations and SQL internals. 7. Experience with Agile delivery in enterprise-wide initiatives. Scaled Agile Framework (SAFe) certificate or equivalent enterprise agile certificate a plus. Client reserves the right to request a copy of certification. 8. Bachelor’s degree in Computer Science, Computer Engineering, or related fields from an accredited or government sanctioned college/university. Client may request a copy of the degree. 9. Experience with utilizing Extensive Markup Language (XML), JavaScript Object Notation (JSON), and Window Functions within SQL as well as experience with database technologies such as SQL, NoSQL, and Hadoop. 10. Experience with encryption and security (in flight, at rest, and column level). 11. Experience with source code management solutions such as Team Foundation Server (TFS) and Visual Source Control. 12. Experience using Simple Object Access Protocol (SOAP), Representational State Transfer (REST), and GraphQL web services.
