Data Warehouse Engineer

2 weeks ago

Manila, National Capital Region, Philippines Monroe Consulting Group Full time

The executive search firm Monroe Consulting Group Philippines is recruiting on behalf of a high-growth regulatory-approved online training and certification company with offices in the USA, Pakistan, and Manila.

About the role
Our respected client is seeking a Data Warehouse Engineer with expertise in gathering business requirements, creating comprehensive design documentation, and executing ETL processes using Azure data factory and logic apps. This role involves mapping data points, handling errors, logging, supporting reporting requirements, and ensuring effective utilization of the Data warehouse by business teams. Additionally, the candidate will contribute to data enrichment efforts, enable self-service functions, and assist in data migration for company acquisitions. The position requires onsite work during the night shift and is based in BGC, Taguig City, Philippines.

Key job responsibilities

  • Gather business requirements and create and document designs for Business Intelligence solutions.
  • Develop new and support existing ETL processes utilizing Azure data factory, logic apps, etc.
  • Document mappings of data points, describing various sources and targets, error handling, logging, etc.
  • Provide support to the organization's reporting requirements. Create ad hoc reports as requested.
  • Supports business teams in utilizing the Data warehouse effectively by identifying gaps in data, work on enriching.
  • Data warehouse and enable business to perform self-service functions.
  • Assist with data migration for company acquisitions.

Key job requirements

  • Bachelor's degree in information technology, Science or Engineering
  • Minimum 5 years of experience in writing SQL Code: Stored Procedures, Functions, Queries, Query Optimization by Indexing
  • Experience in collecting and translating the business requirements and converting them into logical/physical data models.
  • Experience in creating ETL involving heterogeneous data sources (IBM DB2, SQL Server, MySQL, Excel files, CSVs, Azure Blobs, XML, JSON, etc.):
  • Minimum of 2 years using Azure Data Factories, Data Flows, Logic Apps, Azure Functions, calling REST APIs.
  • Minimum of 3 years writing ETL in any other tool
  • Experience designing and developing new reports creating data driven subscriptions, maintaining, and enhancing existing reports using SQL Server Reporting Services
  • Experience in source control systems like Git, TFS
  • Experience in core Azure services related to data and analytics and deploying Azure components using PowerShell Scripting, Azure ARM Templates
  • Experience with Agile development methodology and familiarity with tools such as Atlassian JIRA

