Data Architect - Raleigh, NC
Contract
Hybrid
This is a 6-month contract opportunity located in Raleigh, NC, with hybrid schedule, and potential to extend.
The ideal candidate will have a solid understanding of database architecture and data integration processes and will be responsible for ensuring that our data structures and warehouses are aligned to support global reporting needs. This position will be collaborating with various business and technical stakeholders like developers, architects, and analysts to deliver high quality data solutions that support our organizations growth and operational efficiency.
Job Duties
Design & Development
- Participate in all phases of the Enterprise Data platform development life cycle as appropriate; including, but not limited to gathering customer requirements, defining technical requirements, creating high level architecture diagrams, data validation etc.
- Develop new data pipelines and ETL processes, while enhancing the efficiency of existing ones to support our global reporting objectives.
- Work closely with product managers, developers/architects, and business/reporting analysts to define/sign-off data requirements.
Collaboration & Thought Leadership
- Partner with global and regional business cross- functional teams to ensure data alignment across the organization Subject Matter Expert (SME) on data interfaces from/to core platforms supported by Global Digital Team.
Documentation
- Create and maintain detailed data models, ER diagrams and data flow diagrams.
- Oversee the creation of Data mapping and data dictionary documents.
Qualifications
- Experience mapping, building, testing, and maintaining database pipeline architectures between Salesforce and SAP.
- Strong project management skills.
- Experience with software development life cycle.
- Strong organizational abilities, with a track record of successfully completing data-driven initiatives.
- Advanced skills in Microsoft Excel, PowerPoint and Word and comfort with large variety of online meeting tools.
- Strong understanding of relational database concepts.
- Working knowledge of Salesforce Data/Object model.
- Some familiarity with cloud base database solutions like Salesforce Data cloud, AWS, Azure, Google, SAP DWC/DataSphere.
- Some familiarity with data visualization tools such as Tableau, SAC, Power BI.
- Ability to work closely with data analysts, and other stakeholders to translate business requirements into technical solutions.
- Experience in designing, building, and optimizing ETL/ELT data pipelines to process large datasets.
- Understanding of best practices for data modeling, including star schemas, snowflake schemas, and data normalization techniques.
- Strong documentation skills for pipeline design and data flow diagrams.
- Experience with Salesforce integrations, ETL processes and data migration projects
- Fundamental DevOps Practices, including knowledge of unit testing, CI/CD, and repository management.
- Some understanding of CAN-SPAM and GDPR and other data privacy regulations.
Preferred Qualifications
- Knowledge of SAP, Salesforce and other critical platforms.
Travel Requirements