Developer, Business Intelligence Power BI * Work from home - Military Veterans

As one of the nation’s premier humanitarian organizations, the American Red Cross is dedicated to helping people in need throughout the United States and, in association with other Red Cross networks, throughout the world. When you join our team, you have a direct impact on a meaningful mission, and you can help save lives every day. If you share our passion for helping people, join us in this excellent career opportunity. Work where your career is a force for good.

We are committed to the diversity of our workforce and to delivering our programs and services in a culturally competent manner reflecting the communities we serve.  Our work environment is collaborative, respectful, and inclusive with a focus on building allyship and a culture of belonging that empowers all team members. Come to learn, grow, and succeed while sharing your passion for making a difference.  

The Red Cross supports a variety of cultural and community resource groups for employees and volunteers. From the Ability Network, our Asian American & Pacific Islander Resource Group, the Latino Resource Group, and Red Cross PRIDE, to the Umoja African American Resource Group, our Veterans+ Resource Group, and the Women’s Resource Group, these networks provide connections, mentoring and help give voice to important concerns and opinions. 

At the American Red Cross, your uniqueness can shine!  

This position plays a supporting role on the Real Estate Services team for the American Red Cross (ARC). The Senior Consultant – Power BI Developer shall be responsible for data analysis specific to Real Estate Costs across 950 sites with an estimated 10 million square feet, ARC owns, leases and receives donated facilities of office, industrial, and retail types.

American Red Cross is currently seeking to hire an experienced Power BI Developer to become part of American Red Cross Real Estate Department.  The Microsoft Power BI Developer will be responsible for generation, operation, and maintenance of Power BI applications. The role will also be responsible for interpreting functional requirements into technical designs for BI solutions utilizing Power BI and related tools. The developer will need to understand requirements and transform the business use cases into building applications for end users. Develop a Power Platform Center of Excellence with other resources to develop best practices, share knowledge and ideas, and train power users and subject matter experts.

Ideal candidates should have experience with corporate real estate databases, proficiency in Power BI, and strong Excel and financial analysis skills. This position will play a key role in providing key metrics and analysis of all real estate data and will also support creating financial models for the regions to help decide the ROI on future capital spend. The role demands an analytical, detail- oriented professional who can work independently, guide the reporting team, and maintain stakeholder relationships.

Develop and execute fact-based reporting, analysis, dashboards, and analytical models to improve decision-making. Monitor KPIs, analyze performance data, and work in cross functional teams to influence improvements, to include benchmarking, market analysis and environmental scanning. Gather metrics and drive processes to operationalize reporting, track performance indicators and build dashboards to proactively highlight opportunities and recommend solutions. Serve as a subject matter expert on usage and interpretation of data and explain nuances to business users in a clear and concise manner.

Provide quantitative and qualitative analysis and support for Business Analytics Department while we support our clients Strategic Planning, Operations Support, Transaction Management and Portfolio Administration groups.  Manages cross-functional relationships across Real Estate Services to ensure all requested reporting meets end-to-end business support needs.

Perform all duties and responsibilities in compliance with standard operating procedures and other applicable Federal, State and local regulations.

Responsibilities

Design, develop and manage business intelligence solutions using Power BI with the ability to transform raw data into meaningful insights that drive business decisions.

Design and develop data models that support Power BI reports and dashboards

Use Power Query and DAX (Data Analysis Expressions) to transform, cleanse and structure data for analysis

Optimize data models to ensure efficient performance and scalability

Create visually compelling and interactive reports and dashboards in Power BI

Develop custom visualizations to meet specific business requirements

Implement drilldowns, filters and slicers to enhance user activity

Connect Power BI to various data sources including SQL Server, Dataverse, Azure, Excel, and third-party APIs

Implement scheduled data refreshes to keep reports up to date

Manages cross-functional relationships across RES to ensure all requested reporting meets end-to-end business support needs and translate them into technical specifications for Power BI solutions.

Identify bottlenecks such as slow queries or inefficient data models

Manage user roles and permissions to ensure proper access control

Conduct testing to validate the accuracy and functionality of the Power BI reports and dashboards

Debug and troubleshoot issues that arise during formal testing or in production

Document data models, and report logic for future reference and maintenance

Update reports and dashboards based on changing business needs or feedback from users

