SQL Developer, Integrations & Automations
Founded in 1933 at the request of Albert Einstein, the International Rescue Committee (IRC) responds to the world’s worst humanitarian crises by providing lifesaving care and life-changing assistance to refugees made to flee from war or disaster. At work today in over 40 countries and 28 U.S. cities, serving over 20 million people, the IRC leads the way from harm to home.
This position will sit within the Marketing Technology department, working closely with the IRC’s External Relations team. Marketing Technology is responsible for the supporter management platforms (CRM, website, email marketing, donation platforms…) that power the External Relations department. Comprised of Private fundraising, Communications and Advocacy, the External Relations department is at the beginning stages of creating a new radical and ambitious strategy that will enhance IRC’s ability to ‘punch above its weight’ in private income, advocacy and brand awareness, enabling the organization to have the resources needed to continue serving over 20 million people worldwide, shape the humanitarian sector by influencing key policies and reforms and build and grow IRC’s reputation.
Job Overview/Summary:
As a SQL Developer, this role performs hands-on technical implementation, with a focus on delivering functional solutions on the Mulesoft platform for Salesforce.com and relational databases. This Developer will take a lead role in the design, implementation, deployment, and documentation of projects that leverage the Salesforce.com, ETL, and SQL toolsets.
Drawing on technical skills, critical thinking, problem solving, and creativity, this Developer will implement new solutions and/or troubleshoot issues. We are seeking a dynamic, self-motivated, and technical savvy individual to inspire and motivate the team and provide a technical edge to business users in order to meet the IRC’s ambitious fundraising goals.
Major Responsibilities:
• Integrate and maintain database code using PostgreSQL as primary database technology.
• Develop and maintain database code in the form of Stored Procedures, SQL Queries. Functions and Views as required by business processes.
• Involved with all levels of database management.
• Ensure system optimization, by improving and restructuring databases.
• Perform database updates and migrations.
• Ensure efficiency of database code, integrity of data structures, quality of data content and database code is accurately documented.
• Work closely with other team members to make sure database code meets the requirements.
• Experience building data-warehouses (relational and non-relational databases) and solutions for CRM (Salesforce)
• Manage Heroku connect for Salesforce to Heroku integration.
• Write database queries and code while maintaining data quality, privacy, and security.
• Responsible for requirement gathering, bug fixing, testing, documenting, and implementation.
Key Working Relationships:
Position Reports to: Director, Marketing Technology
Minimum Requirements
• Bachelor’s degree with in Computer Science, Information Technology, Engineering or equivalent;
• At least 3 years of PostgreSQL experience with creating complex stored procedures, SQL scripts functions, triggers, and views.
• Experience with Heroku Connect.
• A minimum 3+ years of professional work experience CRM (Salesforce) and Relations databases (non-profit experience a plus) and IT delivery, IT services, and professional services environments.
• Experience in ETL Design sessions with the team.
• Proficient with SQL, SOQL, JSON for data manipulation and complex custom reports.
• Familiarity with data structure algorithms, message queuing, indexing, and high-performance data concepts.
• Hands-on troubleshooting and problem-solving skills.
• 6+ years of excellent communication and interpersonal skills, including ability to build and maintain positive working relationships with team members, internal customer, high-level staff and external vendors, strong customer service orientation, good writing skills, ability to communicate technical issues to non-technical audience.
Preferred Additional Qualifications
• Experience with MuleSoft, DBAmp
• Experience with MongoDB, MSSQL, Snowflake
• Experience with web services or application programming interfaces is a great plus.
• Experience in implementing fundraising applications for non-profit organizations.
• Experience in working effectively with an agile delivery model.
• Experience in implementing business intelligence and data warehouse solutions.
Working Environment:
A collegiate environment working collaboratively across IT and broader IRC. Strong sense of transparency and accountability to ensure we are doing right by our beneficiaries and donors, exemplifying the IRC Way.
This position is fully remote. The post holder will be required to travel to 3-5 times per year for in-person time with team and learning development opportunities.
The IRC and IRC workers must adhere to the values and principles outlined in IRC Way - Standards for Professional Conduct. These are Integrity, Service, 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.
IRC et les employés de IRC doivent adhérer aux valeurs et principes contenus dans le IRC WAY (normes de conduite professionnelle). Ce sont l’Intégrité, le Service, et la Responsabilité. En conformité avec ces valeurs, IRC opère et fait respecter les politiques sur la protection des bénéficiaires contre l’exploitation et les abus, la protection de l’enfant, le harcèlement sur les lieux de travail, l’intégrité financière, et les représailles.
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.
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.
E
Qualifications