Data Architect (24-25)

San Antonio, TX, United States

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’ll Do - Accountabilities

Essential Duties:

Design future-state analytical architecture and cloud migration roadmap.

Lead platform evaluation and hands-on build-out of data infrastructure on cloud technologies.

Define and implement data integration, security, governance, and metadata retention strategies.

Implement methodologies and reuse strategies to enhance quality while optimizing development.

Define metadata strategy and lineage tracking capabilities.

Drive initiatives to improve system reliability, availability, and performance.

Lead cloud adoption while ensuring continuity of existing analytical initiatives.

Continuously monitor post-implementation architecture health, performance, and scalability.

Provide guidance to software engineering teams on design, scalability, and performance.

Maintain continuity of existing analytics and data engineering initiatives during transformation.

Improve architecture health, scalability, and efficiency as changes emerge.

Design and document the Logical Data Model and develop a Physical Data Model.

Create and execute Data Definition Language (DDL) statements for Snowflake and/or Delta Lake objects.

Lead the team in designing 3NF logical and physical models in Erwin.

Drive and build data model and architecture, implementing frameworks to ensure adherence to data architecture.

Reverse engineer and understand the existing SQL/processes.

Assist in developing data strategies for cloud data platform, master data management, metadata management, analytics, and data integration.

Provide deep expertise in databases, data modeling, data architecture, and operating systems.

Support end-to-end data asset lifecycle management activities.

Design robust, scalable, real-time data pipelines and data platform architecture.

Lead the review and design of new data products, maintaining product documentation.

What You Bring - Competencies

Qualifications:

Education:

Bachelor's degree from four-year college or university in Information Technology/Computer Science

10+ years related work experience and/or training or equivalent combination of education and experience.

Licenses or Certifications:

Any Cloud Certifications (Azure, GCP, AWS)

Knowledge and Skills:

Required

10+ years as a hands-on data engineering and 5+ 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 compellingly 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 people entering this role are competitive and commensurate with relevant experience and qualifications and in alignment 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 account options, generous vacation time, referral bonuses, professional development, and a 403(b) plan. You can find more information about our benefits at https://ideapublicschools.org/careers/benefits/.

* IDEA may offer a relocation stipend to defray the cost of moving for this role, if applicable.

Application process:

Submit your application online through Jobvite. Please note that applications will be reviewed on an ongoing basis until the position is filled. Applicants are encouraged to apply as early as possible.

Learn more about IDEA

At IDEA the Staff Culture and Belonging Team uses our Core Values to promote human connection and a culture of integrity, respect, and belonging for all Team and Family members. Learn more about our Commitment to Core Values here: https://ideapublicschools.org/our-story/#core-values