Data Warehouse Analyst

JOB TITLE: Data Warehouse Analyst

Exempt Position

REPORTS TO: Director Information Technology

DEPARTMENT: Administration

BASIC FUNCTIONS:

Plays a pivotal role in managing and optimizing data storage systems. Expertise will empower organizations to make informed decisions by providing efficient data retrieval, reporting, and analysis.

GENERAL JOB RESPONSIBILITIES:

Collaborate with Business, Data Architects, and Data Modelers to translate business rules into technical requirements for the Incorta Unified Data & Analytics Platform.

Create SQL queries, scripts, and test data for System Integration Testing.

Perform data integration from various sources using Incorta’s Data Mapping Technology. (This utilizes the No-ETL Approach used within Incorta)

Ensure data quality, load metrics, and adherence to data mapping rules.

Ensure data quality and load metrics

Provide training and consultation to the Business for report writing

Provide production support for the Data Warehouse

Proactively solve data-related challenges.

Provide technical expertise to drive effective Business Intelligence and Data Warehouse (BI/DW) strategies. JOB QUALIFICATIONS:

A relevant degree (Bachelor’s) in Computer Science, Information Technology, Engineering, Business, or 3-5 years related field work experience.

Certifications such as Microsoft Power BI Data Analyst

Proficiency in SQL.

Familiarity with Parquet files.

Familiarity with cloud computing (e.g., AWS), relational databases, and data warehousing.

Experience with Incorta Data Warehouse is ideal.

Experience with reporting tools (Power BI).

Scripting skills (Python).

Prior experience working with JD Edwards EnterpriseOne, SAP S4/Hana or SAP ECC6 PHYSICAL REQUIREMENTS:

Ability to sit 7+ hours a day.

Ability to sit or stand 3+ hours a day.

Ability to walk 2+ hours a day.

Ability to reach above shoulder height and below waist.

Must be able to lift up to 25 pounds. OTHER REQUIREMENTS:

Ability to meet objectives by influencing and engaging others across multiple teams.

Quality and cost driven.

Ability to travel 10-15% of the time to other Kito Crosby locations.

The performance of this position may occasionally require exposure to the manufacturing areas where under certain areas may require the use of personal protective equipment such as safety glasses with side shields, safety shoes, and/or mandatory hearing protection.

NOTE:This job description is not intended to be all-inclusive. It represents typical duties and criteria necessary to successfully fulfill the responsibilities of the position. Other duties may be required at the discretion of supervision or management.

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