Design Engineer IV


Posted Under: Pasadena, California jobs in Engineering; Engineering jobs in zipcode 91050
Posted On: 2017-04-21 11:00:00

Job Description:

Job Title : Design Engineer IV Location : Pasadena, CA Job Duties: ADP Technology Services, Inc. seeks a Design Engineer IV at our Pasadena, CA location. Responsibilities: Responsible for source data analysis and defining metrics calculations. Design DataMart from conceptual model to physical model. Oversee the definition of the Extract, Transform and Load (ETL) process for analytics from source to staging, including the creation of mapping documents, ETL design specifications, and ETL workflows. Responsible for ETL processes to be used in workflows, including the validation through User Interface (UI) queries and performance tuning for ETL and UI. Maintain and enhance DataMart for additional compliance metrics. Work on performance bottlenecks and identify and research potential analytics possibilities and source identification. Education and Qualifications/Skills and Competencies: Bachelor's degree in Computer Science, Computer Engineering, Electrical Engineering, Information Technology, Information Systems, Management Science, or a related field and seven (7) years of experience. Work Experience: Experience must include: ETL; ETL design specifications; Creation of ETL workflows; Microstrategy; Business Objects; Tableau; Cognos BI; SSIS/SSRS; RDBMS, including Oracle, SQL Server and DB2; building data warehouse solutions; creation of mapping documents; Reporting topology; designing and modelling of DataMart; design, development and maintenance of Business Intelligence (BI) reports; Source data analysis and defining metrics.

Apply for this job, view similar jobs, and more at!