Role: System Architect IV (ATL)
Location: Atlanta GA (Onsite)
Type: Contract
Job Duties:
- Lead client engagement and guide team on performing the analysis of the existing/company being integrated into US Bank. Reverse engineering a data model ETL code data pipelines. Profiling data.
- Develop conceptual logical and physical data models.
- Define relationships data flows and entity relationships to ensure efficient database architecture.
- Ensure data integrity consistency and normalization.
- Gather requirements from stakeholders to align data models with business needs.
- Collaborate with business analysts data architects and engineers to design solutions.
- Present data models and recommendations to clients and stakeholders.
- Design and implement data schemas in relational (SQL) and NoSQL databases.
- Optimize database performance indexing and query efficiency.
- Support ETL (Extract Transform Load) processes for data migration and integration.
- Ensure adherence to industry standards security policies and data governance frameworks.
- Work with compliance teams to align data models with regulations (GDPR HIPAA etc.).
- Keep up with industry trends in data modeling big data and AI/ML.
- Recommend improvements to data architecture for scalability and efficiency.
- Assess and map the existing structure for Salucro evaluate each field and how it is being used for operations / reporting / intelligence
- Optimize / rationalize the required tables and fields and map them to the target state define the model in the target state based on implementation plan
- Define the target state data model and business process along with technical implementation needs and migrate the data
Minimum Skills Required: Basic Qualifications:
- 8 years experience in professional services or related field
- 3 years experience working with databases such as Oracle SQL Server PostgreSQL and cloud data platforms like AWS Azure or Google Cloud.
- 3 years of experience working with SQL and data modeling tools.
- 3 years of experience working with data visualization tools such as Power BI & DAX Data Modeling
Preferred Qualifications:
- System Architect IV (ATL)