What are the responsibilities and job description for the Sr. Data Analyst position at A.C. Coy?
Overview
Location: Hybrid (3 onsite/ 2 remote) north of Pittsburgh, PA
Job Type: Full Time / Contract
Work Authorization: No Sponsorship
The A.C. Coy company has an immediate need for two Sr. Data Analysts. Ideal candidates must have 5 years of data analysis skills using Oracle SQL Developer and MS SQL Server Management Studio.
Responsibilities
- Write and execute SQL queries against both Oracle (Finders) and SQL Server databases (EDP)
- Perform data validations and comparisons
- Extract data from the Finders Oracle database
- Prepare data ingestion templates to upload into Boomi Master Data Hub (MDH)
- Validate data ingestion results in target databases (MDH/SQL Server)
Qualifications
- Advanced SQL skills - 5 years
- Experience using Oracle SQL Developer and Microsoft SQL Server Management Studio - 5 years