Data Warehouse Analyst Apply
Our manufacturing client in the Harrisburg, PA area is looking to hire a Data Warehouse Analyst to join their expanding data engineering and business intelligence team. You will report to the Director Information Technology.
This is a hybrid position, salary range is 120-140K, excellent benefits and career growth.
How you will contribute:
You will play 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
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 company locations in the US. 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.