Data Engineer
Passion Driven. Purpose Guided. Our People Make the Difference.
Why Neocol?
Neocol helps the world’s most innovative subscription companies solve their most pressing initiatives to ignite outpaced subscription performance. As the largest pure-play Salesforce Summit Partner specifically dedicated to the subscription economy, Neocol has created repeatable playbooks and assets that empower transformation at the highest level.
Day in the Life of a Data Engineer
As a Data Engineer, you will work directly with a data architect to migrate customer data from source systems to target systems, often Salesforce. This data typically includes CPQ (Configure Price Quote), Billing, Sales, and Service Cloud information. You will 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
Our Core Values in Action
-
Collaboration: Across all key stakeholders (employees, partners, customers), it is essential that we work together, as a team, to drive value in every interaction and implementation.
-
Creativity: We enjoy getting creative in the way we solution with our customers, work with our teammates, and drive value with our partners.
-
Trust: It is important that Neocol operate in a fun, open, and ethical environment. Trust is key to our culture.
-
Ownership: We are an environment focused on results and each individual has critical metrics that they are responsible for in order to help our customers and our organization.
-
Passionate: Care about what you do, why you do it, and the impact that it has our customers, employees, and partners.
Required Qualifications
1-3+ years of data migration experience
- A background and experience in successfully completing ETL efforts
- Experience with SQL or other programming languages
- Must 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
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 is helpful
- Experience with DBAmp, PDI, and Dataloading tools
- Familiarity with any other ETL or IPAAS tools
- Use and familiarity of Github, JIRA, and LucidChart are a plus
- 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
A Foundation Built on a Solid Culture
- Ladies+ League
- DE&I Committee
- Neocol Cares
- Mentorship Opportunities:
- Neocol North Star Program
- Neocol Navigate Program
Compensation is More than Salary
- 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
Please note:
Neocol is an equal opportunity employer. Neocol 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.
