Senior ETL Developer

JWay Group, Inc.; Quezon City; Vor Ort; PHP 1.674.000 - 2.567.000; Vollzeit

Zusammenfassung

JWay Group, Inc. seeks an experienced data warehousing professional to design and optimize databases and data models across Oracle and SQL Server environments. You will lead requirements, develop major projects, and enable rich reporting via SSAS and Power BI.

You will collaborate with analytics teams, enforce ETL best practices, and provide ad-hoc data analysis support, documentation, and training to business users.

Qualifikationen

• Holds a college degree in any discipline.
• 5–10+ years in data warehousing, data lakes, BI.
• 3+ years ETL/ELT with Azure Data Factory, Python, Alteryx, SSIS or Informatica.
• Experience building data models.
• Hands-on with Azure services or Power BI/Power Platform.
• SQL expertise including T-SQL, Views, Stored Procedures.

Aufgaben

• Improve existing data designs and design new databases and data models; relational table structures; Unix Shell scripting; Oracle and SQL Server.
• Manage requirements gathering, development and rollout of major projects on the solution platform.
• Create reports and enable slicing/dicing of data in SSAS.
• Collaborate with reporting team to ensure ETL best practices and audit standards.
• Provide ad-hoc support for advanced strategic data analysis initiatives.
• Act as go-to expert on transformation logic for data warehouse.
• Support business users with data questions; provide documentation and training.

Kenntnisse

Data warehousing

ETL/ELT

SQL queries

T‑SQL

Spark

R

DAX

Power BI

Power Platform

Machine Learning

Data modeling

Ausbildung

College degree

Tools

Azure Data Factory

SSIS

Informatica

Alteryx

SSAS

Power BI

Azure Synapse

Databricks

Purview

Jobbeschreibung

Improve existing data designs and design new databases and data models, including relational table structures, using Unix Shell Scripting, Oracle and SQL Server

Manage the requirements gathering, development and rollout of major projects on the solution platform

Creating reports and providing the ability to slice and dice the data in SSAS

Work directly with reporting team to ensure ongoing operational and new work complies with requirements and ETL best practice and audit standards

Provide ad-hoc support for advanced strategic data analysis initiatives

Act as the go-to expert on all underlying transformation logic against data in the data warehouse

Support business user questions about the data and provide documentation and training when and where necessary

Requirements

• Holds a college degree in any discipline
• Minimum 5-10+ years professional/project experience with data warehousing, data lakes, and/or business intelligence
• Minimum 3+ years experience developing ETL/ELT solutions using tools such as Azure Data Factory, Python, Alteryx, SSIS, or Informatica. Integrating data from varied sources using Alteryx and being able to load the data into the SQL Server Analysis Service (SSAS) cubes using SSIS
• Data-modeling experience
• Hands-on experience with Azure services (Data Factory, Synapse, Databricks, Purview, Machine Learning) or Power BI, Power Platform
• Aptitude for data and analytics - SQL queries, ETL frameworks and tools, T-SQL (Views, Queries, Stored Procedures), R, Spark, and DAX
• Experience deploying data pipelines, models, and AI-driven solutions. Packaging the product and turning it over to the client.
• Must be able to understand ledgers at the very least

Data Privacy Consent

By submitting your application for this job, you are authorizing JWay Group to: a) collect and use your personal data, and to disclose such data to any third party with whom JWay Group or any of its related corporations has service arrangements, in each case for all purposes in connection with your job application, and employment with JWay Group or its clients; and b) retain your personal data for consideration of future job opportunities (where applicable for relevant unsuccessful job applicants).