Job Title

POSTED: March 2, 2020
BUSINESS: Purdue Federal Credit Union
POSITION TYPE: Full-time
START DATE: Immediate Availability

Position Summary:

The Data Engineer is responsible for the design, development, testing, and maintenance of data structures and reports.  This position also requires timely and thorough troubleshooting and documentation.

*Employees are expected to adhere to all rules and regulations applicable to this position, including but not limited to all policies and procedures pertaining to the Bank Secrecy Act.

Duties and Responsibilities (Essential Functions):

  • Data Access and Reporting
    • Develop and update reports as well as perform ad-hoc reporting for business units
    • Verify the accuracy of data contained in reports working with the business when needed to do so
    • Work with the development team in order to create or update data queries, views, etc. to capture, store, and present data as required
  • Data Structure and Database Design
    • Design and develop data models and schemas to improve accessibility, efficiency, and quality of data in order to support Credit Union initiatives
    • Design and develop solutions (e.g., ETL processes) for integrating data across multiple platforms
    • Create and maintain technical documentation for new and existing data solutions
  • Data Maintenance
    • Drive process improvement and data consolidation
    • Analyze and confirm the integrity of source data and when necessary facilitate data clean-up efforts
    • Monitor performance and manage parameters to provide appropriate response times to front-end users
  • Integrity and Security:
    • Install, configure, and test Microsoft SQL Server Services (Database Engine, Reporting Service, Integration Service)
    • Configure SQL Server monitoring and alerting
    • Control access permissions and privileges
    • Work with the infrastructure team to develop, manage, and test back-up and recovery plans
    • Ensure that storage and archiving procedures are functioning correctly
    • Ensure data remains consistent across various databases and is defined clearly
  • Work with management to prioritize tasks and technical issues during all phases of software development
  • Display a professional attitude in dealing with supervisors, coworkers, members, and others inside and outside the credit union

Knowledge, Skill, and Ability Requirements:

  • Bachelor’s degree in a technology related field and/or equivalent combination of education and experience
  • 5 to 6 years of proven experience in database management, SSRS, SSIS, Business Intelligence, and Business Analysis preferred
  • Knowledge and expertise with T-SQL
  • Must be able to design complex data structures with data flow to and from multiple sources and destinations.
  • Advanced Report creation abilities, taking data from multiple sources, joining the appropriate pieces of data and providing relevant reporting data from complex sources.
  • Experience with Microsoft SSRS and Power BI reporting tools
  • Strong problem solving and analytical skills to evaluate, understand, and interpret data in ways that end users can understand and digest
  • Experience with SQL Database Management
  • Ability to communicate, verbally and in writing, in a professional manner when dealing with employees, members, vendors and company contacts
  • Ability to follow the core values of honesty, integrity, mutual respect, pride and ownership

Work Environment/Physical Demands:

  • This job operates in a clerical office setting.  This role routinely uses standard office equipment such as computers, phone, photocopiers, filing cabinets and fax machines
  • This position requires manual dexterity, the ability to lift files and open filing cabinets
  • This position requires sitting, bending, stooping or standing as necessary

Benefits:

Purdue Federal offers competitive wages including an advancement program, excellent benefits, training and development opportunities, and employee appreciation.

It is the policy of Purdue Federal Credit Union not to discriminate against any employee or applicant for employment because of race, color, religion, age, sex, national origin, disability, marital status, genetic information, sexual preference, ancestry, student status, veteran status or arrest and conviction records or any other protected class not directly relevant to employment.

Application Instructions:

For further details or if you are interested in joining one of the “Best Places to Work in Indiana” where Honesty, Integrity, Mutual Respect, and Pride & Ownership are the core values, please complete our online application:  https://purduefedcareers.silkroad.com/

 

 

  • Job Listings

Kurz Purdue Technology Center, 1281 Win Hentschel Blvd., West Lafayette, IN 47906, 765-588-3470

© 2020 Purdue Research Foundation | Maintained by Purdue Research Foundation

Trouble with this page? Please contact Purdue Research Foundation by Phone, 765-588-3470, or FAX, 765-463-3501.