Senior Data Warehouse SQL Developer/Supervisor

22 hours ago


Olympia, Washington, United States Washington State Department of Natural Resources Full time
Job Title: Senior Data Warehouse SQL Developer/Supervisor

Join the Washington State Department of Natural Resources as a Senior Data Warehouse SQL Developer/Supervisor and play a key role in shaping the Agency's data management strategy.

About the Role

We are seeking a highly skilled and experienced Senior Data Warehouse SQL Developer/Supervisor to lead our DataMart team. As a key member of our IT team, you will be responsible for designing, developing, and maintaining our enterprise DataMart data warehouse/database and its related automated Extract, Load, and Transform (ELT) processes.

Key Responsibilities
  • Design, develop, support, enhance, and maintain the Agency's enterprise DataMart data warehouse/database and its related ELT processes.
  • Integrate data from multiple source systems and databases to create an analytical data warehouse (in Oracle) serving users across the Agency.
  • Support the Agency's MS SQL Server database management systems that provide the back-end to several business Commercial-off-the-Shelf (COTS) systems to ensure smooth operation, security, and performance.
  • Head the development and maintenance of data warehouse standards, processes, and policies, ensuring that they are aligned with IT best practices and methodologies and OCIO policies.
  • Modernize and enhance the existing data warehouse (enterprise DataMart) and its infrastructure, incorporating the latest data warehouse/analytics platforms and technologies.
  • Supervise activities and direct employees of the DataMart team, assigning tasks, providing feedback, completing annual performance evaluations, and updating ITPDs.
