Data Architect (Immediate Opening)

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

Job summary

A leading educational organization seeks a Data Architect to spearhead their digital transformation. In this role, you will design and implement innovative data solutions using modern cloud technologies, ensuring the architecture meets future needs. You will work collaboratively with data leadership to shape strategies and oversee the migration to cloud platforms. This position offers a competitive salary and comprehensive benefits, including medical, dental, and vision plans, as well as generous vacation time.

Benefits

Medical, dental, and vision plans

Disability and life insurance

Flexible spending accounts

Generous vacation

Referral bonuses

Professional development

403(b) plan

Qualifications

• 10+ years related work experience in data engineering and architecture.
• Proven track record of cloud data platform modernization.

Responsibilities

• Lead architecture and implementation of data solutions on cloud platforms.
• Design and document logical and physical data models.
• Drive initiatives to improve system reliability and performance.

Skills

Data Modeling

Cloud Services

SQL Development

Linux Scripting

Data Governance

Education

Bachelor's degree in Information Technology/Computer Science

Tools

Snowflake

Databricks

Azure

GCP

Job description

Data Architect

Software Development

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

Essential Duties:

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 from a four-year college or university in Information Technology/Computer Science.
• 10+ years 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 leader 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:

Compensation & Benefits: Salaries for this role start between $89,600 and $105,300, based on experience and qualifications, aligned with internal equity. This role is also eligible for performance pay based on organizational performance and goal attainment.

Additionally, we offer medical, dental, and 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:

Submit your application online through Jobvite. Applications are reviewed continuously until filled. Apply early.

Learn More About IDEA:

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