Job Description :
Position : Data Architect
Location : Plymouth-Meeting, PA
Duration : Fulltime (Permanent)
Job Description:
Experience with data modeling tools, specifically Erwin.
Experience with Hadoop ecosystem (Hadoop, Hive, Impala, HBase, MapReduce/Yarn, etc
Details JD:
Contribute to Data Architecture by providing ongoing analysis of enterprise data stores to ensure the overall architecture remains appropriate and optimal for current and planned usage.
Participate in requirements gathering, technical specifications, architectural design and support development as it relate to database design, access and utilization.
Contribute to the overall direction relative to systems of record and how data compliance and regulations affect the handling of data among applications and the overall design recommendations.
Serve as a resource to less experienced team members on escalated issues and as a training resource on understanding and handling the company’s data.
Receive complex work problems/questions, develop accurate estimates and create project and component work based on specifications.
Develop SQL code of medium to high complexity in support of these activities and provide direction to others on how to handle the question going forward.
Technical Skills and Qualifications:
Experience with data modeling tools, specifically ERwin
Experience with Hadoop ecosystem (Hadoop, Hive, Impala, HBase, MapReduce/Yarn, etc
Strong native SQL skills
Strong experience in database and data warehousing concepts and techniques.
Must understand:
Relational and dimensional modeling,star/snowflake schema design, BI, Data Warehouse operating environments and related technologies, and ETL, MDM, and data governance practices.
Working with development lifecycle tools, such as, Jira, Jenkins, DevOps tools
Familiarity with Object Oriented concepts and languages, such as Java
Familiarity with Functional programing concepts and languages