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.
Technical Business Analyst -M365
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...
Data Governance Analyst
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...
Decision Support Analyst (Data Engineer)
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...
Finance Data Analyst (100% Remote Any Timezone)
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...
Data Analyst - Insurance - 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. ...
Entry-Level Data Analyst (Remote)
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...
Job | Data Analyst - Beaverton, OR
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...
Research Data Analyst- CIBMTR Data Manager
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...
DART Data Analyst
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...
Financial Data Analyst - Compensation
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...