#J-18808-Ljbffr

  • Data Engineer

    4 days ago

    Manila, National Capital Region, Philippines Malayan Insurance Co., Inc. (MICO) Full time

    The Data Engineer is responsible for designing, building, and maintaining the data architecture and infrastructure that supports data-driven applications and systems.This includes creation & management of data pipelines that transform and transport data from various sources to data warehouses or other target systems; ensure data quality, security, and...

  • Data Engineer

    2 weeks ago

    Manila, National Capital Region, Philippines Onebyzero Full time

    Manila, Philippines | Posted on 03/07/2024 State/Province National Capital Region (Manila) Country Philippines Job Description The ability to design, implement, and optimize large-scale data and analytics solutions on Snowflake Data Engineering Implementing ETL pipelines within and outside of a data warehouse using Python and Snowflake SnowSQL ...

  • Warehouse Data Analyst

    1 week ago

    Manila, National Capital Region, Philippines Sanitary Care Products Asia, Inc. Full time

    The Warehouse Data Analyst is mainly responsible for collection, analysis, reporting of data to be used for business decision making of Warehouse Department and to Business as a whole. This position should also provide quality data that is gathered, replenished, and consolidated to contribute for the betterment of the company's reports. With the most...

  • Data Engineer

    2 weeks ago

    Manila, National Capital Region, Philippines Michael Page Philippines Full time

    About Our Client The company is a leading business in the retail sector, focused on growth and expansion. Job Description Design, develop, and support data pipelines, warehouses, data models, and reporting systems to tackle marketing impact, performance analysis and new campaign opportunities.Troubleshoot existing data setups to uncover data transformation...

  • Data Engineer

    4 weeks ago

    Manila, National Capital Region, Philippines Michael Page Philippines Full time

    About Our Client The company is a leading business in the retail sector, focused on growth and expansion. Job Description Design, develop, and support data pipelines, warehouses, data models, and reporting systems to tackle marketing impact, performance analysis and new campaign opportunities.Troubleshoot existing data setups to uncover data transformation...

  • Data Engineer

    2 weeks ago

    Manila, National Capital Region, Philippines Michael Page Full time

    About Our Client The company is a leading business in the retail sector, focused on growth and expansion. Job DescriptionDesign, develop, and support data pipelines, warehouses, data models, and reporting systems to tackle marketing impact, performance analysis and new campaign opportunities.Troubleshoot existing data setups to uncover data transformation...

  • Data Engineer

    2 months ago

    Manila, National Capital Region, Philippines Michael Page Philippines Full time

    About Our Client One of the largest FMCG company in the country. Job Description Design, develop and manage data pipelines and orchestrate data integration that meets business requirementsIdentify, design and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalabilityWork...

  • Data Engineer

    2 weeks ago

    Manila, National Capital Region, Philippines Luxclusif Full time

    Luxclusif is a pre owned luxury fashion tech company, that enables brands and retailers to buy & sell used goods through innovation and technology. We have developed a unique Resale as a Service solution utilized by the world's largest retailers, and are also a global distributor (B2B player) of pre-owned luxury fashion for businesses. We currently have...

  • Lead Data Engineer

    2 weeks ago

    Manila, National Capital Region, Philippines Eclaro Business Solutions Incorporated Full time

    Lead Data Engineer Receive a Warm Welcome with Our Joining BonusWork details: Full onsite, Night shift 9PM-6AM, Full time roleDuties/Responsibilities:Design and maintain a scalable and secure Azure data warehouse. Build data pipelines: Create and manage data integration processes, including data extraction, transformation, and loading (ETL) from various...

  • Data Engineer

    2 weeks ago

    Manila, National Capital Region, Philippines Michael Page Full time

    One of the largest FMCG company in the country.Job DescriptionDesign, develop and manage data pipelines and orchestrate data integration that meets business requirementsIdentify, design and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalabilityWork with data and...

  • Data Engineer

    2 weeks ago

    Manila, National Capital Region, Philippines SupportNinja Full time

    The Data Engineer will be responsible for data modeling, data matching, data integration, duplicate record checking, maintaining data quality and technical documentation. This position will provide appropriate access to data to necessary stakeholders. What does a day in the life of a Data Engineer look like?Assist and guide Business Intelligence Developers...

  • Data Visualization Engineer

    1 day ago

    Manila, National Capital Region, Philippines AIA Philippines Full time

    We are looking for Data Visualization Engineering ConsultantActs as a technical lead and main person for the team on design and development of tools and best practices used in analytics data management including but not limited to SAS, Azure Cloud, other data warehouses, data lakes, and data hubs. Roles and Responsibilities:Leads the design, development and...

  • Lead Data Engineer

    2 weeks ago

    Manila, National Capital Region, Philippines Eclaro Full time

    Mathematics, Statistics & Information Sciences (Science & Technology) Design and maintain a scalable and secure Azure data warehouse.Build data pipelines: Create and manage data integration processes, including data extraction, transformation, and loading (ETL) from various sources into the data warehouse.Develop and implement data management strategies to...

  • Data Analyst

    2 weeks ago

    Manila, National Capital Region, Philippines Cobden & Carter International Full time

    Data Analyst (Specialist and Supervisor)Perform data cleaning, preparation, reporting, and data analysisAssemble large, complex sets of data that meet non-functional and functional business requirementsPerform data extraction, aggregation, and quality checking from multiple sources and tables in support of trend identification, root cause analysis, and...

  • Data Engineer

    2 weeks ago

    Manila, National Capital Region, Philippines Macquarie Bank Limited Full time

    As a Data Engineer in the Manila Data and Analytics team, you will be working with traders, desk analysts, and central data teams to provide data and analytics solutions across our Commodities and Global Markets business lines. At Macquarie, our advantage is bringing together diverse people and empowering them to shape all kinds of possibilities. We are a...

  • Senior Data Analyst

    7 days ago

    Manila, National Capital Region, Philippines Cobden & Carter International Full time

    Job Description: o Perform data cleaning, preparation, reporting, and data analysis o Assembling large, complex sets of data that meet non-functional and functional business requirements o Perform data extraction, aggregation, and quality checking from multiple sources and tables in support of trend identification, root cause analysis, and validation of the...

  • Analyst (Data Validation)

    2 weeks ago

    Manila, National Capital Region, Philippines DATA MART Consulting GmbH Full time

    Company DescriptionM3 Global Research, part of M3 Inc., provides the most comprehensive and highest quality market research recruitment and support services available to the industry with relationships reaching respondents in more than 70 countries worldwide.M3 Global Research maintains ISO 26362 and 27001 certifications with the highest quality data...

  • Data Engineer, Managed Services

    2 weeks ago

    Manila, National Capital Region, Philippines 3Cloud Full time

    This Senior Data Engineer position is a member of 3Cloud's Managed Services team. He or she is responsible for ongoing development, support, escalations, and proactive maintenance for our client's Azure Data Platform solution through the Managed Services teams processes, procedures, and tools. As a Data Engineer, you will be a critical part of our core team...

  • Data Engineer

    4 weeks ago

    Manila, National Capital Region, Philippines US Fair Group Full time

    We USA Fair Group Inc. Located in New York City are searching for an accountable, multitalented data engineer and IT Technician to facilitate the operations of our data scientists in the Philippines . The data engineer will be responsible for employing machine learning techniques to create and sustain structures that allow for the analysis of data while...

  • Data Engineer

    2 months ago

    Manila, National Capital Region, Philippines US Fair Group Full time

    We USA Fair Group Inc. Located in New York City are searching for an accountable, multitalented data engineer and IT Technician to facilitate the operations of our data scientists in the Philippines . The data engineer will be responsible for employing machine learning techniques to create and sustain structures that allow for the analysis of data while...