penrod loader
MENUMENU
  • Penrod
  • What We Do
        • Custom Salesforce Implementations

        • Sales Cloud
        • Health Cloud Implementations
        • Community Cloud
        • Field Service Lightning
        • Pardot
        • Marketing Cloud
        • Datorama
        • CPQ
        • Service Cloud
        • Work.com Implementation
        • Salesforce Managed Services
        • Solutions for Health & Life Sciences

        • Medical Device Companies
        • Unleash your sales engine with enhanced tracking, faster quoting, and intelligent cross-selling

        • Providers & Speciality Clinics
        • Aquire more patients, build loyalty, and empower collaboration across the entire care ecosystem

        • Health Insurance
        • Boost revenue by providing authentic member experiences, reducing the cost of care, and attracting providers

        • Pharma
        • Automate your sales force, enhance drug trial management, and integrate systems

        • Labs
        • Innovate faster, grow revenue, engage partners, and support patients.

        • Services

        • Salesforce Managed Services
        • Save time, improve user experience, and maximize your ROI with our Salesforce managed services packages

        • Solutions

        • Provider Enrollment
        • Create a single source of truth across enrollment, contracting, credentialing, marketing, and sales

        • NPI Lookup
        • Connect more members with the care they need in a native Lightning component for Salesforce

  • Resources
        • Salesforce Case Studies
        • A selection of Salesforce success stories from medical device companies, clinics, pharmacies, and labs.

        • Health & Life Science Blogs
        • Thought leadership from Health and Life Sciences experts

        • Salesforce Guides
        • Guides from a Salesforce Expert Navigator

        • Videos
        • Videos highlighting our expertise and Salesforce industry showcases

        • Webinars
        • On-demand and on-topic, our webinars cover events in the Salesforce ecosystem

        • All Resources
  • Blog
  • People
  • Careers
  • Contact
Penrod
MENUMENU
  • Penrod
  • What We Do
        • Custom Salesforce Implementations

        • Sales Cloud
        • Health Cloud Implementations
        • Community Cloud
        • Field Service Lightning
        • Pardot
        • Marketing Cloud
        • Datorama
        • CPQ
        • Service Cloud
        • Work.com Implementation
        • Salesforce Managed Services
        • Solutions for Health & Life Sciences

        • Medical Device Companies
        • Unleash your sales engine with enhanced tracking, faster quoting, and intelligent cross-selling

        • Providers & Speciality Clinics
        • Aquire more patients, build loyalty, and empower collaboration across the entire care ecosystem

        • Health Insurance
        • Boost revenue by providing authentic member experiences, reducing the cost of care, and attracting providers

        • Pharma
        • Automate your sales force, enhance drug trial management, and integrate systems

        • Labs
        • Innovate faster, grow revenue, engage partners, and support patients.

        • Services

        • Salesforce Managed Services
        • Save time, improve user experience, and maximize your ROI with our Salesforce managed services packages

        • Solutions

        • Provider Enrollment
        • Create a single source of truth across enrollment, contracting, credentialing, marketing, and sales

        • NPI Lookup
        • Connect more members with the care they need in a native Lightning component for Salesforce

  • Resources
        • Salesforce Case Studies
        • A selection of Salesforce success stories from medical device companies, clinics, pharmacies, and labs.

        • Health & Life Science Blogs
        • Thought leadership from Health and Life Sciences experts

        • Salesforce Guides
        • Guides from a Salesforce Expert Navigator

        • Videos
        • Videos highlighting our expertise and Salesforce industry showcases

        • Webinars
        • On-demand and on-topic, our webinars cover events in the Salesforce ecosystem

        • All Resources
  • Blog
  • People
  • Careers
  • Contact

Penrod Careers

Data Integration Consultant

Milwaukee, Wisconsin

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 Platinum Salesforce Implementation Partner and certified Healthcare & Life Sciences Master Navigator, Penrod builds amazing experiences that keep its partners ahead of the digital curve.

Join a great team!

Requirements

What You Must Do To Be Successful In This Position:
  • 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
What Skills & Experience We’d Like You To Have:
  • Degree in MIS or equivalent, 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. 

Apply Now


Apply Now
 
  • What We Do
  • People
  • Careers
  • Resources
  • Our Partners
  • Master Navigator
  • Contact
Salesforce Master Navigator Salesforce App Exchange

Milwaukee

219 N. Milwaukee St., 2nd Floor Milwaukee, WI 53202 (855) 273-6763

© 2021 Penrod LLC

Brand Legal Site by Savage

© 2021 Penrod LLC

Brand Legal Site by Savage