IT Data Warehouse Architect and Reporting Analyst

Requisition : 1090

Position Title: IT Data Warehouse Architect and Reporting Analyst

Location: HQ Broken Arrow, Broken Arrow, OK, US

Position Type: Full Time

Arrowhead Winch engineers and manufactures industrial winch, hoist and drive systems under the BRADEN, CARCO and Gearmatic brand names in Broken Arrow and Okmulgee, Oklahoma. We are seeking a talented Data Warehouse Architect and Reporting Analyst to join our IT team. Benefits include 401K with matching up to 5%, plus profit sharing plan; medical, dental and vision plans; flexible spending and health savings accounts;

paid short and long term disability program; paid life insurance; and paid holidays, sick and vacation time. Our work environments are clean, climate controlled and safe.
This position is on-site in our Broken Arrow, Oklahoma office. This is not a hybrid or remote job opportunity. Arrowhead Winch does require applicants to complete a background check, drug test, and pre-employment physical as a condition of employment. Our goal is for all employees to work safely without injury while maintaining the highest safety standards in compliance with company policies.

Design data structuring from existing DB2 environment to allow access from modern development tools and resources. This is a critical transformation role within the organization to transform business data into actionable information.

• Work with business groups to determine existing data to develop a sustainable consistent reporting environment.
• Design data structures that use current business data without impacting business utilization on the existing ERP environment.
• Assist with establishing data integrity rules and sustainable data governance.
• Develop Business dashboards that reflect status as it relates to the various business areas.
• Maintain Data Warehouse performance.
• Familiar with designing, implementing and maintaining Business Intelligence infrastructure.
• Analyze existing data and work with existing ERP business development to tailor data captured to provide the greatest value to future business decisions.
• Work with existing business leaders to determine short- and long-term reporting needs and directions.

• A Bachelor's degree in Information Technology, Computer Science, or Electronics Engineering, along with practical experience in related roles.
• Five (5) to ten (10) years of related experience and professional progression related to Data Warehouses and reporting environments.
• Proficiency in Data Modeling, SQL, OLAP, ETL tools (e.g., SSIS), programming languages (e.g., SQL, PL/SQL, Python), and multiple database platforms (e.g., DB2, SQL Server, MySQL, Oracle).
• Database management skills to facilitate data movement between various systems in a timely manner.

• Experience with Tableau and Power BI or other related tools.
• Experience with data transformations and data integrity roles and responsibilities.
• Mechanical aptitude with an understanding of heavy manufacturing environment and equipment.

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this Job, the employee is regularly required to sit; use hands to handle or feel and talk or hear. The employee is frequently required to reach with hands and arms. The employee is occasionally required to stand;

walk and stoop, kneel, crouch, or crawl. The employee must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds, with assistance. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust.

PI