Data Analytics Manager
IQ-EQ
- Pasig City, Metro Manila
- Permanent
- Full-time
- Experience of working with structured and unstructured database warehouses (SQL server) and data lakes (Snowflake) both on-prem and in cloud (AWS, Azure or GCP) (at least 5+ yrs. on SQL and 2+ yrs. on Snowflake)
- Advance knowledge of Python/Spark packages for data analysis (panda, Numpy, scikit, etc.) as well as data visualisation (matplotlib, plotly, dash, etc.)
- Advanced knowledge of Tableau or Power BI (at least 3 yrs of demonstrable experience)
- Experience of various java libraries for front end development (i.e. D3, react, node, etc.)
- Knowledge of various ETL/ELT tools like Alteryx, dbt, airflow, SSIS
- Engage with internal stakeholders from operations as well as client services team to understand their reporting and dashboard requirements
- Create a high-level architecture of the BI solution
- Conduct in-depth exploratory data analysis and define business critical features
- Work with database administrators, solutions architect, data engineers and data scientists to collaboratively develop advanced visualization (BI dashboards)
- Retrieve Data from Databases. Optimize SQL server queries to efficiently and quickly retrieve data.
- Ensure updates to tickets and work in progress are well commutated and escalations regarding the support being provided is kept to a minimum
- Design Data Solutions. Develop and create and design best-practice data warehouse solutions that support business reporting tasks. This is achieved using different programs and software, such as Tableau, MS SQL Server and Microsoft Excel.
- Create and Maintain Reporting Processes. Develop and maintain a record of the different reporting processes in place.
- Resolve IT and Data Issues. When database issues arise or support requests come in through the help desk, BI Developers work to resolve these problems. This requires an understanding of legacy solutions and issues.
- Degree level education is preferred but equivalent professional experience in IT is acceptable.
- A Minimum of 5 years' experience in a (senior) developer role or similar DB experience.
- Experience with other visualization and reporting tools like Tableau, Power BI, Qlikview, Looker, SSRS
- Experience with MS Excel including PowerPivot
- Experience of supporting a variety of SQL based applications.
- Hands on experience with SQL 2012 and above
- Experience with T-SQL and the ability to analyse queries for efficiency.
- Experience with MS SQL Server suite, including SSIS and SSRS
- Experience with version control software e.g. Git, Bitbucket