ETL/Oracle Developer

Join our community and experience Emerson College!

Reporting to the Director of Business Intelligence, the ETL & Oracle Developer is a key member of the Enterprise Data and Solutions team and is responsible for developing and supporting ETL processes for central IT. The Developer plays a critical role in maintaining the campus Oracle database for operational and project support while scaling the enterprise data warehouse, Snowflake. ETL responsibilities include creating data connections on the Alteryx platform and building and maintaining data in the Snowflake institutional data warehouse, in addition to supporting all current and future Business Intelligence goals. Oracle development responsibilities include supporting the full lifecycle of designing, implementing, and maintaining Oracle database systems. The ETL & Oracle Developer will work closely with the team of developers to maintain custom schemas, tables, and views that meet the data needs for campus initiatives and provide strategic guidance for campus stakeholders.

ESSENTIAL JOB DUTIES

•  Design, develop, and maintain Oracle database systems to ensure optimal performance.
• Collaborate with software developers, business analysts, and stakeholders to understand requirements and translate them into technical specifications.
• Develop complex PL/SQL queries, stored procedures, triggers, and functions.
• Optimize database structures and queries for improved performance and scalability.
• Serve as the key point of contact for assembling and delivering datasets to enterprise colleagues for use in data integration, dashboarding, and application development work.
• Create ETL process on the Alteryx platform based on Data model designs and assist in designing appropriate data models.
• Map data from new sources to the central data warehouse to support the creation of new or extension of existing reports/dashboards and perform data validation. Provide requirements and execute data extraction, transformation, and load procedures. 
• Build data pipelines to support Alteryx and Tableau platforms, facilitate dashboard growth, and incorporate new and diversified data sources.
• Develop queries, tables, views, and data applications in Snowflake to support the 5-year Data Strategy roadmap for Emerson College.
• Focus on API usage and development for loading data into data warehouses and applications.
• Effectively work and collaborate with PMO on BI projects, ensuring deliverables are completed on time and objectives are met. 
• Maintain steady contact with the IT security team regarding security or business intelligence workflows and clients.
• Handle complex data issues with minimal supervision while escalating critical issues to management using sound judgment. Enforce data quality, knowledge retention, and process consistency through the curation and expansion of the institutional data dictionary/catalog.
• Communicate effectively with internal team and external business users through written, verbal, and visual storytelling.
• Develop detailed technical specifications, data mapping, and data flow documentation for major data analytics projects.
• Upkeep and document all data sources for all BI projects.
• Maintain and support the College’s data warehouse and data lake regarding metadata, data dictionary, data integrity, and other tools and technology that allow for efficient data collection, analysis, and a shared understanding of information.
• Keep current on the latest technologies and develop proof-of-concept data model prototypes to advance the BI program.
• Commit to professional development by fostering a climate of team learning, cross-training, and knowledge-base building. 
• Perform other duties as assigned.

QUALIFICATIONS – Qualifications are deemed required or preferred and represent what is needed to effectively perform the job.

• Bachelor’s degree in Computer Science, Management Information Systems, or Information Technology (or another field with relevant combined work experience) is required.
• A minimum of 8 years of combined professional experience as an ETL Developer, Oracle Developer, or related role is required.
• Expert-level proficiency in Oracle Database development, including SQL and PL/SQL programming, is required.
• A strong ability to manage database objects such as tables, views, indexes, directories, sequences, triggers, packages, and stored procedures is required.
• Proficiency in programming languages for ETL and data pipeline creation is required.
• Experience in data mapping, business process analysis, criteria development, and data flow documentation in both written and visual formats is required.
• Hands-on experience in data modeling, enterprise data warehouse maintenance, and database design concepts is required.
• It is required that the candidate be skilled in ingesting, organizing, and structuring data within a data model in a format that is accessible, understandable, and aligned with business objectives.
• Expertise in defining and managing relational, dimensional, unstructured, and master data, ensuring effective data translation and communication for both technical and non-technical audiences is required.
• 6+ years of experience in database systems management is preferred.
• Hands-on experience in data modeling and data warehouse design, with a solid understanding of dimension/fact table structures and data aggregation, is preferred.
• 5+ years of hands-on experience working with ETL tools and procedures is preferred.
• Experience in Higher Education environments is preferred.
• Experience with the Snowflake data platform is preferred.
• Familiarity with Ellucian Banner, Slate, Canvas, or Workday is preferred.
• Experience with cloud platforms (AWS, Azure) for scalable data storage and computation is preferred.
• 2+ years of experience with Alteryx ETL is preferred.
• Proficiency in Python, R, or other tools for data manipulation and analysis is preferred.

KNOWLEDGE, SKILLS, AND ABILITIES – This may be representative but not all-inclusive of the knowledge, skills, and abilities commonly associated with the job. 

• Demonstrated organizational skills, creativity, and agile problem-solving abilities.
• Excellent multitasking, time management, and deadline-oriented execution.
• Skilled in modern layouts, typography, and interaction design best practices.
• Strong written and verbal communication and adaptability to diverse audiences.
• Proven ability to analyze complex problems, develop resourceful solutions, and deliver timely results.
• Experienced with standard analytical practices to produce reliable outcomes.
• Fast learner adept at applying emerging technologies to BI products.
• Committed to continuous technology training and professional development.
• Self-motivated, responsible, detail-oriented, and effective independently or in a team setting.
• Strong skills in SQL, PL/SQL, Oracle relational databases, and Excel.
• Experience with data stewardship and governance frameworks.
• Knowledge of SDLC, project management, and additional databases (MySQL, PostgreSQL).
• Oracle Certified Professional credentials.
• Alteryx certification in Data Preparation, Manipulation, and Transformation.
• Expertise in developing end-to-end BI solutions, from dataset creation to visualization (Tableau, Argos).
• Familiarity with CI/CD pipelines and Git version control.
• Proficient in data exploration/manipulation using Python (Pandas, NumPy) or R.

PHYSICAL ABILITIES – Activities commonly associated with the performance of the functions of this job. The physical demands described below are representative of those that an employee must meet to perform the essential functions of this job successfully. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

• Requires the ability to lift and move light objects
• Requires the ability to move materials occasionally
• Ability to perform standard office tasks such as prolonged sitting, working on a computer, and participating in meetings.
• Occasional physical activity related to event or project support.

WORK ENVIRONMENT – Environmental or atmospheric conditions commonly associated with the performance of the functions of this job.

• Usual Office Conditions

Disclaimer: This job description in no way states or implies that these are the only duties to be performed by the employee occupying this position.  Employees may be required to follow other job-related instructions and to perform other job-related duties as requested, subject to all applicable state and federal laws.  Certain job duties described herein may be subject to possible modification in accordance with applicable state and federal laws.

Hybrid

This position is primarily a hybrid role with expected days in the office each week.

The hybrid arrangement will be made upon hire. To ensure operational effectiveness, candidates must reside within a reasonable commuting distance of the Boston campus. This arrangement must be approved as outlined in the Remote Work Policy. 

This is a time-limited position that cannot extend past 36 months.

Grade of Position: 23-11E

Scheduled Weekly Hours: 36.25

In addition to a competitive salary, Emerson College is committed to the health and well-being of our employees and family members. We offer a generous benefits package to regular staff scheduled to work 20+ hours per week. 

Benefits include outstanding health plans with limited out-of-pocket expenses, dental plans, generous time-off programs, and a 403(b) retirement benefit with a 9% employer contribution once eligible. Additional benefits such as life and disability coverage as well as commuter offerings are available.

Please refer to our benefits website for a full list of benefits and eligibility requirements.