Analytics Engineer

About the Role:

The Senior Analytics Engineer will be responsible for designing, developing, and maintaining end-to-end data solutions. This includes building robust data pipelines that extract from source systems into the data warehouse, transforming raw data into well-modeled datasets readily available for business intelligence, and creating interactive and user-friendly data visualizations using Power BI. The role requires close collaboration with cross-functional teams to empower business stakeholders to derive actionable insights and make data-driven decisions across the organization.

Scope of Work and Responsibilities

• Design and develop scalable data pipelines that extract data from various source systems and transform data inside the data warehouse.
• Transform data into data models that adhere to dimensional modelling techniques i.e. Kimball.
• Create visually compelling and informative dashboards and reports using Power BI.
• Collaborate with data analysts and stakeholders to understand data requirements and deliver meaningful insights.
• Ensure data accuracy and integrity through validation and quality checks.
• Design interactive, user-friendly visualizations tailored to different stakeholder needs.
• Participate in Agile development processes including Scrum and Kanban events.
• Prepare high-level and detailed technical designs for data solutions.
• Apply best practices in coding, testing, and deployment including CI/CD pipelines.
• Stay updated with the latest trends in data engineering and visualization and suggest process improvements.
• Perform other relevant tasks as assigned.

1. Requirement and Qualification (Education & Work Experience)

Educational Requirements:

Graduate of Bachelor of Science in Information Technology, Engineering, Data Science, or other related fields.

Relevant Experience and Other Requirements:

• At least five (5) years of experience in a senior analytics engineering or developer role.
• At least five (5) years of experience in architecture, design, and development of integrated systems.
• Strong analytical and problem-solving skills.
• Strong understanding of dimensional modelling techniques
• Familiarity with software development lifecycle and project management methodologies.
• Proven experience with relational databases like Oracle, SQL Server, etc.
• Proven experience developing data pipelines using Python, PySpark and SQL.
• Extensive experience with Microsoft 365 applications.
• Familiarity with cloud platforms such as Azure or AWS.
• Experience in Agile methodologies (e.g., Scrum or Kanban).
• Proficiency in Power BI; experience with Tableau and other visualization platform is a plus.
• Experience with Azure DevOps is preferred.
• Experience with Azure Cloud Services and CI/CD pipelines is an advantage.
• Certifications in Secure Coding, Scrum, or DevOps are a plus.
• Experience working in teams of five or more members.
• Ability to work with senior executives from diverse cultures.
• Excellent oral and written communication skills in English.

Reporting and Coordination

• The Senior Analytics Engineer will report to the Project Manager and/or designated staff. The Analytics Engineer will work closely with business stakeholders, data analysts, and other teams within the organization.

High Level and Detailed Technical Designs

• Unit Tested and Secure Code

Interactive and Insightful Dashboards

Work Arrangement

• Work arrangement discussion and an opportunity for the candidate to ask questions
• Hybrid, requiring employees to report onsite three times a week. If the user unit requires contractors to report to HQ, compliance is mandatory.
• Work Schedule is from 8:00AM 5:00PM Manila Time.