BUSINESS INTELLIGENCE DATA ARCHITECT

Summary The Business Intelligence Architect will be responsible for designing, developing, and maintaining the company's core BI infrastructure. This role requires deep technical expertise in data warehousing, ETL processes, and database management, with a keen eye for how data can be leveraged for advanced analytics. The ideal candidate will be an expert in the Microsoft BI stack, particularly with D365 Finance and Operations (FO), Azure Synapse Analytics, and SQL Server. This role will also be crucial in laying the technical groundwork for future AI and machine learning initiatives. Key Responsibilities Design, architect, implement, and support enterprise data warehouses using Microsoft Azure cloud technologies. Own and understand existing infrastructure, troubleshoot, and escalate issues as needed. Lead discovery and requirements gathering sessions with end-users at all levels. Partner with business analysts to align business needs with technical solutions. Scope requested enhancements. Complete tasks, milestones, and components including specifications, configurations, QA, and project reviews. Build reports, dashboards, and scorecards using various tools. Train end users and system administrators. Provide ongoing technical support and troubleshooting. Lead optimization initiatives as the business evolves. Manage multiple projects simultaneously. Interact effectively with internal and external resources at all organizational levels. Design, implement, and manage ETL pipelines from D365 FO to Azure Synapse Analytics. Develop and maintain semantic layers and data models within Azure Synapse. Write and optimize complex SQL stored procedures, functions, and views. Ensure data integrity, security, and performance. Collaborate with stakeholders to translate business requirements into data solutions. Evaluate and prepare infrastructure for predictive analytics and data science applications. Stay current with emerging BI and data analytics technologies and best practices.

Qualifications & Education Bachelor's or graduate degree and/or 6-8 years of related experience. Experience with data modeling (normalized and de-normalized). Deep experience with T-SQL scripting. Power BI experience for data visualization. Experience with Microsoft Dynamics F&SC data, entities, and tables (D365). Knowledge of data science, machine learning, and AI methods. Experience with programming languages like Python or R. Experience with Azure Machine Learning. Preferred: Microsoft D365 F&O experience/exposure. Experience with Microsoft Dataverse and Fabric is a plus.

Physical Demands & Work Environment Office environment usually quiet. Occasional physical activities up to 50 pounds.

Seniority level

Mid-Senior level

Employment type

Full-time

Job function

Business Development and Sales

Industries

Food and Beverage Manufacturing

Referrals increase your chances of interviewing at Cacique Foods, LLC. by 2x. Get notified about new Business Intelligence Architect jobs in

Irving, TX . #J-18808-Ljbffr