Data Engineer(Salesforce API)

Wavicle Data Solutions designs and delivers data and analytics solutions to reduce time, cost, and risk of companies’ data projects, improving the quality of their analytics and decisions now and into the future. As a privately-held consulting service organization with popular, name brand clients across multiple industries, Wavicle offers exciting opportunities for data scientists, solutions architects, developers, and consultants to jump right in and contribute to meaningful, innovative solutions.

Our 250+ local, nearshore and offshore consultants, data architects, cloud engineers, and developers build cost-effective, right-fit solutions leveraging our team’s deep business acumen and knowledge of cutting-edge data and analytics technology and frameworks.

At Wavicle, you’ll find a challenging and rewarding work environment where we enjoy working as a team to exceed client expectations. Employees appreciate being part of something meaningful at Wavicle. Wavicle has been recognized by industry leaders as follows:

• Chicago Tribune’s Top Workplaces
• Inc 500 Fastest Growing Private Companies in the US
• Crain’s Fast 50 fastest growing companies in the Chicago area
• Talend Expert Partner recognition
• Microsoft Gold Data Platform competency

About the Role:

We are looking for a Data Engineer with strong real-life experience in Python development, including PySpark in an AWS Cloud environment and ingesting Salesforce data into their data pipeline using the Salesforce API.

Responsibilities:

• Provide support to the Data and Application Integration Team by developing and communicating middleware-based integration architecture, strategies, guidelines, standards, and leading practices.
• Provide support on technical and architectural direction, methodology, and design to support project initiatives.
• Create high-level design artifacts such as common business object models, component models and design abstracts.
• Experience in designing and building REST APIs is REQUIRED.
• Contribute thought leadership to the development and evolution of our Digital Enablement methodologies and build the framework and infrastructure to provide connectivity (APIs) to core business applications (Salesforce).
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of sources utilizing Python, Spark, AWS Lambda, etc.
• Strong real-life experience in Python development in AWS Cloud environment is required.
• Design, develop, test, deploy, maintain and improve data integration pipeline.
• Load and performance test data pipelines built using the above-mentioned technologies.

Requirements

• 5+ years of professional work experience with AWS and Python programming, experience with Python frameworks (e.g., Django, Flask, Bottle).
• Expert level knowledge of using SQL to write complex, highly-optimized queries across large volumes of data.
• Experience in designing and building REST APIs is required.

• At least 1 year of experience in ingesting Salesforce data using the Salesforce API is highly desireable.
• Working experience on ETL pipeline implementation using AWS services such as Glue or Talend or Informatica or DataStage, Python etc is highly desired.
• Hands-on professional work experience creating data pipelines using Python is required.
• Expert level knowledge of using SQL to write complex, highly-optimized queries across large volumes of data.
• Knowledge or experience in architectural best practices in building data lakes.
• Strong problem solving and troubleshooting skills with the ability to exercise mature judgement.
• Bachelor or Master's degree in Computer Science, Engineering or related field is required.
• Must be open to up to 25% travel to the client location, as required by the client.
  

Wavicle is an Equal Opportunity Employer and committed to creating an inclusive environment for all employees. We welcome and encourage diversity in the workplace regardless of race, color, religion, national origin, gender, pregnancy, sexual orientation, gender identity, age, physical or mental disability, gene

Benefits

• Health Care Plan (Medical, Dental & Vision)
• Retirement Plan (401k, IRA)
• Life Insurance (Basic, Voluntary & AD&D)
• Unlimited Paid Time Off (Vacation, Sick & Public Holidays)
• Short Term & Long Term Disability
• Training & Development
• Work From Home
• College Tuition Benefit
• Bonus Program

#LI-MK1