Data Engineer I
Job Type : Full-Time
Exemption Type : Exempt
Wage Amount : $86,488 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 sourcesMaintains a thorough understanding of the data systems used by the organization, including systems operated internally, hosted systems, and third-party systemsMaintains a thorough understanding of the relationships and dependencies between the data in these various systemsWorks 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 goalsWorks at the direction of management to make recommendations to assist with strategic planning, and improving performance, production, and employee and member experienceMiscellaneous
Schedule and conduct individual dialogs with direct manager monthlyParticipate in outside credit union-sponsored activities and community / education events to increase credit union awarenessAttain and maintain working knowledge of all A+ products and servicesMaintain member confidentialityPerform other duties as required or assignedEducation and Experience
Bachelor's 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 pipelinesKnowledge, Skills & Abilities
In-depth knowledge of Databricks, Snowflake, or other cloud-based data platformsStrong skills in SQL programming and databasesFirm understanding of software development and the software development life cycle (SDLC)Familiarity with Python or R for data analysisFamiliarity with machine learning, data mining, and artificial intelligenceStrong math and analytical skillsStrong verbal and written communication skillsProblem-solving and research abilitiesStrong working knowledge of MS OfficeInnovative and creative abilitiesDetail-orientedAbility to take initiative while remaining open to ideas of othersAbility to prioritize projects based on needPossess decision-making abilitiesSelf-motivated individual with strong time management and organizational skillsStrong cross-functional collaboration skills and relationship-building skillsStrong sense of personal responsibility and accountability for delivering high-quality workPhysical Functions
Must have the ability / stamina to work at least 40 hours a weekWill frequently reach, feel, bend, stoop, carry, finely manipulate, and key in dataMust be able to communicate through telephone, email, and in-personMust be able to engage in problem-solving skills to help identify and solve potential issues in the fieldTypes of Decisions Requiring Supervisory Approval
Situations outside A+FCU policies and procedures