Data Integration Developer

HSP Direct; Richmond (VA); On-site; USD 60,000 - 90,000; Full time

Job summary

An established industry player is on the lookout for a Data Integration Developer to enhance their data solutions. This full-time role focuses on designing and implementing data integration processes, ensuring seamless data flow across various systems. The ideal candidate will thrive in a collaborative environment, bringing innovative solutions to the table. With a commitment to conservative values, this organization offers a competitive salary and a comprehensive benefits package, including health, dental, and vision insurance, alongside generous PTO. Join a dynamic team that values initiative and results-driven performance!

Benefits

Comprehensive benefits package

401(k) with company match

Generous PTO and holidays

Onsite fitness center

Annual staff events

MAHA approved snacks and drinks

Company goal trips

Qualifications

• Proficient in ETL tools and data modeling.
• Experience with relational databases and data warehousing concepts.

Responsibilities

• Develop and maintain ETL processes for data integration.
• Ensure data accuracy and integrity through validation checks.

Skills

ETL Processes

Data Integration

SQL

Python

Attention to Detail

Strong Communication

Education

Bachelor's Degree in Computer Science

Tools

Informatica

SSIS

SQL Server

PostgreSQL

Power BI

Job description

Company Overview

HSP Direct is a best-in-class full-service direct mail fundraising agency offering online fundraising, production services, graphic design, and list and data services through our affiliated companies. With over 100 non-profit and political clients, we’re seeking highly motivated team members who share our passion for conservative politics.

Job Summary

HSP Direct is seeking a skilled Data Integration Developer to join our dynamic team. This role will be responsible for designing, developing, managing, and implementing data integration solutions to ensure seamless data flow between various systems and applications. The ideal candidate will have a solid background in data integration, ETL processes, data warehousing, and Data Lakehouse curation. If you’re passionate about data and are looking to grow your skills…we want to meet!

This is a full-time, in-office position located in Ashburn, VA. Remote work is not an option.

Success Profile To be effective at this role you must have the following…

• Proactive Attitude: Takes initiative to identify and solve problems without waiting for direction.
• Adaptability: Thrives in a fast-paced environment and can adjust to changing priorities and requirements.
• Attention to detail: Pays close attention to detail, ensuring data accuracy and process quality.
• Collaborative Nature: Works well with others, fostering a team-oriented environment while sharing knowledge.
• Innovative Mindset: Brings fresh ideas and innovative solutions to improve data integration processes.
• Strong Communication: Communicates clearly and effectively with technical and non-technical stakeholders.
• Results Driven: Focuses on achieving goals and delivering high-quality outcomes consistently.

Key Responsibilities

• Develop and maintain ETL processes to extract, transform, and load data from various sources into data warehouses and other systems.
• Implement data integration solutions to ensure seamless data flow and consistency across different platforms.
• Ensure the accuracy and integrity of data through robust validation and quality checks.
• Create and maintain documentation for data integration processes, including data mappings, transformation rules, and workflows.
• Work closely with data analysts, data scientists, developers, and other stakeholders to understand data requirements and provide solutions.
• Identify and solve data integration issues, ensuring minimal disruption to data flow.
• Optimize data integration processes for performance and scalability.
• Assist in managing and maintaining the systems and platforms that fuel our ETL processes and integrations.

Qualifications

• Passion for conservative politics and causes.
• Bachelor’s degree in computer science, information technology, or related field.
• Proficient in ETL tools such as Informatica, SSIS, SQL, and data modeling.
• Knowledge of programming languages such as Python, .Net, C#, or T-SQL.
• Experience with relational databases such as SQL Server, PostgreSQL, and Delta Lake architecture.
• Familiar with data warehousing concepts and architecture.
• Excellent communication and collaboration skills.
• Experience with RedPoint, mailing data integration, and donor management is highly desired.

Preferred Qualifications

• Relevant certifications in data integration, ETL, or data warehousing
• Experience with cloud platforms such as Azure and Fabric.
• Familiar with data visualization and reporting tools such as Power BI.
• Experience working in Agile or Scrum environments.

Company Benefits

• Competitive salary commensurate with experience.
• Comprehensive benefits package including health, dental, and vision insurance.
• Annual staff events including field day, golf and spa outings, offsite Christmas party, and more.
• 401(k) with company match.
• Generous PTO and holidays.
• MAHA approved snacks and drinks.
• Company goal trips.
• Onsite fitness center

How to Apply

If this challenge seems like a great fit for you and you would like a promising career path, please apply with a cover letter, resume, and salary requirements. Cover letter is required for consideration.

Employment Eligibility

In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification form upon hire. HSP Direct will not sponsor work visas.