What are the responsibilities and job description for the ETL & Oracle Developer position at firstPRO, Inc?
Reporting to the Director of Business Intelligence the ETL & Oracle Developer is a key member of the Enterprise Data and Solutions team, responsible for developing and supporting ETL processes for central IT. The Developer plays a critical role 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, 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 our team of developers to maintain custom schemas, tables, and views which 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 to assemble and deliver datasets to enterprise colleagues to be used for 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.
? Support Alteryx and Tableau platforms through building data pipelines to facilitate the growth of dashboards and incorporate new and diversified data sources.
? Develop queries, tables, views, and data applications in Snowflake to support the 5-year Data Strategy roadmap.
? Focus on API usage and development for loading data into data warehouses and applications.
? Effectively work and collaborate with PMO on BI projects, ensure deliverables are completed on time, and objectives are met.
? Maintain steady contact with the IT security team in regard to 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 documentations 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, 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, Information Technology is required or a bachelor’s degree with relevant combined work experience is acceptable.
? Minimum of 8 years of combined professional experience as an ETL Developer, Oracle Developer, or a related role required.
? Expert level proficiency developing in Oracle Database, using SQL and PL/SQL programming required.
? Adept at managing database objects such as tables, views, indexes, directories, sequences, triggers, packages and stored procedures required.
? Well-versed in programming language(s) for ETL and data pipelining creation required.
? Experience with data mapping, business process analysis, criteria and data flow documentation in written or visual format required.
? Experience working with data modeling, maintaining an enterprise data warehouses understanding of database design concepts required.
? Experience ingesting, organizing, and representing data within a data model in formats that are easy to use, understand and meet business objectives required.
? Expertise in defining and managing relational data, dimensional data, unstructured data, and master data to effectively translate and communicate data to both technical and non-technical audiences required.
? 6 years’ experience in database systems management. Hands on experience in data model/data warehouse design. Solid understanding of dimension/fact table structure and data aggregation.
? 5 years of hands-on experience working with ETL tools and procedures. All preferred.
? Higher Education work experience preferred.
? Snowflake data platform experience preferred.
? Experience working with Ellucian Banner, Slate, Canvas or Workday preferred.
? Experience with cloud platforms (AWS, Azure) for scalable data storage and computation preferred.
? 2 years’ experience with Alteryx ETL Skilled in Python, R, or other tools for data manipulation and analysis preferred.
KNOWLEDGE, SKILLS, AND ABILITIES – May be representative, but not all-inclusive, of those knowledge, skills, and abilities commonly associated with the job.
? Demonstrated organization, creativity, and agile problem-solving approach to resolve problems of diverse scope and complexity within deadlines.
? Ability to multi-task and manage time effectively.
? Demonstrates best practices to use modern layouts, typography and interaction design.
? Excellent written and oral communication skills and ability to deliver messages and ideas effectively for different audiences.
? Capable of working on problems of diverse scope and complexity, is resourceful in developing solutions encompassing challenges to deliver solutions before the deadlines.
? Following standard practices and procedures in analyzing situations or data to obtain trustworthy results.
? Is a fast learner and able to apply new and emerging technologies to the existing BI product portfolio to achieve meaningful business outcomes.
? Ability to keep updated on the latest technologies with technology training and professional development.
? Self-motivated, responsible and detail oriented.
? Ability to work independently and with a team.
? Strong SQL query, PL/SQL and Oracle relational databases skills.
? Strong Excel skill and efficient use of visual tools.
? Experience working with data stewards and data governance.
? Knowledge of SDLC and project management best practices.
? Knowledge of additional database systems (e.g., MySQL, PostgreSQL) preferred
? Oracle certifications (e.g., Oracle Certified Professional) preferred.
? Alteryx credentials (e.g. Data Preparation, Manipulation, Transformation) preferred.
? Can develop end-to-end solutions from constructing the data set to visualizing information in a tool like Tableau or Argos reports and dashboards preferred.
? Familiarity with CI/CD pipelines and version control systems like Git preferred.
? Proficient with data exploration and manipulation tools like Python (Pandas, NumPy) or R preferred.
Salary : $100,000 - $118,000