Associate Analytics Engineer
New York NY
- Organization: IRC - International Rescue Committee
- Location: New York NY
- Grade: Mid level - Mid level
-
Occupational Groups:
- Engineering
- Closing Date: Closed
The International Rescue Committee (IRC) responds to the world's worst humanitarian crises, helping to restore health, safety, education, economic wellbeing, and power to people devastated by conflict and disaster. Founded in 1933 at the call of Albert Einstein, the IRC is one of the world's largest international humanitarian non-governmental organizations (INGO), at work in more than 40 countries and 29 U.S. cities helping people to survive, reclaim control of their future and strengthen their communities. A force for humanity, IRC employees deliver lasting impact by restoring safety, dignity and hope to millions. If you're a solutions-driven, passionate change-maker, come join us in positively impacting the lives of millions of people world-wide for a better future.
This position is currently only open to IRC staff.
Job Overview
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 Analytics Engineer will work as an integral part of an analytics team -- that includes data scientists and analysts -- to contribute to and develop data models and other assets that will serve as the foundation and “single source of truth” for all data-driven strategy for Private Fundraising, Communications, and Advocacy at the IRC.
The Associate Analytics Engineer will play an active role in advancing IRC’s internal data capabilities by contributing to data models, workflows, and assets serving the business intelligence, data science, and operational needs of IRC ER.
Major Responsibilities:
•Collaborate with analysts, data scientists, and ER stakeholders to specify and clarify project requirements; plan and develop well-defined, integrated, and reusable solutions to meet those requirements using Snowflake, dbt, PowerBI, and other tools.
•Create new and enhance existing data models by writing production-quality data transformations in SQL using dbt.
•Apply software engineering practices (e.g. code review, testing, version control, comprehensive documentation) when contributing to the ER data model to ensure data quality & standardization across our pipelines and BI tools.
•Contribute to the design and successful implementation of BI assets and operational workflows, including dashboards, data model documentation, and data operationalization.
•Serve as area expert on ER’s web analytics data. Maintain and enhance self-service resources to provide insight into IRC’s digital fundraising data, including insight into the quality of this data.
•Identify and execute internal improvements to the ER Analytics data platform, including code improvements, testing and documentation coverage, and performance enhancements
•Support of other analytics tasks as needed
Job Requirements:
Demonstrated Skills and Competencies:
•Curiosity to explore complex and ambiguous problems and deliver structured analytics solutions
•2+ years working in the field of data and analytics
•2+ years of professional experience modeling and reporting on large scale data, using BI tools, Excel, or SQL
•1+ years of experience with SQL and cloud-based data warehouses (Snowflake, BigQuery, Redshift, Azure)
•Familiarity with dbt and modular data modeling
•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
•Desire to work in a multi-cultural environment and collaborate with people from different backgrounds and experiences
Nice-to-Haves:
•Familiarity with Salesforce or similar CRM technology
•Experience developing dbt in a high-growth org, including deploying capabilities such as utils, packages, tests, snapshots, and incremental tables
•Experience in 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.
US Benefits:
The IRC offers a comprehensive and highly competitive set of benefits. All US employees are eligible for sick time, a 403b retirement savings plans: up to 4.5% immediately vested matching contribution, plus an 3-7% additional IRC contribution, and an Employee Assistance Program which is available to our staff and their families to support in times of crisis and mental health struggles.
In addition, full-time employees are eligible for 10 US paid holidays, 20-25 paid time off days, disability & life insurance, medical, dental, and vision insurance (employee contribution starting at $135, $7, and $5 per month respectively) and FSA for healthcare, childcare, and commuter costs. Part-time employees are eligible for a proportionate amount of paid time off. These additional benefits apply to employees who work at least 6 months within a 12 month time period.
#LI-DNI
Standard of Professional Conduct:The IRC and the IRC workers must adhere to the values and principles outlined in the IRC Way – our Code of Conduct. These are Integrity, Service, Accountability, and Equality.
Commitment to Gender, Equality, Diversity, and Inclusion: The IRC is committed to creating a diverse, inclusive, respectful, and safe work environment where all persons are treated fairly, with dignity and respect. The IRC expressly prohibits and will not tolerate discrimination, harassment, retaliation, or bullying of the IRC persons in any work setting. We aim to increase the representation of women, people that are from country and communities we serve, and people who identify as races and ethnicities that are under-represented in global power structures.
Commitment to Gender, Equality, Diversity, and Inclusion: The IRC is committed to creating a diverse, inclusive, respectful, and safe work environment where all persons are treated fairly, with dignity and respect. The IRC expressly prohibits and will not tolerate discrimination, harassment, retaliation, or bullying of the IRC persons in any work setting. We aim to increase the representation of women, people that are from country and communities we serve, and people who identify as races and ethnicities that are under-represented in global power structures.
This vacancy is now closed.