Job Details

This ad is expired.

Data Warehouse / Business Intelligence (BI) Developer
Go to our website »

Position Number: 5091429
Location: Syracuse, NY
Position Type: Computer and Information Technology

Data Warehouse / Business Intelligence (BI) Developer

Job #: 039816
Location Syracuse, NY
Pay Range: $64,500 - $85,000
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

Job Description:
The D'Aniello Institute for Veterans and Military Families' (IVMF) research and analytics (R&A) team is seeking an experienced data warehouse / business intelligence developer (DW/BI) interested in joining our rapidly growing team. The DW/BI developer will work collaboratively with subject matter experts across the IVMF to provide enterprise-wide expertise in data management and analytics. This position would establish data management processes, develop data integrations, implement data access and security protocols, and develop dashboards and reports. The DW/BI developer will design, build, and develop data integration solutions. Responsibilities would 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.

This position is anticipated to be filled on a fully remote basis unless the identified candidate resides in the Syracuse / Central New York area. Not all geographical areas within the United States are eligible. Employment offers at Syracuse University are based on a combination of factors including, but not limited to, the job responsibilities; the candidate's education, training, work experience and key competencies; the university's strategic priorities; internal peer equity; applicable federal, state, local laws, grant funding and contractual requisites; and external market analyses.

Qualifications:

Bachelors 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, ETL software, SAS Programming, data warehousing, SQL Server/Oracle database 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 Visual Analytics or Tableau 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 sets and databases.
Translate business needs, processes, and requirements into optimized data solutions.
Use IVMF approved software, 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.
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 in their support to the IVMF as they learn our tools and processes.
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.
Other duties as assigned.

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.

Application Deadline:
Full Consideration By:
Open Until Filled:

To apply, visit https://www.sujobopps.com/postings/101159

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.

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 Universitys 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.

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.