Senior Data Warehouse SQL Developer/Supervisor

3 weeks ago


Olympia, Washington, United States State of Washington Full time
Job Summary

We are seeking a highly skilled Senior Data Warehouse SQL Developer/Supervisor to join our team. As a key member of our IT Division, you will be responsible for designing, developing, and maintaining our enterprise DataMart system.

Key Responsibilities
  • Design, develop, support, enhance, and maintain the Agency enterprise DataMart data warehouse/database and its related automated Extract, Load, and Transform (ELT) processes.
  • Integrate data from multiple source systems and databases to create an analytical data warehouse (in Oracle) serving users across the Agency.
  • Design, develop, test, deploy, document, troubleshoot, and maintain this suite of component modules that contribute to the full DataMart/data warehouse integration process.
  • 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.
Requirements
  • Bachelor of Science in computer science, information systems, or related field.
  • 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.
Preferred Qualifications
  • Experience with Business Intelligence tools, such as Microsoft Power BI, Tableau, or similar software.
  • Experience with cloud technologies, such as Microsoft Azure.
  • Experience with Agile methodologies.
What We Offer

We offer a comprehensive benefits package, including health insurance, paid holidays, retirement plans, sick leave, and vacation days. We also provide opportunities for professional development and career advancement.

How to Apply

To apply, please submit your online application, including your resume, cover letter, and three professional references. We thank you for your interest in this opportunity and look forward to reviewing your application.



  • Olympia, Washington, United States Washington State Department of Natural Resources Full time

    Job SummaryWe are seeking a highly skilled Senior Data Warehouse SQL Developer/Supervisor to join our team at the Washington State Department of Natural Resources. As a key member of our data management team, you will be responsible for designing, developing, and maintaining our enterprise DataMart data warehouse/database and its related automated Extract,...


  • Olympia, Washington, United States Washington State Department of Natural Resources Full time

    Job SummaryWe are seeking a highly skilled Senior Data Warehouse SQL Developer/Supervisor to join our team at the Washington State Department of Natural Resources. As a key member of our data management team, you will be responsible for designing, developing, and maintaining our enterprise data warehouse and related automated Extract, Load, and Transform...


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

    Job SummaryWe are seeking a highly skilled Senior Data Warehouse SQL Developer/Supervisor to join our team at the State of Washington. As a key member of our IT Division, 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...


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

    Job Title: IT Application Development Senior/SpecialistAs an IT Application Development Senior/Specialist, you will serve as a technical authority for designing and building statewide enterprise application and data integration solutions for mission-critical applications.Key Responsibilities:Design, code, and implement application and data solutions for...

  • Data Analyst

    4 weeks ago


    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.Job SummaryWe're looking for a collaborative, curious, and motivated Data Analyst to join our Data Analytics function. As a key contributor to our centralized Analytics team,...

  • Senior Web Developer

    3 weeks ago


    Olympia, Washington, United States Intercity Transit Full time

    Job Title: Senior Web DeveloperJob Summary:We 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...

  • Senior Data Analyst

    4 weeks ago


    Olympia, Washington, United States CVS Health Full time

    Unlock the Power of Clinical DataCVS Health is seeking a highly skilled Sr. Data Scientist to join our Clinical Data Science team. As a key member of our team, you will be responsible for activating our clinical data repository to improve outcomes across multiple lines of business and use cases.Key Responsibilities:Develop, validate, implement, and support...


  • Olympia, Washington, United States Oracle Full time

    Job Title: ACS Business Process NSAW ConsultantWe are currently seeking a highly skilled and experienced ACS Business Process NSAW Consultant to join our team at Oracle. The ideal candidate will have a deep understanding of NetSuite Analytics Warehouse (NSAW) and be able to leverage its capabilities to drive business growth and customer success.About the...

  • Data Scientist I

    4 weeks ago


    Olympia, Washington, United States Centene Corporation Full time

    Job Summary:Centene Corporation is seeking a highly skilled Data Scientist I to join our team. As a Data Scientist I, you will be responsible for advanced and predictive data analytics using big data and data science technology for healthcare innovation. You will perform analysis using data science techniques on structured and unstructured data sets, and...


  • Olympia, Washington, United States Oracle Full time

    Job SummaryOracle is seeking a highly skilled Cloud Database Security Developer to join our team. As a senior member of our engineering group, you will provide leadership and expertise in building high quality database security components, products and solutions that meet stringent enterprise software requirements.Key ResponsibilitiesProvide technical...

  • Materials Supervisor

    4 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 successful candidate will...


  • Olympia, Washington, United States UPS Full time

    Warehouse Operations SpecialistAt UPS, we're looking for a skilled Warehouse Operations Specialist to join our team. As a key member of our warehouse operations, you'll be responsible for loading and unloading, packing and unpacking, auditing, and general housekeeping. You'll also be responsible for scanning orders and data entry into computerized inventory...


  • Olympia, Washington, United States Serco North America Full time

    Job Summary:Serco North America is seeking a Senior Analyst for SEA 05 to support the US Navy for the SEA 05 Cross Platform Engineering Contract. The successful candidate will maintain defense work on various ship classes, evaluating the effectiveness and efficiency of SEA 05 initiatives, programs, and operations.Key Responsibilities:* Analyze SEA 05...


  • Olympia, Washington, United States Oracle Full time

    Job DescriptionAt Oracle, we're committed to delivering innovative cloud solutions that meet the evolving needs of our customers. As a Senior Cloud Infrastructure Developer, you'll play a critical role in shaping our cloud infrastructure and ensuring that our customers receive the best possible experience.Key Responsibilities:Develop automation solutions for...


  • Olympia, Washington, United States Timmons Group Full time

    Job Title: Senior Software EngineerTimmons Group is seeking an experienced Senior Software Engineer to design, develop, and maintain interactive web and web-based mobile applications for our growing client base. This role is remote and supports a west coast client.Key Responsibilities:Design, develop, and implement quality geospatial solutionsAnalyze...


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

    Job Title: Warehouse Operations ManagerJoin the State of Washington team as a Warehouse Operations Manager, responsible for overseeing the daily operations of our warehouse facilities. As a key member of our logistics team, you will be responsible for ensuring the efficient receipt, storage, and distribution of goods and materials.Key Responsibilities:Manage...


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

    Warehouse Lead, Warehouse Operator 3 is a full-time, permanent position at the State of Washington. As a key member of our team, you will be responsible for overseeing warehouse operations, ensuring efficient inventory management, and maintaining a safe working environment. Key responsibilities include:Managing warehouse staff and coordinating daily...


  • Olympia, Washington, United States Oracle Full time

    Job SummaryOracle is seeking a highly skilled Program Management Senior Manager to lead our Data Infrastructure Delivery team. As a key member of our organization, you will be responsible for managing people, projects, and resources to deliver high-quality products and services to our customers.Key ResponsibilitiesManage cross-functional teams to deliver...


  • Olympia, Washington, United States Uline, Inc. Full time

    Warehouse Management InternshipGain hands-on experience in a dynamic warehouse environmentUline, Inc. is seeking a motivated and detail-oriented individual to join our warehouse team as a Warehouse Management Intern. This internship provides a unique opportunity to gain real-world experience in warehouse operations, including order fulfillment, shipping, and...


  • Olympia, Washington, United States Senior Helpers Full time

    We are seeking compassionate and dedicated caregivers to join our team at Senior Helpers. As a caregiver, you will have the opportunity to make a meaningful difference in the lives of our clients, providing them with the care and support they need to live independently.Responsibilities:Assist with personal care and daily living activitiesProvide...