The Role
Penrod, headquartered in Milwaukee’s Historic Third Ward with additional offices in Chicago, Minneapolis, and Dallas, is seeking a Data Integration Consultant to join our growing team. Our Data Integration Consultant will develop and execute complex data migrations and integrations for client applications on the Salesforce platform.
Penrod is a culture-driven consulting agency specializing in Salesforce.com. As a Platinum Salesforce.com partner, we help businesses develop and implement cloud solutions that create customer success.
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
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
Perks
Penrod offers its employees a creative and fast-paced working environment. We differentiate ourselves by hiring people who can grow with our company. We employ some of the brightest minds and invest in their personal growth while avoiding politics.
Penrod is a fast-paced, self-driven, highly inclusive culture.
- Casual dress at the office. Shorts and sandals are encouraged.
- Work/life integration.
- 100% covered monthly employee premium for Health, Dental, and Vision plan.
- Unlimited PTO
- Company outings, lunches, and happy hours.
- An open-concept office environment
- Personal workspaces include LCD monitor and a Herman Miller chair.
- In-office recreation includes Ping-Pong and video games.
- Kitchen stocked with snacks and beverages.
- 100% coverage of expenses related to certification, testing, preparation, and exam fees.
- Free parking or transit to our unique office in the Historic Third Ward.