Job Summary
The Power BI Developer possesses good knowledge and experience to assist in overall design, development, and implementation of BI Applications. The role is involves working in areas of solution design, development, performance tuning and troubleshooting.
This role must have hands-on experience in Fabric, Power BI, Python, DAX functions, data warehouse design, SQL databases ,SQL statements.
Essential Duties and Responsibilities
- Assist in designs, implements, and supports the enterprise BI dashboards and reports.
- Loading and Transforming data from SAP BW into Fabric Lakehouse.
- Develops reports, dashboards & KPI scorecards and aggregate data from various sources.
- Balance functionality look/feel and performance to ensure an excellent user experience which is a strong focus of the role.
- Writing complex SQL queries and functions.
- Work with other teams to gather and document reporting requirements and to use the underlying data sources/data warehouses to meet business requirements.
- Liaise with the SAP Data Warehouse team to design the data model.
- Support to conduct training programs and knowledge transfer sessions for junior developers as needed
- Other duties as assigned
Additional Responsibilities
Education
- Bachelor's Degree or equivalent experience required
Work Experience
- 4-5 years of relevant experience in the areas specified under Essential Duties and Responsibilities
Preferred Knowledge, Skills and Abilities
- Good experience with and in-depth knowledge of Power BI, M and DAX functions
- Very strong in SQL and basic/Advance in ADF(Azure Data Factory)
- Good knowledge in Fabric
- Knowledge on Data warehousing concepts.
- Experience as a Power BI Developer.
- Knowledge and experience in development of reports, dashboards, KPI scorecards, aggregating data from multiple sources
- Experience in designing dashboards on phones and tablets.
- Background in data warehouse design (e.g. dimensional modeling) and SQL databases and SQL statements.
- Good experience in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse
- Understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.
- Proven abilities to take initiative and be innovative
- Analytical mind with a problem-solving aptitude
- Ability to work autonomously in a fast-paced & complex environment with a self-motivated work ethic; utilize sound judgment with an ability to manage multiple priorities with a sense of urgency
- Ability to work in a virtual environment in a global organization
- Able to comply with the company's safety and quality policies at all times
