Salesforce Data Architect

Data Architect, SQL, RDBMS, Oracle, Microsoft SQL Server, PostGres, data integration, migration,, cloud, coding, ETL tools, Informatica, SSIS, Pentaho, Talend
Full Time
Depends On Experience
Telecommuting not available Travel required to 10%.

Job Description

As a leading management and technology consulting firm, Acumen Solutions offers a range of challenging and rewarding opportunities whether you’re just starting out in your career, looking to advance your career, or seeking a senior leadership position. Acumen Solutions employees are ambitious, committed, passionate problem solvers. If you are up to the exciting challenge of the innovative, service-oriented field of consulting, we encourage you to view our open position.

Engage with us at or on Twitter @AcumenSolutions.

Acumen Solutions is hiring a Salesforce Data Architect to be based in our (HQ) McLean, VA office. 

General Duties

  • Lead data management and migration projects

  • Develop, maintain, and review data processes and architecture for both on-premise and cloud-based data systems

  • Conduct team reviews and recommend data modeling, administrative, and design improvements

  • Demonstrate ability to learn and research advanced data technologies and concepts, learning new skills and software as necessary

  • Work closely with team members to optimize database queries

  • Demonstrate high-level knowledge of enterprise IT organizational, business, and technical environments

  • Produce highly detailed document artifacts and maintain them for the duration of projects

  • Assess all risks and offer mitigation strategies, communicating impacts to project across multiple channels

  • Interpret client functional and informational needs and turn them into data requirements, process models, and active systems

  • Support assigned systems throughout transition periods

Skills & Experience

  • Possess a client-focused attitude through conversations and documentation

  • Demonstrate deep data integration and/or migration experience with and other cloud-enabled tools

  • Demonstrate expertise in complex SQL statements and RDBMS systems such as Oracle, Microsoft SQL Server, PostGres

  • Experience with master data management, data governance, data security, data quality and related tools desired

  • Demonstrate experience with complex coding through ETL tools such as Informatica, SSIS, Pentaho, and Talend

  • Demonstrate strong verbal and written communication skills across multiple levels of the organization

  • Coordinate management activities with others on the team

  • Experience with full-fledged data warehouse or data mart models

  • Experience with both dimensional and 3rd normal form data modeling, data integration, and reporting

  • Hands-on ability to set up reporting tools and build reports and ad hoc functionality

  • Experience with reporting / BI tools such as Business Objects, Cognos, or SSRS

  • Strong written and spoken communication skills

  • Related certifications in Informatica and Salesforce a plus

  • Experience with industry standards and frameworks such as TOGAF and DMBOK a plus

  • Previous experience in consulting is a plus

  • Ability to work for any U.S. employer

  • Bachelor’s Degree


Acumen Solutions offers the opportunity for growth and advancement, as well as a competitive base salary, annual performance based incentives, medical benefits & 401k.

About Us

Acumen Solutions is the trusted leader in Enterprise Cloud Transformation, helping organizations realize dramatic improvements in productivity and profitability through innovations in business and technology.  Industry and government leaders including American Express, Comcast, McKesson, the US Army, and the US Securities and Exchange Commission rely on our global consultants to deliver cloud solutions that yield exceptional results.  We apply this same focus on results to our unparalleled social responsibility program, generating sustainable impact across our local communities.

VEVRAA Federal Contractor

Posted By

1660 International Drive, Suite 500 McLean, VA, 22102

Dice Id : 10117591
Position Id : 621433
Have a Job? Post it