Determine best technical solutions and support to satisfy ITS's functional and business requirements. Define requirements for installing and improving related systems and determine appropriate timing for implementation of system modifications or upgrades. Document systems design, create specification, flow charts, and other related diagrams based on user or system design specifications. Analyze data and desired end results to develop testing and conversion plans.
Relevant courses (systems analysis, database systems, data analysis, Java, web programming)
5 years' experience with designing and implementing systems including any of the following: data warehouse technology, data analysis, system design and modeling, business intelligence, reporting operations or an equivalent combination of education and experience.
Experience with data warehousing. This would include ETL expertise, dimensional data modeling, star join schema modeling, FACT and dimensions tables, Physical and Logical data modeling. Expertise with Datastage, PeopleSoft EPM and OBIEE. OBIEE experience to include system administration knowledge.
Required Skills, Knowledge and Abilities:
Data Management - Concrete experience with and a wide base knowledge of general Data management principles, methodologies, and frameworks is a critical area of focus for the position including Data Integration, Data Wrangling, Big Data concepts, Data Quality and APIs.
Business Intelligence - Deep understanding of general BI strategies and solutions utilizing a wide range of products. Personal hands-on experience architecting, designing, implementing, and delivering solutions utilizing technologies from Oracle OBIEE & Tableau.
Enterprise Data Warehousing - Understanding and personal hands-on application of both 'bottom-up' and 'top-down' data warehousing architectures is required. The ability to conversationally discuss detailed aspects of complex data warehousing solution elements with a primary focus on emerging industry concepts and technologies. Full understanding of ETL/ELT is required especially dealing with very large volumes of data. Data architecture and modeling experience implementing proper data structures for an ETL solution for Data Warehousing environment is required. Full comprehension of SQL, cardinality, levels of granularity, normalized vs de-normalized, handling of slowly changing dimensions, auditing, database and tool optimization techniques, Change Data Capture and other such data architecture best practices is a must. Experience designing integrations solutions moving data sets of all sizes connecting File Systems, OLTP, OLAP, Data Lakes, No SQL, Big Data & API environments using batch, request/response & real-time streaming paradigms. Advanced Data modeling techniques & familiarity with newer technologies using AWS, Matillion, Python Programming, & MPP DB such as Redshift & Snowflake.
Preferred Skills, Knowledge and Abilities:
Prior experience designing Data integration using IBM DataStage is a plus. Experience designing & setting up Data as a Service Layer. Experience with large-scale software implementation (high transaction volume and high-availability concepts). Business value focused mindset balancing tactical and strategic needs.
EOE/AA/Minorities/Females/Vet/Disabled/Sexual Orientation/Gender Identity