Data Warehouse Developer and AnalystSnaphunt • Philippines
Data Warehouse Developer and Analyst
Snaphunt • Philippines
30+ days ago
Job descriptionDesign 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 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 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 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 Advanced SQL proficiency including : Power BI expertise including : 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) 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 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 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 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 Opportunity to make a positive impact Excellent career development opportunities Pure Work From Home
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
Business Analysis & Requirements Gathering
Stakeholder Management & Communication
Ideal Profile :
Required Qualifications
Experience
Technical Skills
o Complex joins, subqueries, and window functions
o Stored procedures and functions
o Data manipulation (INSERT, UPDATE, DELETE)
o Performance optimization techniques
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
Analytical Skills
Soft Skills
Preferred Qualifications
Education & Certifications
Additional Experience
What's on Offer?
Create a job alert for this search
Data Analyst • Philippines
Similar jobs
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
Recognised as AWS's Rising Star Partner of the Year for 2023 in EMEA and 2022 in the UK&I, we’re expanding globally with new offices in South Africa and Dubai, a strong presence in the Philippines,...Show more
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 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 
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
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 Recognised as AWS's Rising Star Partner of the Year for 2023 in EMEA and 2022 in the UK&I, we’re expanding globally with new offices in South Africa and Dubai, a strong presence in the Philippines,...Show more 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 
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
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
This is a work-from-home position!.Night shift hours, Monday to Friday (9am PST - 5pm PST) WHO WE ARE At Expertise, we strive to support the best providers in their efforts to serve their local com...Show more
Wordpress Developer (Must know Elementor)
Angel City VA • PH
Quick Apply
Last updated: 30+ days ago
AWS Solutions Architect (PH)
Cloud Bridge Tech Recruitment • Taguig City, Metro Manila, .PH
Quick Apply
Last updated: 26 days ago
AI Content Creator
Bored Panda • Philippines, Philippines
We are one of the leading tech-driven media and entertainment companies, producing uplifting content in 17 languages for people of all ages.
Known for award-winning art and pop culture magazine bore...Show more
Last updated: 30+ days ago • Promoted
ESL Quality Analyst
goFLUENT • Philippines, PH
Quick Apply
Last updated: 30+ days ago
Wordpress Developer
Angel City VA • PH
Quick Apply
Last updated: 30+ days ago
Principal Cloud Solutions Architect
Dayforce • , , Philippines, Philippines
Principal Cloud Solutions Architect.Join to apply for the Principal Cloud Solutions Architect role at Dayforce.Dayforce is a global human capital management (HCM) company headquartered in Toronto, ...Show more
Last updated: 1 day ago • Promoted
Shopify Developer
Pomelo • PH
Quick Apply
Last updated: 30+ days ago
Remote Freelance ML Engineer (Python) — GenAI Projects
Mindrift • , , Philippines, Philippines
A leading AI company is seeking a Freelance Machine Learning Engineer to design computational problems and ensure solutions leverage Python libraries.
Candidates should possess a Master's or PhD in ...Show more
Last updated: 2 days ago • Promoted
Margin Analyst
CommandLink, LLC • , , Philippines, Philippines
Command|Link is a global SaaS Platform providing network, voice services, and IT security solutions, helping corporations consolidate their core infrastructure into a single vendor and layering on ...Show more
Last updated: 2 days ago • Promoted
Senior PHP / Laravel Backend Developer – Scalable Systems & APIs
Qureos Inc • Philippines
Quick Apply
Last updated: 10 days ago
Magento Developer
Cloud Bridge Tech Recruitment • Taguig City, Metro Manila, .PH
Quick Apply
Last updated: 26 days ago
Senior Backend Engineer
Qureos Inc • Philippines
Quick Apply
Last updated: 9 days ago
Full-Stack Developer / Shopify Expert (eCommerce CRO Focus)
Pearl West • PH
Quick Apply
Last updated: 30+ days ago
Data Encoder - CSR - Dayshift - Pure chat
Sapient Global Services • Fairview, National Capital Region, Philippines
We are mass hiring for Call Center Agents - Non Voice Account as prior in our Metro Manila sites! .Sapient is URGENTLY HIRING! APPLY TODAY AND GET HIRED IMMEDIATELY! .
Resolve customer inquiries, co...Show more
Last updated: 30+ days ago • Promoted
Business Intelligence Analyst
PlanetArt • PH
Quick Apply
Last updated: 30+ days ago
Head of CX & Growth — Fully Remote
Manta Sleep • , , Philippines, Philippines
A fast-growing ecommerce brand in the Philippines is looking for a Head of Customer Experience to transform their customer journey.
The ideal candidate will have over five years of experience in lea...Show more
Last updated: 2 days ago • Promoted
Senior Software Engineer
ExpertiseLocal • Philippines, PH
Quick Apply
Last updated: 8 days ago
Consulting Technical Manager / Senior Delivery Manager
Oracle • , , Philippines, Philippines
NetSuite Consulting Delivery Manager.Join to apply for the NetSuite Consulting Delivery Manager role at Oracle.Be among the first 25 applicants.
As a leading contributor within the practice, this se...Show more
Last updated: 1 day ago • Promoted