Salesforce Data Architect

Salesforce Data Architect

LOCATION: New York, NY

PACKAGE: $120,000.00 - $140,000.00, plus bonus, plus all US benefits

Company Information:

My client is a leading management and technology consulting firm, they offer a range of challenging and rewarding opportunities whether you are just starting out in your career, looking to advance in your career or seeking a senior leadership position. Their ground-breaking solutions in the public sector streamline operations and improve productivity. Our client’s employees are ambitious, committed and passionate problem solvers

Key Experience Required:

• Possess a client-focused attitude through conversations and documentation


• Demonstrate deep data integration and/or migration experience with Salesforce.com 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 modelling, 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


• Bachelor’s degree required

Role Information:

• Must be authorized to work for any U.S. employer


• Willingness to travel up to 50%


• 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 artefacts 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