Super exciting opportunity to join Sydney based Data Consulting firm. Hands on end to end project related to data analytics. The SQL Server and Power BI Analyst is responsible for leveraging their expertise in SQL Server and Power BI to gather, analyze, and visualize data, providing valuable insights to support decision-making processes within the organization. With 1-2 years of experience, the candidate will be expected to contribute to database management, data manipulation, report creation, and dashboard development using SQL Server and Power BI.
Key Responsibilities:
1. Data Analysis and Manipulation:
- Write complex SQL queries to extract, transform, and manipulate data from various sources.
- Perform data cleansing and validation to ensure data accuracy and integrity.
2. Database Management:
- Assist in database design, maintenance, and optimization.
- Implement and maintain database objects such as tables, views, and stored procedures.
3. Report Development:
- Create and customize reports using Power BI, showcasing key performance indicators (KPIs) and trends.
- Collaborate with stakeholders to understand reporting requirements and deliver insights.
4. Data Visualization:
- Present data-driven insights to various teams and management, enabling informed decision-making.
- Translate complex data into easy-to-understand visualizations.