Job: ETL Developer - Corporate Office, Olympia

This posting has expired and is no longer available.

Jobing Description

 

Posting date: April 24, 2014

Closing date: Open until filled

Where it’s located: Corporate office in Olympia, with remote work options

When you’d work: Exempt position, Monday – Friday, 8 AM – 5 PM, with scheduling flexibility

How much you’ll earn: DOQ plus an excellent benefits package!

The role of the ETL Developer is to ensure accuracy & integrity of data & applications through analysis, coding, writing clear documentation & problem resolution. Analyze & translate functional specifications & change requests into technical specifications. Translate business needs into end user applications.

The position will be about 70% ETL development and support and 30% supporting application development in other areas of the organization. Ideal candidates will be passionate about exceeding client expectations and will be driven to learn new ETL technologies and operating systems. In addition, candidates must be able to understand complex data structures, and have a strong understanding of logical and physical database design.

 

What does an ETL Developer do?

  • Develop and test extraction, transformation, and load (ETL) processes in a SQL Server environment
  • Support  or enhance the ETL processes to accommodate changes in source systems and new business user requirements. (Microsoft BI Stack: SSIS, SSAS and SSRS)
  • Map source system data to data warehouse models
  • Work with business analysts to understand source data systems
  • Define and capture metadata and rules associated with ETL (SSIS) processes
  • Support  production mappings
  • Monitor ETL applications for performance and improvement opportunities
  • Ensure the quality, consistency and security of company data and data warehouse systems
  • Ability to switch easily between different projects and flexibility to handle a rapidly changing environment for large volumes of data
  • Troubleshoot and diagnosis complex software problems
  • Packaging and release management
  • Work with application developers, business partners, management and Data Warehouse team
  • Develop ETL procedures based on business requirements and service level agreements
  • Responsible for delivering quality data integration projects
  • Responsible for reviewing requirements, architecture and design components of ongoing and upcoming projects

 

What are the requirements?

  • 8+ years of experience working with the Microsoft BI stack: SSIS, SSRS and SSAS
  • 8+ years of experience working in a Data Warehouse, specifically SQL Server
  • 8+ Years of experience as an ETL Developer specifically working with SSIS
  • Extensive Data Modeling experience
  • Strong SQL experience required, candidate should have the ability to create complex queries to retrieve data
  • Solid understanding of SDLC, software best practices and development methodologies
  • Good knowledge of metadata, and using/managing metadata
  • Ability to develop and organize high-quality documentation
  • Take responsibility for performance tuning
  • Understanding of building data warehouses for analytical and business intelligence solutions

What do we mean by ‘We’re All In’?

Together, we can take care of today and grow for tomorrow.

This is WSECU’s Brand Promise. It means we’re here for our members. We’re here for each other. And we’re here for our communities. In other words, we’re all in…for all of us.

For many of our employees, WSECU is a second family. We take care of each other as much as we take care of our members. Just take a look at our employee testimonial pageand see what our staff has to say.

And it doesn’t stop there – we also reach out in many different ways to take care of the communities we’re proud to serve. 

We look forward to receiving your application and learning more about you!

 

Equal Opportunity/Affirmative Action/M/F/Vets/Disability Employer

We also proudly support veterans and those currently serving in the armed forces

 

Social Media

Facebook

Twitter

Locations

Chehalis
2015 NE Kresky Ave
Chehalis, WA 98532
Ellensburg, WA
-
Ellensburg, WA 98926
Everett
404 128th St SW
Everett, WA 98204
Lacey Credit Union Center (LCUC)
4540 6th Ave SE
Lacey, WA 98503
Lakewood
9540 Bridgeport Way SW
Lakewood, WA 98499
Medical Lake
205 E Hwy 902
Medical Lake, WA 99022
NW Compliance Group
8730 Tallon Lane, Suite 101
Olympia, WA 98516
Olympia Branch / Corporate Headquarters
330 E Union Ave
Olympia, WA 98501
Olympia: Legion Way Drive-Thru
515 Legion Way SE
Olympia, WA 98501
Olympia: Martin Way
4245 Martin Way E
Olympia, WA 98516
Olympia: Westside
2302 Harrison Ave NW, Ste 201
Olympia, WA 98502
Pullman Bishop
404 SE Bishop Ave
Pullman, WA 99163
Pullman CUB
1500 NE Terrell Mall
Pullman, WA 99164
Seattle: Fairview
1500 Fairview Ave E, Ste 100
Seattle, WA 98102
Seattle: University
1100 NE 45th St, Ste 110
Seattle, WA 98105
Spokane
2523 W Northwest Blvd
Spokane, WA 99205
Spokane Valley
12209 E Mission Ave, Ste 1
Spokane, WA 99206
Tumwater Town Center
100 71st Ave SW
Olympia, WA 98501
Tumwater Trosper
575 Trosper Rd SW, Ste 104
Olympia, WA 98512
Yakima
1400 Lakeside Ct, Ste 101
Yakima, WA 98902
Chehalis
Ellensburg, WA
Everett
Lacey Credit Union Center (LCUC)
Lakewood
Medical Lake
NW Compliance Group
Olympia Branch / Corporate Headquarters
Olympia: Legion Way Drive-Thru
Olympia: Martin Way
Olympia: Westside
Pullman Bishop
Pullman CUB
Seattle: Fairview
Seattle: University
Spokane
Spokane Valley
Tumwater Town Center
Tumwater Trosper
Yakima