Data Engineer

Description

Role Mission: The Data Engineer 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 Engineer 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.

What You’ll Do – 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 as measured by: 

• % of Critical defects due to SQL code changes and ETL functioning should be limited to a max of 5% 
• % of spilled over development tasks should be limited to a max of 5% 
• Should acquire the complete ownership of at least 20% of the features developed 
• % of reopened defects should be limited to a max of 2% 

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 
• Defects due a mis-match in understanding of the requirements should be limited to a max of 10% 

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 SQL code changes and ETL development should be less than 15% of the original effort. 
• At least 20% of the code developed should be reusable 
• Reuse of code should be leveraged when possible.  Duplication, if any, should be limited to a max of 5%. 

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 
• 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%. 
• 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%. 

Continuous Improvement of Domain, Technical, and Behavioral Skills:  Continuously enhancing the Product domain knowledge, technical, and behavioral competencies to grow to the next level as measured by: 

• Relevant trainings/actions need to be identified, planned and attended 3 times within the year (1 skill from each area – domain, technical, and behavioral) 
• Development and demonstration of these skills for the purpose of the facilitation of team training and/or mentoring should be developed for each team member (1 opportunity per year) 

We look for Team and Family who embody the following values and characteristics: 

• Believes and is committed to our mission and being an agent of change: that all students are capable of getting to and through college  
• Has demonstrated effective 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 
• Works with urgency and purpose to drive student outcomes 
• 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 
• We believe in education as a profession and hold ourselves to high level of conduct, professionalism and behaviors as models for our colleagues and students 

Note: At IDEA, the Data Engineer 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 Engineer 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. 

Supervisory Responsibilities:

This role leads and oversees the work of others in a project capacity as a project technical lead:  

• Planning and directing Data Integration/ETL Developer team member activities on projects 
• Assigning work 
• Overseeing proper maintenance and back-up of source code 
• Participation in evaluating performance (for Data Integration/ETL Developers) 
• Mediating conflict resolution 

Qualifications:

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

What We Offer

Compensation: 

• Salaries for people entering this role typically fall between $66,626 and $80,618, commensurate with relevant experience and qualifications and in alignment with internal equity. This role is also eligible for a performance bonus based on individual and organizational 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, 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. It is recommended that you include a cover letter in your application addressing why you are interested in IDEA and how your experience has prepared you for this position.