Data Engineer

Job Description

• The ideal candidate will excel as a Data Engineer / Data Architect: focusing on development and delivery of data virtualization components of a virtual data access layer between various federated data sources and BI tools. The candidate must have the ability to think both strategically and tactically to enforce global architectural principals while tuning SQL performance at the detail level. An understanding of data warehousing OLAP OLTP naming standards data federation governance and metadata is key to this position. The ability to work independently and learn quickly is essential. The role offers great opportunities to learn various tools and technologies used in a sophisticated data architecture within the Business Intelligence and Analytics Data Services team in Data Products Development organization.
• Responsibilities / Duties
• Hands - on execution as well as leadership of the following:
• Develop and implement data virtualization architecture to build a Semantic Layer that simplifies data analysis for users
• Create and tune SQL for views across federated sources including Hadoop DB2 and Oracle
• Ensure platform stability by performing proactive maintenance activities code deployment in Development and QA automation activities and root cause analysis and remediation.
• Collaborate with BI report developers on design for optimal performance
• Assist on data analytics projects involving data modeling and architecture
• Assist on building integration with other data / metadata tools in the architecture
• Assist on some database administration tasks for the data virtualization platform
• Use business requirements to document clear and concise technical designs
• Maintain design and naming standards
• Contribute to project planning discussions provide status updates for development progress and be a critical resource for issue resolution
• Bachelors degree in Computer Science or related discipline
• Minimum 3 years of experience as a Data Engineer or Data Architect in data warehousing
• Minimum 3 years of strong experience in writing and tuning SQL
• Experience with RDBMS technologies (DB2 Oracle)
• Experience with SQL - on - Hadoop preferred (Hive Impala)
• Experience with Denodo or similar Data Virtualization tools is a plus
• Experience with BI tools like Tableau / MicroStrategy is a plus
• Experience with basic Windows and Linux administration is a plus
• Familiarity with web services APIs and related architectures
• Experience in Agile development methodology / Scrum is a plus
• Excellent written and oral communication skills

Job Summary