Talent.com
Data Warehouse Developer and Analyst
Data Warehouse Developer and AnalystV360 Global Solutions • Philippines
Data Warehouse Developer and Analyst

Data Warehouse Developer and Analyst

V360 Global Solutions • Philippines
30+ days ago
Job description

The Role : Job Responsibilities

Data Analysis & SQL Development

  • Write complex SQL queries to extract, manipulate, and analyze data from multiple databases
  • Develop and maintain stored procedures, views, and functions
  • Perform data validation, cleansing, and quality assurance
  • Optimize SQL queries for performance and efficiency
  • Create automated data extraction processes and ETL workflows
  • Collaborate with database administrators to ensure data integrity

Power BI Report Development

  • Design and develop interactive dashboards and reports using Power BI Desktop
  • Create and maintain Power BI datasets and data models
  • Implement DAX calculations for advanced analytics
  • Publish reports to Power BI Service and manage workspace permissions
  • Schedule automated data refreshes and monitor report performance
  • Create custom visualizations and implement best practices for dashboard design
  • Business Analysis & Requirements Gathering

  • Work with stakeholders to understand business requirements and translate them into technical specifications
  • Conduct data discovery sessions to identify key metrics and KPIs
  • Perform gap analysis and recommend solutions for business challenges
  • Document functional requirements and create user stories
  • Facilitate workshops and requirements gathering sessions
  • Create process flow diagrams and business process documentation
  • Stakeholder Management & Communication

  • Present findings and insights to business users and executive leadership
  • Train end-users on Power BI reports and self-service analytics
  • Provide ongoing support and maintenance for deployed solutions
  • Create user documentation and training materials
  • Collaborate with IT teams, data engineers, and other analysts
  • Ideal Profile :

    Required Qualifications

    Experience

  • 1-2 years of experience in business analysis or related role
  • Proven experience writing SQL queries and working with relational databases
  • Hands-on experience developing Power BI reports and dashboards
  • Experience with data analysis and reporting in a business environment
  • Technical Skills

  • Advanced SQL proficiency including :
  • o Complex joins, subqueries, and window functions

    o Stored procedures and functions

    o Data manipulation (INSERT, UPDATE, DELETE)

    o Performance optimization techniques

  • Power BI expertise including :
  • o Report and dashboard development

    o DAX calculations and measures

    o Data modeling and relationships

    o Power Query for data transformation

    o Power BI Service administration

  • Experience with database systems (SQL Server, MySQL, PostgreSQL, or similar)
  • Knowledge of data warehousing concepts and ETL processes
  • Proficiency in Microsoft Excel (advanced formulas, pivot tables)
  • Analytical Skills

  • Strong problem-solving and critical thinking abilities
  • Experience with statistical analysis and data interpretation
  • Knowledge of business intelligence concepts and methodologies
  • Understanding of data visualization best practices
  • Ability to identify trends, patterns, and anomalies in data
  • Soft Skills

  • Excellent written and verbal communication skills
  • Strong presentation skills with ability to explain technical concepts to nontechnical audiences
  • Detail-oriented with strong organizational skills
  • Ability to manage multiple projects and priorities simultaneously
  • Collaborative mindset with strong interpersonal skills
  • Preferred Qualifications

    Education & Certifications

  • Bachelor's degree in Business Administration, Computer Science, Information Systems, or related field
  • Microsoft Power BI certification (DA-100 or PL-300)
  • SQL Server certifications (MCSA or equivalent)
  • Six Sigma or Lean certification is a plus
  • Additional Experience

  • Experience with cloud platforms (Azure, AWS)
  • Knowledge of programming languages (Python, R, VBA)
  • Experience with other BI tools (Tableau, QlikView, Looker)
  • Understanding of Agile / Scrum methodologies
  • What's on Offer?

  • Opportunity to make a positive impact
  • Excellent career development opportunities
  • Pure Work From Home
  • Create a job alert for this search

    Data Warehouse Developer and Analyst • Philippines

    Similar jobs
    Wordpress Developer (Must know Elementor)

    Wordpress Developer (Must know Elementor)

    Angel City VA • PH
    Quick Apply
    Job Title : WordPress Developer Position Overview : We are looking for a part-time(20hrs / week) skilled WordPress Developer who can create visually stunning, responsive,...Show more
    Last updated: 30+ days ago
    Research Analyst, GMA

    Research Analyst, GMA

    UL Solutions External Career Site • , , Philippines, Philippines
    Research and maintain up-to-date information on regulatory requirements and other areas as assigned.Acquire compliance requirements required to access to specific countries.Monitor sources and mana...Show more
    Last updated: 8 days ago • Promoted
    Wordpress Developer

    Wordpress Developer

    Angel City VA • PH
    Quick Apply
    Job Title : WordPress Developer Position Overview : We are looking for a part-time(20hrs / week) skilled WordPress Developer who can create visually stunning, responsive,...Show more
    Last updated: 30+ days ago
    Service Desk Analyst

    Service Desk Analyst

    Booth and Partners Pte Ltd • NCR, 00, ph
    Quick Apply
    We are seeking a skilled Service Desk Analyst to deliver proactive and responsive support, ensuring smooth issue resolution and appropriate escalation when necessary. This role requires strong techn...Show more
    Last updated: 26 days ago
    Shopify Developer

    Shopify Developer

    Pomelo • PH
    Quick Apply
    About Us Pomelo places the best offshore talent with top brands, startups, and agencies across the globe.We enable hard-working and ambitious talent to work remotely from their home countries, whil...Show more
    Last updated: 30+ days ago
    Dutch Content Developer

    Dutch Content Developer

    goFLUENT • Philippines
    Quick Apply
    FLUENT, headquartered in Geneva, Switzerland, is the world’s leading B2B provider of hyper-personalized solutions that accelerate language skills by blending technology, content and virtual human i...Show more
    Last updated: 4 days ago
    Senior Power BI Lead | Data Modeling & Analytics (Remote)

    Senior Power BI Lead | Data Modeling & Analytics (Remote)

    TASQ Staffing Solutions • , , Philippines, Philippines
    A staffing and consulting firm is seeking a Lead Consultant specializing in Power BI for a remote role.Ideal candidates will have over 5 years of experience in BI solutions, particularly within the...Show more
    Last updated: 30+ days ago • Promoted
    Remote Lead Power BI Architect & Data Strategy

    Remote Lead Power BI Architect & Data Strategy

    TASQ Staffing Solutions • , , Philippines, Philippines
    A staffing solutions firm is seeking a Lead Power BI Consultant to work fully remote.The ideal candidate should have at least 5 years of experience in data management and BI solutions, particularly...Show more
    Last updated: 30+ days ago • Promoted
    Financial Planning and Analysis Lead

    Financial Planning and Analysis Lead

    Angkas • , , Philippines, Philippines
    Monthly financials (MR-FR bridge; Cashflow bridge).Manage Budget approval / Monitoring and evaluate every spending, campaign initiative vs expected yield. Proactive, and assertive in doing task and ca...Show more
    Last updated: 30+ days ago • Promoted
    Senior Power BI Lead | Remote Data & Databricks Expert

    Senior Power BI Lead | Remote Data & Databricks Expert

    TASQ Staffing Solutions • , , Philippines, Philippines
    A staffing solutions company is seeking a Lead Consultant for Power BI with strong data management expertise.Responsibilities include designing data models, developing Power BI solutions, and colla...Show more
    Last updated: 30+ days ago • Promoted
    Sales and Application Leader - Medical IVD

    Sales and Application Leader - Medical IVD

    Fujifilm Philippines Inc. • Philippines, Philippines, Philippines
    Quick Apply
    Drive IVD Sales Result by means of providing academic support and train sales team / distributors / accounts including their employees. It is inherent to this role the creation of presentation materi...Show more
    Last updated: 19 days ago
    Senior PHP / Laravel Backend Developer – Scalable Systems & APIs

    Senior PHP / Laravel Backend Developer – Scalable Systems & APIs

    Qureos Inc • Philippines
    Quick Apply
    Join our vibrant tech team and help shape the future of our digital solutions!.Build and maintain backend services using PHP 8+ & Laravel / Lumen. Design and optimize relational databases (PostgreSQL / ...Show more
    Last updated: 30+ days ago
    Senior Backend Engineer

    Senior Backend Engineer

    Qureos Inc • Philippines
    Quick Apply
    Our backend powers complex workflows across jobs, interviews, sourcing, and AI-driven insights.As we expand these capabilities, we’re strengthening our architecture and introducing new patterns to ...Show more
    Last updated: 30+ days ago
    Full-Stack Developer / Shopify Expert (eCommerce CRO Focus)

    Full-Stack Developer / Shopify Expert (eCommerce CRO Focus)

    Pearl West • PH
    Quick Apply
    Company Overview Pearl West is a leading eCommerce investment and operating group specializing in acquiring, optimizing, and scaling premium brands. Our mission is to build and grow standout online ...Show more
    Last updated: 30+ days ago
    Client Insights Analyst – US CPG Market

    Client Insights Analyst – US CPG Market

    ECLARO • , , Philippines, Philippines
    Client Insights Analyst – US Client Market.This position is part of our client's analytics team supporting US-based clients. You'll work closely with Senior Managers and Client Insights Managers to ...Show more
    Last updated: 9 days ago • Promoted
    Business Intelligence Analyst

    Business Intelligence Analyst

    PlanetArt • PH
    Quick Apply
    Business Intelligence Analyst Philippines Full Time Remote Company and Vision PlanetArt’s vision is to be the leading seller of personalized and make-on-demand products worldwide.We provide c...Show more
    Last updated: 30+ days ago
    Remote PhD Data Partner (Maths) for AI Content

    Remote PhD Data Partner (Maths) for AI Content

    TELUS Digital AI Data Solutions • , , Philippines, Philippines
    A leading technology and AI solutions company is seeking a PhD Data Partner to develop complex question-and-answer pairs for advanced topics in AI. This remote role requires a Doctorate in Maths and...Show more
    Last updated: 11 days ago • Promoted
    Director, Supply Chain Analytics (Data & AI services)

    Director, Supply Chain Analytics (Data & AI services)

    Lingaro • , , Philippines, Philippines
    Director, Supply Chain Analytics (Data & AI services).Growth through diversity, equity, and inclusion.As an ethical business, we do what is right — including ensuring equal opportunities and foster...Show more
    Last updated: 18 days ago • Promoted