Data Engineer

Summary

Join Neocol as a Data Engineer and work directly with a data architect to migrate customer data from various source systems to Salesforce. You will utilize tools like Microsoft SQL Server, DBAmp, and PDI to extract, transform, and load data. Responsibilities include participating in customer workshops, creating data migration plans, developing migration scripts, and ensuring data integrity. You will collaborate with project teams, provide status updates, and document processes. Neocol offers a fully remote work environment and various benefits, including a 401k match, health insurance, flexible PTO, and more.

Requirements

• 1-3+ years of data migration experience
• A background and experience in successfully completing ETL efforts
• Experience with SQL or other programming languages
• Possess the ability to develop SQL Scripts to include an understanding of Inner and Outer Joins, Common Table Expressions (CTEs), aliases, use of functions
• Understand basic database structure
• Ability to resolve logical problems and issues related to ETL processes and Data Analysis
• Demonstrated ability to be a self-starter and work well within a team environment

Responsibilities

• Work directly with a data architect to migrate customer data from source systems to target systems, often Salesforce
• Utilize tools such as Microsoft SQL Server, DBAmp, PDI, and various others to extract, transform, and load data into Salesforce
• Participate in customer workshops to discuss data migration processes and gather requirements
• Aid in the creation of data migration plans, including timelines and milestones, to ensure successful project completion based on data requirements
• Create field mappings, maintain user stories and Jira tickets, develop migration scripts, execute migrations to test and production environments, and troubleshoot/resolve issues
• Perform detailed reviews of customer data, verifying data integrity and identifying possible errors
• Participate in multiple engagements simultaneously, ensuring deadlines and quality standards are met
• Seek efficiencies and standardization in data migration processes
• Support complex migration projects from beginning to end
• Create a positive customer experience by building strong customer relationships
• Participate in regular check-in meetings with customers and project teams to provide status updates and address roadblocks
• Provide clear and detailed documentation of deployment steps, migration processes, test load results, and recommended testing areas
• Collaborate closely with Neocol project teams to ensure overall solutions include data migration considerations

Preferred Qualifications

• Javascript, Python, or other applicable languages for Data analysis and transformation
• Familiarity with extracting and importing data to SQL from CSV, Excel, JSON, or other file formats
• Experience with DBAmp, PDI, and Dataloading tools
• Familiarity with any other ETL or IPAAS tools
• Use and familiarity of Github, JIRA, and LucidChart
• Experience in performing multiple data migrations to Salesforce from various other platforms, to include Salesforce to Salesforce, Zuora, Netsuite, Intacct, Hub Spot, ZenDesk, or generic systems
• An understanding of Salesforce object architecture and its operation
• Familiarity with Salesforce Billing, Salesforce CPQ, Salesforce Sales Cloud, Salesforce Service Cloud

Benefits

• Fully remote workforce ensures that you have the tools you need to successfully perform your job and create a proper balance of work and personal life
• Employer match 401(k) plan
• Medical, vision & dental benefit offerings
• Adoption Assistance Program
• Flexible PTO
• Mobile & Internet reimbursement
• Certification Bonus Program