Data Architect (Immediate Opening)

IDEA Public Schools; El Paso (TX); Remote; USD 89,000 - 106,000; Full time

Job summary

IDEA Public Schools seeks a Data Architect to lead the design and implementation of advanced data solutions in a national, full-time, remote role. You will collaborate with data leadership to modernize analytics infrastructure and ensure data governance. The position requires extensive experience in data architecture and cloud technologies, offering competitive salaries and comprehensive benefits.

Benefits

Medical, dental, vision plans

Disability and life insurance

Flexible spending accounts

Generous vacation

Referral bonuses

Professional development

403(b) plan

Relocation stipend

Qualifications

• 10+ years of related work experience and/or training.
• 3+ years in cloud implementations.

Responsibilities

• Design future-state analytical architecture and cloud migration roadmap.
• Lead platform evaluation and hands-on build-out of data infrastructure.
• Define and implement data integration, security, governance strategies.

Skills

Data Modeling

Cloud Services

Data Architecture

ETL

SQL

Linux Scripting

Education

Bachelor's degree in Information Technology/Computer Science

Tools

Snowflake

Databricks

AWS

Azure

GCP

Job description

Data Architect

Role Mission: IDEA is currently undergoing a significant digital transformation initiative to modernize our data and analytics infrastructure. As the new Data Architect, you will play a pivotal role in leading the architecture, design, and implementation of our next-generation data solutions. In this hands-on role, you will architect and engineer data pipelines, platforms, integrations, and products on modern cloud platforms, such as Snowflake, Databricks, Azure, and/or GCP. Collaborating closely with the data leadership team, you will shape the long-term vision, cloud adoption roadmaps, future-state analytical architecture, and data governance frameworks necessary for this transformation.

Location: This is a national, full-time, remote position. Quarterly travel is required for visits to our headquarters office located in Weslaco, Texas.

What You Do - Accountabilities

1. Design future-state analytical architecture and cloud migration roadmap.
2. Lead platform evaluation and hands-on build-out of data infrastructure on cloud technologies.
3. Define and implement data integration, security, governance, and metadata retention strategies.
4. Implement methodologies and reuse strategies to enhance quality while optimizing development.
5. Define metadata strategy and lineage tracking capabilities.
6. Drive initiatives to improve system reliability, availability, and performance.
7. Lead cloud adoption while ensuring continuity of existing analytical initiatives.
8. Continuously monitor post-implementation architecture health, performance, and scalability.
9. Provide guidance to software engineering teams on design, scalability, and performance.
10. Maintain continuity of existing analytics and data engineering initiatives during transformation.
11. Improve architecture health, scalability, and efficiency as changes emerge.
12. Design and document the Logical Data Model and develop a Physical Data Model.
13. Create and execute Data Definition Language (DDL) statements for Snowflake and/or Delta Lake objects.
14. Lead the team in designing 3NF logical and physical models in Erwin.
15. Drive and build data model and architecture, implementing frameworks to ensure adherence to data architecture.
16. Reverse engineer and understand the existing SQL/processes.
17. Assist in developing data strategies for cloud data platform, master data management, metadata management, analytics, and data integration.
18. Provide deep expertise in databases, data modeling, data architecture, and operating systems.
19. Support end-to-end data asset lifecycle management activities.
20. Design robust, scalable, real-time data pipelines and data platform architecture.
21. Lead the review and design of new data products, maintaining product documentation.

What You Bring - Competencies

Qualifications:

• Bachelor's degree in Information Technology/Computer Science from a four-year college or university.
• 10+ years of related work experience and/or training or an equivalent combination of education and experience.

Licenses or Certifications:

• Any Cloud Certifications (Azure, GCP, AWS)

Knowledge and Skills:

• 10+ years as a hands-on data engineering and 5+ years as a technical data architect with 3+ years in cloud implementations.
• Proven track record of driving large-scale cloud data platform modernization initiatives.
• Deep expertise with cloud services (e.g., AWS, Azure, GCP) and data framework providers (e.g., Snowflake, Databricks).
• Proficiency in designing scalable, fault-tolerant, and secure solutions.
• Ability to mentor developers, conduct code reviews, and lead design sessions.
• Champion data modeling standards and best practices.
• Knowledge of Data Warehousing, ETL, and BI architectures, concepts, and frameworks.
• Strategic leadership with the ability to communicate technology vision to executives.
• Self-driven technologist passionate about innovations in the data space.
• Ability to work independently and contribute effectively in a fast-paced environment.

Preferred:

• Knowledge of Canonical data models like HEDA (Higher education data architecture).
• 5 or more years' experience using Linux scripting (Python, Shell, etc.).
• 5 or more years' experience in SQL development and/or NoSQL databases.
• 5 or more years' experience with cloud-based data offerings (Amazon AWS, Redshift, Snowflake, Google GCP, Microsoft Azure).

What We Offer:

Salaries start between $89,600 and $105,300, based on experience and qualifications, and are aligned with internal equity. The role is eligible for performance pay. We also offer medical, dental, vision plans, disability, life insurance, parenting benefits, flexible spending accounts, generous vacation, referral bonuses, professional development, and a 403(b) plan. More info at IDEA Benefits. IDEA may offer a relocation stipend if applicable.

Application process:

Apply online via Jobvite. Applications are reviewed continuously until filled. Early applications are encouraged.

Learn more about IDEA

Our Staff Culture and Belonging Team promotes our Core Values to foster connection, integrity, respect, and belonging. Learn more at Our Core Values.