Schedule: Monday - Friday 8-5 (40 hours) Hybrid Eligible

Summary/Objective:

The Senior Data Engineer plays a critical role in the design and implementation of Enterprise Data Management (EDM) Solutions at DCU. They are responsible for setting development standards and best practices, and may be required to assist with requirements gathering/analysis, development, testing, documentation, and deployment tasks. This is a business-facing role that will work independently and collaboratively with internal and 3rd party teams, including off-shore teams, to ensure project success. The Senior DE should have practical experience developing EDM solutions, strong working knowledge of the technologies listed below, and an eagerness/ability to learn and train on new technologies. They will have the opportunity to engage with various groups utilizing all aspects of a Data Management organization including Data Governance, Data Quality, MDM, and Business Intelligence. They will also be working closely with Data Architecture, Quality Assurance, DevOps and Project Management professionals.

Essential Functions:

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• As a Senior Data Engineer, you will help lead a team responsible for designing, developing, optimizing, and maintaining the Extract, Transform, and Load (ETL) processes for data used in operational and analytical applications
• Breakdown of duties are estimated at 70% of your time performing Analysis and Development related tasks and 30% Communicating, Planning, and Mentoring
• Provide analysis and recommendations to overall data strategies and roadmaps
• Assembling large, complex sets of data that meet non-functional and functional business requirements
• Partners with Solution Architects to perform source system analysis, identification of key data issues, data profiling and development of normalized and star-snowflake physical schemas
• Leads engineering teams and guides members in best practices for data movement, data quality, master data management (MDM), data masking, data sub-setting and/or data virtualization development (collectively referred to as data integration and data management activities)
• Drives the technical design, installation & configuration, development, optimization, error handling and support of data management initiatives
• Identifying, designing, and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes
• Building required infrastructure for optimal extraction, transformation and loading of data from various data sources using various technologies
• Collaborates with the business to understand and interpret data through stakeholder interviews and by defining, analyzing, and validating data
• Creates and implements scheduling and automation strategies for data management processes
• Develops and executes test cases/plans to ensure high-quality releases, based on test driven development using industry best practices such as Gherkin
• Perform feasibility analysis, scoping exercises, and works with the project manager to prioritize deliverables
• Provides appropriate training, mentoring and support for developers and junior data engineers
• Collaboratively drafts detailed documentation (Designs, Test Plans, Data Flows, etc.) per standards

Perform other job-related duties as assigned by Managers(s).

Other Duties:

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.

Job Competencies:

• Monitors and checks work to meet quality standards; demonstrates a high level of care and thoroughness; checks work to ensure completeness and accuracy.
• Able to learn and properly apply new job-related information in a timely manner. Has the ability to absorb and comprehend job-related information and formal training and other formal and informal learning experiences.
• Takes initiative without being asked or required to; achieves goals beyond job requirements; is proactive and takes prompt action to accomplish objectives.
• Ability to think analytically, act independently and collaboratively, and adapt to rapidly changing requirements with a flexible and creative approach to troubleshooting and problem solving.
• Builds constructive working relationships with clients/customers, other work units, community organizations and others to meet mutual goals and objectives. Behaves professionally and supportively when working with individuals from a variety of ethnic, social, and educational backgrounds.
• Is committed to developing professionally, attends professional conferences, focuses on best practices, values cutting-edge practices and approaches; takes advantage of a variety of learning activities, implements and shares newly gained knowledge and skills on the job
• Clearly conveys and receives information and ideas through a variety of media to individuals or groups in a manner that engages the listener, helps them understand and retain the message, and invites response and feedback. Keeps others informed as appropriate. Demonstrates good written, oral, and listening skills

Education and Experience Requirements:

• Bachelor's Degree in Information Systems, Computer Science, or related field
• Minimum of 4-6 years in as a Data Engineer
• Minimum of 1 years of experience in Financial Services preferably Banking
• Practical experience in Data Integration, MDM, Data Modeling, and Quality Assurance
• Highly proficient in writing complex SQL statements and interpreting results for accuracy and performance
• Documented Experience in ETL design and development using tools like SnapLogic, PowerCenter, Glue, or SSIS
• Experience in Data Integration, MDM, Business and Data Analysis and Modeling
• Experience with AWS Redshift and S3 (preferred) or other modern cloud-based data platforms such as Azure, GCP, Snowflake… etc.
• Practical development experience in optimization and performance tuning of ETL workloads and understanding of database internals

Additional Eligibility Requirements:

• Knowledge of data management industry (DW, BI, BD, Cloud, MDM, DG, DQ, Data Modeling)
• Hands-on in programming language such as Python (preferred), Java, or Scala
• Experience in Linux shell scripting
• Experience with CI/CD and version control frameworks such as Gitlab or Git preferred
• Working knowledge of Agile Methodology
• Out-of-box thinking, and team player approach with a passion for solving complex problems
• Able to work in fast pace continuously evolving environment and ready to take on uphill challenges

Supervisory Responsibility:

This position has no supervisory responsibilities

Work Environment:

This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopier/scanner, filing cabinets, and fax machines.

Physical Demands:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. This is a largely sedentary role. While performing the duties of this job, the employee is regularly required to stand, talk, hear, and use hands and fingers to handle, feel or operate objects, tools or controls and to reach with hands and arms.

Travel:
No travel is expected for this position

Service Excellence: The DCU Way:
All employees are expected to provide service excellence the “DCU Way” through teamwork and by providing quality service to internal and external members, incorporating the Guiding Principles of DCU’s culture:

• People come first
• Do the right thing
• Make a difference

Bank Secrecy Act (BSA):

All Credit Union employees are required to complete all BSA related training annually and maintain knowledge of current BSA policies, specifically those related to functions performed within the department and identify and report possible suspicious activity.

We are proud to be an EEO/AA employer M/F/D/V.

Job Type: Full-time

Pay: $84,067.32 - $190,589.93 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Flexible spending account
• Health insurance
• Life insurance
• Paid time off
• Referral program
• Tuition reimbursement
• Vision insurance

Schedule:

• 8 hour shift
• Day shift
• Monday to Friday
• Weekend availability

Ability to commute/relocate:

• Marlborough, MA 01752: Reliably commute or planning to relocate before starting work (Required)

Work Location: Hybrid remote in Marlborough, MA 01752

rave-on-records.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, rave-on-records.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, rave-on-records.com is the ideal place to find your next job.