Note: The job is a remote job and is open to candidates in USA. Crew is a company that specializes in IT project delivery and business process improvement. They are seeking a Salesforce Data Analyst who will perform data analysis, transformation, and migration using T-SQL and DBAmp, while collaborating with cross-functional teams to ensure data integrity and adherence to Salesforce standards.
Responsibilities
- 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
- Demonstrate a strong working knowledge of the Salesforce data model, including standard and custom object relationships, record ownership, sharing rules, and field-level security
- 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
Skills
- 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
- 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
Benefits
- Comprehensive healthcare package (medical, dental, vision)
- Disability and group term life insurance
- Health and flexible spending accounts
- Utilization bonus
- 401(k) with match
- Flexible time off for salaried employees
- Parental leave for salaried employees
- Flexible work arrangements
Company Overview
- Founded in tandem with Turnberry Solutions, Crew serves as an innovative talent development program for both Turnberry and our clients by focusing exclusively on high-performing early-career consultants. It was founded in 2009, and is headquartered in Minneapolis, Minnesota, USA, with a workforce of 1001-5000 employees. Its website is http://theboomlab.com.