Business Intelligence Specialist jobs in Olympia, WA

Business Intelligence Specialist creates reports, visualizations, dashboards, and metrics that provide business insight and aid business decision-making. Uses querying languages like SQL, scripting languages like R or Python, and other tools like Tableau or Excel to produce reports and perform meaningful quantitative or qualitative analyses addressing impactful business issues or questions. Being a Business Intelligence Specialist combines these reports with subject-matter expertise to deliver coherent, insightful takeaways and advice. Collaborates with project stakeholders to better understand valuable objectives and KPIs and to design relevant reports and dashboards. Additionally, Business Intelligence Specialist requires a bachelor's degree. Typically reports to a supervisor or manager. The Business Intelligence Specialist work is closely managed. Works on projects/matters of limited complexity in a support role. To be a Business Intelligence Specialist typically requires 0-2 years of related experience. (Copyright 2024 Salary.com)

S
Business Intelligence Specialist
  • State of Washington
  • Multiple Locations Statewide, WA OTHER

  • Our ideal candidate is a highly skilled IT professional with a comprehensive background in data management and business intelligence, capable of designing robust databases and developing intricate Power BI/SSRS reports and SSIS packages. They possess a deep understanding of SQL Server environments, data analysis, and migration processes, ensuring accurate and efficient data-driven decision-making.

    They are adept at independent decision-making, stakeholder analysis, and project management, contributing to the organization’s vision and strategic goals. Moreover, they have excellent communication skills, fostering a collaborative environment and effectively serving as a liaison between the department, customers, and the public.

    This candidate is not just seeking a job; they are looking for a place where they can continue to grow, contribute to meaningful work, and help shape the future of the organization. Your journey to make a difference starts here! Apply today - It begins with you!

    * This is a project position with an anticipated end date of December 31st, 2025. Extension will depend on continued legislative funding. *


    The Business Intelligence Specialist calls for a strategic thinker who thrives in designing sophisticated databases, crafting detailed Power BI/SSRS reports, and developing comprehensive SSIS packages. With a solid grasp of SQL Server environments and a keen eye for data analysis and migration processes, the right candidate will be instrumental in steering data-driven decisions within the Employment Security Department (ESD).

    ESD values a professional who embodies equity and inclusiveness, approaches challenges with innovative problem-solving, and demonstrates critical thinking. Your ability to make independent decisions, conduct stakeholder analysis, and manage projects will align seamlessly with our agency’s mission and values. As a natural communicator, you’ll bridge the gap between the department, our customers, and the public, fostering a collaborative atmosphere that propels our vision and strategic objectives forward.

    Some of your duties may include:
    • Develop Power BI/SSRS reports/SSIS packages: Write SQL queries, design and develop reports and packages, perform unit testing, and code review.
    • Application Database Design: Create robust databases, design RDBMS, develop table schemas and stored procedures, evaluate data integrity, and maintain Data Dictionaries.
    • Ad Hoc Data Requests: Conduct business analysis, write SQL queries, peer review, design ETL processes, and create unit test cases.
    • Business Analysis: Conduct stakeholder analysis, facilitate workgroups, document business requirements, identify project tasks, and communicate application issues.
    • Technical Environment Establishment: Analyze data availability, work with customers to define IT solutions, develop ETL processes, design reports, and ensure deployment meets user needs.
    • New Report Development: Define IT solutions with customers, determine data sources, develop reports, test, and troubleshoot, and ensure correct deployment.
    • Production Issue Resolution: Analyze code and database scripts, resolve defects, and implement sustainable solutions.
    To request a detailed position description, click here.
    • Bachelor’s degree in computer science or closely related field AND four (4) years of IT experience developing systems using service-oriented design and development using:
    o    SQL query
    o    Developing SSIS packages
    o    Building and maintaining reports in SSRS
    o    Power BI
    o    Azure Designing table structures, writing stored procedures and queries for combining and analyzing reporting data.

    OR

    • Associate degree in computer science or closely related field AND six (6) years of IT experience developing systems using service-oriented design and development using:
    o    SQL query
    o    Developing SSIS packages
    o    Building and maintaining reports in SSRS
    o    Power BI
    o    Azure Designing table structures, writing stored procedures and queries for combining and analyzing reporting data.

    OR

    • Eight (8) years of IT experience developing systems using service-oriented design and development using:
    o    SQL query
    o    Developing SSIS packages
    o    Building and maintaining reports in SSRS
    o    Power BI
    o    Azure
    o    Designing table structures, writing stored procedures and queries for combining and analyzing reporting data.

    AND

    • Four (4) years of experience reviewing technical documents related to application development, maintenance and adhering to set goals and schedules.

    *A Master's degree or above will substitute for one (1) year of required experience.

    Desirable/Preferred Education, Experience or Certifications:
    •    Certification in SQL server related technologies (e.g. Microsoft MCST, MCSA, Oracle OCP).
    •    Six (6) years of experience in developing SQL/SSIS/SSRS/SSAS servers.
    •    One (1) year of experience with Azure cloud in synapse and Azure Data Factory (ADF).
    •    Four (4) years of experience performing the full application life cycle activities of the standard Application Life Cycle Methodology (Scrum, Kanban, Waterfall, etc.).


    Additional Requirement of Employment:
    •    Must be able to pass an Unemployment Insurance (UI) Claim & Benefit Information Review.
    •    Position may require frequent and/or occasional travel to field offices within the state, and/or occasional travel for meetings and/or training.


    Please submit only the required documents as noted below and ensure all Personal Identifying Information (PII) such as Social Security numbers etc. are edited out of your materials for privacy.


    Please submit your Cover Letter and Resume with your Online Application through the "Add Attachments" field. A resume will not substitute for the "work experience" section of the application or vice versa. Applications with blank fields, or supplemental question responses with comments such as "see attachments" may be considered incomplete.Our agency's mission and values drive every decision that we make, determine how we interact with others, and are at the core of who we are. We value Access, Love, Belonging, Equity, and Stewardship.  We understand that a work environment that respects your work/life balance is key; that's why many of our positions are eligible for flexible work schedules and teleworking opportunities. Through support, value, and trust, our employees are empowered to grow and develop into their best self.

    Opportunity for All
    We strive to create a working environment that includes and respects cultural, ethnic, racial, religious, sexual orientation, and gender identity diversity. Women, racial and ethnic minorities, people with disabilities, people over 40 years of age, people with religious beliefs, veterans or people with military status, and people of all sexual orientations and gender identities are encouraged to apply.

    The Employment Security Department is an equal opportunity employer/program.  Auxiliary aids and services are available upon request to individuals with disabilities.

    If you are a person needing assistance in the application process, if you need this job announcement in an alternate format, or if you have general questions about this opportunity, please contact thomas.digiorgio@esd.wa.gov or the Talent Acquisition Team.

    If you are having technical difficulties creating, accessing, or completing your application, please contact careershelp@des.wa.gov or (360) 664-1960 or toll free (877) 664-1960, Washington Relay 711.

    This recruitment may be used to fill additional agency-wide positions in accordance with Article 4 of the WFSE Collective Bargaining Agreement.

    Candidates who are offered a job with ESD must possess work authorization which does not require sponsorship by the employer for a visa now or in the future.

    **This Organization Participates in E-Verify**
  • 3 Days Ago

