Data Architect

Role Overview

What would make you successful?

  • Bachelor’s Degree in computer science, information systems, or related IT field with coursework in an information technology specialization related to data modeling.
  • 5+ years of experience in an information technology area related to data architecture and data modeling.
  • 5+ years of experience with enterprise-level ETL tools/platforms such as Informatica, Power Center, Cast Iron, Oracle Warehouse Builder (OWB), etc.
  • 5+ years of experience working with complex relational databases, including normalization of data models.
  • 5+ years of experience with Data Warehousing data population techniques for target structures such as Snowflake Schemas
  • Highly developed knowledge of Data Warehouse design principles with dimensional data modeling for Business Intelligence tools.
  • Knowledge of performance tuning, database monitoring, SQL optimization, data archiving, table partitioning, indexes, etc.
  • Experience in enterprise-level data migration/upgrade projects
  • Experience in database administration and analyzing impact of underlying data structural changes.
  • Experience in managing metadata and supporting data governance initiatives.
  • 2+ years of experience with Customer Relationship Management platforms
  • Effective written and verbal communication skills, including presentation skills
  • Self-motivated, able to work independently, and capable of responsibly maintaining
  • schedules for time-sensitive projects.
  • Strong attention to detail and organizational skills.
  • Experience with and its suite of products (Marketing Cloud, Service
  • Cloud, Tableau, etc.) preferred
  • Experience in multiple industries, with a proven ability to deliver on strategic and tactical business objectives

Apply Now

 What is the Role?

   The  Data Architect will be responsible for designing, developing, and managing data models for enterprise level reporting systems. The Data Architect will design, implement and execute scalable integrations between customer enterprise applications that enforce data quality and adhere to strict consistency standards. They will serve as an engineer/expert in ETL/Integrations, Data Warehousing, Business Intelligence, Master Data Management, and database design. The Data Architect will work with other technical and non technical project members to understand and analyze business requirements and translate those requirements into effective data integration and data exchange programs and processes. They will assist with reviewing, researching, and resolving data errors or missing data.

The Data Architect will design and develop ETL programs to extract data from various source

systems, transform as required, and load data into specified target systems using best-in-breed

tools. They will maintain enterprise-wide integrity of data by ensuring that data currency and data cleansing procedures are implemented and followed.

The Data Architect will serve as the primary advocate for data stewardship and data processing best practices within Advancement Information Systems. They will set and maintain standards and best practices as the principal data architect and assist in research, testing of new functionality, data cleanup/archiving, data lifecycle management, and other tasks as necessary.

Gerent pays for all the examination vouchers for any Salesforce certifications and ensures that you have time to prepare and pass the certification exams.

We are looking to hire well rounded individuals that have and will constantly strive to improve upon the following consulting and people skills besides the technical competency skills.

  • Client Focus and Accountability
  • People Leadership/Drive to Succeed
  • Teamwork and Collaboration
  • Communication and Presentation Skills
  • Innovation, Creativity and Problem solving 

We are looking for Data Architects with various degrees of experience at this time. Outlined below are the responsibilities and qualifications that are typically expected of our Data Architects. The actual responsibilities and qualifications may vary slightly based on the experience and the level at which a candidate may get hired.

What will you be doing?

  • The Data along with the integration architect will establish integration and data standards, processes (ensure compliance) and operationalization of the integration solutions, assist in developing a secure, scalable governance and operating model which includes assessment of new applications and technologies to be integrated, protocols to support, and underlying infrastructure components to execute on
  • 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, data mapping and data migration
  • 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
  • Complete Trailheads and Salesforce Certification on the following within 12 months of start date.
  • OmniStudio Consultant
  • OmniStudio Developer
  • Salesforce App Builder
  • Salesforce Platform Developer I
  • Salesforce Data Architecture and Management Designer

Apply Now