Alvarez & Marsal
Senior Data Architect
Alvarez & Marsal, Dallas, Texas, United States, 75215
Description
Location: This hybrid role (3X a week on-site) will be based at one of the
following AandM office locations
Tampa Office - 3111 W Dr Martin Luther King Jr Blvd, Tampa, FL 33607
Dallas - 2100 Ross Ave, Dallas, TX 75201
Houston - 700 Louisiana St Ste 3300, Houston, TX 77002
About AandM :
Alvarez and Marsal is a premier independent global professional services firm specializing in turnaround management, performance improvement, and corporate advisory services. With over 10,000 professionals in more than 70 locations across North America, Europe, Asia, and Latin America, we excel in problem-solving and value creation. Our strong operational heritage and hands-on approach enable us to work closely with organizations and stakeholders to tackle complex business issues and ma ximize value.
Position Overview:
Alvarez and Marsal is seeking a Senior Data Architect with a passion for data management and architecture to advance our corporate IT division. In this role, your expertise will be instrumental in the development and enhancement of our internal data warehouse and business intelligence systems, which support over 18 diverse business units. Your responsibilities will include designing, constructing, and improving our SQL data warehouse, ETL processes, and Azure environments, as well as resolving data and database issues. Success in this role requires meticulous attention to detail, proficiency with the Azure data stack, and a comprehensive understanding of data architecture principles.
Responsibilities:
Develop data architecture strategies aligned with our 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 our 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 our 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 from an accredited institution 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.
igh-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 (Microsoft SQL Server, Azure Data Studio, Azure Data Factory, Blob Storage) as well as non-Microsoft technology such as Snowflake
Compensation Statement:
The salary range is $150,000 - $175,000 annually, dependent on several variables including but not limited to education, experience, skills, and geography. In addition, AandM offers a discretionary bonus program which is based on a number of factors, including individual and firm performance. Please ask your recruiter for details.
#LI-LH1
Diversity and Inclusion:
AandM's entrepreneurial culture celebrates independent thinkers and doers who can positively impact our clients and shape our industry. The collaborative environment and engaging work-guided by Aand M's core values of Integrity, Quality, Objectivity, Fun, Personal Reward, and Inclusive Diversity-are the main reasons our people love working at AandM. Inclusive Diversity means we embrace diversity, and we foster inclusiveness, encouraging everyone to bring their whole self to work each day. It runs through how we recruit, develop employees, conduct business, support clients, and partner with vendors. It is the AandM way.
Equal Opportunity Employer:
It is Alvarez and Marsal's practice to provide and promote equal opportunity in employment, compensation, and other terms and conditions of employment without discrimination because of race, color, creed, religion, national origin, ancestry, citizenship status, sex or gender, gender identity or gender expression (including transgender status), sexual orientation, marital status, military service and veteran status, physical or mental disability, family medical history, genetic information or other protected medical condition, political affiliation, or any other characteristic protected by and in accordance with applicable laws. Employees and Applicants can find AandM policy statements and additional information by region here .
Unsolicited Resumes from Third-Party Recruiters:
Please note that as per AandM policy, we do not accept unsolicited resumes from third-party recruiters unless such recruiters are engaged to provide candidates for a specified opening and in alignment with our Inclusive Diversity values . Any employment agency, person or entity that submits an unsolicited resume does so with the understanding that AandM will have the right to hire that applicant at its discretion without any fee owed to the submitting employment agency, person or entity.
Full-time Positions and Part-time Positions Over 30 hours:
Regular employees working 30 or more hours per week are also entitled to participate in Alvarez and Marsal Holdings' fringe benefits consisting of healthcare plans, flexible spending and savings accounts, life, ADandD, and disability
Location: This hybrid role (3X a week on-site) will be based at one of the
following AandM office locations
Tampa Office - 3111 W Dr Martin Luther King Jr Blvd, Tampa, FL 33607
Dallas - 2100 Ross Ave, Dallas, TX 75201
Houston - 700 Louisiana St Ste 3300, Houston, TX 77002
About AandM :
Alvarez and Marsal is a premier independent global professional services firm specializing in turnaround management, performance improvement, and corporate advisory services. With over 10,000 professionals in more than 70 locations across North America, Europe, Asia, and Latin America, we excel in problem-solving and value creation. Our strong operational heritage and hands-on approach enable us to work closely with organizations and stakeholders to tackle complex business issues and ma ximize value.
Position Overview:
Alvarez and Marsal is seeking a Senior Data Architect with a passion for data management and architecture to advance our corporate IT division. In this role, your expertise will be instrumental in the development and enhancement of our internal data warehouse and business intelligence systems, which support over 18 diverse business units. Your responsibilities will include designing, constructing, and improving our SQL data warehouse, ETL processes, and Azure environments, as well as resolving data and database issues. Success in this role requires meticulous attention to detail, proficiency with the Azure data stack, and a comprehensive understanding of data architecture principles.
Responsibilities:
Develop data architecture strategies aligned with our 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 our 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 our 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 from an accredited institution 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.
igh-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 (Microsoft SQL Server, Azure Data Studio, Azure Data Factory, Blob Storage) as well as non-Microsoft technology such as Snowflake
Compensation Statement:
The salary range is $150,000 - $175,000 annually, dependent on several variables including but not limited to education, experience, skills, and geography. In addition, AandM offers a discretionary bonus program which is based on a number of factors, including individual and firm performance. Please ask your recruiter for details.
#LI-LH1
Diversity and Inclusion:
AandM's entrepreneurial culture celebrates independent thinkers and doers who can positively impact our clients and shape our industry. The collaborative environment and engaging work-guided by Aand M's core values of Integrity, Quality, Objectivity, Fun, Personal Reward, and Inclusive Diversity-are the main reasons our people love working at AandM. Inclusive Diversity means we embrace diversity, and we foster inclusiveness, encouraging everyone to bring their whole self to work each day. It runs through how we recruit, develop employees, conduct business, support clients, and partner with vendors. It is the AandM way.
Equal Opportunity Employer:
It is Alvarez and Marsal's practice to provide and promote equal opportunity in employment, compensation, and other terms and conditions of employment without discrimination because of race, color, creed, religion, national origin, ancestry, citizenship status, sex or gender, gender identity or gender expression (including transgender status), sexual orientation, marital status, military service and veteran status, physical or mental disability, family medical history, genetic information or other protected medical condition, political affiliation, or any other characteristic protected by and in accordance with applicable laws. Employees and Applicants can find AandM policy statements and additional information by region here .
Unsolicited Resumes from Third-Party Recruiters:
Please note that as per AandM policy, we do not accept unsolicited resumes from third-party recruiters unless such recruiters are engaged to provide candidates for a specified opening and in alignment with our Inclusive Diversity values . Any employment agency, person or entity that submits an unsolicited resume does so with the understanding that AandM will have the right to hire that applicant at its discretion without any fee owed to the submitting employment agency, person or entity.
Full-time Positions and Part-time Positions Over 30 hours:
Regular employees working 30 or more hours per week are also entitled to participate in Alvarez and Marsal Holdings' fringe benefits consisting of healthcare plans, flexible spending and savings accounts, life, ADandD, and disability