• Strong dashboard/report production experience in PowerBI.
• Experience in ETL tools including Qlik Replicate, Azure Data Factory
• Experience in Azure Data Lake, Azure SQL, Azure Synapse
• Strong SQL, data querying, and data analysis skills
• Must have an understanding of how to interpret customer business needs and translate them into application and operational requirements.
• Experience working with diverse set of data sources and off-the shelf/enterprise/bespoke applications
• Preferably with experience in Python and machine learning
• Acts as a technical lead and subject matter expert for the project team on data, data platform, and data engineering related requirements including integration tools and best practices used in analytics.
• Acts as a technical lead and main person for the team on design and development of tools and best practices used in analytics data management including but not limited to SAS, Azure Cloud, other data warehouses, data lakes, and data hubs.
• Active participation and involvement in Design & Development of data warehouses, data lakes, and data hubs, Data Governance tools and enterprise solutions.
• Build the data and analytics teams by assessing and learning data engineering tools and data visualization tools
• Train and educate the organization as we transform towards a data-driven organization
• Build processes and tools to govern data analytics across the organization
• Able to Understand data requirements in an assigned project, design, develop, and expand data requirements to be realized following AIA Philam’s data and data platform strategy from ETLs build, data warehouse build, data stores, data lakes.
• Able to Design ETL environment for ingestion of data from source to destination
• Able to Design and test data stores, curated layers (including data mart, data warehouse) in either on-
premise or Azure environment
• Able to Design and test dashboards/reports created through PowerBI or websites
• Able to Analyze source data and data follows and ensures solutions for data consumptions or integration adheres to enterprise and data architect standards
• Able to Implement data pipelines to bring data at reach to platforms or tools used by different business units. Maintain development roadmap aligned with product and infrastructure objectives to support advanced data solutions
• Able to Design, implement, and test solutions for integrating, streaming, processing, and storage of data. This also includes data in data warehouses, data lakes, and/or data hubs and handling of structured, semi- structured, and unstructured data
• Able to Provide subject matter expertise to data, data governance, and data platform solutions in adherence to AIA Philam standards
• Use Business Intelligence Tools to design analytics dashboards for management. Develop dashboard visualizations, metrics, KPI