The Data Engineer assists the organization through the continued build-up and operationalization of an enterprise - class Modern Data environment, including various components within the Azure data system. Resources to do the job require substantial hands-on experience working with the technologies encompassed SQL server, Informatica, and Azure data lake house technology stack.
The Data Engineer coordinates, designs, builds, and integrates complex application technology solutions, aligned to architectural standards and definitions, and will help ensure IT services are delivered effectively and efficiently. General direction is received from the Sr. Manager.
Responsibilities
- Responsible for day-to-day operation and support of SQL data warehouse, Informatica, Azure data lake and Modern Data environments
- Influence adoption of Modern Data new concepts, practices, and approaches
- Build the infrastructure as code required for data platform
- Responsible for extraction, transformation, and loading of data from a wide variety of data sources using SQL , Informatica and Azure technologies
- Develops databases, objects, functions and structures for data storage, retrieval, and reporting
- Designs and develops Extract, Transform and Load (ETL) solutions to populate the data warehouse
- Develops automated and reusable routines for extracting requested information from database systems and/or enterprise management system
- Defines, develops, tests, analyzes, and maintains software applications and back-end interfaces (if applicable) in support of business objectives
- Builds report and analytic prototypes based on initial business requirements.
- Build analytics tools that utilize the data pipeline to provide actionable insights, operational efficiency, and other key business performance metric
- Collaborate with development and strategy teams on component and 3rd party tool identification, recommendation, installation and management of azure services
- Collaborate with the data architecture and Infrastructure teams in technical investigations, development, and prototypes
- Promote strong quality practices by performing unit testing and providing appropriate level of support for user acceptance testing, as needed
- Act as a support resource for the technical support that platform-reported issues are being addressed in an efficient and accurate manner. Serve as a liaison with database administrators, developers, and vendors (if needed) to assist in resolving problems with systems
- Maintain and test the data warehouse in compliance with the company's standard guidelines
- Participate in the design and implementation of a Disaster Recovery strategy for all Modern Data components
- Participate in design, implementation and management of alignment activities with all pertinent audit and compliance activities
- Provide input/develop new processes/standards in support of the organization's business/functional short-term strategies, with limited impact on the business/function overall results
Education:
- Bachelors Degree - Computer Science or related
Years of Experience:
- Proven development and operational experience within data warehousing system
- High proficiency in SQL, data integration toolsets,
- Experience with the entire Software Development Lifecycle (SDLC) process such as change management, defect and issue tracking, to resolve data issues or to implement development enhancements
- Familiarity with Data Science notebooks such Databricks , python
- Familiarity with reusable components in Power Center ( for example, mapplet, worklet etc. )
- Have experience working with PowerShell, UNIX scripting in informatica Power Center and other tools
- Ability to leverage strategic and tactical thinking
- Experience using Informatica PowerCenter 10.X (Designer, Workflow Manager, Repository Manager)
In Leiu of Education:
- 6 years - relevant experience
Compensation & Benefits:
Typical hiring range: $113,000 - $159,550 Annually. Actual compensation will be determined using factors such as experience, skills & knowledge.
Additional Compensation: Annual performance bonus
Benefits: Alliant provides a benefits package including health care, vision, dental, and 401k with employer match.
Additional Benefits:
- Work from home up to 3 days a week
- Paid parental leave
- Employee discount programs
- Time off including paid personal and sick days
- 11 paid holidays
- Education reimbursement
*Note that eligibility and cost of benefits can vary depending on the number of regularly scheduled hours, and job status such as regular full-time, regular part-time, or temporary employment.
Adhere to and ensure compliance of all business transactions with policy and process of the Bank Secrecy Act. Ensures compliance with all applicable state and federal laws, company procedures and policies. Maintains integrity and ethics in all actions and conversations with or regarding credit union members and their accounts; complies with Privacy Act directives.
The responsibilities listed do not contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this position. Duties, responsibilities and activities may change at any time with or without notice.