Stay updated with the latest features and best practices in Power BI

Explore new ways to leverage Power BI for advanced analytics and reporting

Coordinate with and trains stakeholders on our systems, processes and procedures

Responsible for refreshing and validating the monthly RES dashboard on time and accuratelyDrives accountability to ensure successful on time and accurate monthly reports

Data compliance and accuracy checks

Develop complex modeling and reporting tools or exceptions for monitoring and analyzing performance or data integrity

Making and updating our system of record CoStar with any data exceptions or working with clients to make necessary updates for month end reporting

Ensure that all procedures and processing are in compliance with current audit requirements and updates internal SOP’s and process flows

Create and prepare a cost/Benefit commercial Real estate NPV financial Model to help decide the ROI on any future capital spend for the ARC real estate portfolio.

Identify opportunities to streamline and enhance tools and processes and log appropriately

Influence stakeholders for implementation and adoption of available tools and manage priority of Reporting requests. Engage additional resources as needed.

-------------------------

Scope

Individual contributor with comprehensive knowledge in specific area.  Ability to execute highly complex or specialized projects.  Adapt precedent and may make significant departures from traditional approaches to develop solutions.

-------------------------

Qualifications

Education: Bachelor’s degree required.

Experience: Minimum 7 years of related experience or equivalent combination of education and related experience required.

Minimum 7 years relevant work experience, of which at least 4 years in commercial/ corporate real estate

2 years Professional Power BI Reporting Experience

Extensive development experience in the Microsoft Power BI Application

Power BI Report Development:Experience in Power BI UX design and creating visually appealing and interactive reports and dashboards to support business intelligence needs.

Experience maintaining and improving existing reports with an updated UX approach and consistent design.

Experience transforming raw data into actionable insights through interactive and user-friendly reports, ensuring data accuracy and consistency across reports.

Experience using Report Builder or Power Pages

Data Integration and Management:Must have the ability to integrate data from Dataverse into Power BI using SQL queries and Dataflows to provide comprehensive insights.

Experience managing data connections, data models, and transformations within the Power BI environment.

Ability to troubleshoot and resolve any issues related to data or reporting functionality.

Demonstrated ability in planning, execution, and delivery of Power BI solutions within scope, time, and budget.

Strong analytical and problem-solving skills

Excellent communication and collaboration skills, capable of working with stakeholders across different levels of the organization to gather requirements, provide updates, and drive adoption of developed solutions.

Commitment to staying up to date with the latest Power BI features, industry standards, and best practices in application development and data security

Experience with CoStar our RES database

Skills & Abilities: Must have high attention to detail. Advanced skills in Excel required. May require SQL and experience with other programming languages associated with data analytics (Python, Power BI, PowerPivot, etc.). Must possess excellent organizational skills and the ability to handle multiple priorities effectively, assimilate information quickly, analyze problems, and recommend appropriate technical and business solutions. Ability to proactively engage additional partners and resources (e.g. Finance, HR, process/project leads). Ability to develop clear presentations & stakeholder communications. Ability to manage both details and overview picture to achieve project goals successfully. Ability to work on a team.

Travel: May require some travel.

Combination of candidate’s education and general experience satisfies requirements so long as the total years equate to description’s minimum education and general experience years combined (Management experience cannot be substituted).

PAY INFORMATION: The annual salary range for this position is $110,000 - $130,000. We do not offer an annual bonus for this role. Note that American Red Cross salaries are aligned to the specific geographic location in which the work is primarily performed. Other factors that may be used to determine your actual salary may include your specific skills, how many years of experience you have and comparison to other employees already in this role. *We will review specific salary information at the time of phone screening based upon your location & experience.**

+++++++++++++++++

BENEFITS FOR YOU:

We take care of you, while you take care of others. As a mission-based organization, we believe our team needs great support to do great work. Our comprehensive benefits help you in balancing home and work, retirement, getting healthy and more. With our resources and perks, you have amazing possibilities at the American Red Cross to advance and learn. 

•    Medical, Dental, & Vision Plans 

•    Health Spending Accounts & Flexible Spending Accounts

•    PTO + Holidays 

•    401K with up to 5% Match 

•    Paid Family Leave

•    Employee Assistance Programs 

•    Disability and Insurance: Short + Long Term 

•    Service Awards and Recognition]]>