Data Engineer (Oracle And Etl Focus)

People Passion Purpose
Everything School Specialty offers is designed for one purpose – to help students succeed. We believe every student can flourish in an environment where they feel safe and inspired to explore and grow.
We’re determined to positively impact the future, one child at a time. We need to talk if you share our passion:
Transforming more than classrooms.®
Benefits
School Specialty offers Medical, Dental, & Vision plans (Effective Day 1), Wellness programs, Health Savings Accounts, Flexible Spending Accounts, 401 (k), PTO, Promise Hours dedicated to volunteering, Education Reimbursement, Paid Holidays, Fall & Winter Flexible Hours, Employee Discounts and much more!
Data Engineer
Candidate will be responsible for designing, building, and maintaining scalable and efficient data systems supporting our organization's data-driven decision-making. You will work closely with our data scientists and business analysts to develop ETL processes and pipelines that transform raw data into valuable insights. The Data Engineer will serve as a backup to the DBA role in the event of their absence or unavailability.
The base salary range for this role is $77-100K Annually
Summary of Primary Responsibilities

• Design, build, and maintain scalable and efficient data systems and pipelines
• Develop and maintain ETL processes that transform raw data into valuable insights, including data cleansing, data mapping, and data transformation
• Work closely with data scientists and business analysts to understand their data requirements and develop solutions to meet their needs
• Design and implement data storage solutions that are secure, reliable, and accessible
• Develop data quality checks and monitoring to ensure data accuracy and completeness
• Develop and implement data processing and validation procedures
• Develop and maintain documentation on data pipelines, data dictionaries, and data lineage
• Perform data profiling, data mapping, and data modeling to support data analysis and reporting
• Collaborate with cross-functional teams to integrate data from different sources
• Continuously optimize and improve data systems and pipelines for performance, scalability, and reliability
• Creating and executing backups, performing database tuning and optimization, monitoring database activity and usage, and providing support to end-users
• Stay up-to-date with emerging trends and technologies in Data Engineering

Minimum Experience Requirements

• Proven experience as a Data Engineer or similar role
• Strong understanding of data modeling, database design, and data architecture principles
• Experience building ETL processes and pipelines, including data cleansing, data mapping, and data transformation
• Proficiency in SQL and experience working with Oracle and MS-SQL database technologies
• Experience in database administration and be able to troubleshoot issues related to database connectivity, security, and performance
• Ability to work independently and collaboratively in a fast-paced environment
• Excellent problem-solving and communication skills
• Willingness to learn and adapt to new environments and technologies
• Self-starter and confident

Preferred Knowledge and Skills

• Experience with big data technologies such as Hadoop, Spark, or NoSQL databases
• Experience with distributed data processing frameworks like Apache Hadoop, Apache Spark, or Apache Flink
• Knowledge of data warehousing concepts and tools such as Redshift, Snowflake, or BigQuery
• Familiarity with data visualization and reporting tools such as Tableau or Power BI
• Experience working with data streaming and real-time data processing frameworks like Apache Kafka or Apache Storm

Disclaimers
The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.

• School Specialty, LLC. is a Drug Free Workplace. All applicants are subject to a drug screen and background check as a condition of employment.
• We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity and/or expression, status as a veteran, and basis of disability or any other federal, state or local protected class.
• If you need a reasonable accommodation for any part of the employment process, please contact us by email at Opportunities@SchoolSpecialty.com and let us know the nature of your request and your contact information.

#LI-Remote