System Architect IV (ATL)

Role: System Architect IV (ATL)

Work Location: Atlanta, GA (Hybrid)

Type: Contract

Job Duties: Key Responsibilities:

• Lead client engagement and guide team on performing the analysis of the existing/company being integrated.
• 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

• Client has acquired Salucro - a healthcare payments provider. They are looking to integrate its systems into Client’s network.
• The current platform leverages an outdated and disorganized data model that was built for a ticketing system Not a robust data and analytics solution.
• This assignment will strive to identify the gaps in design as well as gaps in data capture and come up with an approach to integrate it into Client data solutions.