Data Architect

Sazerac Company•Louisville, KY

3d•Remote

About The Position

An experienced Data Architect with deep expertise in Microsoft Azure data services, along with strong working knowledge of Azure Synapse, Fabric, SQL Server, IBM DB2, and Cognos. This role is responsible for developing and governing enterprise-wide data architecture strategies to ensure consistency, quality, security, and accessibility of data across the organization. This team member will bring both technical depth and strategic vision to design scalable, modern, cloud-first data solutions aligned with business objectives. This position can be remote in AL, AR, DE, DC, FL, GA, IN, IA, KY, LA, ME, MD, MS, MO, NV, NH, NC, OH, OK, PA, SC, SD, TN, TX, VA or WY. Use Performance Development System (PDS) to enhance performance within the company through evaluation, planning, and goal execution. Strive to constantly develop oneself as a valuable asset through personal and professional growth and attention to the position’s outcomes. Work closely with enterprise architects, data engineers, and governance teams to align data solutions with IT and business strategy. Provide leadership, and other functional areas, key measures against all performance based activities. Contribute to the overall company growth year over year by providing reliable data and support to all functions within the company. Provide data and systems that can be utilized by client groups to improve usability and thus team member’s efficiency of day to day activities. This will lead to improved business decisions and strategic planning. Define and enforce standards for data quality, data lineage, metadata management, and master data management (MDM). Lead architectural planning, data platform modernization, and migration of legacy systems (SQL Server, DB2) to Azure. Perform data architecture reviews and ensure alignment with security, privacy, compliance, and performance requirements. Develop and maintain canonical data models, conceptual/logical/physical data models, and metadata repositories. Design and own enterprise data architecture that supports both operational and analytical workloads across cloud and on-premise environments. Translate complex business needs into end-to-end data architecture that delivers high availability, data integrity, and scalability. Architect data integration pipelines and ELT/ETL frameworks using Azure Data Factory, Synapse Pipelines, and custom orchestration when needed. Participate in architecture governance forums and contribute to technology roadmaps and reference architecture blueprints. Ensure organization and proper time-management by following list of priorities and organizing tasks based on this list. Provide timely updates to team member or requestors. Provide weekly priority updates to manager, along with details of non-priority tasks completed. Serve as the SME on Azure Data Platform technologies: Azure Synapse Analytics, Azure SQL (Database/MI), Azure Data Lake Gen2, Azure Data Factory, Azure Purview or Microsoft Fabric, and Azure Databricks for advanced analytics and large-scale processing. Provide architectural guidance for reporting and analytics solutions, including optimization of Cognos reports and semantic models.

Requirements

Strong analytical and technical skills
Excellent oral & written communication skills
Working knowledge of MS Office Products (Word, Excel and Outlook)
Demonstrate the ability to work as a team as well as self-directed
Ability to handle multiple tasks at one time
Strong communication and interpersonal skills, with the ability to work effectively with cross-functional teams.
Detail-oriented with strong organizational and project management skills.
A proactive mindset and the ability to adapt to a fast-paced and dynamic work environment
Innovative, analytical, solution-oriented mindset with problem solving and strategic thinking skills to evaluate and provide actionable insights
8 years years of experience in data architecture, enterprise data solutions, or large-scale analytics environments
Bachelor’s degree in computer science, information systems, engineering, or related discipline
Extensive hands-on experience in: microsoft azure data services (synapse, adf, data lake, sql), microsoft fabric (lakehouse, real-time analytics), azure databricks, ibm db2, cognos analytics (report modeling, framework manager)
Strong understanding of data security, encryption, rbac, and compliance in cloud environments
Experience in enterprise data modeling (3nf, dimensional, data vault), data integration and transformation design, t-sql and db2 sql (procedures, indexing, tuning), metadata and data catalog design and usage
Proven ability to bridge the gap between business goals and technical execution

Nice To Haves

Azure certifications such as: microsoft certified: azure data engineer associate, microsoft certified: azure solutions architect expert
Experience with data governance tools (azure purview, informatica, collibra).
Experience with enterprise bi tools beyond cognos (e.g., power bi). and integration with microsoft fabric and azure databricks
Exposure to enterprise architecture frameworks (togaf, zachman) and data strategy initiatives
Experience working with oracle fusion erp and informatica is preferred

Responsibilities

Use Performance Development System (PDS) to enhance performance within the company through evaluation, planning, and goal execution.
Strive to constantly develop oneself as a valuable asset through personal and professional growth and attention to the position’s outcomes.
Work closely with enterprise architects, data engineers, and governance teams to align data solutions with IT and business strategy.
Provide leadership, and other functional areas, key measures against all performance based activities.
Contribute to the overall company growth year over year by providing reliable data and support to all functions within the company.
Provide data and systems that can be utilized by client groups to improve usability and thus team member’s efficiency of day to day activities.
Define and enforce standards for data quality, data lineage, metadata management, and master data management (MDM).
Lead architectural planning, data platform modernization, and migration of legacy systems (SQL Server, DB2) to Azure.
Perform data architecture reviews and ensure alignment with security, privacy, compliance, and performance requirements.
Develop and maintain canonical data models, conceptual/logical/physical data models, and metadata repositories.
Design and own enterprise data architecture that supports both operational and analytical workloads across cloud and on-premise environments.
Translate complex business needs into end-to-end data architecture that delivers high availability, data integrity, and scalability.
Architect data integration pipelines and ELT/ETL frameworks using Azure Data Factory, Synapse Pipelines, and custom orchestration when needed.
Participate in architecture governance forums and contribute to technology roadmaps and reference architecture blueprints.
Ensure organization and proper time-management by following list of priorities and organizing tasks based on this list.
Provide timely updates to team member or requestors.
Provide weekly priority updates to manager, along with details of non-priority tasks completed.
Serve as the SME on Azure Data Platform technologies: Azure Synapse Analytics, Azure SQL (Database/MI), Azure Data Lake Gen2, Azure Data Factory, Azure Purview or Microsoft Fabric, and Azure Databricks for advanced analytics and large-scale processing.
Provide architectural guidance for reporting and analytics solutions, including optimization of Cognos reports and semantic models.