Senior Data Architect

$150,000 - $175,000/Yr

Alvarez & Marsal - Houston, TX

Part-time - Mid Level

Houston, TX

5,001-10,000 employees

Professional, Scientific, and Technical Services

About the position

Alvarez & Marsal is seeking a Senior Data Architect to enhance our corporate IT division, focusing on the development and improvement of our internal data warehouse and business intelligence systems. This role is crucial for supporting over 18 diverse business units, requiring expertise in SQL data warehousing, ETL processes, and Azure environments. The ideal candidate will have a strong attention to detail and a comprehensive understanding of data architecture principles.

Responsibilities

• Develop data architecture strategies aligned with the company's goals.
• Lead the redesign of the current SQL-based data warehouse for scalability, performance, and cost-efficiency.
• Design and oversee ETL development using Informatica.
• Consolidate and standardize ETL processes using specialized tools like Cloud Informatica.
• Collaborate with ERP and other teams to review and integrate Master Data Management (MDM) requirements.
• Support the data governance program to ensure data quality, security, and compliance.
• Utilize Informatica for seamless data integration and management.
• Improve existing and new subject areas within the SQL data warehouse.
• Maintain high standards of data quality, consistency, and security across various sources.
• Gather requirements and set data architecture standards in partnership with stakeholders.
• Create and maintain comprehensive data models, flowcharts, and governance protocols.
• Promote and implement best practices for data stewardship, integration, and warehousing.
• Supervise and enhance data infrastructure for optimal performance and scalability.
• Offer specialized knowledge on data organization, analytics, and cleansing.
• Manage sensitive data with the highest level of discretion and adherence to ownership protocols.
• Train users on new data components and data domain usage.

Requirements

• Bachelor's degree or equivalent in Computer Science.
• Minimum 5 years of experience in data architecture, integration, and management.
• Prior professional services experience preferred.
• Proven success in deploying Informatica and/or Snowflake solutions.
• Strong experience with the Azure data stack.
• Well-versed in data structures and algorithms.
• Ability to work with stakeholders to assess potential risks.
• Ability to analyze existing tools and databases and provide software solution recommendations.
• Ability to translate business requirements into non-technical, lay terms.
• High-level experience in methodologies and processes for managing large-scale databases.
• Demonstrated experience in handling large data sets and relational databases.
• High-level written and verbal communication skills.
• Knowledge of building modern data reporting solutions in cloud technologies, including Power BI, is a plus.
• Knowledge of enterprise data, data warehousing, and Azure cloud data platforms.
• Experience with integrating multiple source systems, such as Salesforce and custom-developed systems using REST API.
• Experience with Informatica Intelligent Data Management Cloud (IDMC), modeling, warehousing, and ETL methodologies using cloud-based technologies in the Microsoft stack.

Nice-to-haves

• Knowledge of building modern data reporting solutions in cloud technologies, including Power BI.

Benefits

• Healthcare plans
• Flexible spending and savings accounts
• Life, AD&D, and disability coverages
• 401(k) retirement plan with discretionary contributions
• Paid time off including vacation and personal days
• Seventy-two (72) hours of sick time
• Ten federal holidays
• One floating holiday
• Parental leave