Search jobs > Portland, OR > Data analyst

Data Analyst 2

First Tek
Portland, OR
Full-time

POSITION RESPONSIBILITIES

Note : All official drafts, documents and recommendations, as listed below, must be reviewed, finalized and approved / accepted by appropriate BPA manager or other federal personnel with the authority to do so.

Develop Extract, Transformation and Loading (ETL) procedures for implementing data integration and data migration tasks in support of Data Warehousing and other data integration projects.

Edit C code / routines to transform file formats and / or interact with web services.

Assist with the development of ETL procedures, batch processes, and scheduling; troubleshoot problems and make suggestions for performance tuning and system integrity.

Develop data models and database design techniques, including relational and dimensional modeling.

Effectively map source to target data to meet business / system requirements.

Facilitate SQL stored procedures and advanced SQL queries.

Draft functional and technical requirement documents for diverse audiences (technical and non-technical), including migration, implementation and test plans.

Develop mappings and workflows in Informatica to automate data integration.

Draft working documents for interfaces with non-Standard BPA systems.

Debug, analyze and troubleshoot data quality issues

REQUIREMENTS

Education & Corresponding Experience (required on matrix)

Associate's or Bachelor's Degree in Information / Computer Technology, Business Systems or a related technical field is preferred.

With an Applicable Associate's Degree in applicable fields, years of experience is required.

With an Applicable Bachelor's Degree in applicable fields, years of experience is required.

Without a degree, years of experience is required.

Experience must include direct work experience in Information Technology performing Data Analysis.

Required Technical Skills & Experience (required on matrix)

Demonstrated experience with the following :

Informatica PowerCenter version or higher

Microsoft SQL Server / /

Windows Server or higher

Oracle q or higher

Preferred Skills & Experience (optional on matrix)

The following skills are preferred :

Experience working in a multi domain network environment.

Experience with Azure DevOps (ADO) formerly Team Foundation Server (TFS)

Task automation and monitoring

Informatica Suite including :

Power Center version or higher

Power Exchange version or higher

Microsoft Visual Studio or higher (C .NET)

Experience with software development coordination with clients and management

Experience with Oracle relational database system

Experience using XML, XSD, WSDL, Rest API and JSON

Experience in Database Analysis

Experience with Power Shell development

Additional Requirements (not required on matrix)

Valid Driver's License is required.

30+ days ago
Related jobs
Promoted
NTT DATA, Inc.
Portland, Oregon

NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. We are currently seeking a Technical Busienss Analyst to join our team in the western half of the United States. Where required by law, NTT DATA provides a reasonable range of compensation for speci...

HireTalent
Beaverton, Oregon

Job Title: Data Governance Analyst. Developing, documenting and driving foundational data governance work aimed at ensuring appropriate consumption of product data across. Influencing the identification of functional SMEs/resources to support metadata build work, and then holding those SMEs accounta...

Highmark Health
OR, Working at Home, Oregon

Performs modeling of data sources and flows, works with data management staff to define an operational framework that will define, develop and implement policies and security frameworks to ensure precise and secure delivery of knowledge and information. Perform modeling of data sources and flows, wo...

TEKsystems
Beaverton, Oregon
Remote

We're looking for a Finance Data Analyst (Data Validation & Data Quality) to join the Global Finance Transformation & Strategy team! This person will play a meaningful role in providing financial data analysis and validation to support crucial decisions in performance managing a broad portfolio. Sql...

Work At Home Vintage Experts
Portland, Oregon
Remote

Build and maintain data warehouse, new reports, and ad hoc reports. Compile and prepare data for customer analysis. Ability to compile data results and author commentary on industry studies is a plus. ...

D Aceto Services LLC
Portland, Oregon

D Aceto Services LLC is seeking a motivated and detail-oriented Entry-Level Data Analyst to join our team. Help maintain data integrity and accuracy within databases. In this remote position, you will work closely with various departments to analyze data, generate insights, and support decision-maki...

Sunrise Systems
Beaverton, Oregon

Candidates with certifications in any of the following will be prioritized: SQL, data analysis, Databricks, data modeling, and Hackolade. Design and build innovative data and analytics solutions to support key decisionsSupport standard methodologies in reporting and analysis, such as, data integrity...

Oregon Health & Science University
Portland, Oregon

The OHSU Center for Hematologic Malignancies (CHM) Bone Marrow Transplant Registry directly supports the OHSU Bone Marrow Transplant clinical program by meeting data reporting obligations to the Center for International Blood and Marrow Research (CIBMTR) as part of the Stem Cell Therapeutic Outcomes...

Lithia & Driveway
OR, US

The Data Analyst is responsible for assisting corporate business departments with analyses, report generation and special projects that may arise. Possible DART Rotations: FP&A, Performance Management, Corporate Finance, Treasury, Compensation, Marketing, Audit, Tax, SOX & Advisory, Digital Innovati...

Davis Wright Tremaine LLP
Portland, Oregon

Provide ongoing data and analysis support to the Attorney Compensation Manager. Responsible for data provision for the of the annual Associate Compensation process and Counsel Compensation process. Data support for lateral analyses and pay equity review as needed. Assist with internal and external s...