Data Engineer I

Job Description SummaryResponsible 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 DescriptionEssential 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/EXPERIENCETo 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 Requirements4 Year / Bachelors Degree - Computer Science, Statistics, Informatics, Information Technology or another quantitative field - RequiredExperience Requirement2 Years - Responsible experience in a data engineering, database administration, or data science role - RequiredExperience with the administration and use of relational databases (e.g. Postgres, Oracle, SQLServer) - RequiredExperience with administration and use of data warehouses (e.g. Redshift, Snowflake, Incorta) - RequiredExperience with core programming languages (e.g. SQL, Python, C#) and with Linux/Unix commands, scripting (bash) and file management - RequiredSKILLS/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 DEMANDSThe 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, si