Requirements
  • Bachelor of Science in computer science, information systems, or related field AND seven years of experience in the following areas: Oracle database and/or MS SQL Server database, SQL (PL/SQL or T-SQL) programming experience, trouble shooting all type of technical issues and providing support on data warehouse, scripting/coding experience (e.g. Python, C#), enterprise batch scheduling software (e.g. Application Manager), knowledge and experience in all systems development life cycle (SDLC) stages, experience with data warehousing best practices and methodologies, experience with data modeling and database design principles, experience with ETL (Extract Transform Load) tools, such as Automic Applications Manager, Informatica, SSIS (SQL Server Integration Services), or similar software products.
  • Commitment to fostering and supporting an environment that honors diversity, equity, inclusion, and environmental justice practices.
  • Excellent problem-solving and analytical skills.
  • Strong communication, collaboration, and presentation skills.

  • Senior Data Analyst

    6 days ago


    Olympia, Washington, United States Centene Corporation Full time

    Job Title: Senior SQL Data AnalystCentene Corporation is seeking a highly skilled Senior SQL Data Analyst to join our team. As a Senior SQL Data Analyst, you will play a critical role in analyzing and interpreting complex data from multiple sources, including claims, provider, member, and encounters data.Key Responsibilities:Develop and execute complex SQL...

  • Senior Data Analyst

    2 weeks ago


    Olympia, Washington, United States Centene Corporation Full time

    Job Title: Senior SQL Data AnalystJoin Centene Corporation, a diversified national organization, as a Senior SQL Data Analyst. This role offers a unique opportunity to utilize technology to improve health outcomes worldwide.Job Summary:As a Senior SQL Data Analyst, you will be responsible for integrating, conforming, profiling, and mapping complex data. You...

  • Senior IT Developer

    2 weeks ago


    Olympia, Washington, United States State of Washington Full time

    About the PositionThis senior developer role is part of the Enterprise Technology Services (ETS) division, which serves as the agency's designated technology provider for the Health Care Authority (HCA). The ideal candidate will bring advanced technical expertise in cross-functional.NET application and database development for support of mental health and...


  • Olympia, Washington, United States State of Washington Full time

    Job Title: Senior IT Application DeveloperWe are seeking a highly skilled Senior IT Application Developer to join our team at the Department of Social and Health Services. As a Senior IT Application Developer, you will be responsible for designing, developing, and maintaining complex business applications in both legacy and web-based code.Key...

  • Senior Data Analyst

    3 weeks ago


    Olympia, Washington, United States F5 Full time

    About the RoleWe are seeking a highly skilled Senior Data Analyst to join our Data Accelerator team at F5. As a key member of our Business Information Technology Transformation (BITT) team, you will play a critical role in driving business impact through data-driven insights and governance strategies.Key ResponsibilitiesLead data migration quantification and...


  • Olympia, Washington, United States State of Washington Full time

    About the JobWe are seeking a highly skilled IT Application Developer to join our team at the Office of Financial Management. As a key member of our Data Movement & Integration Team, you will play a critical role in designing, managing, and implementing data and application integration solutions for our agency and other statewide customers.Key...


  • Olympia, Washington, United States State of Washington Full time

    IT Application Development - Senior/SpecialistAs a Senior IT Application Developer, you will be responsible for designing, creating, developing, and maintaining complex divisional and multifunctional business applications in both legacy and web-based code.Key Responsibilities:Design and develop complex business applicationsProvide expert solutions for...


  • Olympia, Washington, United States Cribl, Inc Full time

    About Cribl, IncCribl, Inc is a serious company that doesn't take itself too seriously. We're a remote-first company that empowers our employees to do their best work, wherever they are. As the data engine for IT and Security, we trust Cribl to solve the most pressing data needs of the biggest names in the most demanding industries.Job SummaryWe're looking...


  • Olympia, Washington, United States Oracle Full time

    Job Title: Senior Software DeveloperOracle is seeking an experienced Senior Software Developer to join our NMS product development team. The ideal candidate will have a strong background in mathematics and a methodical/analytical approach to problem-solving.Responsibilities:Analysis of business requirements and design of software solutionsWriting external...


  • Olympia, Washington, United States Oracle Full time

    Job Title: Senior Software DeveloperOracle is seeking an experienced Senior Software Developer to join our NMS product development team. The ideal candidate will have a strong background in mathematics and a methodical/analytical approach to problem-solving.Responsibilities:Analysis of business requirements and design of software solutionsWriting external...


  • Olympia, Washington, United States Nisqually Indian Tribe Full time

    Job Title: Senior Systems AdministratorThe Nisqually Indian Tribe is seeking a highly skilled Senior Systems Administrator to join their team at the Nisqually Generations Healing Center. As a key member of the IT department, you will be responsible for designing, implementing, and maintaining the tribe's technical infrastructure.Key Responsibilities:Manage...

  • Materials Supervisor

    2 weeks ago


    Olympia, Washington, United States Amcor plc Full time

    About the RoleThe Materials Supervisor plays a critical role in ensuring the smooth operation of our production planning, inventory control, customer service, and logistics functions. This position provides support to the Production, Maintenance, and Warehouse Departments to deliver high-quality containers to our customers. The Materials Supervisor will...


  • Olympia, Washington, United States Oracle Full time

    About the RoleWe are seeking a highly skilled and experienced software engineer to join our team at Oracle, working on the development of next-generation data-planes for our cloud infrastructure. As a key member of our engineering team, you will be responsible for designing, developing, and deploying high-performance, scalable, and reliable data-plane...

  • Materials Supervisor

    3 weeks ago


    Olympia, Washington, United States Amcor plc Full time

    About the RoleThe Materials Supervisor plays a critical role in ensuring the smooth operation of our production planning, inventory control, customer service, and logistics functions. This position provides support to the Production, Maintenance, and Warehouse Departments to deliver high-quality containers to our customers.Key ResponsibilitiesDevelop and...


  • Olympia, Washington, United States Intercity Transit Full time

    Job Title: Senior Web DeveloperWe are seeking a highly skilled Senior Web Developer to join our team at Intercity Transit. As a Senior Web Developer, you will be responsible for designing, developing, and maintaining websites that inform and engage external customers and internal staff.Key Responsibilities:Design and develop websites using the Drupal CMS,...


  • Olympia, Washington, United States Oracle Full time

    About the RoleWe are seeking a highly skilled and experienced software engineer to join our team at Oracle, working on the development of our next-generation data-planes. As a key member of our cloud infrastructure team, you will be responsible for designing and developing high-performance, reliable, and available systems that power our cloud...


  • Olympia, Washington, United States Esri Full time

    OverviewEsri is seeking a skilled Sr. Application Developer to join our team of software professionals. As a key member of our Training Department, you will design, develop, and implement software applications to support our training initiatives. Your expertise in multiple developer languages will enable you to create innovative solutions that meet the needs...

  • Software Developer

    2 weeks ago


    Olympia, Washington, United States State of Washington Full time

    Job Title: Software DeveloperWe are seeking a highly skilled Software Developer to join our team at the Office of Financial Management (OFM). As a Software Developer, you will play a critical role in designing, developing, testing, implementing, and maintaining customized software applications that impact all agencies across Washington state.Key...


  • Olympia, Washington, United States Esri Full time

    OverviewAs a key member of our Training Team, you will play a crucial role in designing, developing, and implementing software applications that support our mission to create positive global change. We are seeking a highly skilled and experienced software developer to join our team and contribute to the development of innovative training...


  • Olympia, Washington, United States Esri Full time

    OverviewEsri is seeking a skilled Sr. Application Developer to join our growing team of software developers. As a key member of our Training Team, you will design, develop, and implement software applications to support our training initiatives.ResponsibilitiesDesign and develop internal applications and system architectures for the Training...