Junior Data Engineer (Remote)

Company Description

At Lakeshore, we create innovative learning materials and world-class guest experiences for teachers, parents and children. Since 1954, we’ve grown into a global community—with a thriving e-commerce 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 data-driven decision-making 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

In a time of unprecedented expansion, are seeking a Junior Data Engineer who will be responsible for enabling and enhancing data insights for internal stakeholders, with significant overlap and collaboration with different teams. In this role, you will design, build, enhance and maintain an enterprise business intelligence (BI) platform that supports advanced analytics. The position also requires data cleanup, requirements gathering, data modeling and transformation, reports/dashboard creation, data mining and analytics on complex data sets. The ideal candidate has proven experience working with complex data and has a passion for improving technology. And we’re here to help you succeed—in 2022 Lakeshore earned its Great Place to Work® Certification™ and is proud to put its associates first. 

A day in the office looks like this: 

• Serving as the primary point of contact with business teams to provide actionable insights into current delivery performance, as well as ad hoc investigations into future improvements or innovations 
• Using BI and visualization software (SQL Server, Redshift, AWS Data Lake, Qlik, etc.) to empower nontechnical, internal customers to drive their own analytics and reporting 
• Providing complex analysis, conceptualization, design, implementation and development of solutions for critical BI components 
• Performing dataflow, system and data analysis; developing meaningful presentation of data in BI applications 
• Contributing to data analysis, design and development of new and ongoing BI projects 
• Collaborating closely with internal and external teams to understand modifications impacting data lake, visualization, etc. 
• Participating in the entire lifecycle of BI solution delivery 
• Helping plan, design, implement and manage the deployment of a self-service data visualization platform in Qlik 
• Building and maintaining data visualizations that inform and engage business stakeholders 
• Analyzing key performance indicators to discover root causes for various parameters 

Qualifications

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

• At least 1 year of experience in relevant business domains, including data warehousing and BI tools, techniques and technology 
• Knowledge of data warehouse platforms such as SQL Server, AWS Redshift and SSIS required 
• Knowledge of Qlik and Tableau as visualization tools required 
• Knowledge of ETL, presentation layer and design strategy reporting required 
• Knowledge of data mining and experience using large-scale, complex data sets in a business environment 
• Proficiency in SQL and performance optimization 
• Technical capability to query large data sets and apply statistical models 
• Knowledge of advanced statistics and experience with statistical data analysis systems (scikit-learn, Pandas) a plus 

Additional Information

And here’s our end of the bargain! 

• Hourly: $27-$31 with an annual bonus of up to 10%
• Excellent medical/dental 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
• On-site preschool for our employees’ children
• On-site employee gym for all levels/fitness needs
• Generous employee discount on products that make you smarter
• 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