The CRM Data Architect will collaborate with business analysts and other team members to determine the best design approach regarding data modeling, migrations, and integrations. The candidate must be extremely detail-oriented, have the ability to multitask, be meticulously organized, and be able to prioritize multiple demands in a fast-paced environment.

Essential Functions

  • Translate functional requirements into technical requirements and design
  • Analyze and interpret data to support data modeling, reporting, and analytics
  • Identify risks from data
  • Assist team members in: data quality/cleansing methodology and best practices, data modeling, CRM data design, migration planning, integration methodology and planning, migration & integration tool selection, master data management best practices, and more
  • Develop and/or analyze SQL Queries or data structures that support migrations or integrations to CRM
  • Development, testing, deployment and debugging of ETL packages
  • Database or ETL performance tuning
  • Document processes and procedures
  • Facilitate training on integration techniques and methods

Required Skills and Experience

  • Exhibit PowerObjects’ Core Values
  • Exceptional analytical skills
  • Strong written and verbal communication skills
  • Ability to work effectively within a team
  • 3 or more years of demonstrable working experience in, analysis and design of data migrations and integrations, analyzing business requirements, documenting design, and generating project specifications
  • Experience with Microsoft Dynamics or other CRM, Web Services, SQL query and database tools, SSIS, Scribe or other ETL tool

Desired Skills

  • FetchXML
  • Azure/Azure Service Bus
  • C#/ASP.NET