Job: ETL Developer

This posting has expired and is no longer available.

Jobing Description

Posting date: June 13th 2013

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 is WSECU all about?

At WSECU, we live and breathe our brand promise to our members. We deliver it every day through top-notch service and whenever possible, we take that service a step further to give our members the help they need and deserve.

We place as much value on our employees as we do our members and it shows. But don’t take our word for it – check out our employee testimonial page and read the stories they’ve shared.  Our employee benefits package also receives rave reviews and includes medical, dental, generous leave time and an outstanding 401(k) plan.

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

Skills / Requirements

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

Application Process:   To apply, visit jobs.wsecu.org

WSECU is proud to be an Equal Opportunity/Affirmative Action 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
400 E. University Way Farrell Hall, Rm 123
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
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