Lead SQL OLAP Developer

Sfp Holdings • Mendota Heights, MN

518d

About The Position

The Lead SQL OLAP Developer at SFP Holdings, Inc. will play a crucial role in the design, development, and implementation of a robust data warehouse on Azure Fabric. This position is essential for enabling data analytics capabilities through the creation of OLAP cubes and setting the groundwork for future AI-driven insights. The successful candidate will lead the development of a scalable and efficient data warehouse, ensuring that it meets the advanced data analytics, reporting, and business intelligence needs of the organization. In this role, the developer will be responsible for designing, developing, and maintaining OLAP cubes, which are vital for supporting complex data analytics and reporting requirements. The position requires a strong focus on data modeling, where the developer will create and implement intricate data models that facilitate data analytics and reporting, as well as future AI initiatives. Collaboration is key, as the developer will work closely with reporting teams, data analysts, and business stakeholders to understand their data needs and translate them into technical requirements. Additionally, the Lead SQL OLAP Developer will prepare the data warehouse infrastructure to support future artificial intelligence and machine learning projects, ensuring that data is structured and accessible for advanced analytics. Establishing and enforcing best practices for SQL development, data governance, and security within the data warehouse environment will also be a critical responsibility. The developer will maintain comprehensive documentation of the data warehouse architecture, ETL processes, and data models, while providing guidance and mentoring to development teams to enhance their cloud competencies. The role also involves managing cloud environments in compliance with the organization's security policies and utilizing cloud automation technologies.