Data Warehouse Architect
Company Summary: MGA Entertainment, a consumer entertainment Products Company headquartered in Chatsworth, California, manufactures innovative lines of proprietary products for the toy and consumer electronics market. The company also licenses its IP in such areas as apparel, home décor, stationery and sporting goods. The MGA family includes award-winning brands such as LOL Surprise, Little Tikes®, Project MC2, and Zapf Creation®. For more information please visit www.mgae.com.
The Enterprise Data Warehouse Architect will be responsible for data warehouse architecture and modeling tied to operational and analytical data stores. This includes modifying Datamart, Data Warehouse model design, and/or data load process. This position collaborates with business partners and business analysts to gather DW requirements and translate business requirements into data warehouse design and architecture. In addition, participates in the development of documentation, policies, procedures, and standards for systems and software development. Leads all aspects of the documentation of technical architecture, design, and analysis work.
Experience Requirements:
- 10+ years’ experience in a complex multi-platform environment.
- Extensive experience with data warehousing systems for large enterprises using standard data warehousing design techniques. Capture and model data requirements, data definitions, business rules, data quality requirements.
- Outstanding technical experience and knowledge on data integration technologies, data transformations and data analytics and optimizing sophisticated technology transformation.
- Demonstrable experience in software architecture/design processes and development.
- Ability to read, write and maintain SQL Code.
- Knowledge of relational database technology and client-server applications.
- Experience working in major systems implementations and sophisticated development projects.
- Knowledge of development life-cycle and production environment procedures.
- Must have a solid understanding of SQL and Oracle Databases.
- Demonstrated ability working with modeling tools.
- SSIS Knowledge is a plus.
- Azure Cloud Computing
- Data factory knowledge is a plus.