Job Details

This ad is expired.

ETL Architect/Lead
Go to our website »

Position Number: 1489053
Location: Albany, NY
Position Type: Computing - Other

ETL Architect/Lead
The Research Foundation for SUNY

About The Research Foundation for SUNY:
The Research Foundation for The State University of New York (RF) is the largest comprehensive university-connected research foundation in the country.

Our mission is to provide talent, services, and technology that empower SUNY to research, innovate, and transfer discoveries that transform the world's knowledge economy.

Our vision is to make SUNY the best place for faculty, students and staff to research, innovate, and solve the world's most pressing problems.

The RF serves SUNY by providing essential administrative services that enable SUNY faculty to focus their efforts on the education of students and the performance of life-changing research across a wide range of disciplines including medicine, engineering, physical sciences, energy, computer science, and social sciences.We work with the academic and business leadership of SUNY campuses to support research and discovery through the administration of sponsored projects and technology transfer and management of intellectual property for public benefit and economic growth.

The RF is committed to diversity, inclusion and a working environment that enhances productivity, creates personal and professional opportunities, unleashes everyone's full potential and fuels innovation. We hold the organization and each other to the highest standards of integrity, accountability and ethical behavior.

Visit www.rfsuny.org and connect with the us on Facebook, Twitter and LinkedIn. Learn about SUNY at www.suny.edu.

ADDITIONAL CENTRAL OFFICE EMPLOYEE BENEFITS
As a learning organization, the RF encourages all employees to continue to grow and develop professionally. At the RF Central Office, employees are offered many opportunities for learning and development, including Professional Development Planning, a 12-month Mentoring Program, Tuition Reimbursement, Job Rotation, DiSC Profile Behavioral Assessment, Employee Engagement Teams, Job Skills Training, and an Employee Wellbeing Team.

Job Description:
FUNCTION & SCOPE:
The function of this individual assuming this position is primarily responsible for the team of Business Intelligence technical staff responsible for creating and maintaining the RF Report Center, is the analytical tool used by the Research Foundation (RF) for SUNY, to allow campuses to view integrated information from the RF business systems. This individual is responsible for overall management and resource allocation of the unit and full technical knowledge of all phases of systems analysis and programming plus the duties of instructing, supervising, and checking the work of other personnel. More simply put this individual oversees analyzing and implementing business intelligence for the RF.

Incumbent will act independently to assist in formulating system scope and objectives with focus on overall Business Intelligence architecture and integration between applications. Devise or modify procedures to solve the most complex problems using data processing, keeping in mind the capacity and limitations of the equipment, operating time and form of desired results. Prepare detailed specifications from which programs will be written. Design, code, test, debug, and document these programs.

Additionally, this individual must demonstrate superior technical and analysis skills including but not limited to the following areas: understanding and applying knowledge about technology, understanding and leveraging expert knowledge about relevant business processing, leveraging both technical and business knowledge in designing and developing superior technical approaches and solutions which satisfy business needs.

DUTIES:

Interact directly with the BI Business Analyst Team to understand the reporting needs and challenges and then work on creating solutions. Work closely with business analysts, developers and database administrators to plan, design, develop and implement applications, scripts, procedures and metadata for relational databases.

Analyze, design and develop Business Intelligence technical solutions leveraging off the shelf technologies such as OBIEE, Informatica and similar tools. Also, utilize the ability to think out of the box and come up with creative solutions when needed.

Modify BI semantic layer using OBIEE Admin tool to build new data models and to extend the capabilities of existing models.

Participate in the full development lifecycle within the reporting framework from developing business intelligence requirements to QA and production deployment.

Communicate functional and technical designs and changes to team members and business operational and functional analysts.

Mentor current development staff in the use of Business Intelligence and Oracle coding language based on numerous prior development activities in these environments.

Test and review personal development work as well as work of team members.

Provide additional knowledge of applications architecture and development of Business Intelligence applications based on learning from prior experiences.

Learn other technologies as needed utilizing prior knowledge of related tools in support of the organization projects.

Complies with all supporting change control and problem management policies and procedures.

Ability to be on-call, as needed.

Perform other duties and responsibilities as assigned.

SPECIAL SKILLS:

Education/Expertise/Specialty - Working knowledge of Oracle Business Intelligence Enterprise Edition (OBIEE), ETL processing and Oracle database programming languages.

Must be able to work with problems involving multiple variables.

Must demonstrate the ability to organize and plan tasks; the ability to communicate effectively both written and verbally; the ability to evaluate and implement software into the work environment.

Familiarity or experience with Oracle E-Business Suite preferred.

Background in Data Modelling preferred.

Experience with Informatica preferred.

Experience with Appworx preferred.

Requirements:
EDUCATION & EXPERIENCE:

Bachelor's degree in Computer Science or Information Systems or another related field.

Experience with Business Intelligence for at least 5 and an additional 2-3 years of managing technical development staff.

Certification, training, or proven knowledge in Business Intelligence, and Oracle database tools.

Additional Information:
As an Equal Opportunity / Affirmative Action Employer, The Research Foundation for SUNY will not discriminate in its employment practices due to an applicant's race, color, creed, religion, sex (including pregnancy, childbirth or related medical conditions), sexual orientation, gender identity or expression, transgender status, age, national origin, marital status, citizenship, physical and mental disability, criminal record, genetic information, predisposition or carrier status, status with respect to receiving public assistance, domestic violence victim status, a disabled, special, recently separated, active duty wartime, campaign badge, Armed Forces service medal veteran, or any other characteristics protected under applicable law.

The Company will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant.

Review of applications will begin immediately and continue until the position is filled.

The Research Foundation for the State University of New York is not an agency or instrumentality of the State of New York. Employees of the Research Foundation for the State University of New York are not state employees, do not participate in any state retirement system, and do not receive state fringe benefits. The Research Foundation for the State University of New York operates under a contract with The State University of New York and receives no directly appropriated state funding.

Application Instructions:
To apply for the position, please visit: https://rfsuny.interviewexchange.com/jobofferdetails.jsp?JOBID=108964

Applicants interested in applying MUST submit the following documents:

1. Resume/Cv
2. Cover Letter

After submitting your resume/CV, the subsequent pages enable you to upload additional documents including a cover letter.

Returning Applicants - Login to your RF SUNY Careers Account to review your application.