Data Engineer

Pansophic Learning is an education company that strives to provide students and educators exceptional learning solutions that enable them to maximize their success academically and in life, regardless of geographic, financial, or demographic circumstance. These learning solutions include high quality content, technology, teaching and exceptional schools.

The Data Engineer is responsible for the design, structure, and maintenance of data. A data engineer ensures the accuracy and accessibility of data relevant to an organization or a project. In this role the Data Engineer needs to be able to find a solution that will meet business requirements. The Data engineer needs to be an expert in writing and optimizing SQL queries. They need to be able to document ideas and proposals which will include creating ER diagrams and architectural documents that document the transformation of data throughout its lifecycle.

A successful Data Engineer must possess good analytical skills and be detail oriented. This role requires the ability to communicate effectively as part of a larger team within the information technology department.

*VISA sponsorship is not available. This is a hybrid position *

Responsibilities:

• Work with team members to design and implement data solutions in alignment with the project schedule.
• Codes, tests, and documents new or modified data systems to create robust and scalable data platform for our applications.
• Works with developers to make sure that all data solutions are consistent.
• Expand and grow data platform capabilities to solve new data problems and challenges.
• Help to create and maintain a data catalog for each project.
• Design the logical model and implements the physical database to support business needs.
• Conduct logical and physical database design.
• Design key and indexing schemes and designs partitioning.
• Ensure database changes are reviewed and approved according to database design standards and principles.
• Analyze and resolve technical and application problems.
• Provide analysis and troubleshooting for production issues & code deployment activity.
• Work with various services from Amazon Web Services (AWS) and Microsoft Azure to build, host and maintain data extraction, transformation and loading functions to data warehouse.

Qualifications:

• Bachelor's degree in Computer Science, Mathematics, or Engineering or equivalent work experience.
• 3+ years of data engineering, ETL, or software engineering experience.
• 3+ years of experience in writing SQL queries.
• 3+ years of experience with PostgreSQL and AWS Redshift.
• 3+ years of experience in AWS (or similar cloud technologies) cloud stack including S3, IAM, RDS, SQS, and Lambda.
• Programming experience in Python and Linux bash.
• Demonstrated experience with agile or other rapid application development methods.
• Good knowledge of data modeling and understanding of different data structures and their benefits and limitations under particular use cases.
• Ability to collaborate and partner across a diverse team.

EQUAL EMPLOYMENT OPPORTUNITY

It is our policy to abide by all federal, state and local laws prohibiting employment discrimination based solely on a person's race, color, religious creed, sex, national origin, ancestry, citizenship status, pregnancy, childbirth, physical disability, mental and/or intellectual disability, age, military status, veteran status (including protected veterans), marital status, registered domestic partner or civil union status, familial status, gender (including sex stereotyping and gender identity or expression), medical condition, genetic information, sexual orientation, or any other protected status except where a reasonable, bona fide occupational qualification exists.