JOB DETAILS

Data Engineer II

Litehouse is seeking an experienced Data Engineer to join our team!

The Data Engineer II will work as part of a team to help design and develop data-driven solutions that deliver insights to the business. The ideal candidate will have an opportunity to leverage their technical skills to expand and optimize our data and data pipeline architecture, as well as to apply their technical creativity to streamline existing data flows and improve related data collection solutions in support of cross functional teams. The hire will be an experienced data pipeline builder and data wrangler who is proficient with building data-driven systems that drive analytical solutions from the ground up.

ESSENTIAL JOB DUTIES/KEY ACCOUNTABILITIES

Use advanced/complex SQL to extract data from source systems for ingestion into a data pipeline.
Design, develop and deploy scalable and efficient data pipelines.
Analyze and assemble large, complex datasets that meet business requirements.
Identify, design, and implement internal process improvements. For example: automating manual processes, optimizing data delivery, re-designing data platform infrastructure for greater scalability.
Work independently to enable analytics teams and stakeholders across our business, including Executive, Operations, Finance and Sales; assimilate their needs and then design, develop, deliver and support appropriate solutions that deliver data and insights.
Be a team player and help foster Litehouse culture by leading by example and leveraging company guiding principles.

EDUCATION AND EXPERIENCE

Bachelor's degree in Data Science, Information Systems, Computer Science or related fields, or the equivalent combination of education, professional training, and work experience
3-5 Years of experience working with SQL
3-5 Years of experience with data engineering tools

KNOWLEDGE AND SKILLS

Advanced working knowledge of SQL and experience working with relational databases, query authoring as well as working familiarity with a variety of databases.
Experience with ETL tools like Alteryx, Informatica, SSIS, or Pentaho.
Experience in performance tuning and query optimization
Experience with reporting platforms such as Tableau and Power BI
Experience with object-oriented/object function scripting languages: Python, Java, C++, etc.

IDEAL CANDIDATE QUALIFICATIONS:

Direct experience with Alteryx Designer, Alteryx Server, Oracle, and MSSQL
Working knowledge of orchestration tools like Airflow, Dagster, or Perfect
Familiarity with Machine Learning platforms such as Databricks, SageMaker, H20.ai

WORK ENVIRONMENT/PHYSICAL DEMANDS

The work environment characteristics and physical demands described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Normal Office Environment
Speak clearly so listeners can understand.
Understand the speech of another person.
Prolonged periods sitting at a desk and working on a computer.
Computer Keyboard Proficiency

We do not offer sponsorship

All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.

Related Jobs

MRO Buyer I

Litehouse • Sandpoint, ID, US • 4d ago

Idaho

Litehouse is seeking a full-time MRO Buyer I to join our team. This is not a remote position and will require daily in-office attendance. Do you have strong negotiation and communication skills? Do you find it... more

4d ago

Apply

Line Attendant I (Manufacturing) - 3rd Shift

Litehouse • Sandpoint, ID, US • 1w ago

Manufacturing

https://vimeo.com/722344440/26f7980c01 Starting Pay at $18.13/hour with $3.00/hour shift differential for 3rd Shift. Line Attendant I / Production Worker Litehouse Foods is looking to hire a mo... more

1w ago

Apply

Line Attendant I (Manufacturing) - 1st Shift

Litehouse • Kootenai, ID, US • 1w ago

Manufacturing

https://vimeo.com/722344440/26f7980c01 Starting Pay at $18.13/hour Line Attendant I / Production Worker Litehouse Foods is looking to hire a motivated full-time Line Attendant I / Production... more

1w ago

Apply

Director, Sales & Operations Planning

Litehouse • Sandpoint, ID, US • 2w ago

Sales

Litehouse is seeking an experience Director, Sales &Operations Planning to join our team in Sandpoint, ID. This position is hybrid in Sandpoint, ID. The Director of S&OP is a process improvement leader r... more

2w ago

Apply

Line Attendant I (Manufacturing) - 1st Shift

Litehouse • Kootenai, ID, US • 2w ago

Manufacturing

https://vimeo.com/722344440/26f7980c01 Starting Pay at $18.13/hour Line Attendant I / Production Worker Litehouse Foods is looking to hire a motivated full-time Line Attendant I / Production W... more

2w ago

Apply

Truck Driver

Litehouse • Sandpoint, ID, US • 4w ago

Transportation

https://intelliapp.driverapponline.com/c/litehouseinc JOB SUMMARY The Truck Driver is responsible for over-the-road transport of Litehouse products to assigned destinations and pickup and delivery of o... more

4w ago

Apply

Regional Business Manager - East Coast (Remote)

Litehouse • Sandpoint, ID, US • 1m ago

Corporate

Litehouse is seeking a strategic Regional Business Manager to support our territory in the east. This position is remote. Candidates must live on the east coast. The Regional Business Manager will develop strate... more

1m ago

Apply

Quality Assurance Supervisor - 1st Shift

Litehouse • Kootenai, ID, US • 1m ago

Management Supervisor

Litehouse is seeking a full-time Quality Assurance Supervisor to join our team. The QA Supervisor promotes quality achievement and performance improvement throughout the organization. Additionally, you will ensur... more

1m ago

Apply

Formulation I - 1st Shift

Litehouse • Sandpoint, ID, US • 1m ago

Manufacturing

Basic Purpose and Scope: The Formulation I position prepares, measures, weighs and tests wet ingredients to be utilized in the formulation of products and may be responsible for taking the raw ingredient to comple... more

1m ago

Apply

Line Attendant I (Manufacturing) - 1st Shift

Litehouse • Kootenai, ID, US • 1m ago

Manufacturing

https://vimeo.com/722344440/26f7980c01 Starting Pay at $18.13 / hr Line Attendant I / Production Worker Litehouse Foods is looking to hire a motivated full-time Line Attendant I / Production Wo... more

1m ago

Apply