Cacique® is the #1 brand of authentic Mexican-style cheeses, cremas, chorizos and salsas in the United States. With a leadership position among the Hispanic population nationwide and over 13 years of consecutive revenue growth, Cacique is poised for continued growth and expansion.

Cacique was founded in 1973 upon the four core values of Family, Quality, Integrity, and Authenticity, and these values continue to provide the foundation for our success and how we work. We look to hire future teammates who embody these values, and who are innovative, resourceful, determined, and catalysts of change. As a dedicated, family-owned company, Cacique offers a rewarding environment in which to thrive and grow your career.

Role Overview

The Business Intelligence Data Architect will play a key role in the delivery of critical data and information to the Cacique executive team and business units. The BI Data Architect is responsible for promoting and driving business initiatives with data. This position will provide technical and team leadership capabilities in business intelligence, data warehousing, and analytics. This role will apply technical knowledge and experience to project solutions and will provide technical guidance to the business. The successful candidate must be knowledgeable in all aspects of design and construction of Business Intelligence solutions. They will be a problem solver, creative thinker, fast learner, be detail-oriented, and interested in learning the business of Cacique.

Key Responsibilities:

•          Design, architect, implement and support simple to complex enterprise data warehouses using Microsoft Azure cloud technologies.
•          Own and understand existing infrastructure, troubleshoot, and escalate as determined.
•          Lead discovery and requirements gathering sessions with end-users at every level.
•          Ability to partner with the business analysts to align business needs with tech solutions.
•          Scope requested enhancements.
•         Ensure completion of tasks, milestones, and components including but not limited to functional specifications, design specifications, configurations, quality assurance, implementations, and project reviews.
•         Spearheads development of logical and physical data models, and ETL development, as needed.
•          Building reports, dashboards and scorecards using a variety of tools  
•         Train end users and system administrators
•          Provide end-users with ongoing technical support and troubleshooting.
•          Lead additional optimization initiatives as businesses change and grow.
•         Work on multiple projects at the same times
•          Interact effectively with internal and external resources at all organizational levels.

Required Skills:

• Strong focus and ability to design, manage and construct a Dimensional Data Warehouse
• Strong proficiency with Azure SQL DB, Azure Data Lake, Azure Data Factory, Azure Analysis Services (AAS), Visual Studio, Microsoft SQL Server Management Studio (SSMS) and/or Visual Studio Code (VS Code), Azure Synapse Analytics
• Excellent project management, organization, and follow-up skills
• Excellent people skills
• Ability to meet deadlines and work on multiple projects simultaneously.
• Must be a team player; able to work in virtual teams and independently.
• Willingness and ability to travel.
• Strong data and business acumen, and ability to speak about technology in the language of business.

Required Experience:

• Bachelor's degree or graduate degree and/or 6-8 years of related work experience
• Hands-on experience with data modeling (normalized and de-normalized data models), understanding of the appropriate purpose for each.
• Deep experience using T-SQL scripts (stored procedures, views, functions, etc.) to manipulate data and simplify access to data.
• Analyst and data visualization experience with Power BI
• Experience with Microsoft Dynamics Finance and Supply Chain Management (F&SC) data, entities, and base tables(D365)
• Experience with data science, machine learning, and Artificial Intelligence (AI) methods
• Experience with data science programming languages such as Python or R
• Experience with Azure Machine Learning
• Experience with Microsoft Dataverse Link to Fabric is a plus.

At Cacique, eligible teammates receive a comprehensive benefits package which includes medical, dental, vision, life insurance and short-term disability.  As well as vacation, sick, holiday pay, birthday day off, 401k with company match, and more!

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity and/or expression, status as a veteran, and basis of disability or any other federal, state, or local protected class. When we collect your personal information as part of a job application or offer of employment, we do so in accordance with industry standards and best practices and in compliance with applicable privacy laws.