More jobs:
Data Analyst
Job in
Portland, Multnomah County, Oregon, 97204, USA
Listed on 2026-01-17
Listing for:
Data Freelance Hub
Full Time
position Listed on 2026-01-17
Job specializations:
-
IT/Tech
Data Engineer, Data Analyst
Job Description & How to Apply Below
Job Overview
Position:
Data Analyst 2 – Data Integrations Specialist (Contract – 6+ months). Salary: $60.00 - $65.00 per hour.
Work Location:
In person.
- Draft and maintain ETL procedures, batch processes, and scheduling to implement data integration and migration tasks.
- Develop mappings and workflows in Informatica to automate data integration.
- Design and optimize databases using Oracle and relational/dimensional modeling techniques for efficient data storage and retrieval.
- Implement approved SQL stored procedures, functions, and advanced queries to support operational and analytical needs.
- Map source to target data to ensure alignment with business and system requirements.
- Assist in drafting functional and technical requirements, migration plans, and test plans for diverse audiences.
- Troubleshoot and resolve data quality issues, performance problems, and system integrity concerns.
- Collaborate with cross‑functional teams to integrate data from multiple sources and maintain comprehensive analytics solutions.
- Provide 24x7 rotational production support, on‑call backup, and operations support for existing systems.
- Document workflows, processes, and technical solutions for maintainability and clarity.
- Proficiency with ETL tools, preferably Informatica Suite (Power Center, Power Exchange, or equivalent).
- Strong knowledge of Oracle 11g, 12g, 18c, or 19c, including DDL, table partitioning, procedures, functions, and views.
- Experience with SQL for stored procedures, advanced queries, and data integration tasks.
- Familiarity with Microsoft SQL Server and data warehousing design techniques.
- Knowledge of XML, REST, XSD, WSDL, and web services integration.
- Experience with Power Shell and automation tools for data processing.
- Ability to interpret complex datasets and troubleshoot data quality or system performance issues.
- Strong documentation skills for functional and technical workflows.
- Understanding of SDLC, Agile frameworks, and cross‑functional project collaboration.
Portland, OR 97232, United States.
Work Location:
In person.
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×