API Integration Developer - Wilsonville Oregon

Company: Columbia Distributing
Location: Wilsonville, Oregon
Posted On: 04/14/2024

Job Details

Summary

This position leads the technical components of data integration processes. This position will work with Business Analysts, Business Intelligence Analysts, DBAs, Data Integration Architects, executives, and business stakeholders to deploy data integration automation. Primary focus will be in one of two areas: ELT and/or Application Interfacing. This includes, but is not limited to designing, building, deploying and maintaining: ETL/ELT processes, external and internal EDI processes, data quality methods, transactional interfaces, data modeling, EDW architectures, data marts, data quality profiling, application of related governance processes and data tool/system administration.

Additionally, the position provides instruction, training, and guidance to internal and external team members to ensure effective and efficient use of system resources. This role requires strong technical ability.

This position can be based in Kent, WA, or Wilsonville OR.

Primary Responsibilities

• Communicate with and inform upstream source system owners about data quality issues.
• Perform detailed data requirements analyses, design and implementation of complex data flows
• Design, direct and implement ETL/ELT processes, including data capture, data quality, testing and validation methods
• Own and assist in data flow (lineage and transformation logic) documentation, data dictionary, data flow, data mapping and other MDM and Data Governance documentation
• Analysis, recommendations, and influence on overall strategy and roadmap to build data integration ecosystem and supporting toolsets
• Development of data integrations including state mapping and data roadmaps
• Maintain and monitor data sources for changes to production system, ongoing assessment reporting of data quality issues.
• Develop, maintain and/or assist in data management documentation, support Data Governance and MDM.
• Keeps current on data integration architectures, ETL/ELT, and data management tools and techniques.
• Demonstrates core values
• Performs other related work as required.Key Competencies
  • Consistently demonstrates the ability to assess situations, consider alternatives, and choose the appropriate course of action.
  • The ability to understand and resolve complex problems in a timely and effective manner using critical thinking skills.
  • Excellent verbal and written skills
  • Time organization
  • Able to tolerate stressful situations and manage time well
  • Ability to work as a team playerPeople Management
    
    None
    
    Work Environment
    
    This job operates indoors in an office setting.
    
    Physical Demands
    • Lift/Carry up to 20 lbs occasionally
    • Sitting for entire shift
    • Work indoors entire shiftExpected Hours of Work
      
      This is a full-time position, days/hours of work vary, and may include weekends.
      
      Travel
      
      Local travel only?
      
      Required Education and Experience
      • Bachelor's degree in Computer Science, Information System, Operations, Management or other related field
      • Minimum 3 years of work experience with ETL or interface design, development and maintenance.
      • Proficiency in requirements analysis, reporting build, or other data management related experience.
      • Proficient with Microsoft Office Suite, including Outlook, PowerPoint, Excel and Word.
      • Advanced knowledge of physical database design and data structures
      • Expert knowledge of one or more database management systems
      • Experience with data management platforms (e.g. SSIS, SSAS, Infosphere, Talend, Informatica, SAS)
      • Advanced skill level in SQL, data integration, data modeling and data architecture skills
      • Expert knowledge of interface engines and protocols. Experience with HL7, X12 and/or XML and OPENLinkPreferred Education and Experience
        • Experience may be substituted for required education on a year for year basis.
        • MuleSoft / Anypoint Platform Experience PreferedCompensation
          • Actual compensation packages are based on a wide array of factors unique to each candidate, including but not limited to skill set, years and depth of experience, certifications, and specific location.
          • Employees (and their families) are eligible for medical, dental, vision, and basic life insurance. Employees are able to enroll in our company's 401k plan. Employees are also eligible for 80 hours of vacation every year and 7-8 days of paid holidays throughout the calendar year (depending on location).
          • Hired applicant may be eligible for [incentives/ bonuses/ annual bonuses].
            
            Classification: Exempt
            
            Reports to: Director of IT
            
            Benefits
            
            Paid Vacation and Sick Days Holiday Pay Competitive Health Insurance Plans 401(k) with company matching Short-Term Disability and More Benefits may not be available for positions covered under active CBA, seasonal, or part-time.
            
            AAP/EEO Statement
            
            Columbia Distributing is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, sex, religion, national origin, age, protected veteran status, disability status, or any other characteristic protected by law. Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
            
            Please contact the Human Resources Dept. at (425)251-9300 or email recruiting@coldist.com if you have questions regarding reasonable accommodations. More...

                

            ---

            Register an account with us and set up job agents! We'll email you immediately when jobs like this are posted on our site.

            ---