Data Analyst - Power BI/Excel (4-5 yrs)

Job Description :

As a Data Analyst you will play a pivotal role in the visualization and analysis of critical data for high-impact projects.

You will be responsible for creating, modifying, and maintaining complex data dashboards, primarily for our clients in the sports and construction sectors.

This role requires a high level of proficiency in Power BI, Excel, and other data visualization tools, along with strong communication skills for client interactions.

Key Responsibilities :

Data Visualization and Dashboard Development :

- Develop and maintain data dashboards using Power BI, ensuring accurate and real-time representation of data.

- Make periodic updates to dashboards based on client feedback, including publishing different versions in separate workspaces.

Data Validation and Delivery :

- Engage in data validation processes to ensure accuracy and reliability of dashboard data.

- Deliver finalized dashboards to clients, ensuring they meet specified requirements.

Client Interaction and Support :

- Actively participate in weekly meetings to discuss client requirements and feedback.

- Respond to client queries regarding dashboard visualizations and data interpretation.

- Train clients on understanding and using the dashboards effectively.

- Collaborate with team members, guiding them in client communication and issue resolution.

Project Management and Reporting :

- Maintain a task tracker to manage and prioritize ad-hoc tasks and project deliverables.

- Ensure clear communication of project statuses and updates within the team and to stakeholders.

Technical Skills and Maintenance :

- Utilize complex DAX functions and data preparation techniques in Power BI.

- Apply SQL queries in Snowflake for advanced data analysis.-

- Perform routine maintenance and updates of dashboards based on client feedback and changing requirements.

Technical Skills :

Advanced Proficiency in Power BI :

- Expertise in creating complex dashboards and visualizations tailored to client needs.-

- Skilled in using DAX (Data Analysis Expressions) for creating custom calculations and advanced data manipulation.

- Experience with data preparation and modeling within Power BI, including the use of Power Query.

Excel Mastery :

- Advanced skills in Excel for data analysis, including the use of pivot tables, advanced formulas, and data visualization techniques.

- Ability to manage large datasets within Excel and integrate Excel with other data tools.

Lucid Charts :

- Proficiency in using Lucid Charts for creating flowcharts, process diagrams, and other visual representations of data and workflows.

SQL and Database Management :

- Competence in writing and optimizing SQL queries, particularly within Snowflake environments.

- Understanding of database structures and the ability to efficiently extract, transform, and load data (ETL).

Familiarity with Microsoft 365 Suite :

- Comfortable using various applications within the Microsoft 365 suite, such as SharePoint, Teams, and others for collaboration and data sharing.

- Ability to integrate these tools with data analysis workflows.

Data Analysis and Problem Solving :

- Strong analytical skills with the ability to derive insights and recommendations from datasets.

- Skill in identifying, analyzing, and resolving complex data-related issues.

Communication and Training :

- Ability to clearly articulate technical concepts to non-technical audiences, including clients.

- Experience in training clients or team members on the use of data tools and dashboards.

Requirements :

Qualifications :

- Bachelor's degree in Data Science, Statistics, Computer Science, or a related field.

- Proficient in Power BI, Excel (advanced), and Lucid Charts.

- Experience with SQL and familiarity with Snowflake.

- Strong analytical skills and attention to detail.

- Excellent communication and client-handling skills.

- Ability to work in a fast-paced, dynamic environment.

Preferred Experience :

- Prior experience in data analysis or a similar role.

- Knowledge of Microsoft 365 suite.

- Experience working with data in the sports and/or construction industries