Etl Developer

Why QS?

At QS, our culture fosters a flexible working environment that encourages our employees to own their career whilst personally and professionally thriving. We collaborate, respect, and support each other - and as a company, our values underpin these.

Our mission is to empower motivated people around the world to fulfil their potential through higher education, and to ensure everyone has the same opportunity to achieve that potential. We celebrate the diversity of our teams and believe through sharing our experiences we can learn from one another and become stronger together, which enables us to achieve our goal.

At QS, you’ll be responsible for implementing real change in the international higher education landscape, full of exciting and interesting challenges where you can drive positive impact across the business.

As a ETL Developer, this is what you’ll be doing:
Position Summary:

• Support and maintain data integration between various sources and targets.
• Support and maintain the Data Lake, Data Warehouse and Reporting Databases to meet performance and delivery KPIs.
• Participate in the ongoing development and enhancement of ETL/ELT processes to meet the current and future needs of the business.
• Liaise with stakeholders to determine requirements for change requests as well as provide guidance and advice on the appropriate solutions.

Primary Functions: (in order of importance)

• Develop ETLs/ELTs to extract and prepare data and reporting solutions using SQL, SSIS, Informatica, Python, Kleene, and other tools as required.
• Investigate, design, and develop ETLs/ELTs for new data sources as business need arises.
• Provide global support and maintain existing data pipelines, BI systems, and ETLs/ELTs in production to keep the business running, including investigating, and resolving issues within a reasonable time.
• Monitor the day-to-day operations of the data warehouse.
• Documenting data warehouse data dictionary and maintain data pipeline documentation
• Provide user support for data, reports, and extracts.
• And any other additional duties as required

Personal Requirements to Meet Position Objectives:
A bachelor's degree in computer science, IS, mathematics, or a closely related field or equivalent demonstrable experience in an ETL/ELT Developer/Data Engineer role.

• Minimum of 1 year experience in designing and developing ETL/ELT processes using SSIS, Informatica, Python, or other tools, including but not limited to utilizing APIs to extract data from data sources.
• Proven experience with Data Warehouse design and development; specifically relating to Dimensional Models in MS SQL Server. Knowledge or experience in Amazon Redshift, PostgreSQL or Snowflake would be an advantage.
• Experience implementing MS SQL Server Master Data Management and/or Data Quality solutions would be advantageous.
• Experience utilizing APIs as a method for extracting data from a data source.
• Development experience using integration and automation tools such as Zapier would be an advantage.
• Has knowledge and experience in SQL (Oracle, T-SQL, PL/SQL) including query and database performance optimization.
• Outstanding communication and interpersonal skills. Be a people person, someone that gets the best from those around them and the ability to self-motivate
• Experience of working in small, high impact teams required to meet tight deadlines.
• Able to work autonomously and within a team including managing own workload
• Proven problem-solving skills which involve the acquiring and evaluation of information, and decision-making ability based on risks and assumptions
• Proactive attitude with the ability uses initiative to identify potential issues and offer creative solutions.
• Thorough knowledge of software development life cycle (SDLC) and Agile development methodologies with an ability to prioritize objectively.
• Excellent time management and organizational skills with and aptitude to work under pressure
• Highly developed critical analysis and problem-solving skills with an ability to conceptualize and think creatively.

Particular Considerations:

• All applicants must provide a cover letter outlining how their skill and experience match the Personal Requirements listed.
• Only successful applicants will be contacted

So, who are we and what do we do?

QS is the world’s leading provider of services, analytics, insights, and intelligence to the global higher education sector - supporting university excellence across the world. Our student recruitment and enrolment solutions enable universities and business schools to connect with talented individuals seeking to further their academic progress and career development. Our portfolio of professional services includes consultancy, student mobility and academic partnerships management, and branding solutions. We publish highly visible and influential rankings of international universities, including the QS World University