Data Architect

Data Architect

Job Location: Philadelphia, PA

Job Type: Permanent

Salary: $120K

Job Description:

• Data warehouse architecting, dimensional data modelling experience working with multiple databases
• AWS experience with MySQL, Redshift, Python, and preferably PiSpark and Glue
• Liaison with client to understand business requirement and coordinate with offshore team
• Must be able to grasp business issues and technical problems, and come up with smart, logical solutions. Strong problem solving capability
• Should be able to execute assigned tasks in a timely & efficient manner.
• Develop strong expertise in the entire modules within the DWH scope.
• Effectively communicate status, metrics and issues on a regular basis.
• Help colleagues on a proactive basis.
• Liaison with client to understand business requirement and coordinate with offshore team. Translate requirement into technical design, Data warehouse architecting design, dimensional data modelling and creation of physical design. Presenting dashboard/outcome/status to CFO/customer, effectively communicate status, metrics and issues on a regular basis.

Preferred Skills:

• AWS Glue, SQL/PLSQL, Looker/other BI reporting tool

Mandatory Skills:

• Experience in AWS, Redshift. MySQL Aurora, Dimensional Modelling