Sr. Data Engineer

Company Description

At Lakeshore, we create innovative learning materials and worldclass guest experiences for teachers, parents and children. Since 1954, we’ve grown into a global community—with a thriving ecommerce business, multiple catalogs, 60 retail stores, a peerless national sales force, plus international offices that support our preeminent supply chain division. But today we’re working better, smarter and faster than ever—and setting our sights even higher. We’re building an infrastructure designed for scalability, embracing datadriven decisionmaking and using technology to improve efficiency and ensure the best tools for the best work. Most importantly, we continue to invest in a diverse team of inquisitive top talent who fuel each other’s passions and curiosity, take risks, try new things, and believe that every new day brings opportunities for growth.

Job Description

We are currently seeking a Sr. Data Engineer to join our team. In this role, you will enable and enhance data insights for internal stakeholders, with significant overlap and collaboration across teams. You will also implement data quality, observability and lineage frameworks—creating monitoring, alerting and automated remediation for pipeline failures. The position also involves data cleanup, requirements gathering, data modeling and transformation, report and dashboard creation, and data mining and analytics on complex datasets. Applicants should have a solid grounding in data security, privacy and governance. The ideal candidate brings 5+ years of handson data engineering experience, including ownership of missioncritical pipelines in production.

A day on the job looks like this:

• Design, build and own production data pipelines with tools such as Apache Airflow, Matillion and SSIS, ensuring robust orchestration, auto scaling and fault tolerance
• Integrate data across heterogeneous systems (ERP, CRM, ecommerce, IoT and thirdparty APIs) using RESTGraphQL, Kafka, CDC tools, SFTP and eventstreaming patterns
• Develop and evolve our data foundation (Redshift, SQL Server) architectures for both batch and realtime use cases
• Collaborate with Analytics, BI and Data Science teams to deliver reusable semantic models powering Qlik, Power BI and Excel
• Champion engineering excellence: CICD for data code, infrastructureascode (TerraformCDK), Gitbased workflows and peer code reviews
• Perform rootcause analysis and optimization of SQL, Python and integration workflows
• Partner closely with platform, security and DevOps teams to align on best practices for governance, cost control and compliance
• Ensure reliability and performance of data pipelines by monitoring orchestration workflows and conducting root cause analysis of failures and performance issues. This includes proactively identifying bottlenecks and implementing alerts and recovery strategies to minimize data disruptions

• Qualifications

  Got the skills and experience? Here’s what we’re looking for:

  • 5+ years of handson data engineering experience, including ownership of missioncritical pipelines in production
  • Experience designing dimensional and domaindriven data models to support BI and selfservice analytics
  • Deep expertise with SQL (TSQL, Redshift SQL) and performance tuning for largescale analytics workloads
  • Handson experience with Git for version control and GitHub Actions for CICD automation
  • Demonstrated ability to lead projects, influence crossfunctional stakeholders and elevate engineering standards through partnership and collaboration
  • Proven mastery of modern ETLELT and orchestration frameworks (Airflow, AWS Glue, Matillion and SSIS) and at least one cloud platform (AWS strongly preferred)
  • Strong understanding of integration patterns—batch, streaming, CDC—and technologies such as Kafka, Kinesis, Debezium or Azure Event Hubs
  • Proficiency in Python (Pandas, PySpark) for data transformation and automation; familiarity with Scala or Java is a plus
  • Solid grounding in data security, privacy and governance (encryption, IAM, RBAC, PII handling and GDPRCCPA awareness)

  • Additional Information

    And here’s our end of the bargain!

    At Lakeshore, we pay local market wages for employees that reside within Los Angeles and Orange Counties. For employees residing outside of Los Angeles and Orange Counties, pay is based on national market.

    For this position, new employees joining Lakeshore are typically brought into the organization at a salary rate between $102,500 $143,500 depending on relevant experience & skillset.

    This range is indicative of projected hiring range. The annual base compensation will take into account each candidates relevant experience, location, and skillset.

    • Bonus eligible
    • Paid leave for new parents to support worklife balance and family bonding
    • Excellent medicaldental and vision coverage—EPO, PPO and HSA
    • 401(k) retirement plan with company contribution (because you will retire someday)
    • Flexible benefits—choose what you like, ignore the rest
    • Onsite preschool for our employees’ children
    • Onsite employee gym for all levelsfitness needs
    • Generous employee discount
    • Casual dress…and we really mean it

    • At Lakeshore, we know our diversity makes us stronger, and when everyone feels included and valued, we all win. We strive to embrace our differences and create an intentionally diverse and inclusive community that is representative of the teachers, families and children we serve.

      We know we couldn’t do the extraordinary things we’re doing without the people on our team. Thanks to the passion and enthusiasm of this spectacular group, Lakeshore is more than a great place to work—it’s a great experience to be part of. Day in and day out, we give everything we’ve got to create products that instill a sense of wonder and foster a true love of learning. To help maintain this high bar for success, we’re constantly on the lookout for people to join us. So if you’re a downtoearth professional who shares our desire for making a difference, we’d love to hear from you.
      
      To learn more about Lakeshore, visit www.lakeshorelearning.comcareers
      
      Equal Employment Opportunity Policy
      People are selected to become members of the Lakeshore family based on skill, merit and mindboggling talent—not based on race, color, creed, sexual orientation, gender or gender identity, marital status, domestic partnership status, military status, religion, age, national origin, ancestry, alienage, AIDS or AIDSrelated complex status, genetic information, predisposition or carrier status, status as a victim of domestic violence, physical or mental disability, or any other characteristic protected by applicable law. If things aren’t equal, we all lose.

      To learn about how we collect and use Applicant information, please visit our EmployeeApplicant Privacy Policy.

      Lakeshore is an EVerify employer. We use EVerify to confirm the employment eligibility of all newly hired employees.

      Please see the EVerify Participation Poster and Know Your Rights Poster in English and Spanish for more information. INDRLL1