Mako Professionals is a specialized ITData Management Staffing firm based out of Palm Beach. They have a local client that has asked us to identify a Data Warehouse Architect for their team. Please apply if you are interested or if you want to speak with someone please reach out to and one of our recruiters will be glad to speak with you. Our clientrsquos story. Makorsquos client has been a leader in the telecommunications infrastructure industry for the past 30 years. With over 30,000 cell towers in 14 different countries, they address the nonstop demand for connectivity. Our customers are continually increasing their network capacities by building out or densifying their networks using cell towers, antenna placements on buildings and rooftops, and DAS and small cells ndash the infrastructure - this is what they do at Makos client. The People As a team member, you are the most valuable asset. They appreciate and recognize the impact you have on the success of the company, our customers and the communities they serve. They are collaborative and enjoy each otherrsquos company. They work hard to make those around us a success and they interact with each other in a positive and respectful manner. The Perks So many! Stay healthy with medical, dental and vision insurance options, join the company Wellness program, and use the gym on the premises. Become financially secure with our 401K plan, our annual stock grant, and our Employee Stock Purchase Program. Relax or take needed sick or personal time with 19 days of paid time off (PTO). Stay protected with life and disability insurance, as well as several other voluntary insurance options. Save money with various discount programs. Essential Duties Responsibilities This is a full time, on-premise position based in Boca Raton, FL. Design, implement, and support internal Data Warehouse reporting systems using Microsoft SQL and Microsoft Azure data technologies. Design, code, and implement complex business reporting within TSQL using Power BI with OLAP, DAX, MDX, and Stored Procedures, views, functions where applicable. Write, maintain, and perform ETLrsquos using SSIS and Azure Data Factory for production and test environments. Determines data warehouse structural requirements by analyzing client operations, applications, and programming, reviewing objectives with clients, evaluating current systems. Handle multiple simultaneous adhoc requests from users and prioritize based on business need in a fast paced, challenging environment. Maintains Data Warehouse performance by identifying and resolving production and application development problems calculating optimum values for parameters evaluating, integrating, and installing new releases completing maintenance answering user questions. Develops database solutions by designing proposed system, defining database physical structure (relational and star schema) and functional capabilities, security, backup, and recovery specifications. Responsible for making improvement recommendations to the Manager of Database Systems and Director, ERP Development concerning changes in business process, internal department process, software development tools. Updates job knowledge by participating in educational opportunities reading professional publications maintaining personal networks participating in professional organizations. Experience using and responding to events from SQL monitoring software such as Confio Ignite and Microsoft Systems center. Knowledgeable in Application Lifecycle Management. Test to Production deployment. Provide support to the development staff optimizing stored procedures and Transact-SQL. Deliver excellent service through actively learning the Companyrsquos business, responding to the needs of the internal customer, and following through on commitments. Ensures complete issue tracking and reporting is accomplished. Other projects and duties as assigned. Supervisory Responsibilities None Education andor Experience Bachelorrsquos degree required in Computer ScienceEngineering or related field, applicable industry certifications expected. 10+ years relevant experience with MS SQL Server in a Data Warehouse Reporting role ndash including extensive experience with Data Warehouse techniques. OLAP, MDX, DAX, T-SQL and coding triggers and stored procedures. Microsoft Data Scientist andor Microsoft Azure Data Engineer certifications expected. Functional experience as a data scientist working with big data distributed across the enterprise. Mastery of Microsoft Azure data technologies and data movement in and out of the cloud. Experience with implementation and tuning of Artificial Intelligence and Machine Learning. Extensive experience with development and deployment of interactive Microsoft Power BI reports leveraging multiple data sources. Expertise in designing, implementing and optimizing big data architecture using the Microsoft data stack with multiple internal and external data sources. Previous experience working in a large financial and accounting environment. Experience with SQL clustering in a SAN environment. Current technical expertise in Microsoft SSRS, SSAS, SSIS, Azure Data Factory, Azure SQL Database, and Azure AI. Microsoft Dynamics, Microsoft CRM, and Microsoft Sharepoint experience preferred. Demonstrated knowledge and advanced proficiency working with Microsoft Office 365 Suite software including Word, Excel, PowerPoint, SharePoint, and Outlook. Plus Oracle OBIEE and Hyperion Essbase experience. Language Skills Ability to read, analyze and interpret common scientific and technical journals, financial reports and legal documents. Excellent interpersonal, verbal and written communications skills. Mathematical Skills Ability to calculate figures and amounts such as discounts, interest, proportions, percentages, area and volume. Reasoning Ability Ability to define problems, collect data, establish facts and draw valid conclusions. Certificates, Licenses, Registrations MCDBA certification preferred. Work Environment The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Ablity to work a flexible schedule. Moderate noise level.