EXOedge - Power BI Developer (4-8 yrs)

At EXO Edge, we hire individuals who are fun-loving, embrace life, and are ambitious. We are defined by our core values Team Results Accountability and Quality (TRAQ). If these values resonate with you and you're excited to join our journey, please review the job description below:

We are seeking a detail-oriented and experienced Power BI Developer to join our Data and IT team. As a Power BI Developer, you will design, develop, evaluate, and test data infrastructures. Source system analysis, data modeling, business measure development, and report/visualization formatting. Ensure compliance with policies and procedures, safety, state and federal laws, regulations, and standards.

What to expect in your journey :

- Process of consolidating separate data and reporting suites.

- Ensure business users are enabled with carefully curated data visualizations with accurate, reliable, and consistent data to monitor contract performance and assist in decision-making.

- Determining reporting needs, developing, and building reports, training users, and establishing reporting cadences and processes.

- Responsible for managing and optimizing the SharePoint environment, building workflows, and creating advanced paginated reports in Power BI.

- Leverage data sets and data flows.

- Shape and combine multiple data sources.

- Prepare data models.

- Build and demonstrate prototypes, visualizations, and reports.

- Explore ways to improve visualizations and data models.

- Collaborate with data and analytics team members.

- Experience with Data Warehousing, Data Modelling, Power BI, Power Query, DAX and related technologies.

- Evaluate report performance metrics and implement improvements.

What you bring to the table

- 5+ years of experience as an IT business analyst working closely with the business and functionally designing reports.

- Experience in SharePoint administration, including permissions management and workflow development Conduct complex data analysis and report on results.

- Strong proficiency in building paginated reports in Power BI and scheduling report distribution.

- Advanced knowledge of Excel, including proficiency in macros and complex formulas.

- Experience with property management budgeting processes, including renovations, stabilization, and lease-up.

- Expertise in setting up and managing permissions in SharePoint and implementing approval workflows.

- Experience in integrating various Web APIs with Power BI to fetch and visualize data from multiple sources.

- Transforming and modeling API data within Power BI using Power Query and DAX.

- Understanding of optimizing API queries and data refresh processes in Power BI for data retrieval andanalysis

- Experience with other Microsoft Office 365 applications, such as Teams and OneDrive.

- Knowledge of SQL Server and data modeling concepts.

- Familiarity with DAX (Data Analysis Expressions) for Power BI.

Technically Sound inPower BI Reporting :

- Develop and design advanced paginated reports in Power BI to meet business requirements from multiple data sources, scheduling, and automation.

- Schedule and automate the distribution of paginated reports as needed.

- Utilize advanced Power BI features to create insightful and interactive reports.

- Understanding and ability to create/manage relationships.

- Expected to manage and maintain a Data Warehouse.

- Highly proficient in Data Analysis Expressions (DAX) coding.

Excel Support :

- Utilize Excel expertise to support budgeting processes, including correcting formulas and ensuring accurate logic.

- Provide support for budgeting activities related to property management, renovations, stabilization, and lease-up.

Knowledge Management :

- Stay informed about industry best practices and trends related to SharePoint, Power BI, and Excel.

- Share expertise and provide training to colleagues on SharePoint, Power BI, and Excel functionalities.

Data Flow Management :

- Set up and manage log errors for Power BI data flows to ensure data accuracy and integrity.

- Troubleshoot and resolve issues related to data flows and data sources.

Where will you work

- Mohali