Data Warehouse Engineer Mid to Senior Level

Profile

Job description: Data Warehouse Engineer (Mid to Senior Level roles available)
Duties and Responsibilities:
Contribute to EDW data integration strategy and design
Implement ETL processes with Hadoop, MapReduce, Java, Pig, Hive etc.
Write and/or modify SSIS packages, SSRS reports and report models, and SSAS cubes as necessary
Design and direct the ETL processes, including data quality and testing
Define technical requirements for the data warehouse and data marts
Define and direct the implementation of security requirements
Define data capture methodologies
Define and design production release procedures
Contribute to architectural and data model decisions on projects
Own project development estimates and timelines
Data Warehouse design and tuning to support ETL processes and data analytics applications
Knowledge of any commercially available data modeling tool
Ensure that database design fulfills functional and technical requirements
Review the deliverables throughout development to ensure quality to requirements and adherence to all quality management plans and standards
Education, Skills and Experience:
Bachelors Degree from an accredited college or university required
Advanced degree in Computer Science, Information Systems preferred
At least 8 years of experience designing and maintaining large Database and Warehousing environments (over 5 Terabytes)
Strong ETL and data modeling experience, especially with star schema design
Strong SQL and analytical skills
Strong experience in Enterprise Data Integration
Experience with Microsoft Business Intelligence Stack (SSRS, SSAS and SSIS) or any other industry standard ETL tool
Programming experience with Java or C# .net technologies
Experience designing and supporting Data Warehouses - Microsoft SQL Server 2005/ 2008 experience preferred
Experience with BIG, Hadoop and Map Reduce is desirable
Experience designing relational and multi-dimensional models
Significant skill and experience in requirements definition and analysis
Significant skill in source data discovery
Significant skill in data anomaly identification/resolution
Strong problem solving and analytical skills
Quick learner, eager to leverage new technologies in a dynamic team environment
Able to balance and prioritize multiple concurrent projects effectively
Demonstrated ability to work effectively in a team environment
Demonstrated ability to work well independently and within a fast-paced, team-oriented environment
Demonstrated ability to generate innovative solutions
Excellent communication and interpersonal skills
Naturally curious, goal driven, and self-motivated
PROSUM IS AN EOE.
Prosum
2321 Rosecrans Ave.
Suite 4225
El Segundo, CA 90245
****
Web: ****

Company info

Sign Up Now - WashingtondcCrossing.com