Data Engineer I

Redstone Federal Credit Union is seeking a Data Engineer I to create, manage, and improve their data architecture and pipelines. The role involves collaborating with data scientists to deploy data products and ensuring the integrity and performance of the data warehouse.

Responsibilities:

• Build, maintain and improve the enterprise data warehouse. Monitor & improve performance, implement patches and upgrades, minimize database downtime and manage parameters to provide fast query responses
• Collaborate with data analysts and data scientists and software engineers to build, maintain and improve data models
• Assists with establishing, maintaining and improving metadata management tools and processes
• Build, maintain and improve the infrastructure required for optimal ETL/ELT from a wide variety of data sources
• Create and maintain optimal data pipeline architecture
• Assemble large, complex data sets that meet functional and non-functional business requirements
• Assists with establishing data quality standards and implement processes and tools to assess and improve data accuracy, completeness, reliability, relevance and timeliness
• Assists with development and implementation of disaster recovery plans and processes to protect the integrity and availability of enterprise databases and data pipelines
• Completes all required training programs to maintain a current knowledge applicable to assigned duties and responsibilities, including regulatory compliance requirements
• Maintains a professional image and demeanor at all times, consistently demonstrating Credit Union RISE Values and adhering to the Code of Ethics
• Delivers friendly, caring service to internal and external members
• Complies with all applicable State, Federal and NCUA rules and regulations and all Credit Union policies and procedures
• Follow all physical and online security procedures and maintain strict confidentiality of all member information
• Completes all required regulatory and compliance training and maintains required knowledge of Credit Union products and services
• Works scheduled hours and maintains punctuality
• Performs other related duties as assigned or requested

Requirements:

• 4 Year / Bachelors Degree - Computer Science, Statistics, Informatics, Information Technology or another quantitative field - Required
• 2 Years - Responsible experience in a data engineering, database administration, or data science role - Required
• Experience with the administration and use of relational databases (e.g. Postgres, Oracle, SQLServer) - Required
• Experience with administration and use of data warehouses (e.g. Redshift, Snowflake, Incorta) - Required
• Experience with core programming languages (e.g. SQL, Python, C#) and with Linux/Unix commands, scripting (bash) and file management - Required
• Effectively apply internal/external customer service practices and processes to meet quality service standards and achieve member satisfaction
• Learn and apply information, on a wide range of Credit Union products, services and regulatory compliance requirements, in order to assess member situations and develop solutions
• Communicate in a professional manner and deliver information clearly and effectively. Actively listen to questions, opinions and ideas of others. Use tact and diplomacy in sensitive and confidential situations
• Lead and model RISE values and Code of Ethics through daily interactions and conduct
• Provide guidance in the resolution of complex problems utilizing advanced knowledge and experience within areas of responsibility
• Use correct English including spelling, grammar and punctuation
• Understand and follow written and oral instructions
• Strong analytical aptitude with a driving curiosity to identify, formulate, and solve problems
• Set priorities and manage one's own time effectively
• Experience with ETL/ELT tools (e.g. SSIS)
• Experience with profiling data, with and without data definition documentation
• Experience with data modeling, especially dimensional modeling