at Huron Consulting Group in Chicago, Illinois, United States
Job Description
The Opportunity
Huron is a global consultancy that collaborates with clients to drive strategic growth, ignite innovation and navigate constant change. Through a combination of strategy, expertise and creativity, we help clients accelerate operational, digital and cultural transformation, enabling the change they need to own their future.
Join our team as the expert you are now and create your future.
Position Summary
Senior Associates play an integral client-facing project or work-stream leadership role. While activities vary based on project size/scope and individual skill-sets and strengths, the Sr. Associate can expect to spend their time with a heavy focus on material client interaction through all projects, project management, intensive data-analysis and the identification for the “so-what’s” therein, and to creating compelling client-ready presentations. Additionally, the Sr. Associate will focus on developing Analysts and Coachees.
Qualifications
The Opportunity
Huron is a global consultancy that collaborates with clients to drive strategic growth, ignite innovation, and navigate constant change. Through a combination of strategy, expertise, and creativity, we help clients accelerate operational, digital, and cultural transformation, enabling the change they need to own their future.
Join our team as the expert you are now and create your future.
Position Summary
The conversion lead is responsible for working directly with advancement clients to map and convert their existing legacy system data into Salesforce. In this role, you will leverage your knowledge of advancement data and use cases to work directly with the client to provide guidance on data mapping and translations to Salesforce. You will also serve as a developer, working both independently and with other developers to write SQL scripts to extract and transform the client’s source data into the format needed for Salesforce. The conversion lead must be experienced with SQL and have little trouble moving between Oracle, SQL Server, and other database platforms.
Job Description/Responsibilities:
+ Lead development of the client’s data conversion strategy in alignment with Huron’s practice standards.
+ Provide the client with guidance on establishing the data conversion environment(s) and tools necessary to facilitate the conversion workstream.
+ Prepare supporting materials, such as process documentation and presentations, to effectively support the client’s understanding of the data conversion process.
+ Actively participate in cross-functional project teams implementing Salesforce to ensure an understanding of the client’s use cases for their legacy data in Salesforce.
+ Partner with the client to establish strategies for data clean up and to support prioritization of data that should be converted from the legacy system to Salesforce.
+ Lead client-facing data mapping sessions to identify and document all legacy system data to be moved to Salesforce.
+ Lead team of developers to execute and troubleshoot script development, extraction, transformation, and loading.
+ Complete multiple test loads and final data conversion.
+ Implement and oversee internal quality assurance processes related to data conversion activities.
+ Investigate source and target systems to determine possible data migration strategies and actions
Relevant Skills & Experience
+ 5 years of related experience in the areas of data conversion, data analysis, or database management, preferably in an advancement organization.
+ BS or BA, or equivalent experience preferred.
+ Experience with Salesforce APIs and importing data into Salesforce preferred.
+ Advanced expertise in SQL and Excel.
+ Knowledge of fundraising systems (e.g., Blackbaud CRM, Raiser’s Edge, Banner, Advance, etc.)
+ Possess effective time-management skills and the ability to prioritize and complete tasks on time.
+ Skill to solve problems efficiently and creatively on your own.
+ Ability to lead other SQL developers through the data conversion process from beginning to end.
+ Ability to troubleshoot complex data conversion and migration problems and take corrective action
+ Investigate system databases to determine how the database system interacts with the system user interface to find relevant tables and data points.
Posting Category
Generalist
Opportunity Type
Regular
Country
United States of America
Huron Consulting Group offers a competitive compensation and benefits package including medical, dental, and vision coverage to employees and dependents; a 401(k) plan with a generous employer match; an employee stock purchase plan; a generous Paid Time Off policy; and paid parental leave and adoption assistance. Our Wellness Program supports employee total well-being by providing free annual health screenings and coaching, bank at work, and on-site workshops, as well as ongoing programs recognizing major events in the lives of our employees throughout the year. All benefits and programs are subject to applicable eligibility requirements.
Huron is fully committed to providing equal employment opportunity to job applicants and employees in recruitment, hiring, employment, compensation, benefits, promotions, transfers, training, and all other terms and conditions of employment. Huron will not discriminate on the basis of age, race, color, gender, marital status, sexual orientation, gender identity, pregnancy, national origin, religion, veteran status, physical or mental disability, genetic information, creed, citizenship or any other status protected by laws or regulations in the locations where we do business. We endeavor to maintain a drug-free workplace.