Data Scientist

Job Summary:

We are seeking a highly motivated Data Scientist to join our team.

The Data Scientists will be responsible for designing, implementing, and optimizing data solutions using Microsoft’s data platform technologies, including Azure Data Services, SQL Server, Power BI, and Fabric. This role involves collaborating with business stakeholders to gather requirements, develop data models, and deliver actionable insights through reports and dashboards.

Key Responsibilities:

• Design, develop, and maintain data models, ETL/ELT pipelines, and data warehouses using Microsoft technologies (SQL Server, Azure Data Factory, Synapse Analytics, Databricks, etc.).

• Analyze business requirements and translate them into technical specifications for data solutions.

• Perform data profiling, cleansing, and transformation to ensure data quality and integrity.

• Collaborate with business data engineers, and BI developers to understand data needs and deliver solutions.

• Collaborate with business stakeholders to understand data needs and translate them into technical requirements.

• Implement and maintain data governance, metadata management, and security best practices.

• Troubleshoot and resolve data-related issues and performance bottlenecks.

• Analyze data from Microsoft Dynamics 365 (CRM) to provide insights that support sales, marketing, and customer service operations.

• Develop dashboards, reports, and KPIs using Power BI and other Office 365 tools (Excel, Power Query, Power Automate).

• Cleanse, validate, and ensure data quality within the CRM system.

• Monitor data integrity and work on deduplication, normalization, and enrichment tasks.

• Develop and maintain documentation related to data models, processes, and definitions.

• Perform ad-hoc analysis and deliver data-driven recommendations.

• Contribute to data governance and compliance efforts, ensuring data usage adheres to company and regulatory standards.

Required Skills & Experience:

• Bachelor's degree in Computer Science, Information Systems, Statistics, Mathematics, Economics, or a related quantitative field.

• 5+ years of experience as a Data Analyst, Business Intelligence Analyst, or similar role with a strong focus on Microsoft data technologies.

• Strong proficiency in SQL for data querying, manipulation, and database management.

• Expertise in Microsoft Power BI, including:

o Connecting to various data sources.

o Data modeling (DAX, relationships).

o Creating interactive reports and dashboards.

o Publishing and managing reports in Power BI Service.

• Design, develop, and maintain data pipelines, ETL processes, and data warehouses using Azure Data Factory, Synapse Analytics, SQL Server, and Databricks.

• Proven experience in data cleaning, transformation, and validation.

• Excellent analytical and problem-solving skills with a keen attention to detail.

• Strong communication and presentation skills, with the ability to explain complex data insights to non-technical audiences.

Preferred Qualifications:

• Microsoft Certified: Azure Data Engineer Associate, Data Analyst Associate, or similar certifications.

• Experience with cloud data architecture, big data, or real-time data processing.

• Knowledge of DevOps practices for data projects (CI/CD pipelines for data deployments).

• Familiarity with tools like Git, Azure DevOps, or other version control systems.