AWS Data Architect

Berry Solutions Group is a leading IT Managed Service Provider that offers a wide range of IT solutions and services to small and medium-sized businesses. We help our clients achieve their business goals by providing them with reliable, secure, and efficient IT infrastructure and support. We are a team of passionate and experienced IT professionals who are committed to delivering excellence and customer satisfaction. At BSG, customer service is our top priority. We pride ourselves on delivering exceptional quality, integrity, and results. Our team is committed to solving complex problems and providing tailored IT solutions with care and precision.

About the Role
AWS Data Architect (Data Migration)

This role supports the Commonwealth of Pennsylvania (COPA). COPA is modernizing their Licensing and Permitting system, which will leverage a Salesforce front end and an AWS backend. The AWS backend will have multiple AWS services including data storage and data lake services, API services, and reporting services.

The AWS Data Architect will be responsible for defining and governing the overall data architecture required to support migration of legacy systems into the AWS PLC Data Layer. This role will lead data mapping, transformation design, and migration patterns to ensure data migration solutions are scalable, repeatable, and aligned with AWS best practices and program requirements.

Key Responsibilities
Define AWS data architecture and migration patterns for ingesting data from source systems (e.g., Oracle, CSV) into AWS (S3, data lake, Aurora).

Lead data mapping and design activities including source-to-target mappings, transformation rules, and canonical data model development.

Establish reusable ingestion and transformation patterns leveraging AWS services such as S3, Glue, and Aurora.

Define data quality and validation approaches including row reconciliation, referential integrity, and business rule validation.

Collaborate with stakeholders to evaluate architecture decisions, tradeoffs, and performance considerations.

Work closely with database engineers, data engineers, and SMEs to support migration build, testing, and cutover readiness.

Document data architecture, migration patterns, and process flows in alignment with project standards.

Ensure alignment to data governance requirements including classification, access control, and metadata standards.

Provide architectural guidance and resolve data design issues during migration execution.

Required Skills & Attributes
7+ years of experience in data architecture, data migration, or data platform design.

Strong experience with AWS data services including S3, Glue, and Aurora/RDS.

Strong experience with data modeling (conceptual, logical, physical) and canonical data model design.

Experience designing data migration patterns, ingestion pipelines, and transformation logic.

Experience implementing data validation and reconciliation strategies.

Experience with legacy-to-cloud data migration (Oracle or similar).

Previous experience delivering cloud-based solutions with cross-functional teams.

Previous experience creating architecture documentation including diagrams and process flows.

Nice to have
Experience with AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT).

Experience with Salesforce data integration patterns (external ID loads, CSV/JDBC).

#J-18808-Ljbffr