Data Engineer II

Data Engineer II - Science and Analytics TeamJoin us in our mission to provide students with a safe and stimulating learning experience. At GoGuardian, you’ll get to work with friendly and motivated people to solve challenging problems in a great environment. At GoGuardian, we pride ourselves on bringing the very best talent to empower millions of student lives in the most impactful way.  You’ll be joining a talented science and analytics team at a company making extensive use of modern data techniques to benefit educators and students.GoGuardian is looking for a motivated Data Engineer II to help plan, maintain, and constantly improve our data warehouse and ETL pipeline.  Data Engineer II focuses on integrating, consolidating, and cleansing data from multiple source systems. This position works closely with the data science and business intelligence teams to prioritize tasks that are important to supporting our product and business units.
Who You Are: Bachelor’s degree or equivalent experience 3-5yr experience building/operating systems for data extraction, ingestion, and processing of large data setsExperience with modern data warehousing tools such as Redshift, Big Query, Snowflake, Azure Synapse, Tableau, Google Analytics, AmplitudeHands on experience with Python, SQL and NoSQL query language along with data warehouse design and maintenanceExperience working with data orchestration tools such as Airflow, Luigi, AWS Step Functions, SegmentStrong attention to detail, analytical mindset, and highly organizedAbility to work independently within the policies, processes, and procedures defined for the teamDesire to work in a fast paced startup atmosphere requiring constant learningStrong technical aptitude and demonstrated ability to quickly evaluate and learn new technologiesStrong interpersonal skills, with the ability to work independently and within a team environment
Bonus Points if you also bring the following: Experience with infrastructure as code such as Terraform, Chef, Puppet, CloudFormationExperience with containerization tools such as DockerExperience with a broad set of AWS tools (S3, EC2s, AWS Glue, Lambda, Cloudwatch, AWS data pipeline)Industry experience as a Data Engineer or related specialty (e.g., Software Engineer, Business Intelligence Engineer, Data Scientist)What You’ll Do:Develop new ETL processes to fulfill data needs of data science and other departmentsUtilize expertise in data modeling, ETL architecture, and report design for department initiativesProduce detailed documentation including data flow diagrams, logical diagrams, and physical diagrams as neededEnsure the data collection pipeline and data analysis infrastructure meet the needs of the businessAcquire strong knowledge of data structures, analysis, replication and distributed/ relational data & database mappingAssist with code review process for purposes of learning, asking new questions and finding errors Assist with development of new scripts, KPIs and dashboardsAll other duties as assigned GoGuardian is an equal opportunity employer and makes employment decisions on the basis of merit and business needs. GoGuardian does not discriminate against employees, applicants, interns or volunteers on the basis of race, religion, color, national origin, ancestry, physical disability, mental disability, medical condition, pregnancy, marital status, sex, age, sexual orientation, military and veteran status, registered domestic partner status, genetic information, gender, gender identity, gender expression, or any other characteristic protected by applicable law.
#LI-Remote#BI-Remote