Senior Data Warehouse SQL Developer/Supervisor

1 week 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 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 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.
  • 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, responsible for assigning tasks, making or changing work assignments, 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 OR an equivalent combination and education and/or experience.
  • 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.
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.
About the Department of Natural Resources

The Department of Natural Resources (DNR) is a state agency that manages and protects the state's natural resources. We are committed to serving the public and promoting environmental sustainability. As a member of our team, you will have the opportunity to work on challenging projects and make a positive impact on the environment.

Benefits

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

  • Senior Data Warehouse SQL Developer/Supervisor

    4 weeks ago

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

    Job Title: Senior Data Warehouse SQL Developer/SupervisorJoin 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 RoleWe are seeking a highly skilled and experienced Senior Data Warehouse SQL Developer/Supervisor to lead our...

  • Senior Data Warehouse SQL Developer/Supervisor

    2 weeks ago

    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,...

  • Senior Data Warehouse SQL Developer/Supervisor

    2 weeks ago

    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...

  • Senior Data Warehouse SQL Developer/Supervisor

    1 week ago

    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. As a key member of our IT Division, you will be responsible for designing, developing, and maintaining our enterprise DataMart system.Key ResponsibilitiesDesign, develop, support, enhance, and maintain the Agency enterprise DataMart data...

  • IT Application Development Senior/Specialist

    2 weeks ago

    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

    2 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

    1 week 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...

  • Data Insights Specialist

    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. 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...

  • Senior Data Analyst

    2 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...

  • ACS Business Process Analytics Consultant

    5 days ago

    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...

  • Senior Education Data Analyst

    4 weeks ago

    Olympia, Washington, United States Public Consulting Group Full time

    Job Title: Senior Education Data AnalystPublic Consulting Group LLC (PCG) is a leading public sector solutions implementation and operations improvement firm that partners with health, education, and human services agencies to improve lives.We are seeking a Senior Education Data Analyst to join our team in the Northeast Education Practice Area. This is a...

  • ATS Application Development Supervisor

    3 weeks ago

    Olympia, Washington, United States State of Washington Full time

    About the PositionThis is an exciting opportunity to join the Agency Technology Services (ATS) team as an Application Development Supervisor. As a key member of our team, you will be responsible for overseeing the day-to-day planning, deployment, and development of software solutions within the agency.Key ResponsibilitiesEstablish, document, and continuously...

  • Warehouse Operations Supervisor

    3 weeks ago

    Olympia, Washington, United States Medline Industries Full time

    Job SummaryResponsible for the daily administration and operation of the warehouse. Oversee materials are received, stored, shipped and reported in accordance with established procedures. Direct and supervise warehouse staff. Review effectiveness of operating procedures, maintenance, space utilization and protection of equipment.Key...

  • Senior Systems Administrator

    1 month ago

    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...

  • Data Scientist I

    2 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...

  • Cloud Database Security Developer

    1 week ago

    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

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

  • Senior Database Architect

    3 weeks ago

    Olympia, Washington, United States Centene Corporation Full time

    Job Title: Senior Database AdministratorCentene Corporation is seeking a highly skilled Senior Database Administrator to join our team. As a key member of our technology team, you will be responsible for designing, implementing, and maintaining our database systems to ensure high levels of system availability and data integrity.Key...

  • Warehouse Operations Specialist

    1 week ago

    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...

  • Senior Data Analyst for SEA 05

    1 week ago

    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...