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 Associate Director, Analytics Engineering will lead the External Relations data platform architecture and delivery, scaling IRCโs internal data capabilities and governance as the volume and complexity of our data grows and business needs evolve. The Associate Director, Analytics Engineering will shape strategic and technical collaboration with ER BizOps, IT, and MarTech partners, and they will be a critical thought partner to the Director, Global Analytics on how to optimize our data platforming strategy and investments based on data-driven decision making.
Major Responsibilities:
- Lead in the development of an Analytics Warehouse that will serve as the foundation and โsingle source of truthโ for all data-driven strategy for Private Fundraising, Communications, and Advocacy and other partners of ER throughout the IRC.
- Coordinate with other members of External Relations Analytics, GDO, MarTech to implement data quality solutions, and to drive governance and data platform adoption.
- Lead ER Analyticsโ relationship with IT Data team members to improve and enhance the ER data platform, and work collaboratively with leaders across IT.
- Lead External Relations analytical product roadmap to drive the strategic goals of the IRC, while tracking and budgeting data platform tooling costs
- Own planning of and delivery against analytics engineering roadmap, including feature development and internal process improvements toward scalability and automation.
- Lead the analysts and analytics engineers from the ER Analytics team and consultancies, in execution of data modeling and data warehousing projects, while developing design, documentation, and code review standards.
- Drive collaboration, governance, and documentation of data consumption resources, such as dashboards, data science pipelines, and outbound data flows, in partnership with other members of ER Analytics.
- Own the entire workflow of the ER Analytics Warehouse: Cloud Data Warehouse admin, data pipeline development, ELT performance, timely loading of data sets, and maintenance of data models via the use of monitoring, testing, and automation.
Job Requirements:
Demonstrated Skills and Competencies:
- Curiosity to explore complex and ambiguous problems and deliver structured analytics solutions
- 6+ years working in the field of data and analytics, with 2+ years of experience recruiting, training, and supervising the development of team members.
- At least 5+ years of professional experience manipulating large scale data, using both Python and SQL (nested data structure manipulation, windowing functions, query optimization, data partitioning techniques)
- Strong experience with data pipeline management technologies (e.g. Airflow, dbt, docker), dependency checking, schema design, and dimensional data modeling
- 4+ years of experience with cloud-based data warehouses (Snowflake, BigQuery, Redshift, Azure)
- 2+ years of experience owning dbt in a high-growth org, including deploying capabilities such as utils, packages, tests, snapshots, and incremental tables
- Knowledgeable and passionate about the โmodern data stackโ
- Strong adherence to data ops best practices, including version control (e.g., GitHub), and data testing
- Independent worker with strong attention to detail & commitment to a high standard of work product
- Exceptional partner management skills, including experience collaborating across multiple offices with distributed teams, and delivering on roadmaps.
- Strong organizational and communications skills, including the ability to coordinate multiple workstreams while responding to complex requirements across multiple stakeholders.
- Desire to work in a multi-cultural environment and collaborate with people from different backgrounds and experiences, with a partner-first approach to interacting with stakeholders in a mission-drive organization.
Nice-to-Haves
- Familiarity with Salesforce or similar CRM technology
- Experience with Snowflake
- Exposure to Microsoft BI tooling: PowerBI, Power Query and, DAX/MDX scripting language
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.
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.
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.
Gender Equality:
IRC is committed to narrowing the gender gap in leadership positions. We offer benefits that provide an enabling environment for women to participate in our workforce including parental leave, gender-sensitive security protocols and other supportive benefits and allowances.
Professional Standards:
The IRC and IRC staff must adhere to the values and principles outlined in IRC Way โ Global 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.
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.