SQL OLAP Developer

Ledgent Technology
Mendota Heights, MN, United States
$150K a year
Permanent
We are sorry. The job offer you are looking for is no longer available.

Position Overview : 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 is a direct hire position that will pay up to $150,000 annually and will be 3 days on site (2 days remote) in Mendota Heights, MN.

Key Responsibilities :

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

Qualifications :

  • Educational Background : A degree in computer science, IT, or a related field, with advanced degrees and specialized cloud certifications being advantageous.
  • Experience :
  • 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.

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.

Desired Skills and Experience

SQL, OLAP, Data Modeling, Data Warehousing, Azure

All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status.

We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, and Los Angeles County Fair Chance Ordinance.

To the extent our customers require a background check for certain positions, the Company faces a significant risk to its business operations and business reputation unless a review of criminal history is conducted for those specific job positions.

15 days ago
Related jobs
Promoted
Legrand AV, Inc.
Minneapolis, Minnesota

Working under the guidance of the software supervisor, candidate will develop software for assigned projects in coordination with other software, hardware, and FPGA team members for design implementation and verification of new products. The Software Engineer Intern will assist with new product deve...

Promoted
Metropolitan Council
Saint Paul, Minnesota

This includes databases, data platforms, data lakes, data warehouses, and data marts as well as data movement (data pipelines/ETL/ELT - extracting, transforming, and loading data). Design, develop, and maintain data solutions for operations, reporting, and analytics, including databases, data platfo...

Promoted
Consolidated Communications
Edina, Minnesota

As a Data Analyst II, you will work collaboratively and support cross-functional team members, provide and create analytical and reporting solutions for the Field Operations, Call Center and Consumer business segments. Create data pipelines for ETL processes using Snowflake, Alteryx or similar tools...

Promoted
Talent Software Services
Richfield, Minnesota

Job Summary: Talent Software Services is in search of a Back End Developer for a contract position in Richfield, MN. ...

Promoted
University of Minnesota
Minneapolis, Minnesota

Data Analyst/ Database Manager. Data Analyst/Database Manager position within the Office of Nursing Research and Scholarship's (ONRS) Statistics Team. The Data Analyst/Database Manager will partner with the ONRS Statistics Team to:. Provide data quality control, data maintenance support and perform ...

Promoted
Housekeeper.com
Minneapolis, Minnesota

DATA ENTRY ANALYST/ ADMINISTRATIVE ASSISTANT We are searching for motivated Specialists. The Data Entry Specialist will be the key liaison between our clients and our company, our representatives are the face and the backbone of our organization. Meetings with clients are done using Zoom and Cicso W...

Promoted
Beacon Hill
Minneapolis, Minnesota
Remote

We are looking for an experienced ETL Developer to build out and optimize specific components of our new hire automation process using SQL Server Integration Services (SSIS). Proven experience with SQL Server Integration Services (SSIS) and developing complex ETL solutions. ...

Promoted
Dew Software Inc
Minneapolis, Minnesota

Dew Software is looking for a talented Quality Engineer to join our team. As a Quality Engineer, you will play a vital role in ensuring the quality, reliability, and performance of our software products. We are a leading software solutions company that values quality and strives to deliver top-notch...

Promoted
SmartThings
Minneapolis, Minnesota

We're looking for an Embedded Software Engineer who'll be responsible for the development of software for core hub application features. In this role, you'll be part of the SmartThings Hub Platform team responsible for developing, building, and deploying software that runs on platforms within the Sm...

Promoted
Veradigm®
Minneapolis, Minnesota
Remote

We are looking for a Senior Quality Engineer to join our data engineering team. Design, develop, and implement comprehensive data quality tests to identify anomalies, inconsistencies, and data integrity issues for new product development initiatives, product changes, policy changes, and database cha...