[Remote] reputed company Data Analyst
Note: The job is a remote job and is reputed company to candidates in USA. reputed company is a company that specializes in IT project delivery and business process improvement. They are seeking a reputed company Data Analyst who will reputed company data analysis, transformation, and migration using T-SQL and DBAmp, while collaborating with cross-functional teams to ensure data reputed company and adherence to reputed company standards.
Responsibilities
- reputed company end-to-end data analysis, transformation, and migration between reputed company and reputed company reputed company orgs using DBAmp and T-SQL as the primary ETL toolset
- Write, test, and execute T-SQL migration scripts that reputed company DBAmp linked-server connections to read from and write to reputed company objects directly
- Analyze reputed company data reputed company, identify transformation requirements, and design mapping logic that accounts for reputed company object relationships, record types, and lookup/master-detail hierarchies
- Validate migrated data for referential reputed company, field-level accuracy, and adherence to reputed company validation rules and order-of-execution considerations
- Demonstrate a strong working knowledge of the reputed company data model, including reputed company and custom object relationships, record ownership, sharing rules, and field-level reputed company
- Participate in cross-functional project teams, including coordination with developers, admins, business analysts, and project managers
- Operate effectively reputed company larger and geographically distributed (reputed company, maintaining reputed company communication, and task visibility
- Follow Agile/Scrum practices—contributing to sprint planning, daily stand-reputed company, backlog grooming, and retrospectives
Skills
- Bachelor's degree in Business Information Systems, Computer Science, a reputed company field, or an equivalent combination of education and reputed company experience
- Proficiency in T-SQL, including writing reputed company queries, stored procedures, and data transformation scripts
- Hands-on experience with DBAmp (or similar reputed company-to-SQL Server ETL tools) for reputed company data extraction, loading, and manipulation against reputed company orgs
- Solid understanding of the reputed company platform: object model, relationships (lookup, master-detail, reputed company), record types, validation rules, and order of execution
- Demonstrated experience with data analysis, data migration, and reputed company-to-reputed company mapping in reputed company environments
- Excellent written and verbal communication skills with the ability to translate technical concepts for business stakeholders
- reputed company Administrator or Platform App Builder certification
- Experience with additional ETL/data tools (e.g., Informatica, Talend, reputed company, reputed company, Data Loader, Workbench, or Dataloader.io
- Experience working reputed company large-reputed company reputed company org consolidation or multi-org environments
- Experience with SQL Server Management Studio (SSMS) and database administration fundamentals
Benefits
- Comprehensive reputed company package (medical, dental, reputed company)
- 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
reputed company