Data Analyst - SQL Programmer

Job description

Welcome to Rowan University’s Career Site

Rowan University is a Carnegie-classified Doctoral University (Moderate Research Activity) with approximately 19,000 students. Its main campus is located in Glassboro, N.J., 20 miles southeast of Philadelphia, with additional campuses in Camden and Stratford. The University comprises seven academic colleges and five schools—the William G. Rohrer College of Business; the Henry M. Rowan College of Engineering; the Colleges of Communication and Creative Arts, Education, Humanities and Social Sciences, Performing Arts, and Science and Mathematics; the Cooper Medical School of Rowan University; the Rowan University School of Osteopathic Medicine; the Graduate School of Biomedical Sciences; the School of Health Professions; and the School of Earth and Environment—with an Honors College that spans across disciplines. Rowan is one of two public universities in the country to offer M.D. and D.O. medical degree programs. The institution is also home to the South Jersey Technology Park, which fosters the translation of applied research into commercial products and processes. Rowan has been recognized as one of the top 90 public research universities and the 7th fastest growing research institution in the nation.

Rowan University is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, creed, color, national origin, age, ancestry, nationality, marital or domestic partnership or civil union status, sex, pregnancy, gender identity or expression, disability status, liability for military service, protected veteran status, affectional or sexual orientation, atypical cellular or blood trait, genetic information (including the refusal to submit to genetic testing), or any other category protected by law. For the complete Rowan University non-discrimination and affirmative action policy see: https://sites.rowan.edu/equity/_docs/policies/eeo-statement.pdf.

Data Analyst - SQL Programmer

Job no: 493919
Work type: Regular full time
Location: Stratford, New Jersey
Categories: Professional

Summary:

Responsible for support for Rowan School of Osteopathic Medicine data and report requests as well as the creation and maintenance of appropriate database applications for organizational needs.

Essential Duties and Responsibilities:

Recommend, develop, test, implement and maintain stored procedures that are used for reporting.

Recommend new Business Intelligence and reporting tools.

Document technical and user requirements of all new projects. Recommend, implement and maintain solutions for new projects.

Work closely with the Executive Director of Rowan Medicine and his appointed Subject Matter Experts to identify needed data structures, business logic, reporting etc. Recommend and implement solutions. Support state and finance reporting requirements as identified by SME’s to ensure system integrity, changing regulatory reporting requirements and continuous improvement. Anticipate and respond to changing reporting requirements in order to meet deadlines.

Organize planning teams for future data warehouse design and implementation.

Prioritize with the Clinical Systems Director, SOM and Information Resources and Technology senior leadership new projects based on organizational need, government/mandatory reporting requirements and maximization of organizational financial/clinical opportunities.

Optimize existing databases for efficiency, ease of use and for security and programmatic enhancements.

Participate as a vital member of the Rowan SOM IRT clinical technical team to supply support services for the organization.

Work closely with the Clinical IRT staff to provide fill-in and on call support. Independently interact with end users to help guide decision making. Demonstrate critical-thinking skills when developing solutions. Coordinate and collaborate with members of various Rowan IRT departments for maintenance, project planning, scheduling and implementation.

Other duties may be assigned.

QUALIFICATIONS:

Bachelor’s Degree in Information Technology or related discipline. Minimum experience: at least three (3) years of SQL reporting and development using preferably MS SQL in a clinical or business setting is required. Oracle experience will also be considered. Requires expert skills with T-SQL query writing. Certification in either Microsoft SQL Server or Oracle query writing a plus.

Demonstrated experience in gathering complex reporting requirements, designing and implementing Visualization Solutions (Reports, Dashboards, Metrics, KPI’s). Familiarity with scripting and scripting tools. ETL experience a plus. Good written and oral communications skills are a must.

SALARY:

WL28S

Min. $ 66,526.63
Mid. $ 80,311.94
Max. $ 95,756.95

Advertised: Aug 14 2019 Eastern Daylight Time
Applications close: Aug 28 2019 11:55 PM Eastern Daylight Time

 

 

 

Diversity Profile: University

 

AAUP COMPENSATION SURVEY DATA

View more

Learn more on Inside Higher Ed's College Page for University

Arrow pointing right
Job No:
Posted: 8/15/2019
Application Due: 8/28/2019
Work Type:
Salary: