Data Analytics Specialist - SQL / ETL

Responsibilities :

• Develop, design, and manage interactive dashboards and reports using Spotfire and Tableau.
• Analyze complex data sets to derive actionable insights and support data-driven decision-making processes.
• Write and optimize advanced queries using SQL and PL / SQL for data extraction and transformation.
• Collaborate with cross-functional teams to understand business requirements and provide customized analytics solutions.
• Ensure data integrity, security, and consistency across various data sources and platforms.
• Monitor, troubleshoot, and resolve issues in analytics tools and data pipelines.
• Stay updated on the latest trends and technologies in data analytics and visualization.
• Understand business requirements in BI context and design data models to transform raw data into meaningful insights
• Perform ETL operations using SQL in conventional environments (MSSQL / Oracle), Big data environments (Hadoop), and data virtualization tools (Denodo).
• Manage and maintain databases to ensure data quality, integrity, and security, optimizing database performance and scalability.
• Interpret business requirements from cross-functional teams and develop advanced analytical and reporting solutions.
• Apply statistical knowledge and its applications to drive business insights.
• Leverage supply chain knowledge and general business acumen to inform data-driven decisions.
• Deliver valuable solutions to business problems and present findings and recommendations to Management.
• Create dashboards and interactive visual reports using Power BI
• Analysing and presenting data through reports that aid decision making
• Convert business requirements into technical specifications and decide timeline to accomplish
• Create relationships between data and develop multidimensional data models
• Chart creation and data documentation explaining algorithms, parameters, models and relations
• Design, develop, test and deploy Power BI scripts and perform detailed analytics
• Perform DAX queries and functions in Power BI
• Analyse current ETL process, define and design new systems
• SQL querying for best results, use of filters and graphs
• Developing Dashboards : Created dynamic, KPI-driven dashboards for [specific industries, e.g., retail, finance, or logistics], increasing visibility into key performance metrics.
• DAX Implementation : Used DAX functions to create custom measures for sales performance, trend analysis, and forecast modeling.
• Data Connectivity : Integrated multiple data sources into Power BI, including SQL databases, Excel files, and online services.
• Requirement Gathering : Worked closely with business teams to define objectives, ensuring dashboards meet their analytical needs.

Requirements :

ref : hirist.tech)