Senior PowerBI Developer

Job Overview

The External Relations (ER) department has been created in February 2020 and is comprised of 3 main but complementary functional areas: Private fundraising, Communications and Advocacy. The ER department is at the beginning stages of creating a new radical and ambitious global strategy that will enhance IRC’s ability to ‘punch above its weight’ in private income, advocacy, and brand awareness. The main objective of the department is to enable this organization of more than 12,000 staff to have the resources needed to continue serving 18 million people worldwide in places affected by war and disaster, shape the humanitarian sector by influencing key policies and reforms and build and grow IRC’s reputation.

The Senior PowerBI Developer will work as an integral part of an analytics team– that includes data scientists, analysts, and engineers– to lead the development of a suite of dashboard that will be leveraged across all global ER teams– Private Fundraising, Communications, and Advocacy.

Major Responsibilities:

• Partner with ER Stakeholders and analysts to develop insightful, visually compelling, and user-friendly dashboards in PowerBI that empower both technical and non-technical audiences
• Lead on the collection of business requirements, development of project plan, and creation & iteration of mock-ups
• Write production-quality data transformations in SQL (and DAX when applicable) using dbt with an eye towards performance, maintainability, and scalability; collaborate with engineers to transform and synthesize data from multiple sources and identify performant data structures for reporting needs
• Define and implement core principles and best practices for dashboard administration, development, maintenance, and governance & cataloging
• Leverage technical expertise and creative problem solving to build, enhance, and automate analytics and dashboarding capabilities
• Constructively challenge business on assumptions and goals; asks questions that effectively lead to deeper understandings
• Develop trainings and support analysts in development of smaller-scale PowerBI dashboards; act a technical expert on best practices in data visualization & PowerBI to the ER Analytics team, and larger ER organization

Job Requirements:

Demonstrated Skills and Competencies:

• 6+ years working in the field of data and analytics; advanced SQL skills (nested data structure manipulation, windowing functions, query optimization, data partitioning techniques)

• 3+ professional experience building dashboards (Looker, Tableau or PowerBI)

• Strong knowledge of dimensional modeling; expertise in building performant and scalable data models that align with dashboards

• Professional experience with workflow orchestration tools and data warehousing technologies

• Strong adherence to data ops best practices, including version control (e.g., GitHub), and data testing

• Excellent written and verbal communication

• Independent worker with strong attention to detail & commitment to a high standard of work product

• Desire to work in a multi-cultural environment and collaborate with people from different backgrounds and experiences

Desirables:

• Professional Experience with PowerBI, Power Query and, DAX/MDX scripting language
• Familiarity with Salesforce or similar CRM technology
• Experience in Azure Synapse
• Experience with dbt

Working Environment:**

• Standard office working environment.
• This role may require working remotely full or part time and part time remote employees may be required to share workspace.

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

Standards of Professional Conduct: The IRC and IRC workers adhere to the values and principles outlined in IRC Way – Standards for Professional Conduct. These are Integrity, Service, Equality and Accountability. In accordance with these values, the IRC operates and enforces policies on Beneficiary Protection from Exploitation and Abuse, Child Safeguarding, Anti Workplace Harassment, Fiscal Integrity, and Anti-Retaliation.

COVID-19 Vaccination Requirement:

In accordance with IRC’s duty to provide and maintain a workplace that is free of known hazards and our commitment to safeguard the health of our employees, clients, and communities, IRC requires new hires to furnish proof of vaccination against COVID-19 in order to be considered for any in-office or hybrid positions. All IRC US offices require full vaccination to attend any in-office functions (e.g., meetings, trainings).

Commitment to Diversity and Inclusivity:

IRC is committed to building a diverse organization and a climate of inclusivity. We strongly encourage applications from candidates who can demonstrate that they can contribute to this goal.

Equal Opportunity Employer:

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

US Benefits:

We offer a comprehensive and highly competitive set of benefits. In the US, these include: 10 sick days, 10 US holidays, 20-25 paid time off days (depending on role and tenure), medical insurance starting at $145 per month, dental starting at $7 per month, and vision starting at $5 per month, FSA for healthcare, childcare, and commuter costs, a 403b retirement savings plans with up to 4.5% immediately vested matching contribution, plus a 3-7% base IRC contribution (3 year vesting), disability & life insurance, and an Employee Assistance Program which is available to our staff and their families to support counseling and care in times of crisis and mental health struggles.

Compensation:

Posted pay ranges apply to US-based candidates. Ranges are based on various factors including the labor market, job type, internal equity, and budget. Exact offers are calibrated by work location, individual candidate experience and skills relative to the defined job requirements.