Salesforce Technical Data Architect

Leads end-to-end Salesforce data migration and integration initiatives. Designs ETL processes, writes SQL and SOQL queries, develops automation scripts, performs data profiling and transformation, and ensures data quality, security, governance, and reconciliation. Collaborates with Salesforce, integration, and business teams on cutovers, resolves migration issues, documents procedures, and delivers scalable data solutions using automation and AI-enabled tools., We have an opportunity for a Salesforce Technical Architect with deep expertise in data migration, ETL, and Salesforce data architecture. The ideal candidate will be located near a Perficient office.

Perficient is the global AI-first consultancy. Our team of strategists, designers, technologists, and engineers partners with the world’s most innovative enterprises and admired brands to deliver real business results through the transformative power of AI.

As part of our AI-First strategy, we empower every employee to build AI fluency and actively engage with AI tools to drive innovation and efficiency. We break boundaries, obsess over outcomes, and shape the future for our clients. Join a company where bold ideas and brilliant minds converge to redefine what’s possible - while building a career filled with growth, balance, and purpose.

The Salesforce Technical Data Architect leads end-to-end data migration and integration initiatives across Salesforce and connected enterprise systems. This role designs and executes data migration strategies, develops ETL processes and automation scripts, performs data profiling and transformation, and ensures data quality, integrity, security, and governance throughout the migration lifecycle. The architect partners closely with Salesforce, integration, and business teams to deliver seamless data transitions, resolve complex data challenges, and support scalable, data-driven solutions using modern automation and AI-enabled tools., * Plan, design, execute, and manage end-to-end data migration projects, including extraction, transformation, loading, and validation.

• Write and optimize complex SQL and SOQL queries for data validation, migration, and reconciliation.
• Build, configure, and run ETL jobs to move and transform data across Salesforce, ERP, and external databases.
• Develop and maintain automation scripts (Apex, Python, Shell, PowerShell, or similar) for data processing, cleansing, and quality checks.
• Perform data profiling, mapping, and transformation to meet business and technical requirements.
• Troubleshoot and resolve migration issues including data mismatches, performance bottlenecks, and integrity errors.
• Collaborate with Salesforce, integration, and business teams to coordinate cutovers and validate migrated data.
• Document migration procedures, scripts, mappings, and reconciliation steps for repeatability and compliance.
• Ensure all migrations follow best practices for data quality, security, and governance.
• Leverage AI tools to enhance productivity and support data-informed delivery., Owns end-to-end technical architecture for Salesforce Data 360 and Agentforce solutions. Designs scalable data models, ingestion and identity-resolution strategies, real-time activation, RAG and generative AI solutions, integrations with MuleSoft and enterprise data platforms, and CI/CD practices. Collaborates with customers and delivery teams throughout the project lifecycle, mentors technical staff, and ensures secure, governed, well-tested deployments. Top Skills: AgentforceAmazon ConnectAmazon RedshiftApexAWSBigQueryCi/CdData FederationDevOpsEtl/EltGitJavaJavaScriptMulesoftPythonRagSalesforce Data 360Salesforce EinsteinSalesforce PlatformService Cloud VoiceSnowflakeSQL NeuraFlash, As a Salesforce Technical Architect focused on Data & AI, you’ll design and implement solutions using Salesforce Data 360, oversee technical projects, collaborate with various stakeholders, and mentor junior staff to drive AI innovations.

• 5+ years of direct experience in data migration, ETL, or database engineering roles
• Strong technical expertise in relational database architecture (Salesforce, Oracle, SQL Server, or similar)
• Advanced proficiency in SQL including query optimization, joins, and stored procedures
• Practical experience with Salesforce SOQL, Apex, and the Salesforce data model
• Proven track record in data migration projects including reconciliation and cutover planning
• Hands-on scripting skills in Python, Shell, PowerShell, or similar
• Familiarity with ETL tools, APIs, and bulk data processing
• Experience with cloud platforms (AWS, Azure, or GCP) is a plus
• Strong analytical skills, attention to detail, and ability to deliver under tight deadlines
• Bachelor’s degree in Computer Science, Information Systems, or related field, or equivalent experience

Who We’re Looking For:

Technical depth gets you in the door. Beyond that, we’re hiring for four qualities together, not any one in isolation: humble, hungry, and smart.

Humble – a team player first. You teach as readily as you learn, and you don’t need to be the smartest person in the room to add value.

Hungry – genuinely curious and self-driven. You take on a new certification or course because you enjoy it, not because it’s assigned, and you dig into unfamiliar problems until you’ve figured them out.

Smart – people-smart. You read a room, enjoy talking with customers, and can hold your own in front of a client audience.

Remote or Hybrid United States 145K-196K Annually Senior level 145K-196K Annually Senior level Artificial Intelligence * Cloud * Information Technology * Sales * Security * Software * Cybersecurity Manage and mentor Product Managers while guiding product strategy, prioritization, roadmap execution, and lifecycle management for Rapid7’s cybersecurity platform. Partner with Product, Engineering, UX, executives, customers, and cloud ecosystem partners to define requirements, launch features, analyze usage and feedback, and drive market impact. The role also promotes AI-enabled product management practices, customer-centric decision-making, cross-functional alignment, and development of high-performing global teams. Top Skills: Artificial IntelligenceCloud SecurityVulnerability Management

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

• Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
• Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
• Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
• Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
• Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
• Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

Excited about AI – you’re already using AI tools to work faster and deliver better outcomes, and you want to keep pushing on that. This is where our SF+ practice is headed, so it’s a practical, non-negotiable skill, not a nice-to-have., About UsPerficient is the global AI and technology consulting firm disrupting the traditional consulting model. Powered by our 7,000+ advisors, engineers, and designers, Perficient implements AI-first solutions that break conventions and deliver outcomes that matter. Proudly serving clients that represent the world’s most innovative brands, and in collaboration with our powerful technology partner ecosystem, we bring deep industry expertise and data-driven design to redefine how businesses run and succeed. Perficient is different. For real. Learn more at perficient.com.