SQL OLAP Developer

$150,000 - $150,000/Yr

Ledgent - Saint Paul, MN

Full-time - Senior

Saint Paul, MN

Administrative and Support Services

About the position

We are looking for a seasoned leader to join our Data & Analytics team, focusing on SQL OLAP development. This role involves designing, building, and implementing a cutting-edge data storage solution on a cloud platform, specifically tailored to enhance data analytics and lay the groundwork for AI-driven insights. This position is ideal for a technical leader with deep expertise in SQL OLAP development, ready to drive innovation and excellence in a dynamic data-focused environment. The successful candidate will lead the design, development, and deployment of a scalable data storage system using cloud technology, with a strong emphasis on SQL OLAP capabilities. Additionally, the role requires the design, creation, and maintenance of OLAP cubes to support advanced data analytics, reporting, and business intelligence. The candidate will also be responsible for developing complex data models and frameworks that support both current analytics and future AI-driven projects. Collaboration is key in this role, as the candidate will work closely with data professionals, business stakeholders, and reporting teams to translate data requirements into technical solutions. Furthermore, the candidate will prepare the data storage infrastructure to support future AI and machine learning initiatives, ensuring data is optimally structured for advanced analytics. Establishing and enforcing best practices for SQL OLAP development, data governance, and security within the data storage environment will also be a critical part of the role. Thorough documentation of the data architecture, ETL processes, and data models will be maintained to ensure clarity and compliance. Finally, the candidate will provide thought leadership, guidance, and mentoring to development teams to enhance cloud and SQL OLAP competencies, while managing cloud environments to ensure compliance with security policies and leveraging automation technologies where applicable.

Responsibilities

• Lead the design, development, and deployment of a scalable data storage system using cloud technology, with a strong emphasis on SQL OLAP capabilities.
• Design, create, and maintain OLAP cubes to support advanced data analytics, reporting, and business intelligence.
• Develop complex data models and frameworks that support both current analytics and future AI-driven projects.
• Work closely with data professionals, business stakeholders, and reporting teams to translate data requirements into technical solutions.
• Prepare the data storage infrastructure to support future AI and machine learning initiatives, ensuring data is optimally structured for advanced analytics.
• Establish and enforce best practices for SQL OLAP development, data governance, and security within the data storage environment.
• Maintain thorough documentation of the data architecture, ETL processes, and data models.
• Provide thought leadership, guidance, and mentoring to development teams to enhance cloud and SQL OLAP competencies.
• Manage cloud environments, ensuring compliance with security policies and leveraging automation technologies where applicable.

Requirements

• A degree in computer science, IT, or a related field, with advanced degrees and specialized cloud certifications being advantageous.
• 7+ years of experience in SQL development and data warehousing.
• Significant expertise in SQL OLAP, including the design, development, and implementation of OLAP cubes.
• Extensive experience in architecting and deploying cloud-based solutions, particularly within Azure services.
• Proficiency in data modeling techniques and experience with data integration and ETL tools in an Azure environment.
• Familiarity with AI and machine learning technologies is a plus.
• Strong collaboration skills with multidisciplinary teams, including developers, business analysts, and subject-matter experts.
• Excellent project management skills, with a strong ability to prioritize tasks and manage multiple projects concurrently.

Nice-to-haves

• Familiarity with AI and machine learning technologies is a plus.

Benefits

• Direct hire position with a competitive salary up to $150,000 annually.
• Flexible work arrangement: 3 days on-site and 2 days remote in Mendota Heights, MN.