Lead AWS Data Warehouse Architect (SME) - Onsite work in MD / Onsite interview

Lead Data Warehouse Architect

Position Description: The Data Warehouse Architect ( shall provide expertise in the most current principles and practices of architecture data management systems and experience in large system designs, and with data modeling in the information management arena. This individual provides expertise in modeling and organizing information to facilitate support of projects or information architectures. The individual also provides guidance on how and what to data and process models. The position primarily deals with transition planning from legacy to modern systems by concentrating on information flows, data exchange, and data translation standardization services.

1. Architect and design scalable solutions for the shared platform environment, focusing on reliability, performance, stability, and observability.
2. Collaborate with technical teams to optimize databases, ETL process, and reporting tool performance, minimizing resource contention and ensuring efficient data processing.
3. Define and implement data governance policies, standards, and procedures to uphold data integrity, security, and regulatory compliance within the shared platform.
4. Manage dependencies between applications and tools to ensure seamless integration and interoperability across the shared platform.
5. Develop monitoring solutions to track and manage the health and performance of the shared platform infrastructure, facilitating proactive issue resolution.
6. Implement change management processes to handle concurrent data access and changes, minimizing disruptions to the shared platform.
7. Foster collaboration among cross-functional teams to ensure clear communication and alignment of objectives.
8. Gather and analyze business requirements and technical constraints to design a scalable, secure, and high-performance architecture for the shared platform environment.
9. Collaborate with data governance teams to ensure alignment with data governance policies and security standards.
10. Design and document the overall system architecture, including data flows, integration points, and component dependencies.
11. Develop resource allocation, performance tuning, and observability strategies to optimize resource utilization and address potential contention issues.
12. Implement best practices in database design, data modeling, and performance tuning to enhance platform performance and scalability.
13. Design and implement monitoring solutions to proactively identify and resolve performance, stability, and reliability issues.
14. Collaborate with development teams to support versioning, change management, and concurrent data access requirements.
15. Evaluate and recommend appropriate technologies, tools, and frameworks for the shared platform environment, considering scalability, security, and integration capabilities.
16. Provide technical leadership and guidance to ensure adherence to architectural principles, standards, and best practices.
17. Stay updated with industry trends, emerging technologies, and best practices related to solution architecture, data management, and observability.

Education: Bachelor s Degree from an accredited college or university with a major in Engineering, Computer Science, Mathematics or a related field. Master s degree preferred.

General Experience: At least ten (10) years of experience planning, designing, building, and implementing IT systems.

1. Strong understanding of database design, performance tuning, data governance, and security best practices.
2. Proficiency in data modeling, ETL processes, and data integration techniques.
3. Experience with monitoring and observability tools like Splunk, Datadog, or New Relic.
4. Knowledge of cloud computing platforms and containerization technologies (e.g., AWS, Azure, Kubernetes).
5. Excellent analytical, problem-solving, and decision-making skills.
6. Strong communication and collaboration skills, with the ability to work effectively with cross-functional teams and stakeholders.
7. Familiarity with agile development methodologies and project management practices.

Specialized Experience: At least five (5) years of the required ten (10) years of experience must be in the direct supervision and management of major projects that involve providing professional support services and/or the integration, implementation and transition of large complex system and subsystem architectures. Must have led or been chief architect in major IT implementation efforts. Must demonstrate a broad understanding of client IT environmental issues and solutions and be a recognized expert within the IT industry. Must demonstrate advanced abilities to team and mentor and possess demonstrated excellence in written and verbal communication skills.

1. Key qualifications include strong project management skills, leadership abilities, effective communication, and the capacity to identify and resolve issues while adapting to changing circumstances. Significant experience collaborating with cross-functional teams, product owners, and stakeholders is essential
2. Preferred qualifications include a technical background and experience in data and AI/ML projects. Functional experience with local or government projects in Data Services (MDM/R360/EDMS), Child Support, Integrated Eligibility, Child Welfare, Adult Protective Services, Juvenile Justice, or Health and Human Services is also preferred