Java Software Engineer and ETL Data Warehouse Engineer

  • Full-time

Job Description

1) This is a direct-client opening for a Data Warehouse Engineer I position located in Seattle, WA. This is a Full-Time Position

We are looking for a highly motivated, results-oriented Data Warehouse Engineer to join our Data & Analytics team to help solve some hard problems for the business. If you have strong technical skills and love to solve challenging problems to help business make better decisions through collection & organization of data, data analysis and report development, you will have a great time working on this small team. We are looking for a person with strong technical skills and has the ability to learn quickly without the help of a lot of documentation. You will focus on the development of the data warehouse and build solutions that leverage the power of the data warehouse for business benefit. The Data & Analytics team is responsible for enabling reporting and analytics for the entire company. The data warehouse is a strategic asset for the company and powers data, insights, and actions across all business functions.

Primary Responsibilities:

Develop robust and scalable ETL using tools such as ODI, and programming languages such as SQL and PL/SQL
Regularly use SQL for data analysis and discovery, providing summary data for answering adhoc business questions, identifying data inconsistencies, etc.
Work with business teams to understand their data needs and provide data & reporting solutions using SQL, Tableau or Microsoft Reporting Services
Perform complex data analysis against our OLTP and DW databases to create actionable insights for the business
Debug data issues and develop scripts in Oracle SQL & PL/SQL to perform data backfills
Use query tuning techniques like optimizer hints, indexes, etc. and work closely with DBA's to ensure optimal performance of ETL
Analyze business requirements and develop data sources and extracts in Tableau
Build reports in Microsoft Reporting Services that source data from heterogeneous data sources
You have to be really strong in SQL as you will be using it on a daily basis - for development, data analysis, debugging data issues, etc.

Qualifications:

Bachelor’s Degree in Information Technology or Computer Science or equivalent
2 years experience working in a data warehouse environment
Excellent SQL & PL/SQL skills
Demonstrated strength in ETL development, and data warehousing
Ability to learn quickly and work with minimal supervision
Tableau experience is a plus
Microsoft Reporting Services experience a plus
Oracle Data Integrator (ODI) experience a plus

Please complete the following skills-matrix and send back with your response:

Full Name:
Total IT Experience:
Total Experience as a Data Warehouse Engineer:
Total Experience with Data Warehousing:
Total Experience with PL/SQL:
Total Experience with SQL:
Total Experience with ETL Development:
Do you have any experience with Tableau?
Do you have any Microsoft reporting services experience?
Current City/State:
Availability:
Phone Number:
Current Salary:
Expected Salary: 
Work Status:
What is the link to your Linkedin Profile?

 

2) This is our direct-client opening for a Java Software Engineer II located in Seattle, WA. This is a Full-Time Position

We are seeking a Software Engineer II to join our Pioneer Square based Technology team.  Our Technology team embraces a culture of adaptability.  We are nimble, innovative and resourceful and make an impact on both the business and each individual customer’s personal experience.  We value hard-work, flexibility and curiosity and collaborate to creatively solve problems, constantly improve and implement meaningful changes.  Our team celebrates achievements and is inspired by success.  This role presents an excellent opportunity to design and build new web applications and features that utilize the latest technology for our successful and growing company.

Primary Responsibilities:

Design and implement new features and next generation software systems
Develop and deliver maintainable, scalable, stable, reliable, high-quality systems on time, and on budget
Analyze complex problems, implement robust and maintainable solutions, & integrate new technologies into an existing stack
Perform code and test plan reviews; take responsibility for the quality of released software
Learn quickly and apply new knowledge to solutions

Required Qualifications:

Bachelor’s degree in Computer Science, Information Systems, Software Engineering, or equivalent experience
3+ years of software development experience
Strong analysis, design, & development skills
Strong Java development background
Experience developing with Spring (Boot, MVC, and Security)
Experience with Oracle PL/SQL, Solr, and Mongo a plus
Excellent communication skills; a desire to work as part of a tightly integrated team
Proven track record of delivering high quality features to production
Aptitude to independently learn new technologies

Please complete the following skills-matrix and send back with your response:

Full Name:
Total IT Experience:
Total Experience as a Software Engineer/Developer:
Total Experience with Java Development:
Total Experience with Spring:
Total Experience with Oracle PL/SQL:
Current City/State:
Availability:
Phone Number:
Current Salary:
Expected Salary: 
Work Status:
What is the link to your Linkedin Profile?

Additional Information

All your information will be kept confidential according to EEO guidelines.