Data Engineer

Overview -

Our Research & Development (R&D) team is the technical talent at the heart of our product suite, overseeing the product development lifecycle from concept to delivery. From engineering to quality assurance to data science, the R&D team ensures our customers seamlessly use our products and can depend on their consistency.

This position, under the general direction of Engineering leadership, will be responsible for technical and development support for our award-winning K-12 software. This role will use their knowledge to implement, code, build, and test new features, maintain existing features, and develop reports that will include components, data models, customization, and reporting features for our products. This position will gather and refine requirements, develop designs, implement, test and document solutions to produce the highest quality product and customer satisfaction.

Description -

• Essential duties and responsibilities include the following. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions:
• Implement data replication and data ingestion software features and products following best practices such as authoring of unit tests, writing maintainable code, applying established patterns and algorithms.
• Specialize in data engineering as a member of a project team.
• Design and development of software engineering strategies.
• Design and implement ETL processes to extract, transform, and load data from diverse sources.
• Develop and optimize SQL queries for data extraction and transformation.
• Perform data profiling, cleansing, and validation to ensure data accuracy and integrity.
• Troubleshoot and resolve issues related to data integration processes.
• Create and maintain documentation for ETL processes, data mappings, and transformations.
• Stay abreast of industry best practices and emerging technologies in ETL and data integration.
• Investigate and resolve issues following best practices such as authoring or updating unit tests, writing maintainable code, applying established patterns and algorithms.
• Analyze performance and develop improvements to performance.
• Assist and analyze security best practices.
• Develop software to support internal initiatives, tools, update framework and application functionality.
• Work as part of an Agile SCRUM team in the planning, scoping, estimation, and execution of technical solutions.
• Other duties as assigned.

Requirements -

• Bachelor's degree in Computer Science or Information Technologies required, or equivalent experience:
• 4+ years' experience in software engineer role.
• Strong experience with Snowflake and various database (MySQL, MSSQL, etc.) platforms.
• Strong experience in TSQL and writing SQL transformations.
• Strong experience in building data engineering pipelines using Python.
• Experience with any replication technologies like SQL Replication, Fivetran, Qlik Replicate.
• Understanding of data governance.
• Experience in building CI/CD pipelines.
• Excellent written and verbal communication skills.
• Excellent ability to work with current software design principles and concepts such as patterns, algorithms.
• Ability to handle a heavy workload while working on multiple projects and frequent interruptions.
• Ability to work in a changing, dynamic environment.
• Ability to provide an accurate and reliable estimate.
• Willingness to work in a fast-paced environment.