ETL/Database Developer Job at MCS Group | Your Specialist Recruitment Consultancy, Boston, MA

eEtKbjNMb3FGQ0JWMWtVVG4rMW84cTBtMkE9PQ==
  • MCS Group | Your Specialist Recruitment Consultancy
  • Boston, MA

Job Description

MCS Group is pleased to be working with a client that is a staple in the Greater Boston community. This client is in need of an ETL/Database Developer with experience using Banner. The role is a hybrid position, with the teams in office on Wednesday/Thursday and remote Monday/Tuesday/Friday. In this role, you will act as the subject matter expert for the given project, supporting enterprise data initiatives through robust ETL development, Oracle database administration, and Snowflake data warehouse expansion. This role requires e xperience with Ellucian Banner. It would be nice to have hands-on experience with ETL development using SnapLogic and Alteryx, API-based data integration, and Snowflake development, combined with strong Oracle database skills. Reporting to: Director of Business Intelligence Team: Enterprise Data and Solutions Essential Responsibilities Design, develop, and optimize Oracle databases to support operational applications and enterprise reporting needs. Build and maintain ETL pipelines using SnapLogic and Alteryx to streamline data integration processes. Connect and integrate data through APIs , ensuring secure, scalable, and efficient workflows across platforms such as Banner, Slate, Canvas, and Workday. Write, optimize, and maintain SQL and PL/SQL code for Oracle and Snowflake environments. Develop Snowflake objects (tables, views, procedures) to support enterprise reporting and analytics strategies. Collaborate with business analysts, software developers, and project managers to deliver scalable and reliable data solutions. Maintain custom schemas, tables, and views that support strategic initiatives across the organization. Perform data mapping, validation, and quality assurance for new and existing integrations. Document ETL processes, data flow diagrams, API schemas, and database architectures. Work closely with IT security teams to uphold strong data governance, security, and compliance standards. Research and prototype emerging technologies to drive innovation in ETL, API, and cloud data practices. Required Qualifications Bachelor's degree in Computer Science, MIS, IT, or related field. Professional experience as an ETL Developer, Oracle Developer, or related role. Strong expertise in Oracle SQL, PL/SQL development , and management of database objects. Hands-on experience building ETL workflows using SnapLogic and Alteryx . Experience integrating and connecting data via APIs , particularly with Ellucian Banner . Experience writing, optimizing, and managing code and data flows into Snowflake . Solid understanding of relational, dimensional, unstructured, and master data management concepts. Strong experience with data validation, troubleshooting, and performance tuning. Preferred Qualifications Experience supporting Higher Education or other complex organizational environments. Direct experience with Snowflake platform features such as Snowpipe, Streams, Tasks, and Resource Monitors. Working with Alteryx specifically in ETL or advanced data preparation roles. Experience working within cloud environments (AWS, Azure) for scalable data solutions. Python or R proficiency for advanced data manipulation. Familiarity with Slate, Canvas, and Workday platforms. Knowledge, Skills, and Abilities Exceptional organization, prioritization, and project management skills. Strong communication abilities, particularly in translating technical requirements to business audiences. Commitment to continuous improvement, technical learning, and innovation. High attention to detail regarding data security, integrity, and documentation. Ability to work both independently and collaboratively within a cross-functional team. Physical and Work Environment Requirements Standard office conditions. Ability to perform prolonged computer-based tasks. Desired Skills and Experience Banner, ETL, Oracle, Alteryx, Snaplogic, Snowflake MCS Group | Your Specialist Recruitment Consultancy

Job Tags

Remote job, Monday to Friday,

Similar Jobs

Olacar

Panel Beater for Luxury Cars - Miami, USA Job at Olacar

 ...Body Technicians to join a professional and dynamic team in the USA. If you have experience in body repair and want to work with top-...  ...of a team. Willingness to relocate and work in the USA (work visa may be required). What We Offer: Competitive salary and benefits... 

Ardor Health Solutions

Travel Medical Technologist - $2,244 per week Job at Ardor Health Solutions

 ...Ardor Health Solutions is seeking a travel Medical Technologist for a travel job in Gardena, California. Job Description & Requirements ~ Specialty: Medical Technologist ~ Discipline: Allied Health Professional ~ Start Date: 05/19/2025~ Duration: 13 weeks... 

Lenzi Incorporated

Demolition Laborer Job at Lenzi Incorporated

ROLE AND RESPONSIBILITIES -Public Safety First -Cleaning and Preparing the site -Demolition and removal of the building or materials from the site. (No Hazardous Materials)-Improvement work, leveling, and grading -Removing and disposing of any objects that could... 

InterAgency

Freelance Copywriter Job at InterAgency

 ...advice, tutorials, and swipe files they can use right away. What We're Looking For We are looking for talented people with strong writing skills and a passion for the arts. We are looking for writers who understand marketing. Writers who understand the art world or... 

Avera Health

Registered Nurse (RN) - Behavioral Healt... Job at Avera Health

 ...problems, use healthy coping skills and set and complete goals. If you are a nurse that Enjoys working with children ages 5 to 12 years old and adolescent ages 13 to 17 years old as well as their families. Has a passion helping patients with conditions such as...