Empeople Credit Union

Data Engineer

• Support the Credit Union and Data & Analytics teams with efficient, dynamic, and automated data solutions
• Design, create, and maintain frameworks for importing and transforming data into tables for analysts' strategic insights
• Create, schedule, and trigger data pipelines, ETL processes, and automated validation/alerting
• Use AI LLM models to research, create, and maintain ETL data routines when possible
• Build, maintain, and document data solution frameworks, including API connections, database tables, and CSV extracts flowing into the data warehouse
• Use Snowflake tools including Snowpipe, SnowSQL, Openflow, Native SDK for Connectors, and CLI
• Use Microsoft Azure Data Factory for connecting to network sources and evaluate other tools
• Partner with business users, programming and technology teams, data analysts, and project management teams to define requirements and implement solutions within an agile framework
• Create and maintain automated ETL frameworks within Snowflake and other ETL tools based on business transformation rules
• Use version control functions within ETL tools to manage and track data automation revisions
• Maintain data warehouse configuration documentation with business partners
• Use Azure Data Factory, Snowflake, and Python to create data automations and reports
• Use Python programs for custom data transformations
• Validate and cleanse data and implement alert automations using predefined quality assurance checks
• Optimize on-time delivery of data for analysts and custom extracts to third-party systems
• Diagnose and troubleshoot data-related issues
• Support all areas of the credit union and perform other assigned duties
• Identify new process improvement opportunities