Principal Data Engineer
insightsoftware
CloudOracle
Salesforce Data Migration Lead
ON Partners
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteSalary
💰 $170,000 - $200,000 per year
Job Level
Senior
Tech Stack
CloudETLOracleRDBMSSDLCSQL
About the role
- The candidate will be responsible for leading data migration and integration projects through the requirements definition and solution design phases.
- The candidate will be responsible for the overall solution design to meet the business requirements and fulfill user stories, and for leading a team of resources through the build, test, and deployment phases for data migrations and integrations.
- The candidate must demonstrate progressive leadership in the full life cycle of the software development environment.
- Through user story definition, logical data model design, functional system design, and best-practice methodologies, you will be responsible for the detailed design of enterprise-level Salesforce and related technology projects from inception through production support.
- You will be responsible for providing industry best practices as a trusted advisor to key business and technology stakeholders and identifying areas of product growth.
Requirements
- Expert level understanding of the Salesforce product suite – preferably the ascend managed package – in relation to data structure and data model.
- Extensive experience with cloud-based higher education and nonprofit fundraising systems such as Ellucian’s Advance product or Raiser's Edge, both end-user interaction and the underlying data structures.
- Experience and working knowledge of Higher Education Advancement business operations such as: prospect management, annual giving, major gift giving, planned gifts, donor stewardship, gift receipting, and pledge reminders.
- Extensive experience in the technical migration from legacy CRM platforms to state-of-the-art solutions such as Kindsight's ascend. This includes data migrations, system integrations, reporting, testing, and deployment.
- 10+ years direct experience in software development life cycle.
- 5-8 years’ experience in implementing data integration and migration processes with Salesforce-based CRM systems.
- Proven experience in overseeing the direction, development, and implementation of best-practiced migration and integration projects.
- Extensive experience with ETL, data transformations, SQL, and RDBMS platforms, in particular Oracle RDBMS
- Experience in documenting current state business processes and wireframing system designs using process flow diagram tools, sequence diagrams, etc. as well as making recommendations for future state improved processes and system designs.
- A strong background in database design and system architecture.
- Experience integrating Salesforce with different business systems, as well as working with ETL integration tools such as Oracle SQL Developer and MuleSoft.
- Expert level understanding of environment management, release management, code versioning best practices, and deployment methodologies.
- Salesforce Admin Certification.
Benefits
- Competitive health, dental, and vision coverage, HSA and FSA accounts, life and disability insurance, fertility and family planning benefits, and employee assistance and discount programs
- 11 paid federal holidays and flexible unlimited time off (UTO)
- Generous 401(k) matching with immediate vesting
- Flexible career paths – our career tracks provide advancement, mobility, and flexibility as you continue to grow with us
- A healthy environment where we value unique experiences, and care about everything that makes you, you.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
Salesforce product suitedata migrationdata integrationETLSQLRDBMSdatabase designsystem architecturecloud-based systemssoftware development life cycle
Soft skills
leadershipcommunicationproblem-solvingstakeholder managementproject managementadvisory skillsteam leadershipanalytical thinkinguser story definitionprocess improvement
Certifications
Salesforce Admin Certification
