[Remote] Salesforce Data Analyst

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.ResponsibilitiesPerform end-to-end data analysis, transformation, and migration between source and target Salesforce orgs using DBAmp and T-SQL as the primary ETL toolsetWrite, test, and execute T-SQL migration scripts that leverage DBAmp linked-server connections to read from and write to Salesforce objects directlyAnalyze source data quality, identify transformation requirements, and design mapping logic that accounts for Salesforce object relationships, record types, and lookup/master-detail hierarchiesValidate migrated data for referential integrity, field-level accuracy, and adherence to Salesforce validation rules and order-of-execution considerationsDemonstrate a strong working knowledge of the Salesforce data model, including standard and custom object relationships, record ownership, sharing rules, and field-level securityParticipate in cross-functional project teams, including coordination with developers, admins, business analysts, and project managersOperate effectively within larger and geographically distributed (remote) teams, maintaining clear communication, and task visibilityFollow Agile/Scrum practices—contributing to sprint planning, daily stand-ups, backlog grooming, and retrospectivesSkillsBachelor's degree in Business Information Systems, Computer Science, a related field, or an equivalent combination of education and professional experienceProficiency in T-SQL, including writing complex queries, stored procedures, and data transformation scriptsHands-on experience with DBAmp (or similar Salesforce-to-SQL Server ETL tools) for direct data extraction, loading, and manipulation against Salesforce orgsSolid understanding of the Salesforce platform: object model, relationships (lookup, master-detail, junction), record types, validation rules, and order of executionDemonstrated experience with data analysis, data migration, and source-to-target mapping in enterprise environmentsExcellent written and verbal communication skills with the ability to translate technical concepts for business stakeholdersSalesforce Administrator or Platform App Builder certificationExperience with additional ETL/data tools (e.g., Informatica, Talend, MuleSoft, Jitterbit, Data Loader, Workbench, or Dataloader.ioExperience working within large-scale Salesforce org consolidation or multi-org environmentsExperience with SQL Server Management Studio (SSMS) and database administration fundamentalsBenefitsComprehensive healthcare package (medical, dental, vision)Disability and group term life insuranceHealth and flexible spending accountsUtilization bonus401(k) with matchFlexible time off for salaried employeesParental leave for salaried employeesFlexible work arrangementsCompany OverviewFounded 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.



Apply To This Job