Senior Data Engineer
Paradigm Health
AirflowETLJavaKafkaPythonSparkSQL
Senior Data Engineer
Virtuous
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteJob Level
Senior
Tech Stack
CloudETLKafkaPythonSQLTableau
About the role
- Support the design, development, and maintenance of our enterprise data warehouse and ETL/ELT pipelines. Architect and implement data solutions that support a wide range of reporting, insights, analytics, and fundraising needs, including donor segmentation, campaign attribution, and predictive modeling.
- Support in building and managing robust, scalable data pipelines from various internal and external sources (e.g., CRM, third-party data sets) into our data warehouse. Ensure data integrity, reliability, and security.
- Troubleshoot and resolve data-related issues to ensure a single source of truth for key metrics.
- Conduct exploratory data analysis to undercover trends and insights. Build and manage comprehensive reports and dashboards.
- Partner closely with product managers, designers, software engineers, ML engineers, data scientists, and business stakeholders to understand their data requirements and deliver solutions that empower their work. Translate business needs into technical specifications.
Requirements
- Expert-level experience with SQL server and data modeling in a cloud data warehouse, such as Snowflake.
- Ability to create ETL tools and optimize big data sets, including familiarity with cleaning, structuring, and aggregating the raw data to make it useful for analysis and reporting (e.g. DBT)
- Experience in the nonprofit sector or with donor/constituent relationship management (CRM) systems (e.g., Virtuous, Salesforce NPSP, Blackbaud, HubSpot, EveryAction).
- Familiarity with business intelligence tools (e.g., Sigma,Tableau, Power BI, Looker).
- Knowledge of event-driven architecture and streaming data technologies (e.g., Kafka).
- Knowledge of python and/or the ability to easily pull data from APIs
- Strong analytical and problem-solving skills.
- Excellent communication and collaboration abilities.
- Detail-oriented and able to manage multiple tasks and projects simultaneously.
- Experience working with nonprofits or a strong desire to support nonprofit initiatives.
- A curious and analytically-minded approach to data analysis
Benefits
- Market competitive pay leveraging Carta data
- Employee recognition through Bonusly (birthdays, anniversaries, achievements, etc.)
- 401(k) retirement plan with company matching- 50% match up to 6% of compensation after 90 days
- We value our employee’s work-life balance and encourage taking advantage of Unlimited PTO
- Supportive time off including paid volunteer days and company holidays
- Employer-contributed healthcare benefits, encompassing medical, dental, and vision coverage, with plans available for dependents and choices for Health Savings Accounts (HSA) and Flexible Spending Accounts (FSA).
- 12 weeks primary parent leave, 4 weeks secondary parent leave - full pay (adoption as well)
- We pride ourselves on Community and host exciting company outings and events.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQL serverdata modelingcloud data warehouseETL toolsbig data optimizationdata cleaningdata structuringdata aggregationPythonAPI data extraction
Soft skills
analytical skillsproblem-solving skillscommunication abilitiescollaboration abilitiesdetail-orientedproject managementcuriositydata analysis mindset
