- Map data between source systems, data warehouses, and data marts.
Occupations with related tasks Save Table: XLSX CSV
- Map data between source systems, data warehouses, and data marts.
- Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
- Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
- Verify the structure, accuracy, or quality of warehouse data.
- Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
- Design and implement warehouse database structures.
- Develop or maintain standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases.
- Provide or coordinate troubleshooting support for data warehouses.
- Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
- Design, implement, or operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements.
- Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
- Create or implement metadata processes and frameworks.
- Review designs, codes, test plans, or documentation to ensure quality.
- Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
- Select methods, techniques, or criteria for data warehousing evaluative procedures.
- Prepare functional or technical documentation for data warehouses.
- Test software systems or applications for software enhancements or new products.
- Implement business rules via stored procedures, middleware, or other technologies.
- Map data between source systems, data warehouses, and data marts.
- Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
- Develop system interaction or sequence diagrams.
- Develop new visual design concepts and modify concepts based on stakeholder feedback.
- Develop Web site maps, application models, image templates, or page templates that meet project goals, user needs, or industry standards.
- Direct and execute pre-production activities, such as creating moodboards or storyboards and establishing a project timeline.
- Research and apply innovative solutions for product design, visuals, and user experience to meet the needs of individual Web development projects.
- Collaborate with management or users to develop e-commerce strategies and to integrate these strategies with Web sites.
- Collaborate with web development professionals, such as front-end or back-end developers, to complete the full scope of Web development projects.
- Communicate with network personnel or Web site hosting agencies to address hardware or software issues affecting Web sites.
- Conduct user research to determine design requirements and analyze user feedback to improve design quality.
- Confer with management or development teams to prioritize needs, resolve conflicts, develop content criteria, or choose solutions.
- Create searchable indices for Web page content.
- Create Web models or prototypes that include physical, interface, logical, or data models.
- Design, build, or maintain Web sites, using authoring or scripting languages, content creation tools, management tools, and digital media.
- Develop and document style guidelines for Web site content.
- Develop or implement procedures for ongoing Web site revision.
- Develop, validate, and document test routines and schedules to ensure that test cases mimic external interfaces and address all browser and device types.
- Document technical factors such as server load, bandwidth, database performance, and browser and device types.
- Identify or maintain links to and from other Web sites and check links to ensure proper functioning.
- Identify problems uncovered by testing or customer feedback, and correct problems or refer problems to appropriate personnel for correction.
- Incorporate technical considerations into Web site design plans, such as budgets, equipment, performance requirements, or legal issues including accessibility and privacy.
- Maintain understanding of current Web technologies or programming practices through continuing education, reading, or participation in professional conferences, workshops, or groups.
- Perform or direct Web site updates.
- Perform Web site tests according to planned schedules, or after any Web site or product revision.
- Provide clear, detailed descriptions of Web site specifications, such as product features, activities, software, communication protocols, programming languages, and operating systems software and hardware.
- Register Web sites with search engines to increase Web site traffic.
- Research, document, rate, or select alternatives for Web architecture or technologies.
- Respond to user email inquiries, or set up automated systems to send responses.
- Select programming languages, design tools, or applications.
- Write and edit technical documentation for digital interface products and designs, such as user manuals, testing protocols, and reports.
- Write supporting code for Web applications or Web sites.
- Develop system interaction or sequence diagrams.
- Develop new visual design concepts and modify concepts based on stakeholder feedback.
- Develop Web site maps, application models, image templates, or page templates that meet project goals, user needs, or industry standards.
- Direct and execute pre-production activities, such as creating moodboards or storyboards and establishing a project timeline.
- Research and apply innovative solutions for product design, visuals, and user experience to meet the needs of individual Web development projects.
- Prepare detailed workflow charts and diagrams that describe input, output, and logical operation, and convert them into a series of instructions coded in a computer language.
- Write, analyze, review, and rewrite programs, using workflow chart and diagram, and applying knowledge of computer capabilities, subject matter, and symbolic logic.
- Correct errors by making appropriate changes and rechecking the program to ensure that the desired results are produced.
- Perform or direct revision, repair, or expansion of existing programs to increase operating efficiency or adapt to new requirements.
- Write, update, and maintain computer programs or software packages to handle specific jobs such as tracking inventory, storing or retrieving data, or controlling other equipment.
- Consult with managerial, engineering, and technical personnel to clarify program intent, identify problems, and suggest changes.
- Conduct trial runs of programs and software applications to be sure they will produce the desired information and that the instructions are correct.
- Compile and write documentation of program development and subsequent revisions, inserting comments in the coded instructions so others can understand the program.
- Consult with and assist computer operators or system analysts to define and resolve problems in running computer programs.
- Perform systems analysis and programming tasks to maintain and control the use of computer systems software as a systems programmer.
- Write or contribute to instructions or manuals to guide end users.
- Investigate whether networks, workstations, the central processing unit of the system, or peripheral equipment are responding to a program's instructions.
- Assign, coordinate, and review work and activities of programming personnel.
- Train subordinates in programming and program coding.
- Develop Web sites.
- Train users on the use and function of computer programs.
- Collaborate with computer manufacturers and other users to develop new programming methods.
- Prepare detailed workflow charts and diagrams that describe input, output, and logical operation, and convert them into a series of instructions coded in a computer language.
- Define the goals of the system and devise flow charts and diagrams describing logical operational steps of programs.
- Troubleshoot program and system malfunctions to restore normal functioning.
- Provide staff and users with assistance solving computer-related problems, such as malfunctions and program problems.
- Test, maintain, and monitor computer programs and systems, including coordinating the installation of computer programs and systems.
- Use the computer in the analysis and solution of business problems, such as development of integrated production and inventory control and cost analysis systems.
- Coordinate and link the computer systems within an organization to increase compatibility so that information can be shared.
- Use object-oriented programming languages, as well as client and server applications development processes and multimedia and Internet technology.
- Analyze information processing or computation needs and plan and design computer systems, using techniques such as structured analysis, data modeling, and information engineering.
- Consult with management to ensure agreement on system principles.
- Expand or modify system to serve new purposes or improve work flow.
- Train staff and users to work with computer systems and programs.
- Assess the usefulness of pre-developed application packages and adapt them to a user environment.
- Determine computer software or hardware needed to set up or alter systems.
- Read manuals, periodicals, and technical reports to learn how to develop programs that meet staff and user requirements.
- Develop, document, and revise system design procedures, test procedures, and quality standards.
- Recommend new equipment or software packages.
- Confer with clients regarding the nature of the information processing or computation needs a computer program is to address.
- Review and analyze computer printouts and performance indicators to locate code problems, and correct errors by correcting codes.
- Interview or survey workers, observe job performance, or perform the job to determine what information is processed and how it is processed.
- Supervise computer programmers or other systems analysts or serve as project leaders for particular systems projects.
- Prepare cost-benefit and return-on-investment analyses to aid in decisions on system implementation.
- Specify inputs accessed by the system and plan the distribution and use of the results.
- Define the goals of the system and devise flow charts and diagrams describing logical operational steps of programs.
- Develop conceptual designs of security systems.
- Assess the nature and level of physical security threats so that the scope of the problem can be determined.
- Budget and schedule security design work.
- Conduct security audits to identify potential vulnerabilities related to physical security or staff safety.
- Design security policies, programs, or practices to ensure adequate security relating to alarm response, access card use, and other security needs.
- Design, implement, or establish requirements for security systems, video surveillance, motion detection, or closed-circuit television systems to ensure proper installation and operation.
- Develop or review specifications for design or construction of security systems.
- Engineer, install, maintain, or repair security systems, programmable logic controls, or other security-related electronic systems.
- Inspect fire, intruder detection, or other security systems.
- Inspect physical security design features, installations, or programs to ensure compliance with applicable standards or regulations.
- Interview witnesses or suspects to identify persons responsible for security breaches or to establish losses, pursue prosecutions, or obtain restitution.
- Monitor tapes or digital recordings to identify the source of losses.
- Monitor the work of contractors in the design, construction, and startup phases of security systems.
- Outline system security criteria for pre-bid meetings with clients and companies to ensure comprehensiveness and appropriateness for implementation.
- Perform risk analyses so that appropriate countermeasures can be developed.
- Prepare documentation for case reports or court proceedings.
- Prepare, maintain, or update security procedures, security system drawings, or related documentation.
- Provide system design and integration recommendations.
- Recommend improvements in security systems or procedures.
- Respond to emergency situations on an on-call basis.
- Review design drawings or technical documents for completeness, correctness, or appropriateness.
- Test security measures for final acceptance and implement or provide procedures for ongoing monitoring and evaluation of the measures.
- Train personnel in security procedures or use of security equipment.
- Develop conceptual designs of security systems.
- Develop system interaction or sequence diagrams.
- Write supporting code for Web applications or Web sites.
- Design, build, or maintain Web sites, using authoring or scripting languages, content creation tools, management tools, and digital media.
- Back up files from Web sites to local directories for instant recovery in case of problems.
- Select programming languages, design tools, or applications.
- Evaluate code to ensure that it is valid, is properly structured, meets industry standards, and is compatible with browsers, devices, or operating systems.
- Develop databases that support Web applications and Web sites.
- Perform Web site tests according to planned schedules, or after any Web site or product revision.
- Perform or direct Web site updates.
- Maintain understanding of current Web technologies or programming practices through continuing education, reading, or participation in professional conferences, workshops, or groups.
- Analyze user needs to determine technical requirements.
- Respond to user email inquiries, or set up automated systems to send responses.
- Renew domain name registrations.
- Confer with management or development teams to prioritize needs, resolve conflicts, develop content criteria, or choose solutions.
- Communicate with network personnel or Web site hosting agencies to address hardware or software issues affecting Web sites.
- Collaborate with management or users to develop e-commerce strategies and to integrate these strategies with Web sites.
- Document test plans, testing procedures, or test results.
- Establish appropriate server directory trees.
- Recommend and implement performance improvements.
- Document technical factors such as server load, bandwidth, database performance, and browser and device types.
- Develop or implement procedures for ongoing Web site revision.
- Create Web models or prototypes that include physical, interface, logical, or data models.
- Provide clear, detailed descriptions of Web site specifications, such as product features, activities, software, communication protocols, programming languages, and operating systems software and hardware.
- Evaluate or recommend server hardware or software.
- Monitor security system performance logs to identify problems and notify security specialists when problems occur.
- Install and configure hypertext transfer protocol (HTTP) servers and associated operating systems.
- Research, document, rate, or select alternatives for Web architecture or technologies.
- Design and implement Web site security measures, such as firewalls and message encryption.
- Incorporate technical considerations into Web site design plans, such as budgets, equipment, performance requirements, and legal issues including accessibility and privacy.
- Develop system interaction or sequence diagrams.