
Data Analyst
Posted 4 days ago

Posted 4 days ago
This is a fully remote position, open to applicants in Philippines.
• Analyze source datasets to gain insights into their structure, completeness, consistency, relationships, and potential data quality concerns.
• Develop and troubleshoot SQL queries to explore data, investigate inconsistencies, and fulfill warehouse requirements.
• Assist in defining warehouse tables, including columns, data types, keys, and relationships, in accordance with the project's design objectives.
• Create and uphold source-to-target mappings, incorporating transformation rules and business logic.
• Collaborate with stakeholders and technical team members to clarify data definitions, business rules, and anticipated outputs.
• Utilize SQL and reconciliation checks to verify mappings and transformations.
• Maintain records of profiling findings, mapping specifications, table definitions, and unresolved data inquiries.
• Take ownership of assigned analysis tasks, communicate progress, identify blockers early, and adhere to established project standards.
• Collaborate with data engineers and project stakeholders to facilitate the delivery of the Microsoft Fabric data warehouse.
• Mid-level, hands-on experience in data analysis, particularly in supporting data warehouses or data integration projects.
• Proficient SQL skills for querying, joining, aggregating, and analyzing data across multiple tables.
• Practical experience in profiling source data and identifying data quality issues.
• Experience in contributing to table design, including data types, keys, and relationships.
• Proficient in creating source-to-target mappings and documenting transformation rules.
• Understanding of data warehouse concepts and ETL/ELT processes.
• Ability to convert data findings and business rules into clear, usable documentation.
• Strong analytical, problem-solving, and communication abilities.
• Capacity to follow technical guidance while independently executing assigned tasks.
• Located in the Philippines with the ability to work remotely, overlapping with US Central business hours, as per the agreed schedule.
• Experience with Microsoft Fabric is an advantage.
• Relevant experience with Azure data platforms, Azure Synapse, or similar data warehouse environments is also advantageous.
• Fully remote work setup.
• Flexibility to work from anywhere within the Philippines.
• Opportunity to contribute to a Microsoft Fabric data warehouse project.
• Hands-on involvement in data profiling, SQL analysis, table design, and data mapping.
• Collaboration with data engineers and project stakeholders.
• Chance to enhance practical experience in modern data warehouse delivery.
Expana
RELX
Get handpicked remote jobs straight to your inbox weekly.