onsite
Senior Data Architect - The Squires Group
Software Engineer
Senior Data Architect leading the design, modernization, and optimization of enterprise data platforms and pipelines for a high‑profile federal client, leveraging Python, SQL, AWS, and advanced data modeling to enable scalable analytics and data‑driven decision making.
About the role
Key Responsibilities
- Design and architect scalable data platforms, pipelines, and analytics solutions that meet federal security and compliance standards.
- Lead modernization of legacy data systems, implementing modern ETL/ELT workflows and cloud‑native services on AWS.
- Collaborate with data scientists, analysts, and stakeholders to define data models, governance, and quality frameworks.
- Optimize performance and cost of data pipelines through advanced SQL tuning, partitioning, and caching strategies.
- Mentor and guide a cross‑functional team on best practices in data architecture, security, and automation.
Requirements
- 10+ years of experience in data architecture, with a strong focus on enterprise data platforms and cloud services.
- Proficiency in Python, SQL, and AWS services such as Redshift, Glue, S3, and Athena.
- Deep knowledge of data modeling, ETL/ELT design, and big data technologies (Spark, Hadoop, etc.).
- Experience with data governance, security, and compliance in a federal or regulated environment.
- Excellent communication skills and ability to translate complex technical concepts to non‑technical stakeholders.