Data Warehouse Administrator - American Heritage Credit Union
Philadelphia, PA
About the Job
American Heritage Credit Union, a $4.6+ billion credit union, has an immediate opening for a Data Warehouse Administrator. This position will implement the Advanced Reporting for Credit Unions (ARCU) data warehouse and manage the operation of the system. Take and handle new requests from the end user community for new queries and reports. Add additional data sets to the system for end user consumption. Complete special research projects to allow for targeted data gathering.
RESPONSIBILITIES INCLUDE:
- Develop new report queries for end user consumption. This process will encompass gathering requirements, developing the new queries and obtaining approval from an oversight board prior to release to the end user community.
- Develop graphical interfaces for end user consumption, including but not limited to Microsoft's Power BI (business intelligence) visualization software.
- Implement new data sets to be incorporated into the ARCU system.
- Handle assignments for special research projects for management, which is subject to the same vetting as normal requests. Special projects will encompass one-off and strategic data gathering.
- Work with end users to improve and enhance the ARCU system for end users to obtain additional research capabilities.
- Perform integration from ARCU into other systems as required.
- Perform database maintenance of the structured query language (SQL) system and generalized cleanup of data to maximize efficiencies.
- Responsible for management of the Help Desk ticketing system.
QUALIFICATIONS:
- Three years to five years of similar or related experience
- A two-year college degree or (2) Completion of a specialized course of study at a business or trade school or (3) Completion of a specialized and extensive in-house training or apprenticeship program.
- Must have detailed understanding of SQL and data base structure.
- Experience with data visualization software such as Power BI or similar required.
- Extensive knowledge of end user testing and acceptance testing required.
- Must have working knowledge of database administration for tuning and maintenance of the databases.
- Professional, well-developed interpersonal skills essential for servicing Credit Union members, staff and clients and projecting a positive image as representative for the Credit Union.
Our commitment to your success is enhanced by our competitive salary commensurate with experience and an extensive benefits package including paid time off, health benefits, 401(k) with a generous company match, and future growth opportunities within the company. We work to maintain the best possible professional and environmentally friendly atmosphere for our employees.
To be considered, correspondence should include a resume listing job history and salary expectations. Please be advised that credit, criminal, employment, drug/alcohol testing and education background checks are conducted on potential candidates. All resumes will be reviewed, but only competitive candidates will be contacted for further conversation.