Sr. Data Engineer, AmazonLocal Job in Seattle 98119, Washington Us
Sr. Data Engineer, AmazonLocal
Sr. Data Engineer, AmazonLocal
The AmazonLocal is looking for a data warehouse engineer to play a key role in building their financial and operational metrics Data Warehouse. If you have experience in building and maintaining very large data warehouses with high transaction volumes then we need you!!!
AmazonLocal develops consumer websites and applications for mobile devices using the latest in front-end, back-end and mobile technology. We write high quality, well-tested code and maintain a very low operational overhead that allows us to focus continuously on delivering exciting new functionality for our users. We utilizes the latest in agile and test-driven development methods and tools.
Job Summary
The Data Warehouse Engineer should be an expert familiar with all of the data warehousing technical components (e.g. ETL, Reporting, Data Model), infrastructure (e.g. hardware and software) and their integration. The ideal candidate will be responsible for developing overall architecture and high level design. The candidate must have extensive experience with Star Schemas, Dimensional Models, and Datamarts. The individual is expected to build efficient, flexible, extensible, and scalable ETL design and mappings. Excellent written and verbal communication skills are required as the candidate will work very closely with a diverse teams
Responsibilities
- Applies broad knowledge of technology options, technology platforms, design techniques and approaches across the data warehouse life cycle phases to design an integrated, quality solution to address the business requirements
- Meets and collaborates with business users on requirements, objectives and measures.
- Designs the technology infrastructure across all technical environments
- Ensures completeness and compatibility of the technical infrastructure to support system performance, availability and architecture requirements
- Designs and plans for the integration for all data warehouse technical components
- Provides input and recommendations on technical issues to the project manager
- Responsible for data design, data extracts and transforms
- Develops the implementation and operation support plans.
- 7+ years experience with and detailed knowledge of data warehouse technical architectures, infrastructure components, ETL/ ELT and reporting/analytic tools and environments, data structures.
- 3+ years experience in architecting data warehouse solutions and integrating technical components
- 5+ years experience with relational and star schema data modeling concepts
- Experience in relational database concepts with a solid knowledge of Oracle, SQL and PL/SQL.
- Demonstrated knowledge and experience in capacity planning for hardware and storage needs
- Excellent communication skills, both written and verbal
- Strong ability to interact, communicate, present and influence within multiple levels of the organization
EDUCATION: BS in Computer Science or Information Systems; MS preferred
- Experience with Informatica or other ETL tools preferred
- Knowledge of OBIEE is preferred
