Data Warehouse Administrator - NY, NJ, Or PA

Visions Federal Credit Union; Endwell (NY); Remote; USD 65,000 - 90,000; Full time

Job summary

A financial service provider is seeking a Data Warehouse Administrator to join their team in the United States. The role involves ensuring data quality and managing server processes. The ideal candidate will have a Bachelor's degree in a computer science discipline with a strong background in SQL Server Administration and ETL processes. This full-time position offers a competitive salary and generous benefits.

Benefits

Pension Plan

401k matching contributions

Excellent health benefits

Flexible Paid Time Off (PTO)

Tuition reimbursement

Student loan repayment

Employee recognition program

Qualifications

• 1-3 years of relevant experience expected; 4-6 years may be considered without a degree.
• Familiar with using code repositories.

Responsibilities

• Ensure server patching for vulnerabilities.
• Monitor nightly processing and report errors.
• Document Data Warehouse processes.
• Analyze end user needs for new and updated reports.
• Advocate for data quality in development projects.
• Participate in on-call rotation for the data warehouse.

Skills

SQL Server Administration

Data quality advocacy

T-SQL

SSIS

SSRS

Proficient in Microsoft Office

Education

Bachelor's degree in computer science or related discipline

Tools

Symitar PowerOn

Powershell

C#

VB.NET

Microsoft Azure

Job description

Description

About Us

We're in the business of people helping people and you can help us change lives just by working here. Whether it's helping a member make a transaction, buy their first home, or improve their financial wellness one step at a time - you have an impact on their lives just by working here, no matter what your position may be.

Work with us - and be part of something bigger than banking.

In exchange for your time and talents, we offer generous benefits. After all, you make us awesome, so we take care of you with things like...

• Pension Plan, 401k Plan, and 401k matching contributions


• Excellent health benefits


• Flexible Paid Time Off (PTO), Volunteer Time Off (VTO), and Wellness Time Off (WTO)


• More than ten paid holidays per year


• Wellness program


• Tuition reimbursement


• Student loan repayment


• Employee recognition program


• Educational incentives
  ...and more!

At Visions, we do, and will continue to, treat all of our employees fairly and with complete respect, regardless of race, ethnicity, gender, and any other differences. We strive to celebrate the diversity of our employees, as they are part of the fabric of this great credit union.

Title of Position: Data Warehouse Administrator - NY, NJ, Or PA

Position Type: Full-Time. Typical shifts include Monday through Friday 8:00AM to 5:00PM, with rotating on-call schedule for incidents outside of business hours.

Compensation Range: $65,000/Yr. - $90,000/Yr. *Hiring rates may be dependent on a number of factors, including years of directly related work experience, education, geographic location or special skills*

Location: Remote Opportunity available for NY, NJ, or PA residents ONLY.

At this time, Visions Federal Credit Union will not sponsor a new applicant for employment authorization or offer any immigration related support for this position (i.e., H1B, F-1 OPT, F-1 STEM OPT, F-1 CPT, J-1, TN, or another type of work authorization). If you need sponsorship now or in the future, look for this statement in the job description before you apply: Visions Federal Credit Union will consider sponsoring a new, qualified applicant for employment authorization for this position.
If this is not listed in the job description, Visions Federal Credit Union will not provide sponsorship for the candidate to work in the United States.

Responsibilities/Duties::

• Assist DBA to ensure server is patched for all vulnerabilities identified by IT Security, Monthly Health checks or personal review.


• Monitor nightly processing and report on/fix all errors.


• Work monthly Health check tickets as assigned.


• Document Data Warehouse processes.


• Analyze end user needs to determine if a new report is needed, or an existing report can be updated.


• Implement and update reports for business users, ensuring to update old reports to meet with current Data Warehouse Standards.


• Advocate for data quality and processing efficiency with all development projects.


• Assist the Data Warehouse architect with implementing enterprise projects or special requests from the IT Department.


• Manage several ETL processes and act as Subject matter expert on those processes, providing assistance and documentation, as well as programmatic support for updates and feature enhancements.


• Develop new administrative tools to help the DW Team monitor the DW servers for performance issues.


• Stay current with trends in data warehousing as well as work to grow knowledge and ability with T-SQL, SSIS, and SSRS development skills.


• Teach occasional training classes to IT Programming, Business Performance, and IT Operations as needed.


• Provide departmental back-up coverage as needed.


• Respond effectively to changing ideas, responsibilities, expectations, trends, strategies, and other processes.


• Demonstrate a commitment to diversity, equity, inclusion, and belonging through continuous development, modeling inclusive behaviors, and proactively managing bias.


• Perform other duties needed to help fulfil our mission, drive our strategy, and support our organization's values.


• Participate in the after hours on-call rotation for the data warehouse. Be capable of troubleshooting and resolving common issues when on call.

Minimum Qualifications & Experience:

• Bachelor's degree in computer science related discipline and 1-3 years of relevant experience is expected; 4- 6 years of relevant experience may be considered in lieu of a degree.


• Competence in SQL Server Administration and Database development using SSRS for reporting and SSIS for ETL packages, as well as familiar with using code repositories.


• Proficient in the Microsoft Office Suite programs.


• Proficient with standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines, PCs, etc.


• Visions remains committed to the aspects of diversity and inclusion and will consider alternative education and experience.

Preferred Qualifications & Experience:

• Proficiency in Symitar PowerOn programming, Powershell, C#, or VB.NET.


• Familiarity the Episys or similar financial core.


• Proficiency in query performance tuning.


• Microsoft Azure Cloud database platform.


• Experience in working with very large databases.

We're more than banking. You can be, too. #ClaimYourSeat

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

This employer is required to notify all applicants of their rights pursuant to federal employment laws.
For further information, please review the Know Your Rights notice from the Department of Labor.