IDEA Public Schools Job - 31978269 | CareerArc
  Search for More Jobs
Get alerts for jobs like this Get jobs like this tweeted to you
Company: IDEA Public Schools
Location: Austin, TX
Career Level: Associate
Industries: Government, Nonprofit, Education


Position at IDEA Public Schools

About IDEA Public Schools


At IDEA Public Schools, we believe in college for ALL and we are committed to ensuring that all our students graduate from college. IDEA Public Schools has grown from a small school to the fastest-growing network of tuition-free Pre-K-12 public charter schools in the United States sending 100% of our students to college. 50% of our students graduate from college in 6 years – that's 8 times the national rate for students in our communities!  

IDEA was founded in 2000 as a single school with 150 students in the Rio Grande Valley. When interest exceeded building capacity, to meet the demands, IDEA's co-founders committed to serving more students in the Rio Grande Valley of Texas and beyond. We now serve nearly 53,000 students across Texas and Louisiana. By 2022, IDEA will serve 100,000 students. Be on the lookout for IDEA schools opening near you—with continued growth in our current regions and new launches in Houston (2020), Permian Basin (2020), and Tampa Bay (2021)!


When you choose to work at IDEA, you are part of our IDEA Team and Family. You will work alongside team members who set and reach ambitious goals every day, are excited to continue to grow with IDEA, and work relentlessly to make college for all a reality.  


To learn more about IDEA, check out this  video .

Role Mission: 

The Data Integration/ETL Developer will be responsible for improving IDEA's operational processes and supporting critical strategies by assisting in the new development and implementation related to our internal applications systems.  The Developer will deliver the testing, ongoing evaluation, and validation of organizational data structures and identify issues in current processes while providing proven strategies for ongoing database and data warehouse development relating to internal custom applications development and deployment.  This position will provide recommendations and insight on IDEA's IT operations and strategy from an applications development standpoint.  This job requires the ability and desire to work and communicate well in a dynamic team environment as well as dependability and self-sufficiency. 

At IDEA, the Data Integration/ETL Developer role is a mid to high level role with a focus on building upon the IDEA data warehouse.  The IDEA data warehouse is the central data store for all analytics and reporting.  As a result, the developer is responsible for data extraction, transformation, and loading of data into the data warehouse and is the primary keeper of this system. These processes require strong skills with a variety of specialized tools and techniques for data cleansing, preparation, modeling, and integration.  This role is also required to have a strong background in analytics and server-side processing. 




  1.  Drive to and maintain 80% of IDEA systems integrated in the IDEA Data Warehouse, including 100% of mission critical applications as designated by chiefs. 
  • Inventory operational departmental data sources, determine the effort necessary to incorporate into the data warehouse, and create a prioritization matrix based on resulting inventory. 
  • Design and develop priority data structure connections, ETLs, and final data structures. 
  •  Design and develop secondary data structure connections, ETLs, and final data structures. 

  1. 100% of all new major project and 50% of existing project work (rolling plan) is documented for the following: Work Stream Inventory, Process Flows, Back-Up Methodology, Maintenance Plans, and Reference Materials (vary depending on the project). 
  • Design, develop, implement and document deployment best practices and protocols, administration processes, emergency protocols for all core projects (Teacher Dashboards, The Hub, DI Online, and TCP.) 
  • Build redundancy in applications development with a minimum of 2 developers on each project to effectively manage risk to business continuity and growth. 
  •  Complete projects with at least 15% of reusable materials (use of project artifacts, previously developed objects, classes, etc. and replicate processes for the sole purpose of reuse). 
  • Control scope creep to no more than 10% per project/iteration through standardized requirements gathering and change control processes/management 

  1. Net Promoter Score Growth of 20 points from beginning of year (BOY) to end of year (EOY) with surveys every 8-10 weeks for Teacher Dashboards. 
  • Provide regular, relevant iterations to proposed work (i.e, dashboard development and application improvements) 
  •  Build redundancy in applications development with a minimum of 2 developers on each project to effectively manage risk to business continuity and growth. 
  • Survey core product end-users at regular intervals. 
  •  Compile, analyze, and report results. 
  • Review results and change strategies based on feedback/trends 

  1. 85% Tool Use and Adherence of Operational Mechanisms. 
  •  Provides progress reporting for all project work in a timely and reasonable manner including estimates, time spent, risk assessment, and resource allocations 
  •  Manages/owns weekly check-in preparations including progress-toward-goals, 3 week work plans, and agendas including project status updates and pain points 
  • Manages/owns project and tactical preparation preparations including progress-toward-goals, 3 week work plans, and agendas including project status updates and pain points 
  • Actively participates in organizational meetings and functions as a team member representing the Software Development Team 
  • Manages and maintains 100% of project and team artifacts related to assigned projects including planners, meeting minutes, checklists, and the tracking of progress-toward-goals
  1. Live values of IDEA
  • Believes and is committed to our mission: that all students are capable of getting to and through college  
  • Is driven by outcomes and results, and wants to be held accountable for them 
  • Has a propensity for action, willing to make mistakes by doing in order to learn and improve quickly 
  • Thrives in an entrepreneurial, high-growth environment; is comfortable with ambiguity and change 
  • Seeks and responds well to feedback, which is shared often and freely across all levels of the organization 
  • Works through silos and forges strong cross-departmental relationships in order to achieve outcomes 
  • Embodies IDEA's core values   

