Data Integration Developer - Remote

Are you looking to accelerate your career without having to hide your authentic self - a place where you can be you? A career that’s making a bigger impact on the world?  At OneDigital, we are on a mission to help people do their best work and live their best lives.  From the services we offer to the way we show up for each other each day, we are fueling dreams, achieving big goals, and embracing each other’s truest selves.

We understand that pursuing a new job is a big deal.  Maybe you’re afraid you won’t fit in.  Well, here’s the good news.  For us, the days of “fit in to get in” are over and being different is not a barrier to getting ahead. Greatness comes in all shapes, sizes, colors, and experience levels. If you are looking for a people-first culture that is wired for growth, driven to serve, and totally committed to having your back, give us a shot. Your best life awaits.

Must be eligible to work in the United States without the need for work visa or residency sponsorship.

Our Newest Opportunity: 

Summary:

As the Data Integration Developer, this individual will participate in the development and testing of database and back-end data processes using ETL techniques and tools to facilitate the creation and population of databases, data marts, and other data integration solutions. In addition, this person will execute and maintain deployed data solutions, troubleshoot and remediate existing data integration processes develop and optimize SQL queries and stored procedures, and maintain high availability of data integration services.

This person will work closely with technical team members, initiating and maintaining positive and proactive relationships and working collaboratively to deliver data integration solutions that are high performance, rapid response time, and as close to real-time as possible. A large focus of this role is ETL with significant emphasis on SQL development, database modeling, and data quality.

Typical functions include, but are not limited to, developing ETL packages, writing and optimizing SQL code, deploying new and updated data integration solutions, monitoring existing integration services, and maintaining databases, managing inbound and outbound data, mitigating data risks,  enforcing data quality standards, offering technical expertise, and implementing technical advances based on business needs.

The Data Integration Developer will report to the Senior IT, Governance, Strategy & Planning Controller and be a member of the data operations team that both supports and leads RxConnection’s various technical and business teams through their required data needs.

Essential Duties and Responsibilities (include but are not limited to):

• Support secure transfer of continuous inbound data feeds as well as evaluate various data dictionaries to implement transformations on inbound data on an ongoing basis

• Develop, test, and maintain ETL processes and SQL queries (stored procedures, functions, views)

• Create new data connections and maintain data connections to internal and external sources.

• Design, document, and maintain relational and dimensional database models to support reporting and integration

• Support various business projects and assist in data integration and data quality initiatives including profiling, validation, and reconciliation, in addition to data integration

• Support external meetings that require technical knowledge/feedback

• Evaluate and maintain existing data integration and connection documents and make recommendations/improvements based on business needs

• Assess data practices on an ongoing basis to reduce any risk as well as recommend more efficient practices

Qualifications, Skills and Requirements:

• Proficient in Data Integration and Business Intelligence tools and concepts

• Data Integration concepts and strategies: ETL, Data Warehousing, event-based processing

• Data Integration tools: SSIS

• Database: SQL Server with strong SQL development experience (T-SQL, stored procedures, query optimization)

• Data Management and Quality: data mapping, data profiling, validation, relational and dimensional modeling

• Analytical – not afraid to dive into complex code and data to troubleshoot issues

• Creative problem solver who is automation focused

• Good communicator who wants to work in a team environment, comfortable working collaboratively with peers

Education, Training and Experience:

• Minimum of 2-5 years of experience in Data Integration / Business Intelligence in a complex environment working with SSIS

• Data Analytics experience focused with demonstrated experience in SQL development and database modeling

• Experience with Pharmacy, Pharmacy Benefit Management (PBM), and/or Healthcare data preferred

The typical base pay range for this role nationwide is $65,000 to $85,000 per year.  

Your base pay is dependent upon your skills, education, qualifications, professional experience, and location. In addition to base pay, some roles are eligible for variable compensation, commission, and/or annual bonus based on your individual performance and/or the company’s performance.  We also offer eligible employees health, wellbeing, retirement, and other financial benefits, paid time off, overtime pay for non-exempt employees, and robust learning and development programs. You will receive reimbursement of job-related expenses per the company policy and may receive employee perks and discounts. 

To learn more, visit: www.onedigital.com/careers  

OneDigital is an equal opportunity employer. Not only as a matter of standard, but to honor and celebrate our differences. We believe that the power of ONE starts with you. We are committed to cultivating and preserving a culture that celebrates diversity, insists on equity and inclusion, and connects us. Ensuring our people feel seen, valued, respected, and supported is fundamental to our core values and business goals.

OneDigital provides equal employment opportunities to all employees and applicants for employment regardless of their: veteran status, uniformed servicemember status, race, color, religion, sex, sexual orientation, gender identity, age (40 and over), pregnancy (including childbirth, lactation and related medical conditions), national origin or ancestry, citizenship or immigration status, physical or mental disability, genetic information (including testing and characteristics) or any other category protected by federal, state or local law (collectively, “protected characteristics”). A copy of the Federal EEO poster is linked here.

Pursuant to local Fair Chance Ordinances, we will consider qualified applications with arrest or conviction records for employment. For applicable candidates, the following ordinances are linked here to inform you of your rights as an applicant:

City and County of San Francsico

City of Los Angeles

County of Los Angeles

Employment decisions shall comply with all other applicable federal, state and city/county laws prohibiting discrimination in employment. OneDigital complies with all criminal history inquiry [or ‘ban the box’] laws in California, Connecticut, Colorado, Hawaii, Illinois, Maine, Maryland, Massachusetts, Minnesota, New Jersey, New Mexico, Oregon, Rhode Island, Vermont and Washington.

In short, we believe in hiring the most qualified applicant for the position, regardless of background.

If you have questions about our hiring policies and practices, we would be happy to discuss upon receiving your application. We hope to welcome you to OneDigital and look forward to hearing from you.

OneDigital understands the immense responsibility and opportunities provided by Artificial Intelligence. We utilize advanced Artificial Intelligence [AI] technologies to enhance our recruitment process. This includes using AI to filter candidates based on their qualifications and to rediscover potential candidates from our existing applicant pool. Our AI systems help us efficiently identify the best fit for our open positions, ensuring a streamlined and effective hiring experience. However, AI does not replace the humans in our process. If you have concerns about our use of AI, you may opt out where laws allow.

 OneDigital understands the immense responsibility and opportunities provided by Artificial Intelligence. We utilize advanced Artificial Intelligence [AI] technologies to enhance our recruitment process. This includes using AI to filter candidates based on their qualifications and to rediscover potential candidates from our existing applicant pool. Our AI systems help us efficiently identify the best fit for our open positions, ensuring a streamlined and effective hiring experience. However, AI does not replace the humans in our process. If you have concerns about our use of AI, you may opt out where laws allow.

Thank you for your interest in joining the OneDigital team!