The Odom Corporation SQL Server Software Developer/Programmer in Bellevue, Washington

Requisition Number 17-0281 Title SQL Server Software Developer/Programmer Job Type Full-Time Regular City Bellevue State WA Description Job Description: The Odom Corporation is looking for an experienced and passionate software engineer who has a strong background in development with Microsoft SQL Server 2012/2014 and Visual Studio.Net. This individual will help architect and develop solutions for the new future of Odom's application environment which is constantly and currently evolving. Requires strong experience with developing ETL (SSIS) packages, Stored Procedures, SSRS Reports and have some programming experience with either C# or VB.Net. Time will be spent automating, maintaining and reconciliation of many daily, weekly, and monthly reports which are created using our Enterprise Data Warehouse (EDW). Essential Duties & Responsibilities include but are not limited to: * Develop new and modify existing reports and extracts from our EDW. * Develop new ETL (SSIS) packages to populate data from disparate source systems through to the EDW. * Develop new and refactor existing .net applications currently written in VB.Net. * Work in development, design and reviews, troubleshooting and post production issue resolution * Follow the SDLC and create and maintain documentation of newly developed and refactored applications. * Experience with EDI - generation of documents and mapping of transactions * Support for existing EDI relationships and documentation of documents in use by each. * Assist with problem determination and resolving any issues with Odom applications. * Reconcile all internal and external (supplier) reports with our EDW. Develop a streamlined and automated process for the Reconciliation of supplier reports. * Able to travel as necessary to remote sites for problem identification and resolution. * Identifies system/application problem trends to management and recommends solutions for proactive mitigation. * Delivers basic training and support on certain Odom systems. Requirements Job Requirements * 4 year college degree or higher in Computer Science, Computer Engineering, or related discipline. * 5+ years of experience in SQL programming in T-SQL building stored procedures and jobs. * 3+ years data integration and ETL experience with SQL Server Integration Services (SSIS) including ability to configure SQL Server agent. * 3+ years of experience in designing and developing ETL processes including naming conventions, connection to variety of systems and processing of large volume of data. * 2+ years of experience in identifying and mapping data elements across multiple systems including creating templates and best practices to maintain the mapping information. * Strong understanding of data integration, quality and validation. * Experience with SQL Reporting Services (SSRS) and Reporting tools (Excel, PowerPivot). * Understanding of MDM, Data warehouse / Data mart and relational database design. * Experience with one or more .Net programming languages (C#, VB.Net). * Experience in logical and physical data modeling. * Excellent written and verbal communication skills and be able to interact with multiple IT teams and business partners both formally and informally. * Should possess sound knowledge of SDLC. * Demonstrated ability to quickly learn new job related tasks. * Demonstrated competency with customer support. * Ability to multitask with changing priorities. * Self-motivated with the ability to work both independently and in a team environment. * iSeries background helpful but not required. * Experience with file and work automation. 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 will be made to enable individuals with