Data Analyst (ETL/DWH)

Role: Data Analyst

Location: Pittsburgh PA

Hire: Contract- W2

Client: Banking & Financial Domain

Open to candidates in other hubs as secondary preference.

Summary:

The main function is to coordinate changes to computer databases, test, and implement the database applying knowledge of database management systems.

Job Responsibilities:

• Work with senior management, technical and client teams in order to determine data requirements, business data implementation approaches, best practices for advanced data manipulation, storage and analysis strategies
• Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions
• Design, implement, automate and maintain large scale enterprise data ETL processes
• Modify existing databases and database management systems and/or direct programmers and analysts to make changes
• Test programs or databases, correct errors and make necessary modifications

Skills:

• Experience with database technologies
• Knowledge of the ETL process
• Knowledge of at least one scripting language
• Strong written and oral communication skills
• Strong troubleshooting and problem-solving skills
• Demonstrated history of success
• Desire to be working with data and helping businesses make better data driven decisions

Education/Experience:

• Bachelor's degree in a technical field such as computer science, computer engineering or related field required or equivalent work experience.
• 3-5 years applicable experience required

Roles and Responsibilities: Data warehouse experience, Requirement Analysis, translate business requirements to technical specifications, perform data analysis, extensive experience in SQL and writing complex query writing, ETL, document source to target mapping, experience in database modeling & design, implementation and maintenance. Experience with Oracle, Teradata, Hadoop/Big Data. Experience in business intelligence tools (OBIEE/Tableau). Related certifications preferred.

Must Have Technical Skills:

- ETL

- SQL (Prioritized skill, most be extremely proficient)

- JIRA

- Microsoft Office (specifically Excel)

- Data Warehouse

Flex Skills/Nice to Have:

- Presenting

Soft Skills:

Communication skills at all levels of business

Documentation skills

Bachelor's degree required in a technical field or business with an emphasis in technology, any certifications related to agile or requirement elicitation, safe certifications - Degree preferred, experience required.

Years of experience: Level 2 3-5 years