Data Analyst

Description

Job Summary: A professional to provide support in data collection, processing, and organization; create Power BI dashboards; and develop reports, contributing to strategic analysis. Key Highlights: 1. Support in data collection, processing, and organization 2. Creation and enhancement of Power BI dashboards 3. Support in database modeling and structure creation Responsibilities: * Support data collection, processing, and organization from diverse sources to inform analysis and strategic decision-making. * Contribute to the creation, enhancement, and maintenance of interactive dashboards in Power BI, ensuring clear and objective visualization of key performance indicators (KPIs) and metrics. * Participate in developing and updating periodic reports using BI tools and predictive analytics. * Join sprint planning and system rollout meetings, providing data-driven insights. * Support execution of database queries and scripts for extracting and analyzing relevant information. * Collaborate on database modeling and creation of database structures and objects according to project requirements. * Assist in developing data pipelines, import routines, and ETL (extract, transform, load) processes. * Support building and consolidating analytical reports, ensuring coherence and integrity of presented information. * Support publishing and updating systems in production environments, ensuring data consistency. * Perform adjustments and optimizations on database scripts to ensure improved performance and maintenance of BI-related tables. * Contribute to researching, evaluating, and applying new methodologies aimed at continuously improving internal processes and technological modernization. * Support automation of routines and processes related to data management and manipulation. * Document and record data manipulation and processing procedures to ensure transparency and traceability of analyses. * Assist in monitoring and validating KPIs and metrics, ensuring information timeliness and accuracy. * Support data cleaning, standardization, and transformation processes to ensure data quality and consistency. Required Knowledge: * Hands-on experience with SQL and Power BI. * Basic knowledge of SQL for database querying and development (SQL Server, Oracle, MySQL, and PostgreSQL). * Practical experience creating and maintaining dashboards. * Knowledge of AWS - S3, Parquet, Glue, Spark, and Athena. * Advanced proficiency in Excel and Google Sheets for data analysis and manipulation. * Familiarity with Python programming. * Experience with ETL tools and development of data import routines. Minimum Education: Bachelor's Degree * Health Insurance * Dental Insurance * PASS Support Program * Transportation Allowance * Meal or Food Voucher * Life Insurance * Well Hub