What are the responsibilities and job description for the Junior Data Engineer position at KNS International?
Company Overview
KNS International – Founded in 2002, KNS International has grown from the beginning of eCommerce and is at the forefront of providing Men’s and Women’s Fashion Footwear to national online retailers. The Company designs and distributes branded products across multiple categories and is a preferred partner for national retailers looking to optimize inventory and expand online product offerings.
Job Summary:
The Junior Data Engineer is responsible for assisting in the development, optimization, and maintenance of data pipelines, ensuring data accuracy, and supporting business intelligence efforts. This role involves working with databases, dbt, and Power BI for reporting, as well as contributing to C# integrations and data analysis. The ideal candidate will have a foundational understanding of data architecture, ETL processes, and database management, with a willingness to learn and grow.
Key Responsibilities:
- Assist in developing, optimizing, and maintaining SQL queries and database structures.
- Support the building and management of ETL pipelines using dbt for efficient data transformations.
- Contribute to Power BI reporting to enable accurate and timely business insights.
- Help ensure data quality, integrity, and performance across all data pipelines.
- Collaborate with cross-functional teams to understand data needs and implement scalable solutions.
- Monitor and troubleshoot data issues under supervision, optimizing performance and reliability.
- Stay current with emerging data technologies and best practices.
- Aid in C# integration development to connect and streamline data sources.
Key Qualifications:
- Bachelor's degree in Computer Science, Data Engineering, Information Systems, or a related field.
- 1 years of experience in data engineering, database management, or a related role (internships or projects accepted).
- Basic proficiency in SQL, including query optimization and database performance tuning.
- Understanding of Power BI for reporting and data visualization.
- Exposure to C# for integration development and data processing.
- Knowledge of ETL processes, data warehousing, and pipeline automation.
Preferred Qualifications:
- Familiarity with version control systems such as Git.
This role offers an excellent opportunity for growth and hands-on experience in data engineering. If you are passionate about data and eager to develop your skills, we encourage you to apply.
Benefits:
PTO and Work-Life Balance:
At KNS International, we know the importance of recharging and spending time away from work. We offer generous Paid Time Off (PTO), 17 paid holidays, and a flexible work environment that supports balance. Our culture is built around fostering an environment where creativity thrives, and team members feel valued.
Healthcare:
Comprehensive medical, dental, and vision coverage are provided to ensure you and your family are taken care of. We also offer short-term and long-term disability plans, along with maternity and parental leave.
Retirement:
Plan for your future with our 401(k) program, including employer matching to help you meet your retirement goals. Plus, you'll be immediately vested.
Perks and Wellness:
We provide a variety of wellness initiatives, including free gym memberships, monthly massages, and access to Impact Suites for mental health support. Employees enjoy a fully stocked kitchen with snacks and drinks, recreational areas for breaks, and a dog-friendly workspace. Plus, you’ll receive free shoes and discounts through our employee purchase program.
Growth and Development:
We believe in rewarding talent and encouraging growth. Join a collaborative environment that values innovation and provides ample opportunities to advance your career.
- Location: Draper, UT – Candidates must be willing to relocate if not currently local.
- Work Schedule: Hybrid position requiring in-office work on Tuesdays, Wednesdays, and Thursdays.
Salary : $75,000 - $85,000