Data Engineer I

Redstone Federal Credit Union; United States; Remote; USD 110,000 - 150,000; Full time

Job summary

Redstone Federal Credit Union seeks an experienced data engineer to design, build and optimize our data architecture, pipelines and data warehouse. You will work with data scientists to deploy data products that reveal insights and guide action, while exploring new tools and practices.

The role emphasizes improving performance, data quality, and metadata management, with a focus on scalable ETL/ELT across varied data sources and strong collaboration across teams.

Qualifications

• 4 Year / Bachelor's degree in a quantitative field is required.
• 2 years of responsible experience in data engineering, database administration, or data science.
• Experience with relational databases (Postgres, Oracle, SQLServer) is required.
• Experience with data warehouses (Redshift, Snowflake, Incorta) is required.
• Proficiency in SQL, Python, C# and Linux/Unix; scripting (bash) and file management are required.

Responsibilities

• Build, maintain and improve the enterprise data warehouse.
• Monitor performance, apply patches, upgrades and minimize downtime for fast queries.
• Collaborate with analysts, data scientists and engineers to refine data models.
• Establish and improve metadata management tools and processes.
• Oversee ETL/ELT infrastructure from diverse data sources.
• Create and maintain optimal data pipeline architecture.
• Assemble large, complex data sets meeting business needs.
• Help ensure data quality, accuracy, completeness and timeliness.
• Contribute to disaster recovery plans to protect data and pipelines.
• Complete required training to stay compliant with regulations.

Skills

SQL

Python

C#

Data modeling

ETL/ELT

Linux/Unix

Analytical thinking

Problem solving

Communication

Team collaboration

Education

Bachelor's degree in Computer Science, Statistics, Informatics, Information Technology or other quantitative field

Tools

Postgres

Oracle

SQLServer

Redshift

Snowflake

Incorta

SSIS

Job description

Overview

Job Description Summary: Responsible for creating, managing and continuously improving our data architecture, pipelines, and data warehouse. Collaborates with data scientists to create and deploy data products that identify insights, predict behavior and prescribe action. The ideal candidate is an experienced data pipeline builder, data wrangler, who enjoys both building new and optimizing, who is excited about exploring new tools and practices, and enjoys contributing in many ways to a data team with fluid and flexible roles.

Responsibilities

• Build, maintain and improve the enterprise data warehouse.
• Monitor and 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.
• Assist 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.
• Assist with establishing data quality standards and implement processes and tools to assess and improve data accuracy, completeness, reliability, relevance and timeliness.
• Assist with development and implementation of disaster recovery plans and processes to protect the integrity and availability of enterprise databases and data pipelines.
• Complete all required training programs to maintain current knowledge applicable to assigned duties and responsibilities, including regulatory compliance requirements.

Qualifications

• Education
• 4 Year / Bachelors Degree in Computer Science, Statistics, Informatics, Information Technology or another quantitative field - Required
• Experience
• 2 Years of 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

Skills and Abilities

• Effectively apply internal/external customer service practices and processes to meet quality service standards and achieve member satisfaction.
• 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
• Learn and apply information, on a wide range of Credit Union products, services and regulatory compliance requirements, 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.

Physical Demands

The physical demands described here are representative of those that must be met by employees to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Intermittent standing, sitting, walking, bending and climbing. Using hands repetitively to handle, feel or operate computers and other standard office equipment. Reaching with hands and arms. Intermittent lifting and carrying up to 25 pounds.

Work Environment

An employee in this job will experience the following main work environments, others not listed may also be encountered on occasion; Works in a typical technology office environment. Remote work environment considered.

Redstone Federal Credit Union is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran status or status as an individual with disability. All qualified applicants will not be discriminated against on the basis of disability.

We are proud to be a Drug-Free and Tobacco Free Workplace. Redstone Federal Credit Union has been serving the communities of North Alabama and middle Tennessee since 1951. We’re a strong, stable, and growing organization looking for ambitious individuals who can collaborate effectively on a team, yet still thrive on their own. You’ll be helping us change our communities by supporting our mission – improving the financial well-being of our members and communities by offering trusted advice, choices, opportunities, and solutions – and ultimately giving members a better experience. Discover a unique opportunity to join an innovative and rapidly growing company today!