Primary Responsibilities: 

  • New Data Source Evaluation and Design 
  • Data Cleansing and Preparation 
  • ETL Development, Testing, Maintenance and Troubleshooting  
  • Business Rule Design and Development 
  • Relational and Dimensional Model Design 
  • SQL Development (Tables, Views, Relationships, Indexes, Stored Procedures, Functions, Jobs, Agents, Dynamic SQL queries, Complex SQL syntax, etc. ) 
  • Key Performance Index Design and Implementation 
  • Meta-Data Store Design, Development, and Implementation 
  • Participates as a Data Governance Liaison 
  • Documentation (Technical and End-user) 
  • Testing, Quality Assurance, and Risk Analysis 
  • End-User Support 
  • Source code back-up, branching, and merging 

Supervisory Responsibilities:

  • This role leads and oversees the work of others in a project capacity as a project technical lead:  
  • Gathers business requirements in collaboration with Product Managers 
  • Participates in developing the best strategy based on identified risks and available resources 
  • Provides basis for creating estimates for the time necessary to complete work 
  • Ensures technical and project documentation is kept up to date 
  • Manages subordinate work to ensure that deadlines are met and/or slippage is proactively communicated 


  • Education:  Bachelor's degree from four-year college or university in Information Technology/Computer Science 
  • Experience: 8+ years related work experience and/or training; or equivalent combination of education and experience.  
  • Licenses or Certifications : Microsoft Certified Solutions Associate (SQL 2016 BI Development), Certified Associate in Project Management (CAPM) preferred 



Knowledge and Skills: 

  • Server Installation, Configuration, Maintenance, and Troubleshooting 
  • SQL - Installation, Configuration, Maintenance, Troubleshooting and Development of Solutions in Management Studio (SSMS), Analysis Services (SSAS), Integration Services (SSIS), Reporting Services (SSRS) 
  • Data Warehouse Design/Development - ETLs, Data Modeling, Advanced Data Management Techniques 
  • Advanced Analytics Programming using R/Python/SPSS 

Compensation: Salaries for people entering this role typically start between $48,650 and $60,800, commensurate with relevant qualifications and experiences. This role is also eligible for a performance bonus based on individual and organizational goal attainment.


IDEA Public Schools does not discriminate on the basis of race, color, national origin, age, sex or disability, in admission or access to, or treatment of employment in its programs and activities. Any person having inquiries concerning the organization's compliance with the regulations implementing Title VI of Civil Rights Act of 1964 (Title VI), Section 504 of the Rehabilitation Act of 1973 (Section 504), or Title II of the Americans with Disabilities Act of 1990 (ADA), may contact IDEA Human Resources at (956) 377-8000.

 Apply on company website