Data Architect

Capco - Houston, TX

Full-time - Mid Level

Houston, TX

Chemical Manufacturing

About the position

Capco's Data Team is dedicated to transforming every aspect of our clients' businesses through effective data management. As a Data Architect, you will play a crucial role in formulating data strategies and defining business and technology initiatives across the data management lifecycle. In an era where digital technologies are rapidly advancing and regulations are becoming stricter, the importance of high-quality data is paramount. Our team works to establish comprehensive methods for managing data through the modern data supply chain, facilitating its consumption through analytics, modeling, AI, machine learning, dashboarding, and reporting. In this role, you will collaborate across various domains and solution offerings within Capco to tackle complex problems and develop innovative solutions. You will leverage leading data platforms to create data-driven strategies that drive transformation for our clients. Your responsibilities will include establishing policies and guidelines for Data Governance, ensuring that data decisions are consistent and adhere to best practices. You will also be responsible for maintaining up-to-date Data Standardization definitions, Data Dictionary, and Data Lineage, ensuring they are accessible to relevant stakeholders. Additionally, you will work closely with ETL, Replication, and DBA teams to determine best practices for data transformations and movements. Mentoring Data Analysts to uphold best practices in database design and data management will also be a key part of your role. You will assist in the overall architectural solutions, including Data Warehouse, Master Data Management (MDM), Operational Data Store (ODS), and Data Replication/ETL initiatives. Collaborating with business teams and the Enterprise Architecture team will be essential to ensure optimal architectural solutions from a data perspective. You will also play a significant role in implementing a strategic roadmap for MDM and ensuring that the architectural rules and design of the MDM process are well-documented and adhered to.

Responsibilities

• Establish policies, procedures, and guidelines regarding all aspects of Data Governance.
• Ensure data decisions are consistent and best practices are adhered to.
• Maintain Data Standardization definitions, Data Dictionary, and Data Lineage.
• Collaborate with ETL, Replication, and DBA teams to determine best practices for data transformations and movements.
• Work with support teams to ensure consistent and proactive support methodologies for data movements and transformations.
• Mentor Data Analysts to ensure adherence to best practices in database design and data management.
• Assist in overall architectural solutions including Data Warehouse, MDM, ODS, and Data Replication/ETL initiatives.
• Collaborate with business teams and the Enterprise Architecture team to ensure optimal architectural solutions from a data perspective.
• Assist in implementing a strategic roadmap for MDM implementation.
• Support the implementation of a Master Data Management tool.
• Establish policies, procedures, and guidelines for Master Data Management.
• Document architectural rules and design of the MDM process and ensure best practices are followed.
• Assist in Data Architecture strategy related to the Data Virtualization tool (Denodo).

Requirements

• 3+ years of Solution Architecture experience.
• 3+ years of MDM experience.
• 3+ years of Data Governance experience with knowledge of best practices.
• Extensive knowledge of Data Movement and Processing, including Middleware, ETL, API, OLAP, and best practices for data tracking.
• Good communication skills and the ability to present to various audience levels.
• Self-motivated and capable of working well in a team environment.
• Experience with Hadoop/MongoDB is a plus.
• Working experience with Data Virtualization is a plus.

Nice-to-haves

• Experience with cloud architecture.
• Familiarity with machine learning concepts.
• Knowledge of data governance frameworks.

Benefits

• Health insurance
• Dental insurance
• Vision insurance
• 401(k)
• Tuition reimbursement