P
Business Intelligence Report Developer
  • Physicians of Southwest Washington, LLC
  • Olympia, WA FULL_TIME
  • THIS POSITION REQUIRES WASHINGTON STATE RESIDENCY Employees must establish a residence in Washington State within 30 days of their first day of employment and must maintain a residence in Washington S...
  • 6 Days Ago

I
Business Intelligence Analyst
  • IGT - International Game Technology
  • Lacey, WA PART_TIME
  • Business Intelligence Analyst I This is a PART-TIME job at 29 hrs/week. IGT (NYSE:IGT) is a global leader in gaming. We deliver entertaining and responsible gaming experiences for players across all c...
  • 7 Days Ago

I
Business Intelligence Analyst I
  • IGT
  • Lacey, WA FULL_TIME
  • Location: Lacey, WA, US, 98516 Requisition ID: 14677 IGT (NYSE:IGT) is a global leader in gaming. We deliver entertaining and responsible gaming experiences for players across all channels and regulat...
  • 26 Days Ago

S
GIS Analyst / Location Intelligence Specialist
  • State of Washington
  • Thurston, WA FULL_TIME
  • AGRICULTURE - A Cornerstone of Washington's Economy The Washington State Department of Agriculture has been serving the state for more than 100 years. Through service, regulation, and advocacy, we kee...
  • 23 Days Ago

