Power BI Developer - SQL/Azure Data Factory (5-7 yrs)

About Awign Expert :

Awign Expert is an Enterprise focused platform that helps businesses Hire, Assess and Manage high skilled resources for Gig Based Projects. We provide our Experts a gateway to work for and build a freelance/consulting career with large scale Enterprises. We are a newly launched business division of Awign, which is one of the pioneers and currently the largest player in the Gig Economy in India. Here at Awign we are changing how the world works with a vision to uplift millions of Careers.

Location : Bangalore, Pune, Hyderabad

Duration : 6 Months

Overall Experience : 5 - 7 Years

Must-Have Skills :

- Power BI

- SQL

- ADF

Responsibilities :

Report and Dashboard Development :

- Create insightful and interactive reports and dashboards using BI tools (e.g. Power BI) to visualize and communicate key performance indicators.

- Collaborate with business users to gather reporting requirements and ensure deliverables meet their needs.

- Optimize SQL queries for better performance and responsiveness.

- Troubleshoot and resolve data-related issues in a timely manner.

- Stay informed about emerging trends and technologies in the BI domain.

- Make recommendations for adopting new tools or methodologies to improve BI capabilities.

- Develop interactive Dashboards reports and hands on experience working with complex DAX queries.

- Knowledge of working on various data sources and handling multiple mode of reports (e.g. Import, Direct query).

- Ability to work on various databases PostgreSQL, MSQL etc.

- Develop robust, high-quality code with SQL programming, writing stored procedures, View and Data Modelling knowledge.

- Knowledge of advanced SQL programming concepts like CTE (Common Table Expressions), SUB-queries and handling complex joins etc.

- Proficient into creating desired index, tuning SQL queries, debug and analyze performance issues.

- Responsible for ensuring quality delivery of code through testing techniques.

- Experience developing engaging visual reports/dashboards

- Experience in creating and applying themes, templates

- Good understanding of l latest PBI features, best practices, limitations

- Good experience on designing the pages

- Basic understanding of the data modeling

Qualification :

- Bachelor's or Master's degrees in Computer Science, Computer Engineering, or related technical discipline.

- Ability to work independently and to adapt to a fast-changing environment.

- Creative, self-disciplined, and capable of identifying and completing critical tasks independently and with a sense of urgency.