Data Architecture & Integration Sup / Information Technologist III/S
Data Architecture & Integration Sup / Information Technologist III/S
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Working/Functional Title
Data Architecture & Integration Sup
Position Summary
As a key member of the Data Architecture & Integration team this role will be responsible for strategically designing developing and implementing a data integration hub to facilitate seamless data exchange across various systems. This role involves creating dimensional data models for enterpriselevel reporting systems at multiple layers including conceptual logical business area and reporting application.
This role will lead a team of professionals providing supervision coaching and mentorship. They will participate in unit administration including planning budgeting policy development and resource management. The role requires expertise in data warehousing business intelligence ETL processes and data integration methodologies to ensure data accuracy quality and integrity.
Additionally this role will manage and support all projectrelated activities from architecture and design to development and deployment ensuring projects are completed within budget and on time. This position is pivotal in driving strategic initiatives that enhance data governance and utilization across the organization.
Michigan State University (MSU) is a top 100 global university located in East Lansing three miles east of the states capitol. The MSU community includes more than 12000 faculty academic and support staff as well as over 52000 students. MSU offers an extensive benefits package to its employees including health care prescription and dental coverage and a base retirement program with a University matching contribution as well as basic life insurance. In addition MSU offers educational benefits including a course fee courtesy program and educational assistance.
MSU Information Technology provides the primary leadership for strategic financial and policy initiatives affecting information technology (IT) across MSU. MSU IT offers technology resources that support MSUs mission of providing education conducting research and advancing engagement.
Minimum Requirements
Knowledge equivalent to that which normally would be acquired by completing a fouryear college degree program; five to eight years of related and progressively more responsible or expansive work an information technology area related to data architecture; experience in an enterpriselevel ETL or ETL platform such as Informatica DIH Power Center IBM Datastage Oracle Warehouse Builder (OWB) etc.; experience working with complex relational and dimensional databases; supervisory experience; or an equivalent combination of education and experience.
Desired Qualifications
- 510 years of experience in IT related to data integrations and architecture.
- 5 years with enterpriselevel ETL platforms (e.g. Informatica DIH Power Center).
- 7 years with complex relational and dimensional databases.
- 5 years with Oracle SOA suite.
- 4 years with data warehousing techniques (Star Schemas Snowflake Schemas).
- Knowledge of data warehouse design principles and dimensional data modeling.
- Proficient in PL/SQL for Oracle databases.
- Experience in performance tuning database monitoring and capacity planning.
- Unix (AIX) shell scripting experience.
- Experience in data migration projects and database administration.
- Performance optimization for relational and dimensional models.
- Managing metadata and supporting data governance initiatives.
- Selfmotivated independent worker with effective communication skills.
- Familiarity with IBM Cognos Framework Manager SPSS and UC4 process flow.
- Knowledge and experience in a fundraising setting.
- Experience with multiterabyte environments and data archiving/purging best practices.
Equal Employment Opportunity Statement
All qualified applicants will receive consideration for employment without regard to race color religion sex sexual orientation gender identity national origin citizenship age disability or protected veteran status.
Required Application Materials
Resume and cover letter.
Special Instructions
Please provide three professional references who are knowledgeable of your work.
Work Hours
STANDARD 85
Website
Bidding eligibility ends May 6 2025 at 11:55 P.M.
Employment Type
Full-Time
