Overview

Crew helps our clients deliver change through IT project delivery, business process improvement, and operational efficiency efforts. Our high-performing consultants are natural leaders who manage a wide range of responsibilities that vary from assignment to assignment. Our consultant training programs, investment in career development, and premier client portfolio ensure constant challenge and rapid growth for our employees. Crew data analysis associates bring data insights to life with predictive and descriptive analytics, create meaningful business intelligence and data visualization dashboards, and learn data profiling and cloud data practices.

Responsibilities

Data Analysis and Migration

Perform end-to-end data analysis, transformation, and migration between source and target Salesforce orgs using DBAmp and T-SQL as the primary ETL toolset
Write, test, and execute T-SQL migration scripts that leverage DBAmp linked-server connections to read from and write to Salesforce objects directly
Analyze source data quality, identify transformation requirements, and design mapping logic that accounts for Salesforce object relationships, record types, and lookup/master-detail hierarchies
Validate migrated data for referential integrity, field-level accuracy, and adherence to Salesforce validation rules and order-of-execution considerations

Salesforce Platform and Data Architecture

Demonstrate a strong working knowledge of the Salesforce data model, including standard and custom object relationships, record ownership, sharing rules, and field-level security

Collaboration and Project Execution

Participate in cross-functional project teams, including coordination with developers, admins, business analysts, and project managers
Operate effectively within larger and geographically distributed (remote) teams, maintaining clear communication, and task visibility
Follow Agile/Scrum practices—contributing to sprint planning, daily stand-ups, backlog grooming, and retrospectives

Qualifications

Bachelor's degree in Business Information Systems, Computer Science, a related field, or an equivalent combination of education and professional experience
Proficiency in T-SQL, including writing complex queries, stored procedures, and data transformation scripts
Hands-on experience with DBAmp (or similar Salesforce-to-SQL Server ETL tools) for direct data extraction, loading, and manipulation against Salesforce orgs
Solid understanding of the Salesforce platform: object model, relationships (lookup, master-detail, junction), record types, validation rules, and order of execution
Demonstrated experience with data analysis, data migration, and source-to-target mapping in enterprise environments
Excellent written and verbal communication skills with the ability to translate technical concepts for business stakeholders

Preferred Qualifications

Salesforce Administrator or Platform App Builder certification
Experience with additional ETL/data tools (e.g., Informatica, Talend, MuleSoft, Jitterbit, Data Loader, Workbench, or Dataloader.io)
Experience working within large-scale Salesforce org consolidation or multi-org environments
Experience with SQL Server Management Studio (SSMS) and database administration fundamentals

The salary range for this role is $62,000 to $85,000 or the hourly equivalent. Pay is based on several factors including but not limited to education, work experience, certifications, etc. In addition to your salary, Turnberry Solutions offers benefits such as a comprehensive healthcare package (medical, dental, vision), disability and group term life insurance, health and flexible spending accounts, a utilization bonus, 401(k) with match, flexible time off for salaried employees, parental leave for salaried employees, and flexible work arrangements (all benefits are subject to eligibility requirements). No matter where or when you begin a career with Turnberry, you'll find a far-reaching choice of benefits and incentives.

At Turnberry, we are committed to creating a positive and connected work environment for all and are fully invested in and focused on hiring and growing a diverse team of high performers. We believe that uniqueness in ideas, experiences, and backgrounds make us a better Turnberry: Turnberry is an Equal Employment Opportunity employer, and recruits, employs, trains, compensates, and promotes regardless of age, ancestry, family medical or genetic information, gender identity and expression, marital, military, or veteran status; national and ethnic origin; physical or mental disability; political affiliation; pregnancy; race; religion; sex; sexual orientation; and any other protected characteristics.

Americans With Disabilities Act (ADA)

Turnberry will provide reasonable accommodation with our application process upon request as required to comply with applicable laws. If you have a disability and require accommodation assistance in this application process, please send an email to our Human Resources department at turnberryhr@turnberrysolutions.com.

Salesforce Data Analyst