Founded in 2001, Newegg Inc. (“Newegg” or the “Company”) is the premier e-commerce retailer of information technology products, peripherals and consumer electronics to the do-it-yourself and online gaming markets. With its phenomenal growth rate (from $0 in 2001 to 2010 revenues of $2.5 billion), an unbroken track record of profitability and consistently top rankings in customer service, it has a strong basis for that claim. The Company, which is privately held, has over 2,400 employees worldwide and more than 14 million registered customers. This is an extremely exciting period in the life of the company, as it prepares for the next stage of growth by strengthening the executive leadership team.
Develop, maintain, and implement data warehouse for e-commerce retailer. Design company’s Business Intelligence (BI) data flow architecture to enhance data storage arrangement in the data warehouse and data flows from source systems to users through these data storage. Design and develop BI’s data system architecture, physical arrangement and connections between company’s various servers, networks, software, storage systems, and clients. Perform data modeling by designing multi-dimensional data storage based on business process studies and analysis. Perform data extraction, a process of retrieving and transforming data from the various source systems and putting it into company’s Data Warehouse. Perform data cleansing and matching, a process of identifying and correcting dirty data. Prepare data quality report through internal program that retrieves data from company’s data warehouse and presents it to internal users. Monitor data warehouse ETL (Extract, Transform, Load) to ensure accurate data for vital top management reports. Work with technology leadership to set strategic direction for data warehouse initiatives. Interact with all levels of the business and external partners to work on implementation of data warehousing projects. Ensure data integrity, process controls, and securities are in accordance with all applicable laws and regulations.
Bachelor’s degree in Computer Science, MIS/Management Science or related plus 2 years experience in architecting and developing Business Intelligence (BI) solutions. Must also have background in: 1) architecting & developing BI dimensional models, data marts, dashboards, scorecards & reports; 2) relational DB management systems—building cubes & programming complex SQL queries & stored procedures; 3) IBM Cognos 8 BI tools—Report Studio, Query Studio, Framework Manager & Transformer; 4) data warehousing architectures, data integration, data profiling & OLAP technologies (MOLAP, ROLAP, and HOLAP); 5) performing ETL using MS SSIS; and 6) VB.NET & Java.