Data ArchitectJob Location: Philadelphia, PAJob Type: PermanentSalary: $120KJob Description:Data warehouse architecting, dimensional data modelling experience working with multiple databasesAWS experience with MySQL, Redshift, Python, and preferably PiSpark and GlueLiaison with client to understand business requirement and coordinate with offshore teamMust be able to grasp business issues and technical problems, and come up with smart, logical solutions. Strong problem solving capabilityShould 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 toolMandatory Skills:Experience in AWS, Redshift. MySQL Aurora, Dimensional Modelling