Sr. Data Architect
Apply NowCompany: RICEFW Technologies, Inc.
Location: Tallahassee, FL 32303
Description:
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).
CONTRACTOR RESPONSIBILITIES
Collaborate with the Project team, committees, and workgroups to design the enterprise data modernization architecture framework that will support manage data ingestion, storage, processing, and integration for internal and external data sets and include strategies to support advanced data analytics and dashboard reporting.
Collaborate with the information technology teams to customize and implement the enterprise Master Person Index (MPI) solution.
Perform data management tasks (such as data collection, ensuring high data availability, and disaster recover) for the customer on a weekly basis.
Produce and submit data reports related to quality improvement or technical assistance visits on a weekly basis.
Each day, maintain current SQL Server integration packages deployed in production.
Each day, maintain and support the Data Lakehouse.
Each day, develop new SQL server integration packages as needed for Extract, Transform and Load (ETL).
Each day, work with the programs and offices to standardize collection and storage of shared data as directed.
Implement SQL Server database standards on the Data Lakehouse.
Each day, monitor and optimize the existing Data Exchange Interfaces, including SQL Server Integration Services (SSIS), or any other system.
Each day, perform database administration tasks for the databases as per applicable policies and procedures.
Each day, collaborate with developers, management and cross-functional teams, and stakeholders at the enterprise level systems.
Each day, develop relational and dimensional data modeling, for SQL, Cosmo DB, and other NoSQL databases, for the data modernization efforts that align with business requirements.
Each day, assist to develop and establish data governance, master data management, and data architecture principles.
Each day, assist in developing and implementing data standards and policies to ensure data consistency, integrity, and quality.
Each day, develop, design, and implement data intake and optimization.
Each day, develop strategies for data storage, backup, and disaster recovery.
Assist the Department to ensure compliance with data security and privacy policies.
Actively participate in project status meetings.
Follow IT processes, and coordinate with other IT staff to ensure compliance with standards and guidelines (such as the Department Policies and Procedures).
Required Skills : Data Analysis,Tableau,Data Warehouse,SQL,SQL Server
Additional Skills : Data Architect,Business Intelligence Architect,Big Data
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).
CONTRACTOR RESPONSIBILITIES
Collaborate with the Project team, committees, and workgroups to design the enterprise data modernization architecture framework that will support manage data ingestion, storage, processing, and integration for internal and external data sets and include strategies to support advanced data analytics and dashboard reporting.
Collaborate with the information technology teams to customize and implement the enterprise Master Person Index (MPI) solution.
Perform data management tasks (such as data collection, ensuring high data availability, and disaster recover) for the customer on a weekly basis.
Produce and submit data reports related to quality improvement or technical assistance visits on a weekly basis.
Each day, maintain current SQL Server integration packages deployed in production.
Each day, maintain and support the Data Lakehouse.
Each day, develop new SQL server integration packages as needed for Extract, Transform and Load (ETL).
Each day, work with the programs and offices to standardize collection and storage of shared data as directed.
Implement SQL Server database standards on the Data Lakehouse.
Each day, monitor and optimize the existing Data Exchange Interfaces, including SQL Server Integration Services (SSIS), or any other system.
Each day, perform database administration tasks for the databases as per applicable policies and procedures.
Each day, collaborate with developers, management and cross-functional teams, and stakeholders at the enterprise level systems.
Each day, develop relational and dimensional data modeling, for SQL, Cosmo DB, and other NoSQL databases, for the data modernization efforts that align with business requirements.
Each day, assist to develop and establish data governance, master data management, and data architecture principles.
Each day, assist in developing and implementing data standards and policies to ensure data consistency, integrity, and quality.
Each day, develop, design, and implement data intake and optimization.
Each day, develop strategies for data storage, backup, and disaster recovery.
Assist the Department to ensure compliance with data security and privacy policies.
Actively participate in project status meetings.
Follow IT processes, and coordinate with other IT staff to ensure compliance with standards and guidelines (such as the Department Policies and Procedures).
Required Skills : Data Analysis,Tableau,Data Warehouse,SQL,SQL Server
Additional Skills : Data Architect,Business Intelligence Architect,Big Data