Data Developer

Beaverton, OR

Apply Now

Description


Summary:
We are seeking a Data Developer to join our growing, agile web development team. The Data Developer will work with our in house team on the creation of new web applications as well as existing by building databases tables, views, stored procedures, triggers, functions, etc… to ensure a quick turn around time. This person will also help build and maintain different ETL tools and packages to support our different banners data. A motivated team player with a strong background in Microsoft SQL Server, both in production and development support is required. 

Essential Functions:
• Translating functional requirements into database architecture/designs. 
• Modifying databases according to the company/team needs. 
• Working with the DBA to ensure company and user data stays secure. 
• Create stored procedures, functions, tables, and views. 
• Develop custom code and reports. 
• Build and maintain SSIS packages. 
• Develop standardized SSRS reports. 
• Import & export data to and from SQL Server using ETL tools as well as native SQL and flat files. 
• Participate in the resolution of complex design and implementation issues across projects. 
• Identify and resolve data discrepancies and inconsistencies. 

Other Duties and Responsibilities:

Solution Development and Delivery 
• Understands technical and functional design requirements. 
• Assists in physical and logical database design. 
• Creates prototypes for client engagements. 
• Designs, codes, and tests technical solutions. 
• Identifies system deficiencies and recommends solutions. 

Communication 
• Promotes active listening with team members. 
• Contributes appropriately to conversations. 
• Accurately prepares written business correspondence that is coherent, grammatically correct, effective, professional and engaging. 

Relational Databases 
• Understands advanced relational database concepts. 
• Demonstrates proficiency with physical and logical database design. 
• Writes effective stored procedures. 
• Possesses demonstrated work experience with an enterprise SQL Server environment. 

Programming Languages 
• Demonstrates strong proficiency in Microsoft T-SQL. 
• Reads and understands XML schemas. 
• Reads and understands JSON strings 
• Basic understanding of HTML, CSS, Javascript, preferred. 

ETL 
• Demonstrates strong skills in using and maintaining ETL programs/services 
• Identify opportunities to optimize the ETL environment, including implementation of monitoring, quality and validation processes which ensure data accuracy and integrity 

Qualifications:
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. 

Knowledge/Experience/Skills:
3+ years of direct experience in database development 
3+ years experience writing stored procedures, functions, views, etc. 
3+ years experience with SQL Server Integration Services 
1+ years experience with SQL Server Reporting Services 
Proficiency with the ETL process 
Knowledge of SQL Server 2008R2 through 2016 related utilities 
Strong communication skills 
Experience with C# .Net a plus 

Language Skills:
• Promotes active listening with team members. 
• Contributes appropriately to conversations. 
• Accurately prepares written business correspondence that is coherent, grammatically correct, effective, professional and engaging. 

Reasoning Ability: Highly motivated independent thinker, can adapt quickly and effectively to changing requirements. 

Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. 
While performing the duties of this job, the employee is required to sit; use hands and fingers operating a computer terminal with multiple monitors. 
Extensive use of computer and keyboard and viewing of computer screen is required. 

Work Environment: Office type environment.

Apply Now