Source description
About the role
You will be responsible for supporting business intelligence, reporting, and data-driven decision-making by collecting, cleaning, and analyzing structured and unstructured data from multiple sources. Additionally, you will develop reports, dashboards, and KPIs to aid in business operations and strategic decisions. Your expertise in SQL, Python, BI tools, and statistical analysis will be crucial in transforming complex datasets into actionable insights. Experience with cloud data platforms and AI-enabled analytics tools will be advantageous. - Collect, clean, and analyze structured and unstructured data from multiple sources - Develop reports, dashboards, and KPIs to support business operations and strategic decisions - Perform exploratory data analysis (EDA) to identify trends and patterns - Generate actionable insights and recommendations based on business requirements - Ensure data accuracy, consistency, and integrity across reports and databases - Write complex SQL queries for data extraction and analysis - Work with joins, subqueries, CTEs, window functions, and indexing techniques - Develop and maintain stored procedures and optimize query performance - Manage and validate large datasets for reporting purposes - Perform statistical analysis using Python and R - Conduct regression analysis, hypothesis testing, clustering, and forecasting - Utilize Pandas and NumPy for data transformation and manipulation - Automate repetitive data processes and workflows - Design and develop interactive dashboards using Power BI and Tableau - Create data models and KPI reports to track business performance - Utilize DAX functions and storytelling techniques to deliver meaningful insights - Collaborate with stakeholders to understand reporting requirements - Work with Snowflake for cloud data warehousing and analytics - Develop operational reports using ServiceNow Analytics - Leverage AI tools such as ChatGPT, Power BI Copilot, and Excel AI for automated insights and reporting The company does not provide any additional details in the job description. You will be responsible for supporting business intelligence, reporting, and data-driven decision-making by collecting, cleaning, and analyzing structured and unstructured data from multiple sources. Additionally, you will develop reports, dashboards, and KPIs to aid in business operations and strategic decisions. Your expertise in SQL, Python, BI tools, and statistical analysis will be crucial in transforming complex datasets into actionable insights. Experience with cloud data platforms and AI-enabled analytics tools will be advantageous. - Collect, clean, and analyze structured and unstructured data from multiple sources - Develop reports, dashboards, and KPIs to support business operations and strategic decisions - Perform exploratory data analysis (EDA) to identify trends and patterns - Generate actionable insights and recommendations based on business requirements - Ensure data accuracy, consistency, and integrity across reports and databases - Write complex SQL queries for data extraction and analysis - Work with joins, subqueries, CTEs, window functions, and indexing techniques - Develop and maintain stored procedures and optimize query performance - Manage and validate large datasets for reporting purposes - Perform statistical analysis using Python and R - Conduct regression analysis, hypothesis testing, clustering, and forecasting - Utilize Pandas and NumPy for data transformation and manipulation - Automate repetitive data processes and workflows - Design and develop interactive dashboards using Power BI and Tableau - Create data models and KPI reports to track business performance - Utilize DAX functions and storytelling techniques to deliver meaningful insights - Collaborate with stakeholders to understand reporting requirements - Work with Snowflake for cloud data warehousing and analytics - Develop operational reports using ServiceNow Analytics - Leverage AI tools such as ChatGPT, Power BI Copilot, and Excel AI for automated insights and reporting The company does not provide any additional details in the job description.