T
Lawn Specialist - Earn $13-$22/Hour + Benefits
  • TruGreen - Lawn Specialist
  • Olympia, WA FULL_TIME
  • TruGreen is Now Hiring Lawn Specialists! Earn Up to $22.00 per Hour - Comprehensive BenefitsAt TruGreen, we are committed to our customers, our teams, our values, and the science of lawn care. A caree...
  • 8 Days Ago

Filters

Clear All

  • Filter Jobs by companies
  • More

0 Business Intelligence Specialist jobs found in Olympia, WA area

C
Energy Proposal Manager
  • Cadmus
  • Olympia, WA
  • **Overview** **What Youll Be Doing** Cadmus is seeking an experienced proposal manager adept in technical sales writing,...
  • 4/19/2024 12:00:00 AM

C
Business Developement Analyst
  • Cayuse Holdings
  • Olympia, WA
  • **Overview** The Business Development Analyst utilizes resources to support revenue-generation staff to become both know...
  • 4/19/2024 12:00:00 AM

M
Technical Quality Specialist, WhatsApp ProdOps
  • Meta
  • Olympia, WA
  • Summary: Meta Platforms, Inc. (Meta), formerly known as Facebook Inc., builds technologies that help people connect, fin...
  • 4/19/2024 12:00:00 AM

A
Patient Services Specialist
  • American Oncology Network
  • Olympia, WA
  • Location: Vista Lilly Office Pay Range: $18.09 - $30.14 Position Summary: The primary responsibilities of Patient Servic...
  • 4/19/2024 12:00:00 AM

C
Mental Health Care Coordinator (Internal Title: FBH Clinical Care Coordinator)
  • CCSWW
  • Tacoma, WA
  • Overview: Are you a novelty seeker? Do you seek new ideas and creative approaches? Are you tired of working 9-5? Do you ...
  • 4/19/2024 12:00:00 AM

C
Health Information Operations Supervisor
  • CIOX Health
  • Tacoma, WA
  • Health Information Operations Supervisor Job Locations US-WA-Auburn | US-WA-Seattle | US-WA-Federal Way | US-WA-Tacoma R...
  • 4/19/2024 12:00:00 AM

S
National Estuary Program Financial Assistance Planner (Environmental Planner 4)
  • State of Washington
  • Olympia, WA
  • Keeping Washington Clean and Evergreen The Water Quality Program within the Department of Ecology is looking to fill a N...
  • 4/16/2024 12:00:00 AM

S
Automation Maintenance Technician (All Levels)
  • Symbotic
  • Centralia, WA
  • Who we are With its A.I.-powered robotic technology platform, Symbotic is changing the way consumer goods move through t...
  • 3/6/2024 12:00:00 AM

Olympia is the capital of the U.S. state of Washington and the county seat of Thurston County. European settlers claimed the area in 1846, with the Treaty of Medicine Creek initiated in 1854, and the Treaty of Olympia initiated in January 1856. Olympia was incorporated as a town on January 28, 1859, and as a City in 1882. The population was 46,479 as of the 2010 census, making it the 24th largest city in the state. The city borders Lacey to the east and Tumwater to the south. Olympia is a cultural center of the southern Puget Sound region. Olympia is located 60 miles (100 km) southwest of Seat...
Source: Wikipedia (as of 04/11/2019). Read more from Wikipedia
Income Estimation for Business Intelligence Specialist jobs
$66,160 to $87,174
Olympia, Washington area prices
were up 2.9% from a year ago

Business Intelligence Specialist in Florence, AL
It means that there are fewer and fewer jobs that we can support ourselves by being just specialists.
December 02, 2019
Business Intelligence Specialist in Danbury, CT
Specialist, Business Intelligence & Reporting is responsible for supporting the enhancements of products and services to improve business value and service quality according to business needs and industry best practices.Essential Functions.
November 29, 2019
Business Intelligence Specialist in Pittsburgh, PA
… change within the Consumer Credit Division of the business.
January 15, 2020