Data Engineer I

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.

Job Description

Essential Duties and 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.

Company Wide Expectations

• 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.

EDUCATION/EXPERIENCE

To perform this job satisfactorily, an employee must be able to carry out each essential duty competently. The requirements listed below are representative of the education, experience, skills and abilities required. An equivalent combination of education and experience may be considered.

Education Requirements

4 Year / Bachelors Degree - Computer Science, Statistics, Informatics, Information Technology or another quantitative field - Required

Experience Requirement

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

SKILLS/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, 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.

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.

Physical Requirements

• 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.