Data Integration ETL Developer - (Immediate Opening)

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.

Accountabilities

On-time Product Delivery: Drive to and maintain on-time development and delivery of high-quality features for custom applications and business intelligence tools as defined by monthly sprint plans and measured by:

• % of critical defects due to code changes should be limited to a max of 5% team wide
• % of spilled over development tasks should be limited to a max of 5% team wide
• % of complete ownership of deployed features should exceed 20% team wide.
• % of reopened defects should be limited to a max of 2% team-wide

Effective Requirements Analysis: New major product work and execution is detailed with full requirements analysis and effective preparation for sprint planning, with detailed task/effort estimates as measured by:

• Difference between estimated effort and actual effort should be limited to a max of 15% and decrease gradually team-wide
• Defects due a mismatch in understanding of the requirements should be limited to a max of 10% team-wide

Efficient Object-Oriented Analysis and Design: Thorough object-oriented analysis and design of features with the documentation of necessary design artifacts as measured by:

• Refactoring time to enhance/improve code changes should be less than 15% of the original effort team-wide
• At least 20% of all code developed should be reusable
• Reuse of code should be leveraged whenever possible. Duplication should be limited to a max of 5% team wide

 Adherence to Effective Scrum Practices

• Adhering to all of the Scrum processes, with active and punctual participation in Scrum meetings as measured by:
• Absenteeism in scrum ceremonies including daily huddles, retrospectives, product reviews, and planning sessions should be limited to a max of 5% with prior intimation team-wide
• All planned leaves (both short and long duration) should be intimated in advance and documented so that sprint commitments are not affected. Deviation should be limited to 5% team-wide
• Unplanned leaves (both short and long duration) should be intimated as soon as possible and documented so that sprint commitments are not affected. Deviation should be limited to 5% team-wide.

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
• SQL Development (Tables, Views, Relationships, Indexes, Stored Procedures, Functions, Jobs, Agents, Dynamic SQL queries, Complex SQL syntax, etc. )
• ETL Development, Testing, Maintenance and Troubleshooting
• API Integration with 3rd Party Applications
• Business Rule Design and Development
• Relational and Dimensional Model Design
• 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

Qualifications:

 Education:

• Bachelor's degree from four-year college or university in Information Technology/Computer Science/Engineering
• 3+ 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 Required:

• 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
• Database Development (tables, relationships, indexes, stored procedures, functions, jobs, agents, etc.)
• 3rd Party System Integrations/API programming
• Agile (methodologies and practical application)
• Continuous Integration/Continuous Deployment (methodologies and practical application)
• New System Installations (Server Setup, Configuration, Testing, Deployment)
• System Migrations (i.e., On-Premise to Cloud)

 Preferred

• Advanced Analytics Programming using R/Python/SPSS

Information Technology and Software Engineering Competencies

• Application Development, Support and Maintenance
• Architecture
• Business Analysis
• Database Design and Management
• IT Project Management
• IT Support Troubleshooting
• Processes, Methodologies, and Tools
• Quality Management and Assurance
• Security/Information and Application Protection
• Service Management Processes
• Systems Design
• Systems Integration and Porting

Compensation: Salaries for people entering this role typically start between $60,569 and $72,683 commensurate with relevant qualifications and experiences. This role is also eligible for a performance bonus based on team performance and goal attainment.

Other Benefits:  

We offer a comprehensive benefits plan, covering the majority of the employee premium for the base medical plan and subsidizing the majority of costs for a spouse/domestic partner and children. Other benefits include dental and vision plans, disability, life insurance, parenting benefits, flexible spending account options, generous vacation time, com‐muter benefits, referral bonuses, professional development, and a 403(b) plan. We also offer an inclusive environment where staff are encouraged to bring their whole selves to work every day. IDEA may offer a relocation stipend to defray the cost of moving for this role, if applicable.  

To Apply  

Please submit your application online through Jobvite. It’s in your best interest to apply as soon as possible.   

About IDEA Public Schools   

At IDEA Public Schools, we believe each and every child can go to college. Since 2000, IDEA Public Schools has grown from a small school with 150 students to the fastest-growing network of tuition-free, Pre-K-12 public charter schools in the United States.     

IDEA Public Schools boasts national rankings on The Washington Post and U.S. News & World Report’s top high schools lists. IDEA serves nearly 75,000 college-bound students in 137 schools across Texas, Southern Louisiana and Florida and is on-track to maintain its legacy of sending 100% of its graduates to college. Be on the lookout for IDEA schools opening near you—with new launches in Jacksonville, FL (2022). Cincinnati, OH (2022), and Arkansas (2023)!      

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.