Data Analyst

Role & responsibilities

Job description:

Data Engineering & ETL:

• Design, develop, and maintain SSIS packages or Azure Data Factory pipelines or similar mechanisms for data extraction, transformation, and loading (ETL) from various sources, including multiple D365 CRM instances, Dataverse, SharePoint Sites, etc..
• Implement data cleansing, validation, and transformation processes to ensure data quality and consistency.
• Optimize data pipelines for performance and scalability.
• Develop and maintain daily scheduled jobs for data updates from diverse data sources.
  Reporting & Analytics:
• Design and develop comprehensive reports and dashboards using tools like SSRS, Power BI or similar, to visualize key performance indicators (KPIs) and provide actionable insights.
• Conduct ad-hoc data analysis to answer business questions and support decision-making.
• Present findings and recommendations to stakeholders in a clear and concise manner.
• Configure automated notifications to stakeholders for reporting KPIs, pending actions etc.
  Data Management:
• Extract, analyse, and report on data from multiple data sources.
• Understand the applications data models and entity relationships.
• Troubleshoot data-related issues, implement corrective actions and suggest preventive actions.
  Data Maintenance & Specification Documentation:
• Monitor data quality and implement processes to maintain accuracy.
• Maintain documentation for data pipelines, reports, dashboards and data models.
  Data Migration:
• Create and execute data migration packages to copy data from between different sources or CRM instances over to standardized Eurofins solution on D365 CRM.
• Ensure data integrity and accuracy during migration processes.
• Document data migration processes and procedures.

EXPERIENCE:

• 3+ years of experience as a Data Analyst or Data Engineer
• Strong experience in creating reports and dashboards using Power BI or similar tools.
• Experience in developing and maintaining ETL for large datasets
• Proficiency in SQL for data querying and manipulation.
• Strong understanding of data warehousing concepts.
• Experience with data migrations and automating jobs.
• Experience in D365 CRM is not a mandatory requirement

SKILLS:

• Excellent analytical and problem-solving skills.
• Excellent verbal and written communication and interpersonal skills.
• Experience in working with cross functional teams spread across geographies is a plus.
• Excellent analytical and problem-solving skills.
• Ability to work independently and as part of a team.
• Strong attention to detail.
• Knowledge of data governance best practices.

PRERRED QUALIFICATIONS:

• Azure Data Engineer certifications
• Microsoft Power BI or equivalent certifications.