Clearance Requirement: Must be US Citizen and should be able to obtain DHS FEMA clearance. Job Description As a Data Architect, you will be responsible for owning the strategy, design, and implementation of data migration across multiple systems. The candidate must have a thorough understanding of database systems and software and a strong understanding of data security and data governance. The person in this position will own the data migration process throughout the entire project implementation lifecycle. They will also be responsible for ensuring the migration of data and/or data transformation meets the agreed-upon business requirements, ensures proper testing is implemented as well as performance and security are closely monitored. The candidate will also need to have experience in providing level-of-effort estimates for solutions around data migration and/or data transformation. Primary Responsibilities The Data Architect provides leadership in coordinating and reviewing the business process analyses, needs assessment, and preliminary cost/benefit analyses to align information technology solutions with the enterprise business initiatives. Develop database migration strategy and solution for On-prem to cloud data migration from multiple systems to one system. Migrate data from structured databases (source) to a combination of structured, semi-structured and unstructured databases (target) for a live system. Relies on experience and judgment to assign work to team members to completion dates. Is responsible for the orientation, coordination of training, assigning, and checking the work of team members. Direct team members around project related tasks and ensure they follow best practices. Is responsible for the organization’s data management, security, and migration initiatives. Examines the organization’s current data management systems and identifies opportunities to enhance performance and prepare for growth. Works with Enterprise Architecture team and assists in development of policies for standardizing systems, development tools and security practices. Design, model, document, and guide the logical and conceptual relationship of data and database changes for complex legacy applications. Identifies requirements, research options, designs, and implements solutions at a leadership level for the application included in the portfolio. Performs technical planning, system integration, verification and validation, cost, and risk assessments. Must be a self-starter, strong leader, and can work independently with little supervision. Required Skills and Experience 12-15 Years of a solid understanding of cloud and data architecture and the data flows between systems 8+ years of major projects focused on cloud and data architecture, master data management, data federation, ETL, security, quality, and related initiatives. Experience with database development and troubleshooting skills and ability to work closely across multiple teams and vendors to ensure successful releases and enterprise scale data migration. 5+ years of experience designing, developing, and managing enterprise-level databases using relational databases (Oracle/Postgres) Expert in data modeling experience (Conceptual, Logical, Physical/ERD) using proven techniques and modern tools. Experience migrating data from On-prem to cloud Developing a target state data vision and supporting realization by leading development activities in conjunction with various application development teams to achieve objectives. Data leadership, stakeholder engagement and management by applying excellent oral communications, solid presentation, interpersonal and problem-solving skills. Experience implementing large-scale solutions that empower business data and enterprise data integration using one or more major RDBMS platforms such as (Oracle, SQL Server, etc.) Experience with cloud data platforms (such as AWS RDS, etc.) Applying data engineering in a large environment by assessing the current state, performing requirements gathering, and producing analyses in multiple dimensions for disparate consumers Developing semantic layers and models in support of business intelligence and data analytics (BI and DW support) AWS Certifications Desired Skills and Experience Java Experience Experience with AWS DMS and/or AWS Glue
Data Flows Troubleshooting data-management Databases data-security Enterprise architecture (EA) Data Engineering data-modeling cloud-computing amazon-dms data governance aws-glue Team Leader Database engines Entity Relationship Diagram (ERD) stakeholder-management Business Intelligence (BI) Data Analyst Problem-solving data-migration Quality Assurance (QA) integration Data Architect requirements-management data-integration Java ETL RDBMS amazon-rds