Senior Data Analytics Specialist

The Data Engineer will play a critical role in designing, developing, and maintaining data infrastructure. This role involves working closely with data scientists, analysts, and stakeholders to ensure data integrity, build robust data pipelines, and deliver insightful analytics solutions.

Responsibilities include stakeholder management, data modeling, data quality management, and project management. The ideal candidate has a strong background in data engineering, analytics, and a keen eye for detail.

• Work with data scientists, analysts, and stakeholders to understand data needs.
• Analyze and interpret data to identify trends, opportunities, and areas for improvement.
• Analyze business needs of stakeholders and customers.
• Gather customer requirements via workshop questionnaires, surveys, site visit, workflow storyboards, use cases, and scenario mappings.
• Translate business requirements into functional requirements.
• Create extensive project scope documentations to keep project and client teams on the same page.
• Collaborate with cross-functional teams to integrate analytics insights into operational processes.

Data Modeling:

Develop and maintain data models to support analytics and reporting.

Design dimensional models and star schemas to effectively organize retail data including sales, inventory, customer behavior, and product performance metrics.

Collaborate with stakeholders to translate analytical requirements into efficient data structures and ensure models align with reporting needs.

Document data lineage, business rules, and model specifications to ensure knowledge transfer and maintain data governance standards.

Data Quality Management & Governance:

Develop and implement comprehensive data quality frameworks and monitoring systems to ensure accuracy, completeness, and consistency of retail and e-commerce data.

Lead root cause analysis of data quality issues and implement preventive measures to minimize future occurrences.

Implement data cleansing and enrichment processes to improve overall data quality.

Provide training and support to team members on data quality best practices and validation procedures.

Project and Team Management:

Lead end-to-end analytics projects from initiation to delivery, ensuring adherence to timelines, budgets, and quality standards.

Coordinate cross-functional project teams including data engineers, analysts, and stakeholders to achieve project objectives.

Develop detailed project plans, resource allocation strategies, and risk mitigation plans for analytics initiatives.

Mentor junior team members and provide technical guidance on analytics engineering best practices and methodologies.

Facilitate project status meetings, manage deliverable timelines, and communicate progress updates to senior leadership and clients.

Establish and maintain project documentation standards, including technical specifications, testing protocols, and deployment procedures.

Identify and resolve project bottlenecks, resource constraints, and technical challenges to ensure successful project completion.

Drive continuous improvement initiatives within the team by implementing agile methodologies and optimizing workflow processes.

Qualifications:

Bachelor's degree in Computer Science, Data Science, Engineering, or related field.

6+ years of experience in analytics.

Technical Skills:

Proficiency in SQL and database technologies.

Core expertise with dbt (data build tool).

Experience with data pipeline tools (e.g., Apache Airflow).

Familiarity with cloud platforms (e.g., AWS, Google Cloud).

Knowledge of Python or R.

Experience with data visualization tools (e.g., Tableau, Power BI).