Data Engineer I
Primary Functions
Job Type: Full-Time
Exemption Type: Exempt
Wage Amount: $86488 yearly minimum
The Data Engineer is responsible for gathering data from multiple internal databases and systems as well as information from third-party data sources and reviewing data for quality assurance quality control completeness and correctness. The Data Engineer plays a critical role in designing and building the foundational data infrastructure components that empower the A product teams with business-critical metrics.
The Data Engineer develops systems and tools for ingesting and processing data from diverse data sources to enable seamless data publication and subscription and to support self-service analytics for business metrics reporting. The Data Engineer participates in the automation of data governance processes data quality monitoring and supports data needs for AI/ML capabilities.
The Data Engineer works with management and team members in using data science methods to build predictive models to help with decision-making and to help in targeting actionable data that can be used to reduce risk increase financial opportunities make better use of time spent by employees and improve member service member satisfaction and member experience.
The Data Engineer works with employees management department representatives and programmers from across the organization to improve data governance and to help move the organization toward a more strategic use of data to meet organizational goals.
Programming and Data Science
- Uses SQL programming to work with relational databases such as Microsoft Access Microsoft SQL SQLite PostgreSQL or others to extract analyze summarize and validate data
- Uses data visualization tools such as Excel Power BI Tableau or others to analyze and summarize data in order to help others understand data characteristics patterns and trends and to provide high-level representations of data to inform decision-making
- Uses programming tools such as Python R Java C C or others to extract analyze summarize and validate data
- Reviews data for quality assurance quality control completeness and correctness including verifying that data for any specific field is present is the appropriate data type is within an expected value range and is consistent with any metadata available
- Performs data extracts data formatting application of business rules to data and other functions necessary to provide data for internal reporting dashboards and exchange with third-party providers
- Works with management and team members to perform data analysis to gain a better understanding of the data and to identify trends or patterns in the data including the use of statistical methods or concepts such as regression fit analysis probability distributions and correlation
- Works with management and team members in using data science methods primarily clustering and classification to build predictive models to help with decision-making and to help in targeting actionable data that can be used to reduce risk increase financial opportunities make better use of time spent by employees and improve member service member satisfaction and member experience
Organizational Support
- Gathers data from multiple internal databases and systems as well as information from third-party data sources
- Maintains a thorough understanding of the data systems used by the organization including systems operated internally hosted systems and third-party systems
- Maintains a thorough understanding of the relationships and dependencies between the data in these various systems
- Works with employees management department representatives and other data analysts from across the organization to improve data governance and to help move the organization toward a more strategic use of data to meet organizational goals
- Works at the direction of management to make recommendations to assist with strategic planning and improving performance production and employee and member experience
Miscellaneous
- Schedule and conduct individual dialogs with direct manager monthly
- Participate in outside credit union-sponsored activities and community/education events to increase credit union awareness
- Attain and maintain working knowledge of all A products and services
- Maintain member confidentiality
- Perform other duties as required or assigned
Education and Experience
- Bachelors degree required (in computer science or other data-related field highly preferred)
- Three years of hands-on Data Engineering experience building data models data warehouses and ETL pipelines
Knowledge Skills & Abilities
- In-depth knowledge of Databricks Snowflake or other cloud-based data platforms
- Strong skills in SQL programming and databases
- Firm understanding of software development and the software development life cycle (SDLC)
- Familiarity with Python or R for data analysis
- Familiarity with machine learning data mining and artificial intelligence
- Strong math and analytical skills
- Strong verbal and written communication skills
- Problem-solving and research abilities
- Strong working knowledge of MS Office
- Innovative and creative abilities
- Detail-oriented
- Ability to take initiative while remaining open to ideas of others
- Ability to prioritize projects based on need
- Possess decision-making abilities
- Self-motivated individual with strong time management and organizational skills
- Strong cross-functional collaboration skills and relationship-building skills
- Strong sense of personal responsibility and accountability for delivering high-quality work
Physical Functions
- Must have the ability/stamina to work at least 40 hours a week
- Will frequently reach feel bend stoop carry finely manipulate and key in data
- Must be able to communicate through telephone email and in-person
- Must be able to engage in problem-solving skills to help identify and solve potential issues in the field
Types of Decisions Requiring Supervisory Approval
- Situations outside AFCU policies and procedures