(Junior) Office 365 Consultant
- Remote
- Freelancer
- Management Consulting
Your Tasks
Data Collection: Gather, clean, and preprocess data from various sources, using Python, SQL, or other relevant languages, to ensure data quality and accuracy.
Data Analysis: Conduct exploratory data analysis (EDA) to identify patterns, trends, and insights within datasets, employing strong mathematical and statistical knowledge.
Data Visualization: Create clear and informative data visualizations using tools like Power BI, including proficiency in reporting and dashboarding.
Data Modeling: Build and maintain data models, especially Star architecture, and apply them to data analysis.
ETL and ELT: Develop ETL and ELT pipelines for data processing, transformation, and loading.
Big Data: Work with big data sets, demonstrating experience in handling and analyzing large volumes of data.
API Integration: Retrieve and store data through REST APIs and access various types of databases, both relational and non-relational.
Advanced Analytics: Utilize advanced analytics tools, including M-Language (Power Query) and DAX, for in-depth data analysis.
Process Automation: Apply an in-depth understanding of process automation to streamline data-related workflows.
Agile Principles: Work in alignment with Scrum and Agile principles, contributing to agile development methodologies.
Software Development: Experience in the software development lifecycle is a plus, demonstrating the ability to collaborate on software projects.
Required Skills and Qualifications for Junior Data Analysts:
Programming Languages: Proficiency in one or more of the following languages: Python, SQL, JavaScript, CSS, HTML, with the ability to write code for data analysis and manipulation.
Data Warehousing: Familiarity with data modeling, especially Star architecture, for effective data storage and retrieval.
Power BI: Proficiency in Power BI for reporting and dashboard creation, including experience with the Power BI Cloud service environment.
Process Automation: In-depth understanding of process automation to improve data-related workflows.
Big Data: Experience in handling and analyzing big data sets efficiently.
API Integration: Experience with REST APIs for retrieving and storing data, including accessing various database types.
Advanced Analytics: Advanced knowledge of M-Language (Power Query) and DAX for in-depth data analysis.
Agile Methodologies: Strong understanding of Scrum and Agile principles, contributing to agile development methodologies.
Software Development Lifecycle: Experience in the software development lifecycle is a plus, showcasing the ability to collaborate on software projects.
Microsoft Environment: Proficiency in Microsoft tools and platforms, including SharePoint, Teams, PowerApps, Power Automate, and Azure.
Team Collaboration: Experience working effectively in a team and contributing to collaborative data projects.
Creativity: Ability to tell stories with data and a „can-do attitude“ to find innovative solutions.
Certifications: Possession of one or more Agile certifications (e.g., Scrum Developer CSD, Scrum Master CSM) and/or data-related certifications (e.g., MS SharePoint, MS Dynamics 365 Developer Associate, MS Power BI Data Analyst Associate, Microsoft 365 Certified, Data Analyst certification) is a plus.