Alvarez & Marsal - Tampa, FL
posted 3 months ago
Alvarez & Marsal is seeking a skilled Data Architect to join our corporate IT team. In this role, you will play a crucial part in expanding and designing our internal data warehouse and business intelligence functions, which support over 18 different business lines. Your primary responsibilities will include designing, building, and enhancing our SQL data warehouse, managing ETL processes, and working within Azure environments. You will also be tasked with troubleshooting data and database issues, ensuring that our data architecture is robust and efficient. To excel in this position, you will need a keen eye for detail and a solid understanding of data architecture fundamentals. You will be responsible for designing and commissioning new subject areas, implementing new or upgraded cloud data strategies, and creating Entity Relationship diagrams. Writing relational database queries and maintaining referential integrity will also be key components of your role. Additionally, you will manage master data, including its creation, updates, and deletion, and design, implement, and help maintain ETL migrations to Azure Data Factory. Your role will involve processing confidential data according to strict guidelines, providing quality assurance for imported data, and collaborating with business stakeholders and analysts. You will participate in peer design reviews and development sessions, develop data models, and be responsible for data acquisition, access analysis, and recovery. Supporting initiatives for data integrity and normalization will be essential, as will capturing requirements from internal customers and managing user requests for datasets. You will adhere to SDLC processes to ensure proper coding practices and train end users on new data elements. Your technical expertise will be vital in data storage structures, data mining, and data cleansing, and you will apply best practices in data pipeline and model design to create flexible data solutions.