Business Intelligence / Data Warehouse Developer

Posting Details

Job # 036667 Department Code 31301-0097 Department Institute for Veterans and Military Families Job Title Business Intelligence / Data Warehouse Developer Location Syracuse, NY Pay Range Commensurate with Experience Staff Level S5 FLSA Status Exempt Hours

Standard University business hours

8:30am – 5:00pm (academic year)
8:00am – 4:30pm (summer)

Hours may vary based on operational needs.

Job Type Full-time Campus Syracuse, NY Unionized Position Code Not Applicable Job Description

The Institute for Veterans and Military Families’ ( IVMF ) research and analytics (R&A) team is seeking an experienced business intelligence/data warehouse developer interested in joining our rapidly growing team as we roll out an enterprise data warehouse. The BI/DW developer will work collaboratively with subject matter experts across the IVMF to provide enterprise-wide expertise in data management and analytics. This position will establish data management processes, develop data integrations, implement data access and security protocols, and develop dashboards and reports.

The BI/DW developer will design, build, and develop data integration solutions using a suite of SAS tools. Responsibilities include supporting, maintaining, improving existing data solutions, coding new ETL interfaces, and developing and maintaining data visualizations.

This position requires initiative, independence, drive, and the ability to work successfully in a fast-paced, dynamic environment with the ability to perform a wide variety of responsibilities. Strong communication skills are an asset that will be helpful while working closely with various teams across the institute.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or relevant field.

• Three (3) plus years of data integration and development experience.

• Experience and /or training in SQL, Stored Procedures, SAS Data Integration Studio, SAS Data Management Studio, SAS Enterprise Guide, data warehousing, SQL Server/Oracle management.

• Experience in data modeling.

Job Specific Qualifications

• Expertise in developing legible and well-structured scripts and queries in SQL .

• Experience working with large data repositories and/or relational databases.

• Experience as an ETL developer with strong data architecture knowledge around data warehousing concepts, SQL development and optimization, and operational support models.

• Knowledge of SAS tools would be a plus.

• Strong aptitude to learn and adapt to technology.

• Ability to work on multiple projects simultaneously with minimal supervision.

• Highly self-motivated and directed with keen attention to detail.

• Candidates must possess excellent written and verbal communication skills.

• Positive customer-service mindset.

• Ability to work collaboratively in dynamic team environment.

• Preference given to those with a military service connection, or who have worked with veteran, military, and/or family stakeholders, universities or think-tanks, and familiarity with related government programs and services for veterans, families, and related civilian human services programs.

Responsibilities

• Thoroughly understand and support existing infrastructure of data/databases.

• Translate business needs, processes, and requirements into optimized data solutions.

• Use suite of SAS tools, programming best practices, and departmental standards to design and develop integration solutions.

• Monitor performance of existing data jobs and address issues to ensure scalability.

• Monitor routine data loads and ensure they are successful.

• Investigate data quality issues and implement appropriate solutions.

• Design solutions to be optimal for reporting, analytics, and dashboards.

• Gather requirements for data design, storage, and management.

• Manage the technical documentation for all code, data definitions, dashboards, and data management applications.

• Manage individual priorities and coordinates with other teams to meet timelines.

• Assist in ongoing development of technical best practices for data integration, data quality, data cleansing and other ETL related activities.

• Provide support to production systems.

• Maintain status and resolution updates per team standard or as requested.

• Maintain proficiency in current data warehouse development platforms, languages, and integration method.

• Research new developments in data warehouse technology. Work with Data Solutions team to possibly implement and leverage the new and changing technology.

• Provide Institute-wide support and training to users of the self-service tools.

• Guide temporary staff and students in their support to the IVMF as they learn our tools and processes.

Physical Requirements

Not Applicable

Tools/Equipment

Not Applicable

Application Instructions

In addition to completing an online application, please attach a resume and cover letter.

About Syracuse University

Syracuse University is a private, international research university with distinctive academics, diversely unique offerings and an undeniable spirit. Located in the geographic heart of New York State, with a global footprint, and nearly 150 years of history, Syracuse University offers a quintessential college experience.

The scope of Syracuse University is a testament to its strengths: a pioneering history dating back to 1870; a choice of more than 200 majors and 100 minors offered through 13 schools and colleges; nearly 15,000 undergraduates and 5,000 graduate students; more than a quarter of a million alumni in 160 countries; and a student population from all 50 U.S. states and 123 countries. For more information, please visit www.syracuse.edu.

About the Syracuse area

Syracuse is a medium-sized city situated in the geographic center of New York State approximately 250 miles northwest of New York City. The metro-area population totals approximately 500,000. The area offers a low cost of living and provides many social, cultural, and recreational options, including parks, museums, festivals, professional regional theater, and premier shopping venues. Syracuse and Central New York present a wide range of seasonal recreation and attractions ranging from water skiing and snow skiing, hiking in the Adirondacks, touring the historic sites, visiting wineries along the Finger Lakes, and biking on trails along the Erie Canal.

EEOC

Syracuse University is an equal-opportunity, affirmative-action institution. The University prohibits discrimination and harassment based on race, color, creed, religion, sex, gender, national origin, citizenship, ethnicity, marital status, age, disability, sexual orientation, gender identity and gender expression, veteran status, or any other status protected by applicable law to the extent prohibited by law. This nondiscrimination policy covers admissions, employment, and access to and treatment in University programs, services, and activities.

Commitment to Supporting and Hiring Veterans

Syracuse University has a long history of engaging veterans and the military-connected community through its educational programs, community outreach, and employment programs. After World War II, Syracuse University welcomed more than 10,000 returning veterans to our campus, and those veterans literally transformed Syracuse University into the national research institution it is today. The University’s contemporary commitment to veterans builds on this historical legacy, and extends to both class-leading initiatives focused on making an SU degree accessible and affordable to the post-9/11 generation of veterans, and also programs designed to position Syracuse University as the employer of choice for military veterans, members of the Guard and Reserve, and military family members.

Commitment to a Diverse and Inclusive Campus Community

Syracuse University maintains an inclusive learning environment in which students, faculty, administrators, staff, curriculum, social activities, governance, and all other aspects of campus life reflect a diverse, multi-cultural, and international worldview. The University community recognizes and values the many similarities and differences among individuals and groups. At Syracuse, we are committed to preparing students to understand, live among, appreciate, and work in an inherently diverse country and world made up of people with different ethnic and racial backgrounds, military backgrounds, religious beliefs, socio-economic status, cultural traditions, abilities, sexual orientations and gender identities. To do so, we commit ourselves to promoting a community that celebrates and models the principles of diversity and inclusivity.

Quick Link http://www.sujobopps.com/postings/85085 Job Posting Date 09/30/2020 Application Deadline Full Consideration By Job Category Staff Message to Applicants

Similar jobs

Similar jobs