Data Analyst at Lake Oswego

Job Description

.

Adecco Engineering & Technical is currently looking for a Data Integration Specialist for our client in the Portland metro area!!Job Title: Data Integration SpecialistNumber of Positions: 3Start Date: ASAPWork Location: Portland, Oregon (Local area candidates only, please)Work Shift: Mon-Fri 8:00 AM - 4:30 PMPay Rate Range: W-2 hourly/ ~ $30-45/hr/ DOEQualified candidates please send an MS Word version of your resume to [Click Here to Email Your Resum]**The Data Integration Specialist performs complex systems analysis, technical file specifications, data mapping, data validation, data integration, system configuration, business rules development, testing, implementation and documentation, to regularly build and installation of our product, and work with developers and QA teams to ensure the product is continuously built, integrated and working. **This is considered a highly specialized, advanced systems analyst/product configuration role in the companys Product Services Department.**The Integration Engineer will need to have essential technical knowledge to accurately assessing issues with product integration and work with the right people to get the issues resolved. **Your contribution will be focused on the data imported from multiple client and third-party systems and the processing of that data through the clients software products and into transactional and BI databases. **The ideal IT Professional for this role is someone who is looking "to land"- someone in search of a long term employment engagement, working for a company using state of the art cutting edge technology, where you will plug into a sharp, motivated, team structured environment, and demonstrate a long-term commitment to mastering the methodology, best practices, and tools of this company in order to become a functional and technical subject matter expert and advisor to clients here in Portland and across the United States.

-Qualified candidates please send a MS Word version of your resume to [Click Here to Email Your Resum] or call Mary Lavin at (503) 535-2580 What to expect "on the job":The work may span initial implementation to production go-live, ongoing maintenance and system upgrades. The onboarding process for incoming Senior Product Specialists includes comprehensive functional and product-related new hire training programsDemonstrate a long-term commitment to mastering our methodology, best practices and tools in order to become a functional and technical subject matter expert and advisor to our clientsTranslate client and/or project team functional requirements into accurate, effective and sustainable technical solutions that meet client needs and drive benefitApply analytical problem-solving, innovation and critical thinking skills while performing highly detailed technical work in the data, code and/or database engineDemonstrate client-facing consulting skills and emotional intelligence by through ownership, responsiveness, professionalism, dedication and openness to feedback while collaborating with internal and external stakeholdersDisplay work management skills that will facilitate smooth work execution and quality service delivery, communicating status and risks proactively.
Lets break it down:Senior Product Specialists typically spend 75% or more of their time digging deep into the details of our software code-base, tools and databases. Tasks vary by product but may include some or all of the following areas:

Technical Implementation-

Database manipulation - updating and creating SQL functions, procedures, tables, views, and other database objects

Data Integration - performing tasks associated with the mapping, scrubbing, staging and integration of raw data files into transactional and decision support systems.

Design, development, validation, testing, and deployment of client-specific reporting needs - including BI scorecards, dashboards, detailed listing reports, ad hoc real-time analysis tools, etc.

SQL Server and Windows environment-configuration, monitoring, and maintenance activities.

BizTalk development - defining and implementing BizTalk schemas, data maps, business rules logic, etc.

BizTalk administration - environment configuration, monitoring, and maintenance activities

And when it all comes together you will also:

Demonstrate ability to function effectively in a team environment

Employ established review processes for complex product changes. Seek to identify and recommend changes to established work processes and tools that may improve efficiency, effectiveness, and quality

Seek to identify situations where ownership, next steps, and timelines may be ambiguous, driving clarity and providing recommendations to key project and client contacts as appropriate

Provide Quality Assurance reviews of Analyst-level work and coach on best practice changes to the baseline software.

Proactively anticipate technical or service risks related to solution design and implementation; coach others to do the same.

While some contact is face-to-face (typically limited to less than 10% travel unless you express interest in additional travel opportunities), most of contact is on conference calls or via e-mail with clients and internal staff. At times, this will include group discussion and presentations to both internal and external clients.

The Technical Requirements (required, please, check em off):

Bachelors degree or equivalent with a focus in computer science is preferred. Relevant computer-related degrees and/or experience are also accepted, including management information systems, industrial engineering, mathematics, healthcare informatics, etc.

3-5 years of experience in a related technical field, ideally within product configuration, implementation, database development, data analysis or data architecture.

Experience with SQL Server in a Windows Server environment with Management Studio, Integration Services, Reporting Services, and other MSSQL services.

Strong understanding of relational database architectures and tools. Practical experience using SQL Server, SQL and T-SQL.

Heavy exposure to ETL work: data mapping, conversion, staging, scrubbing, and quarantining.

Experience with C# .NET, PowerShell, VBScript or similar programming or scripting languages, XML, FTP, SQL Agent.

Strong understanding of software development life cycle. Practical experience using Visual Studio or a similar IDE for source code control.

Ability to communicate effectively with a wide range of audiences (technical and non-technical, staff and managerial), and in a wide range of settings (e.g., one-on-one, small group, in person, on conference calls and via e-mail).

Basic skills using Microsoft business products (Excel, Word, PowerPoint, Visio, Windows, SharePoint, etc.).

Solid understanding and vigilant adherence to all Huron compliance program requirements.

Candidates must currently reside in the Portland metro area or be willing to relocate to Portland upon hire.

Preferred Skills:

Experience with administration and/or development within the Microsoft BizTalk suite of tools and services is a plus - including messaging architecture, business rules development, data mapping and integration, performance tuning, etc.

Experience with Windows Server administration is a plus - hardware, software, security, maintenance, networking, etc.

Tuning databases and database code for optimum performance.

Other -Must have unrestricted authorization to work in the United States -Drug, background and employment verification required-You must have unrestricted authorization to work in the United States -Local / Regional Portland, Oregon Candidates only-Qualified candidates please send a MS Word version of your resume to [Click Here to Email Your Resum] or call Mary Lavin at (503) 535-2580**The Adecco Group is a Fortune Global 500 company and the global leader in HR services. Our group connects over 700,000 associates with our business clients each day through our 6,600 offices in over 70 countries and territories around the world. We offer employment opportunities at any stage in your professional career. Contact us today to discuss available contract and direct hire positions. Adecco Engineering and Technical offers benefits including Holiday, 401(k), Insurance Benefit Plans and Anniversary Bonus opportunities. Adecco Engineering and Technical is an Equal Opportunity Employer.

Job Requirements

 
Country: USA, State: Oregon, City: Lake Oswego, Company: Adecco Technical.