Address
Form of work HOW LONG HAVE THE DUTIES & DISTRIBUTION OF TIME BEEN SUBSTANTIALLY AS BELOW?
ATTACH A COPY OF MOST RECENT ORGANIZATION CHARTAMOUNT OF TIMEDUTIES AND TASKS80%Data Warehouse Architecture, Design and Development (80% time)
SKILLS, KNOWLEDGE AND ABILITIESTASK
REFERENCEIMPORTANCEHighly technical with a BS in Computer Science or 8 years of experience in data management. Masters preferred.AllRequiredExpert in building and managing enterprise-level data integration and data transformation platforms - cloud experience preferredAllRequiredExpert in Kimball dimentional data modeling, architecting and managing data warehouse and datamart schema (star/snowflake schama, OLAP cubes)AllRequiredPassion for continuous quality improvement and leading organizational change through the use of data-driven decision makingAllRequiredExpert in implementing data warehousing methodologies using RDBMS (MSSQL, MySQL, Oracle, Postgres) systems.AllRequiredBS in Computer Science/Engineering/Mathematics or related field required. Masters preferred.AllRequiredDatabase administration expertiseAllPreferredExpert level ability to program in SQL (such as PLSQL, TSQL )AllRequiredExpert level experience in ETL development and standards. Proven skills in standardization of ETL development and execution for large-scale enterprise data sourcesAllRequiredExperience with standard ETL tools such as SSIS, Informatica, ODIAllRequiredExperience and knowledge of programming/scripting languages (e.g. Ruby, Python).AllRequiredExperience with cloud hosted data management services and pipelines (AWS, Azure)AllPreferredPractioner of automation and DevOps practicesAllRequiredUnderstanding of the full Business Intelligence development lifecycle.
Including an understanding of Business Intelligence tool functionality (SAP BO, Cognos, Tableau, QlikView); ability to install and manage BI software systems; experience architecting BI software suites.AllRequiredStrong communication skills with a proven ability to understand key concepts and communicate effectively with technical staff, business stakeholders and senior management. Proven ability to communicate technical concepts to nontechnical people to enhance understanding and drive to decisions that lead to positive outcomes. AllRequiredDemonstrated interpersonal skills to work in a group environment, establishing and maintaining cooperative working relationships with all levels of staff and other department personnel.AllRequired
ATTACH A COPY OF MOST RECENT ORGANIZATION CHARTAMOUNT OF TIMEDUTIES AND TASKS80%Data Warehouse Architecture, Design and Development (80% time)
- Design and manage the physical and logical architecture of data lake and data warehouse.
- Manage ETL processes for accessing new sources into data warehouse
- Data interface management
- Manage master data management processes
- Build scalable datamarts for application and analytics/business intelligence platforms to consume
- Document design and implementation of data warehouse.
- Maintenance of knowledgebase for cosnumsers of datamarts
- Champion automation and DevOps practices
- Provide assistance and daily direction to junior ETL developers.
- Conduct small group training sessions regarding data architecture and ETL development.
- Work with team to develop and implement standardized processes
- Backstop ETL Developers and DBAs in their duties.
SKILLS, KNOWLEDGE AND ABILITIESTASK
REFERENCEIMPORTANCEHighly technical with a BS in Computer Science or 8 years of experience in data management. Masters preferred.AllRequiredExpert in building and managing enterprise-level data integration and data transformation platforms - cloud experience preferredAllRequiredExpert in Kimball dimentional data modeling, architecting and managing data warehouse and datamart schema (star/snowflake schama, OLAP cubes)AllRequiredPassion for continuous quality improvement and leading organizational change through the use of data-driven decision makingAllRequiredExpert in implementing data warehousing methodologies using RDBMS (MSSQL, MySQL, Oracle, Postgres) systems.AllRequiredBS in Computer Science/Engineering/Mathematics or related field required. Masters preferred.AllRequiredDatabase administration expertiseAllPreferredExpert level ability to program in SQL (such as PLSQL, TSQL )AllRequiredExpert level experience in ETL development and standards. Proven skills in standardization of ETL development and execution for large-scale enterprise data sourcesAllRequiredExperience with standard ETL tools such as SSIS, Informatica, ODIAllRequiredExperience and knowledge of programming/scripting languages (e.g. Ruby, Python).AllRequiredExperience with cloud hosted data management services and pipelines (AWS, Azure)AllPreferredPractioner of automation and DevOps practicesAllRequiredUnderstanding of the full Business Intelligence development lifecycle.
Including an understanding of Business Intelligence tool functionality (SAP BO, Cognos, Tableau, QlikView); ability to install and manage BI software systems; experience architecting BI software suites.AllRequiredStrong communication skills with a proven ability to understand key concepts and communicate effectively with technical staff, business stakeholders and senior management. Proven ability to communicate technical concepts to nontechnical people to enhance understanding and drive to decisions that lead to positive outcomes. AllRequiredDemonstrated interpersonal skills to work in a group environment, establishing and maintaining cooperative working relationships with all levels of staff and other department personnel.AllRequired
