Match score not available

Senior ETL Developer

extra holidays - fully flexible

Remote:

Full Remote

Experience:

Expert & Leadership (>10 years)

Work from:

Philippines

Offer summary

Qualifications:

College degree in any discipline, 5-10+ years of experience in data warehousing, data lakes or business intelligence, 3+ years experience with ETL/ELT solutions using various tools like Azure Data Factory, Python, Alteryx, SSIS or Informatica, Hands-on experience with Azure services, Power BI, Power Platform, SQL Server Analysis Service (SSAS), T-SQL, R, Spark, DAX.

Key responsabilities:

Enhance existing data designs and create new databases, models, and reports
Manage project requirements gathering, development, rollout on the solution platform
Work closely with reporting team for data insights compliance
Act as the primary expert on transformation logic, support advanced data analysis initiatives

JWay Group, Inc. Information Technology & Services SME https://www.jway.com/

51 - 200 Employees

See more JWay Group, Inc. offers

Job description

Responsibilities:

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).