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.
Data Analyst
Experience with Excel, database software, and data processing tools like Alteryx or similar platforms is essential. Your expertise will guide school districts in planning for the future, and you'll play a key role in advancing demographic research and data analytics across the country. Develop s...
Senior Data Reporting Analyst
This job consults with cross-functional groups and levels to identify data and analytical needs, conduct analyses, review analyses and findings with leadership, facilitate related process/data improvement efforts, and develop executive level presentations. Develop and implement data collection syste...
Data Analyst
Join AZAD Technology Partners as a Data Analyst and be an impactful contributor that will draft Extract, Transformation and Loading (ETL) procedures for implementing data integration and data migration tasks in support of Data Warehousing and other data integration projects within an enterprise leve...
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...
IT Data Modeler/ Development Analyst Senior LDA
Lead the development of standards for metadata and interact with business analysts and application developers to ensure accuracy of metadata. Automate the management of database server performance tuning and database life cycle utilizing database administration tools. Advanced Knowledge and Skill - ...
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...
Data Analyst II - 1.0 FTE - Research, Assessment & Accountability
Responsible for all aspects of assigned small-to-large scale data analysis and reporting, including query and report design, programming and development, gathering and combining data from multiple sources and data manipulations and validation; extract, review, analyze, validate and maintain data set...
Data Analyst 2
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. Develop data models and database design techniques, including relational and dimensional modeling. Effectively m...
Senior Data Analyst
Ensures data integrity and compliance by performing data cleansing, data audit and/or data validation. Ensure data integrity and compliance by performing data cleansing, data audit and/or data validation. Provides business process, system support and data quality governance through data coordination...
Measure 110 Data Systems Analyst (Operations & Policy Analyst 2)
This body of work includes gathering requirements from internal and external stakeholders including the Oversight and Accountability Council and communities with lived experience, providing gap assessments of existing data systems and identifying future data/system needs, develop and test new data c...