The core responsibilities and tasks of the Data Engineer & Analytics role revolve around essential functions that contribute to the overall purpose of the job. These functions include:
- Conducting advanced data engineering and analytics activities to support key performance metrics.
- Resolving complex data engineering and analytics problems through comprehensive analysis of various factors.
- Collaborating with stakeholders and department leaders to gather and clarify data requirements for sophisticated data engineering solutions and advanced analytics.
- Developing and optimizing data pipelines, ETL processes, and workflows using tools such as SSIS, Azure Data Factory, Databricks, Talend, Informatica, StreamSets, or their equivalents.
- Designing and implementing data models, database structures, and schemas to ensure efficient data storage, retrieval, and advanced analytics.
- Creating and maintaining reports, dashboards, and visualizations using tools like Microsoft Power BI, Tableau, Looker, QlikView, SSRS, or their equivalents.
- Collaborating with cloud platforms like AWS and Azure to architect and implement scalable and robust data solutions for advanced analytics.
- Applying advanced database performance tuning techniques to optimize data processing, query performance, and advanced analytics algorithms.
- Conducting in-depth data analysis and mining to identify patterns, correlations, and anomalies for further investigation and advanced analytics insights.
- Contributing to industry benchmarking analysis and developing quantitative business cases based on data insights and advanced analytics.
- Preparing and delivering presentations and recommendations to managers and senior leaders, providing expert consultation on data engineering, analytics, and advanced analytics techniques.
- Generating forecasts, recommendations, and strategic/tactical plans based on data analysis, advanced analytics, and market knowledge.
- Identifying and resolving data-related errors and issues for end users, implementing functional solutions, and providing necessary training and support for advanced analytics.
Snowflake, Snowflake schema, Microsoft SQL Server, Microsoft SQL Server Database, SQL Server Analysis, SQL Server Business Intelligence, SQL Server DBA, Azure SQL Database, Datastage ETL, ETL - Extract Transform Load, Datastage ETL, ETL - Extract Transform Load, SSIS ETL, Redshift, Azure Databricks, Databricks, Azure Databricks, Talend, Create Ssrs Reports, Microsoft SSRS, SSIS SSRS, Create Ssrs Reports, Tableau, Performance Tuning, SQL Performance Tuning, Data Analytics, Quantitative Data Analysis