Bi/Ssrs Report Developer

Yale University New Haven , CT 06501

Posted 3 weeks ago

Essential Duties

1.Develops programs or systems of small to moderate size and complexity. Modifies existing systems at all levels of difficulty. 2.

Provides informational input into decisions concerning the development and delivery of applications, programs and systems. Defines and analyzes requirements to meet the expectations of stakeholders and intended end user needs, scheduled timeline, and budgetary targets. 3. Analyzes, defines and designs new systems and applications.

Writes code in support of business solutions. 4. Responsible for the creation, definition, communication, and management of project plans which includes architectural design, technology selection and methodologies to apply. 5. Troubleshoots problems and provide ongoing maintenance and support for applications and systems. 6.

Prepares documentation, user manuals and develops formal proposals for new systems and modifications to existing systems. Mentors technical staff and provide training for end users. 7. Contributes in the development of policies or modifications to exiting policies. 8.

Applies and keeps current with existing and emerging technologies and methodologies. Provides ongoing input to the establishment of programming standards, procedures, and methodologies. 9. May perform other duties as assigned.

Required Education and Experience

Bachelor's Degree in a related field and two years of related work experience or an equivalent combination of education and experience.

Background Check Requirements

All candidates for employment will be subject to pre-employment background screening for this position, which may include motor vehicle, DOT certification, drug testing and credit checks based on the position description and job requirements. All offers are contingent upon the successful completion of the background check. Please visit www.yale.edu/hronline/careers/screening/faqs.html for additional information on the background check requirements and process.

Position Focus:

Yale University is looking for a well-rounded Software Engineer to join a large Application Development and Support team. This team is responsible for the development, enhancement, and support of a suite of applications built in a variety of technologies. This is a hands-on position which will require both breadth and depth in software development, as well as delivering technical solutions for complex projects.

Responsibilities of this position will include:

Key responsibility of this position is as a Report and Dashboard developer.

Responsible for developing and maintaining BI Dashboards using Tableau.

Responsible for developing custom SSRS Reports.

Responsible for developing Stored Procedures and Views using TSQL as data sources for the Tableau dashboards and SSRS Reports.

Responsible for working with Application developers and ETL developers to design and develop reports and dashboards that follow Yale's style guidelines.


Preferred Education, Experience and

Skills:

Bachelor's Degree in a related field and 6 years of related work experience.. 4-6 years experience in Microsoft stack. Experience in Database Design, Development and administration. Programming experience using Blackbaud's Infinity Platform SDK is a big plus.

Posting Disclaimer

The intent of this job description is to provide a representative summary of the essential functions that will be required of the position and should not be construed as a declaration of specific duties and responsibilities of the particular position. Employees will be assigned specific job-related duties through their hiring departments.

Affirmative Action Statement:

Yale University considers applicants for employment without regard to, and does not discriminate on the basis of, an individual's sex, race, color, religion, age, disability, status as a veteran, or national or ethnic origin; nor does Yale discriminate on the basis of sexual orientation or gender identity or expression. Title IX of the Education Amendments of 1972 protects people from sex discrimination in educational programs and activities at institutions that receive federal financial assistance.

Questions regarding Title IX may be referred to the University's Title IX Coordinator, at TitleIX@yale.edu, or to the U.S. Department of Education, Office for Civil Rights, 8th Floor, Five Post Office Square, Boston MA 02109-3921. Telephone: 617.289.0111, Fax: 617.289.0150, TDD: 800.877.8339, or Email: ocr.boston@ed.gov.



icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Sr System Anaylst Database Developer

Yale-New Haven Health

Posted 2 weeks ago

VIEW JOBS 3/11/2020 12:00:00 AM 2020-06-09T00:00 Overview To be part of our organization, every employee should understand and share in the YNHHS Vision, support our Mission, and live our Values. These values - integrity, patient-centered, respect, accountability, and compassion - must guide what we do, as individuals and professionals, every day. Working under minimal direction of HRIS Technical Manager, designs, builds and manages large relational database system projects that run on Client Server platforms. Responsible for system development, programming, system maintenance and report development as it relates to HR Systems. Develops complex web applications and interfaces with Lawson HR data. Responsible for creating and maintaining Oracle views and stored procedures within applications. EEO/AA/Disability/Veteran Responsibilities * 1. Participates as team leader in the design of relational databases. Performs basic Oracle Database Administration to create database objects and create, modify and document new systems. Makes changes to existing custom applications and develops appropriate documentation. * 2. Assists other team members in Oracle query/view design and optimization; provides technical guidance in analytical tasks; Oversees project assignments and monitors progress against plan. * 3. Collaborates with team members and User community in planning new projects. Provides consultation to enterprise divisions on procedures and processes affecting HR network and applications. * 4. Works with IT Database Administrators and HRIS Technical Manager to develop standard configuration and methodologies assuring a level of uniformity across various applications. * 5. Develops enhancements for existing HR realted applications using Visual Studio, PL/SQL, MS.net and UNIX/AIX/NT skills. * 6. Responsible for system development, programming, system maintenance and report development as it relates to HR Systems. * 7. Develops web programming for complex web applications and interfaces. * 8. Provides programming support on third party and custom PC applications for areas such as Workers' Compensation, Recruitment, Joint Commission Mandatory Training, Pension and Compensation. * 9. Develops, maintains and assists other Corporate HRIS staff in the development of Health System-wide Crystal reports and HRDB queries for functional users. * 10. Reviews, coordinates and processes end user security access requests for all Lawson related features such as HRDB, HR Oracle and Crystal Reports. * 11. Assists Super Users in testing proposed code changes, including interfaces. * 12. Conducts cost/benefit analyses of various methods for fulfilling micro-computer systems support requirements. * 13. Assists in the development of system procurement specifications, Requests for Proposals, and Information Systems plan for microcomputer systems enterprise-wide as it relates to the Human Resources function. * 14. Serves as a liaison with IS&T and Human Resources staff, assisting in coordinating functions and problem solving involving Lawson and other ancillary software packages. * 15. Keeps abreast of recent developments in the Information Systems field as related to HR products. Participates in professional development programs. * 16. Mentors and coaches other Corporate HRIS staff members. * 17. Performs other job related duties as required. Qualifications EDUCATION Position requires a Bachelor's degree in Computer Science or related disciplines, or technical training and work related experience equivalent. (courses in System Analysis and Design, database management, data gathering, oral and written communications) Education in the use of Visual Studio suite of products, PL/SQL and MS.net required. Oracle DB Administration fundamental training required. EXPERIENCE Seven (7) to ten (10) years of experience in a variety of systems analysis and programming activities, with at least five (5) years of primary emphasis on micro-computing systems and web applications development required. Demonstrated experience working with MS.net, MS Access, Visual Basic Scripting and Crystal Reports required. Experience in the use of Visual Studio suite of products and PL/SQL required. SPECIAL SKILLS In-depth knowledge of a variety of personal computer based hardware and software systems, communications networking and analysis techniques. Excellent client-relations skills. Strong web application development skills utilizing MS.Net. Working knowledge of Visual Studio suite of products, MS Access and Crystal Reports is required. Knowledge of industry standards such as SQL, ODBC, Crystal server pages and Client Server. Knowledge of JAVA scripting or Visual Basic scripting preferred. Well developed programming, analytical, and problem resolution skills. Excellent oral and written communication, planning, organizational, and project management skills. Yale-New Haven Health New Haven CT

Bi/Ssrs Report Developer

Yale University