Role : Data Architect Sr. Advisor
Location : Atlanta, GA (Onsite)
Type : Contract
Job Duties :
Key Responsibilities :
- Lead client engagement and guide team on performing the analysis of the existing / company being integrated into Client. 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 field3+ 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 ModelingPreferred Qualifications :
Proven work experience as a Data ModelerKnowledge of database structure systems and data miningExcellent analytical and problem-solving skillsUnderstanding of agile methodologiesUndergraduate or Graduate degree preferredAbility to travel at least 25%.