Job Details:
Data Warehouse Engineer
POSITION PURPOSE:
This position is part of the Data Warehouse Team. This position will be responsible for providing BI best practices and developing and maintaining company’s Enterprise Data Warehouse impacting sales, operation and employee data.
ESSENTIAL FUNCTIONS:
• Develop robust ETL packages and support data warehouse processes. Ensure data integrity, validity, accuracy, completeness and quality through data acquisition process design and process monitoring capabilities
• Identify opportunities for usability improvements, simplification and standardization across ETL package and process
• Responsible for the company’s enterprise data warehouse design, development, operations and maintenance
• Design, develop, and operationalize complex logical and physical data models that meet complex business analytical needs
• Support ad hoc business data requests by understanding requirements and developing queries as needed
• Must have excellent analytical capability and comprehension of business challenges and address them during technical design
EDUCATION/EXPERIENCE REQUIREMENTS:
• 5+ years of hands-on experience on developing and supporting data warehouses (ETL) in an enterprise environment, supporting PL/SQL Oracle with large data volumes and complex data processes
• 5+ years hands-on experience in data modeling (conceptual, logical, and physical) across various business subject areas. Data models presented in an enterprise business intelligence suite * 3+ years of experience in writing SQL queries
• B.S. degree in Computer Science
TECHNICAL SKILL REQUIREMENTS:
• Experience with ETL processing
• Must possess advanced PL/SQL programming and SQL tuning skills
• Experience writing and tuning stored procedures * Expert knowledge of Relational databases such as SQL Server, Oracle
Kevin McCarthy
Liberty Personnel Services, Inc.
410 Feheley Drive | King of Prussia, PA 19406
Direct Line: 484.238.1949
kevin@libertyjobs.com www.libertyjobs.com
http://www.linkedin.com/pub/kevin-mccarthy/0/521/133