Data Integration Consultant

The Role

This role owns architecture of integrations, leveraging custom solutions. Can you learn, assess, and implement new ETL tools, understand API technologies, data schema mapping and complex SQL queries, and protect sensitive data? Apply now!

As a Salesforce Healthcare and Life Sciences expert navigator, Penrod builds amazing experiences that keep its partners ahead of the digital curve.

Join a great team!

Requirements

• Experience with atleast 1 enterprise ETL Tool (MuleSoft, Dell Boomi, Informatica, Oracle Data Integrator, SAP BusinessObjects Data Integrator)
• Manually import client data files into the database
• Strong Understanding of API technologies
• Write complex SQL queries
• Diagnose and correct exceptions within dataloads
• Consult the client and project teams on proper completion of CPQ and FSL Templates
• Define and develop data integration and migration processes and procedures (CPQ templates, FSL templates)
• Work closely with clients and project teams on integration and migration strategies, best practices, and design.
• Write logical expressions to pull data from files as necessary
• Achieve and maintain Salesforce Administrator or Salesforce Developer 1 Certification within 60 days of hire and
• Prepare Integration Strategy Documentation and Field Mapping Documentation to ensure quality data migrations and integrations
• Write Jira Tickets within the structure and set the Data Specialist up for success
• NOTE: Based on the nature of our clients, and our contracts with them, certain vaccinations may be required

• 2-4 years of experience
• Working experience of relational databases and writing SQL queries to extract and transform data
• Knowledge and expertise writing complex SQL queries
• Understanding of API technologies
• Experience with atleast 1 enterprise ETL Tool (MuleSoft, Dell Boomi, Informatica, Oracle Data Integrator, SAP BusinessObjects Data Integrator)
• Ability to explain technical solutions to a non-technical audience
• Strong analytical, problem-solving skills
• Ability to consistently complete tasks and meet deadlines
• Attention to detail and an upbeat, helpful attitude
• Ability to consult and effectively communicate with clients
• Working experience working with clients and/or internal teams

Work Perks

Penrod offers its employees a creative and fast-paced working environment. Penrod differentiates itself from others by hiring people who can grow with our company. We hire some of the brightest minds and invest in their personal growth while avoiding politics.

Penrod is a fast-paced, self-driven, highly inclusive culture.

• Work/Life Integration
• 100% Health, Dental, & Vision Coverage
• Unlimited PTO
• Volunteer Time Off
• 401k
• Training Cost Coverage
• Paid Parental Leave
• Biannual company get-together — PenrodPalooza!
• Gym reimbursement
• Free parking or transit
• Casual dress— express yo’self!

We hope to hear from you soon!

Please note:
Penrod is an equal opportunity employer. Penrod does not discriminate against any employee or applicant because of race, religion, sex, sexual orientation, age, national origin, ancestry, disability, arrest or conviction record, marital status, military service or any other characteristic protected by applicable local, state or federal law and reasonably accommodates applicants and employees as required by applicable law.

To all recruitment agencies:
Penrod does not accept agency resumes. Please do not forward resumes to our jobs alias, Penrod employees, or any other company location. Penrod is not responsible for any fees related to unsolicited resumes.