Education Analytics (EA) is seeking to hire two summer interns for the Data Engineering team who are motivated to learn the technical skills and concepts needed to build data systems for analytics in K-12 Education. For this role, we are seeking candidates who may not yet have experience in the data engineering field but have demonstrated programming skills and an interest in working with data. In this role, a successful candidate will build skills in data engineering and analytics engineering. We're looking for someone who is interested in learning data modeling concepts and building data systems and data products that are user-friendly and reliable.

EA is a non-profit organization based in Madison, WI that creates research-informed analytics to support school districts, regional offices of education, non-profits, and policymakers in improving student outcomes and education systems with data-driven decision making. Many of EA's partner organizations are large public school districts that serve diverse, often under-represented, student populations. Because of this, EA values a breadth of educational experiences in employees, and encourages applications from students who reflect these populations. We encourage applications from current undergraduate students from all ethnic and racial backgrounds, sexual orientations, gender identities and expressions, and first-generation college students.

Interns will work closely with our full-time data engineering staff to support the timely delivery of data and analytics to educators and administrators who use this data to drive change and improvement in education. We are looking for candidates who are innovative, hard-working, and curious to help us continue to develop our team's capacity in the development and use of cutting-edge tools. Successful Interns will be driven to learn, understand, and challenge these tools and the engineering practices they support. Our current stack uses an ELT approach via Apache Airflow and dbt to create data warehouses in Snowflake or Postgres, depending on the scale of the data. These blog posts on our website illustrate some projects that someone on our team might work on.

1. https://www.edanalytics.org/blog/building-a-multi-source-analytics-database-to-support-teachers-during-covid-19

2. https://www.edanalytics.org/blog/turning-public-data-into-custom-insights-how-ea-has-built-a-public-data-platform-for-our-partners

This opportunity is a fully in person role based out of our office in downtown Madison, Wisconsin. The salary for this position is budgeted at $21/hour. The program runs from June 3 – August 16, with flexibility for the right candidate.

Orientation to the Work

• Interns are paired with a mentor from their teams for the summer. These mentors serve as the intern's main point of contact, help assign interns work, support them as they plan out projects, answer their questions, help them manage their time, and provide additional one-on-one support.
• Through a series of interactive lunches and workshops, interns get a first-hand look at all the functions of EA and greater insight into nonprofit work.
• Attend professional development seminars on topics such as resume and cover letter writing, interview tips, and negotiation advice.

_Duties and Responsibilities _

• Interns are expected to work 40 hours a week for at least ten weeks. Specific schedules will be determined by the supervisor/mentor.

• Implement and design data warehousing structures for research, analytics, and reporting/dashboarding.

• Apply best practices from software engineering to building data pipelines.

• Help implement code testing, continuous integration, and deployment strategies to ensure system reliability.

• Implement data pipelines to integrate data coming from a mix of APIs, flat files, or other database sources.

• Create a final project, an independent hands-on learning experience, and share results to all EA colleagues at the end of the internship.

• Establish and maintain positive relationships with internal stakeholders at all levels of the organization.

• Safeguard confidentiality, privacy and security of organization and customer (PII) information.

• Perform other duties as assigned.

_Required Knowledge and Skills. _

• Some exposure to programming, python preferred but not required
• Some exposure to or interest in working with data, knowledge of SQL preferred but not required
• Demonstrated effective verbal and written communication skills, utilizing proper grammar, syntax and excellent business acumen.
• Strong organizational and time management skills with proven ability to multitask and prioritize in a high paced environment with limited direction.
• Intermediate proficiency with Microsoft Word, Excel, and Outlook.
• Comfortable with taking initiative and sharing responsibility in a team-based, collaborative environment at a fast-paced nonprofit organization.
• Customer-service orientation to working with others.

_Work Environment and Requirements _

• Ability to communicate effectively in numerous conversations throughout the day on the telephone, in writing, on-line zoom and in person to provide information, collaboration and assistance.
• Ability to reach in all directions and bend/stoop to store and retrieve files, use telephone, calculator, computer, and other office equipment.
• Dexterity and hand/eye coordination necessary to operate computer keyboard and other office equipment.
• Ability to complete job duties where there may be eyestrain due to constant viewing of computer screens.
• Ability to complete job duties in an environment where background noise and frequent interruptions are consistent.
• Demonstrate the ability to utilize basic math skills of addition, subtraction, multiplication and division.
• Must be able to communicate effectively both orally and in writing, follow instructions and be able to comprehend written material or requests.
• Must demonstrate the ability to use reason and problem-solving skills in a fast-paced environment.

_Benefits _

• Company laptop provided for all interns. Additional technology required for specific roles will also be provided.
• One time housing stipend of $2400 for all onsite/hybrid interns. The stipend is split between the first and last paychecks of the internship.
• Opportunity to participate in EA's annual Summer Week (meals, travel and accommodations covered by EA).
• Optional intern socials, in-person and virtual, held throughout the summer.
• EA provided snacks and beverages for those working onsite in the Madison office.

_Additional Details _

Education Analytics is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

The job duties, responsibilities, skills, experience, educational factors and the requirements and conditions listed in this job description are representative only and not exhaustive of the tasks that an employee may be required to perform. The employer reserves the right to revise this job description at any time and require employees to perform other tasks as circumstances or conditions of its business, competitive considerations or the work environment change.