Sr. Data Engineer (#Hybrid at our Chicago HQ near O'Hare Airport)

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

You will benefit from:

• Competitive medical, dental, and free vision benefits
• Paid parental leave
• Competitive compensation plan
• Gym memberships discounts
• Generous PTO and banking holidays off
• Tuition reimbursement
• 401k with immediate employer match and vesting

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.