Data Analyst (Homebased) at Outsourced.ph

About the Job

Job Description

• As our Data Analyst you will be instrumental in analyzing data discrepancies and data lineage in our operational life cycle and assist with solving data problems. This position will report to the VP, Head of Data Operations.

Responsibilities:

• Perform extensive data validation/quality assurance analysis within large datasets
• Build proactive data validation automation to catch data integrity issues
• Ability to organize and lead meetings with business and operational data owners
• Coordinate and communicate between business users and the data warehouse organization, balancing requirements, and resources to solve business problems
• Strong ability to identify, troubleshoot and resolve data issues
• Ability to build tabular and/or visualization reports as needed
• Work closely with engineering and operations to document business processes
• Work independently and with team members to understand database structure and business processes
• Design SQL/Python scripts to directly query and analyze internal and external data sources to package together clear, actionable findings
• Provide timely, valuable solutions for ad hoc analyses via SQL with a focus to detail on crafting scripts that can be easily manipulated to efficiently address similar future analyses
• Own the design of advanced analytics dashboards and KPI reports in our business intelligence tool starting from requirements gathering across media, strategy, and senior leadership teams to the delivery of a final, polished reports in production
• Grow to serve as the team’s subject matter expert for advanced analytics and report design, offering insights and suggestions on what potential problems the team should be solving
• Work closely with Accounts and Media teams and support their analysis and data needs
• Work closely with the Analytics Team to deliver actionable insights to the organization

Qualifications

​​​​​​Must Have: 

• Minimum of 3 years working experience in technical data analysis, data science, or data warehousing with proven business analysis experience
• Experience writing SQL, views, stored procedures, functions, and triggers
• Previous experience on a data team in an agile environment preferred
• Experience designing reports and dashboards Tableau
• Excellent communication, presentation, writing, and Excel skills are a must
• Experience in an analytical role with a heavy focus on querying data, analyzing, and clearly presenting analyses to stakeholders across the organization
• A flexible, collaborative teammate with the ability to deliver both high level explanations of complex problems while also able to deep dive into complex problems
• Confidence, energy, drive, and accountability is key as the impact of your work is crucial to our success
• Someone who can work independently or autonomously

Nice to Have: 

• Cloud based and AWS experience i
• Experience with Google Analytics, Google Tag Manager 
• Python experience 
• Power BI, or equivalent BI product

Work Location:

• Homebased 
• Work hours: Tues to Sat, 12am to 9am