What are the responsibilities and job description for the Production Support Data Analyst position at Ampcus?
Data Warehouse Support Analyst - Long Term Contract
Must have Strong SQL
Hybrid Role on site Tues, Wed and Thurs in any of the following locations
Conshohocken, PA; Florham Park, NJ; New York, NY; Purchase, NY
The DataWarehosue Support Data Analyst is a hands-on position with a focus on supporting the data accuracy and completeness within the enterprise data warehouse. The position will work within IT to help our client maintain the enterprise data warehouse architecture. Furthermore, the data warehouse architecture will measure performance in all aspects of the organization's operations.
ROLE RESPONSIBILITIES
- Work with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouse.
- Create source-to-target mapping documents to capture additional application data elements.
- Load the source-to-target mapping documents from source systems into the enterprise data warehouse.
- Collaborate with the ETL team to ensure the source-to-target mapping documents are in correct ETL code.
- Ensure the ETL code align with STM requirements.
- Perform data validation, to insure correct data movement into the enterprise data warehouse architecture.
- Consult with reporting teams to develop a general understanding for any identified variances - between the enterprise data warehouse and source system applications.
TECHNICAL QUALIFICATIONS
GENERAL QUALIFICATIONS
EDUCATION REQUIREMENTS
please send your resume to janice.dicicco@ampcus.com
