Design, implement and maintain Pinger’s Data Warehouse. Involved in technical design, development, implementation, and production support activities related to loading, transforming and auditing Pinger’s data. Work closely with otherdevelopers on the Data Warehouse team along with Product Managers, Marketing and Business Analysts. Analyze source data to understand the data structure, definitions and anomalies. Interact with other technical team members to establish data requirements and designs. Maintain and enhance the existing Data Warehouse processes. Design, develop and implement new Data Warehouse processes. Support the nightly Data Warehouse jobs and help resolve production data load issues as they occur.
Bachelor’s degree or equivalent in Computer Science, Computer Engineering, Electronic Engineering, or a related field. Five years of progressive experience in the job offered or five years of progressive experience in Software Engineering, Software Quality Engineering, Business Intelligence/Data warehouse engineering, or a combination thereof.
Work experience to include: 1.) Database systems experience using at least one of the following: MySQL, MS SQL Server, Oracle, Postgress. 2.) Data reporting experience using at least one of the following: Tableau, Microstrategy, Microsoft SSRS, Microsoft SQL Server Integration Services (SSIS), Microsoft Excel. 3.) ETL packages using at least one of the following: Talend, Microsoft SSIS, Python, Java. 4.) Scriptingexperience in at least one of the following: SQL, SHELL, PHP.
A standardized pre-employment technical exam will be administered by the hiring manager before hire. A minimum score of 80% on the technical exam is required as a condition of employment.
40 hrs./wk. Job location: San Jose, CA