Lead SQL OLAP Developer

3 weeks ago

Mendota Heights, United States SFP Holdings, Inc Full time

Are you interested in working for the nation's leading fire protection company and beginning a rewarding and satisfying career that helps save the lives of thousands each year? Do you want to be a part of a growing and expanding team of industry experts? If so, exploring career opportunities with Summit Companies may be right for you Summit Companies, through its subsidiaries, is a full-service provider for fire detection, suppression, and security with a full suite of capabilities that includes design, installation, testing, inspections, and maintenance. We serve customers across many verticals on a local, regional, and national scale. We're proud of our well-deserved reputation for quality work that's completed by our talented and experienced installation workforce. Summit Companies is a dynamic organization with endless growth opportunities spanning over 100 locations in more than 30 states. Our company is consistently recognized for service excellence in the fire protection industry. Summit Companies supports trade skills and workforce development by hosting Recognized Apprenticeships and on-the-job training (OJT) programs for new career-seekers. Many members of our leadership team serve as chair on NFPA code compliance committees, serve on regional safety boards, and support technical education in local schools. Summit Companies supports employees in their professional development by offering continued development, training, and education by encouraging NICET and other career-advancing certifications. We continually strive to be the Employer of Choice for highly motivated team members who want to succeed in a high-growth environment. We encourage initiative, independence, diversity, and personal career growth. The combination of experience, knowledge, and customer service is the key to our performance and helps us achieve our goal of providing the highest quality of fire protection services to protect lives and property. JOB SUMMARY: The Lead SQL OLAP Developer will focus on designing, developing, and implementing a robust data warehouse on Azure Fabric. The successful candidate will be instrumental in enabling data analytics capabilities through the creation of OLAP cubes and setting the foundation for future AI-driven insights. ESSENTIAL JOB DUTIES: Data Warehouse Development: Lead the design, development, and implementation of a scalable and efficient data warehouse using Azure Fabric. Cube Development: Design, develop, and maintain OLAP cubes to support advanced data analytics, reporting, and business intelligence needs. Data Modeling: Develop and implement complex data models that support data analytics, reporting, and future AI initiatives. Collaboration: Work closely with reporting, data analysts, and business stakeholders to understand data needs and translate them into technical requirements. AI Readiness: Prepare the data warehouse infrastructure to support future artificial intelligence and machine learning projects, ensuring data is structured and accessible for advanced analytics. Best Practices & Standards: Establish and enforce best practices for SQL development, data governance, and security within the data warehouse environment. Documentation: Maintain comprehensive documentation of data warehouse architecture, ETL processes, and data models. Give development teams advice, thought leadership, and mentoring to help them enhance their cloud competencies. Ensure application size, performance, and uptime while upholding strict code quality criteria. Manage cloud environments in compliance with the organization's security policies. Utilize Cloud's automation technology possibilities. QUALIFICATIONS The qualifications listed below are representative of the elements required to perform the job successfully, however in some cases, an equivalent combination of Education, Training, Certifications and Experience may meet the job qualifications. Education, Training, Certifications: High school Diploma, or equivalen , required. Bachelor's or master's degree in computer science, information technology, or relevant discipline, strongly preferred. Experience, Knowledge, Skill Requirements: 7+ years of experience in SQL development and data warehousing. Three or more years of experience in architecting, designing, developing, and implementing cloud solutions Azure SQL Database, Azure Data Factory, or Azure Synapse Analytics. Proven experience in designing and implementing OLAP cubes and data models. Experience with data integration and ETL tools, preferably in an Azure environment. Proficient in data modeling techniques, including star and snowflake schemas. Experience with AI and machine learning technologies is a plus. Providing support to cloud users Experience in several of the following areas: database architecture, ETL, business intelligence, advanced analytics Proven ability to collaborate with multidisciplinary teams of business analysts, developers, and subject-matter experts Excellent project management skills and strong ability to prioritize, preferred. Communication Skills: Must have the ability to effectively read, write and communicate in English with employees and customers Other Qualifications: Valid driver's license with acceptable driving record required. Must be able to comply with SFPH's Drug and Alcohol policy and Background screening requirements, which may also include customer specific requirements based on contractual agreement PHYSICAL & WORK ENVIRONMENT REQUIREMENTS Reasonable accommodations may be made to enable individuals with disabilities to perform Essential Job Duties. Physical Requirements: While performing the duties of this job, the employee is required to sit for long periods. Employee will occasionally be required to bend, kneel, balance, lift

  • Data Analyst

    2 weeks ago

    Mendota Heights, Minnesota, United States Ledgent Technology Full time

    Job Title: Data Analyst - AzureWe are seeking a highly skilled Data Analyst to join our team at Ledgent Technology. The ideal candidate will have a strong background in enterprise environments and be proficient in Azure Fabric.Key Responsibilities:Data Warehouse Development: Design and deploy a robust, scalable cloud-based data warehouse using Azure Fabric...

  • Data Analyst

    4 weeks ago

    mendota heights, United States Ledgent Technology Full time

    We are looking for a skilled professional to fill a direct hire position for a Data Analyst (Azure) at our customer's office in Mendota Heights, MN, with an annual salary of up to $140,000. The ideal candidate will have a strong background in enterprise environments.Candidates must also be eligible to work in the United States without sponsorship both now...

  • Data Analyst

    6 days ago

    Mendota Heights, Minnesota, United States Ledgent Technology Full time

    We are seeking a skilled professional to fill a direct hire position for a Data Analyst (Azure) at our customer's office in Mendota Heights, MN, with an annual salary of up to $140,000. The ideal candidate will have a strong background in enterprise environments.Candidates must also be eligible to work in the United States without sponsorship both now and in...

  • Data Analyst

    2 weeks ago

    mendota heights, United States Ledgent Technology Full time

    We are looking for a skilled professional to fill a direct hire position for a Data Analyst (Azure) at our customer's office in Mendota Heights, MN, with an annual salary of up to $140,000. The ideal candidate will have a strong background in enterprise environments.Candidates must also be eligible to work in the United States without sponsorship both now...

  • Data Analyst

    1 month ago

    Mendota Heights, United States Ledgent Technology Full time

    We are looking for a skilled professional to fill a direct hire position for a Data Analyst (Azure) at our customer's office in Mendota Heights, MN, with an annual salary of up to $140,000. The ideal candidate will have a strong background in enterprise environments.Candidates must also be eligible to work in the United States without sponsorship both now...

  • Data Analyst

    4 weeks ago

    Mendota Heights, Minnesota, United States Ledgent Technology Full time

    Job Title: Data AnalystWe are seeking a highly skilled Data Analyst to join our team at Ledgent Technology. As a Data Analyst, you will play a critical role in helping us make data-driven decisions by analyzing and interpreting complex data sets.Key Responsibilities:Design and deploy a robust, scalable cloud-based data warehouse using Azure Fabric to fulfill...

  • SQL Developer 2

    4 weeks ago

    Sterling Heights, Michigan, United States US Tech Solutions, Inc. Full time

    SQL Developer 2 Job DescriptionUS Tech Solutions, Inc. is seeking an experienced SQL Developer 2 to optimize and develop SQL queries, ensure data integrity, and support application development in a remote setting.Key Responsibilities:Developing SQL scripts and queries to support application developmentOptimizing and troubleshooting existing SQL queries for...

  • IBM BPM/BAW Developer

    6 days ago

    Mendota Heights, Minnesota, United States Elevance Health Full time

    Job Summary:We are seeking a highly skilled IBM BPM/BAW Developer to join our team at Elevance Health. As a key member of our organization, you will be responsible for designing, developing, and implementing business processes using IBM BAW product suites.Key Responsibilities:Maintain active relationships with customers to determine business requirements and...

  • IBM BPM/BAW Developer

    1 week ago

    Mendota Heights, Minnesota, United States Elevance Health Full time

    Job Summary:The IBM BPM/BAW Developer is responsible for designing, developing, and implementing business processes using IBM BAW product suites. This role requires strong technical skills and experience with multi-dimensional platforms, business, and technical applications.Key Responsibilities:Maintains active relationships with customers to determine...

  • SQL Database Administrator

    1 week ago

    Middleburg Heights, Ohio, United States Quadax Full time

    Job Summary:The Database Systems Engineer will oversee the administration of Quadax's Microsoft SQL Server environments. This role requires a strong analytical and troubleshooting skillset, with experience in performance tuning and optimization of SQL Server environments. The successful candidate will collaborate with the IT and application development teams...

  • Business Intelligence Architect

    6 days ago

    Inver Grove Heights, Minnesota, United States Alliant Insurance Services, Inc. Full time

    Job DescriptionAt Alliant Insurance Services, Inc., we are seeking a highly skilled Business Intelligence Architect to join our team. As a key member of our organization, you will be responsible for designing, developing, and implementing our enterprise business intelligence platform.Key Responsibilities:Design relational and dimensional enterprise BI data...

  • Azure SQL Database Administrator

    1 month ago

    Richmond Heights, Virginia, United States Taylor Corporation Full time

    Unlock Your Potential with Taylor CorporationTaylor Corporation is a dynamic and diversified company with a passion for innovation and growth. We're seeking a skilled Azure SQL Database Administrator to join our forward-thinking IT team.Your Opportunity:As a crucial member of our remote workforce, you will play a pivotal role in managing, securing, and...

  • Senior Software Developer

    2 weeks ago

    Maryland Heights, Missouri, United States Spectrum Full time

    Job Summary:As a Senior Software Developer at Spectrum, you will design, develop, test, and implement software systems, including OLTP database systems. You will perform maintenance on existing software products, implement complex business logic, and work in an environment with a short development cycle. You will also design and develop Oracle PL/SQL code,...

  • Azure SQL Database Administrator

    1 month ago

    Richmond Heights, Virginia, United States Taylor Corporation Full time

    About the RoleTaylor Corporation is seeking a skilled Database Administrator with expertise in Azure SQL databases to join our forward-thinking and innovative IT team. As a crucial member of our remote workforce, you will play a pivotal role in managing, securing, and optimizing our database infrastructure, directly contributing to the success of our Tax and...

  • Talent Development Supervisor

    17 hours ago

    Mendota Heights, United States Dungarvin Full time

    Job DescriptionWe are thrilled to announce an exciting opportunity for a Talent Development (TD) Supervisor! In this vital role, you will lead and support a dynamic regional Talent Development team, primarily collaborating with our Operations team. Your mission? To ensure that our orientation and ongoing staff training are timely, consistent, and impactful,...

  • Training and Development Professional

    1 week ago

    Mendota Heights, Minnesota, United States Dungarvin Full time

    Job SummaryDungarvin is seeking a skilled Training and Development Professional to join our regional training team. As a key member of our team, you will be responsible for delivering high-quality training programs to our direct care staff. Your primary focus will be on facilitating new employee orientation and annual required trainings, as well as leading...

  • Database Developer

    4 weeks ago

    Berkeley Heights, United States Net2source Full time

    Job Title: Database Developer (with ETL)We are seeking a highly skilled Database Developer with expertise in ETL (Extract, Transform, Load) to join our team at Net2Source. As a Database Developer, you will be responsible for designing, developing, and maintaining databases and ETL processes to support our clients' business needs.Key Responsibilities:Design...

  • Training and Development Specialist

    6 days ago

    Mendota Heights, Minnesota, United States Dungarvin Full time

    Job Title: Trainer Talent Development Specialist Social ServicesJob Summary: We are seeking a highly skilled and experienced individual to join our regional training team as a Talent Development Specialist.Key Responsibilities:* Facilitate new employee orientation and annual required trainings on a regional basis* Lead virtual trainings using Zoom,...

  • Senior Software Systems Developer

    6 days ago

    Maryland Heights, Missouri, United States Charter Communications Full time

    Job Summary:As a Senior Software Systems Developer at Charter Communications, you will be responsible for designing, developing, testing, modifying, implementing, and supporting software systems, including OLTP database systems. You will perform maintenance on existing software products, implement complex business logic, and work in an environment with a...

  • Training and Development Specialist

    2 weeks ago

    Mendota Heights, Minnesota, United States Dungarvin Full time

    About the RoleWe are seeking a highly motivated and experienced Training and Development Specialist to join our team at Dungarvin. As a key member of our regional training team, you will play a crucial role in delivering high-quality training programs to our direct care staff.Key ResponsibilitiesDesign and deliver specialized staff training programs,...