Data Engineer I
Job Description
Redstone Federal Credit Union is seeking a Data Engineer I to help design, build, and improve the organization’s data architecture. In this remote role, you will focus on data warehouse capabilities, reliable pipeline and ETL/ELT infrastructure, and the data practices that keep analytics and data products dependable.
You will collaborate with data scientists, data analysts, and software engineers to assemble and refine large datasets, support data models, and contribute to metadata management, data quality, and disaster recovery planning. The position also includes ongoing training and compliance responsibilities to ensure your work aligns with applicable requirements.
What you’ll do
- Build, maintain, and continuously improve the enterprise data warehouse.
- Monitor and improve data warehouse performance, implement patches and upgrades, minimize database downtime, and manage parameters to support fast query responses.
- Collaborate with data analysts, 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 datasets that meet functional and non-functional business requirements.
- Assist with establishing data quality standards and implementing processes and tools to assess and improve data accuracy, completeness, reliability, relevance, and timeliness.
- Assist with developing and implementing disaster recovery plans and processes to protect the integrity and availability of enterprise databases and data pipelines.
- Complete required training programs to maintain current knowledge applicable to assigned duties, including regulatory compliance requirements.
Required experience and skills
- At least 2 years of relevant experience.
- ETL/ELT experience with tools such as SSIS.
- Experience profiling data, with and without data definition documentation.
- Experience with data modeling, especially dimensional modeling.
- Ability to learn and apply information across a range of Credit Union products, services, and regulatory compliance requirements to assess member situations and support solutions.
- Professional communication skills, including clear information delivery and active listening; use tact and diplomacy in sensitive or confidential situations.
- Ability to lead and model RISE values and the Code of Ethics through daily interactions and conduct.
- Ability to provide guidance in resolving complex problems using advanced knowledge and experience within areas of responsibility.
- Strong analytical aptitude and a driving curiosity to identify, formulate, and solve problems.
- Use correct English, including spelling, grammar, and punctuation; understand and follow written and oral instructions.
- Strong time management skills and the ability to set priorities effectively.
Technologies
- SQL, Python, C#, Linux/Unix, bash
- Postgres, Oracle, SQLServer, Redshift
- Snowflake, Incorta, SSIS
Company-wide expectations
- Maintain a professional image and demeanor, consistently demonstrating Credit Union RISE Values and adhering to the Code of Ethics.
- Deliver friendly, caring service to internal and external members.
- Comply with all applicable State, Federal, and NCUA rules and regulations, plus all Credit Union policies and procedures.
- Follow physical and online security procedures and maintain strict confidentiality of member information.
- Complete required regulatory and compliance training and maintain required knowledge of Credit Union products and services.
- Work scheduled hours and maintain punctuality.
- Perform other related duties as assigned or requested.
Location: Remote (remote). Education: 4 Year / Bachelors Degree - Computer Science, Statistics, Informatics, Information Technology or another quantitative field (as listed). Work environment: Typical technology office environment; remote work environment considered. Physical demands: Intermittent standing, sitting, walking, bending, and climbing; repetitive hand use to handle or operate computers and standard office equipment; reaching with hands and arms; intermittent lifting and carrying up to 25 pounds.