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