Data Engineer - Constellation

At MissionWired, we help our partners create revolutionary fundraising strategies that advance their mission, change our country, and have a positive impact on the world. 

MissionWired is the only wholly integrated direct marketing agency for nonprofits and Democratic organizations. We help our partners tell big, ambitious stories that invite their supporters into communities to raise mission-changing revenue. Our results are unrivaled, having converted more than $4.5 billion in donations to the world’s most trusted philanthropies and groundbreaking campaigns. We do it over email and SMS, in the mail, across social media, everywhere. We don’t think in terms of channels; we’re single-minded in pursuit of your success.

We’re innovative, progress-obsessed, do-gooders who care deeply about social change and continuing to push the limits on what we can accomplish together. We’ve brought strategies to life for nonprofit organizations working around the world, including Sandy Hook Promise, Human Rights Watch, The Humane Society of the U.S., Save the Children, and Friends of the Earth. Over the years, we have worked with various progressive political organizations and believe that each election cycle is an opportunity for us to support organizations across the country and elect Democrats to legislative bodies up and down the ballot.

We’re an equal-opportunity employer and take seriously our commitment to equality and equity. Our efforts to be inclusive and create opportunity don’t end when someone joins us – they begin. 

We’ve set our sights on changing the world through our work and with our clients, and representation is at the foundation of what we do. We know that diversity of thought and background makes us stronger. That’s why we’re committed to building and maintaining a diverse community.

Every new team member broadens our perspective and allows us to think bigger. We’ll be at our best when people from underrepresented communities and people with a range of perspectives and lived experiences want to come, stay, and push the boundaries of what’s possible.

Overview: We are looking for a Data Engineer to structure our client’s data, enabling effective and efficient querying and advanced segmentation. You’ll be supporting everything from electing Democrats to combating climate change throughout the world. With us, you’ll put your skills to use for disruptive innovation that powers social good.

You will be responsible for

• Building SQL pipelines to extract, transform, and load data sets from a variety of internal and external data sources;

• Working in client systems such as Salesforce and Civis;

• Creating SQL queries against data tables to enable advanced segmentation for direct mail campaigns;

• Structuring data to enable effective and efficient querying and segmentation;

• Assembling large and complex data sets that meet project needs;

• Using an array of technological languages and tools to connect systems and move data;

• Working toward constantly improving data reliability and quality;

• Joining each and every one of your colleagues in creating an inclusive workspace; and

• Collaborating with cross-functional teams to support their data infrastructure needs.

Must-have qualifications

• 2+ years of professional experience;

• Experience with and advanced knowledge of SQL;

• Ability to build and optimize data pipelines, architectures, and data sets;

• Attention to detail;

• Curiosity to innovate on ways to solve data management issues; and

• Passion, energy, and excitement for progressive and philanthropic causes.

Nice-to-have qualifications

• Experience with Civis or similar data warehouse systems;

• Experience with direct response fundraising;

• Experience with DBT;

• Knowledge of Python; and

• Experience working with cross-functional teams in a dynamic environment.

Salary range for this role is $91,000 to $100,000 per year, depending on experience. This is a temporary, salaried and benefits eligible position for a limited period lasting no more than 6 months.

Location

We are currently working remotely with no return to office date. Applicants may reside in the following states: AZ, CA, CO, CT, DC, FL, GA, IL, IN, LA, MA, ME, MD, MN, MO, NC, NE, NH, NJ, NM, NY, OR, PA, SC, TX, VA, and WA. Due to FL legislation, MissionWired is required to participate in e-verify.

Benefits

100% employer-paid premiums for platinum-level medical plan on a national health care network

100% employer-paid life insurance and short term disability

50% employer-paid vision and dental insurance

401(k) with 3% employer contribution

17 vacation days in addition to 12 paid holidays, sick days, bereavement leave, and a volunteer day off.

Paid parental leave at 100% of your salary

Financial support for reproductive and transgender care

Flexible telecommute and remote work policies

Company issued Mac products for home offices

Cell phone service reimbursement, meal and ride-share reimbursement, and other perks available

*Supporting your team on some nights and weekends as we approach high-volume times such as elections may be required.

If you feel you can do the job and are excited about this opportunity but are not sure if you meet all the qualifications, consider applying anyway. We’d love to hear from you!