How a data warehousing specialist can use AI, task by task

I work as a data warehousing specialist. Part of my job is to verify the structure, accuracy, or quality of warehouse data.

Context: We use Microsoft SharePoint and SAS; the work draws on computers and electronics, design and mathematics.
Dataset: [paste a sample or describe columns]
Rules: [formats, ranges, required fields]

List quality issues and write validation checks or queries. Make a table: requirement, met / not met / unclear, and the exact evidence.

I work as a data warehousing specialist. Part of my job is to perform system analysis, data analysis or programming, using a variety of computer languages and procedures.

Context: We use C and Microsoft Azure software; the work draws on computers and electronics, design and mathematics.
Language and context: [language, existing code]
Goal: [what it should do]
Constraints: [style, performance, security]

Propose an approach, then write the code with comments and tests. Propose the approach first, then the code with comments and tests, and point out security risks.

I work as a data warehousing specialist. Part of my job is to develop and implement data extraction procedures from other systems, such as administration, billing, or claims.

Context: We use Microsoft SharePoint and Microsoft Word.
Data: [databases, archives, queries]
Needs: [access, backup, quality]

Draft procedures with roles, steps and controls. Use plain language and headings where they help, and mark anything you had to guess with [CHECK].

I work as a data warehousing specialist. Part of my job is to provide or coordinate troubleshooting support for data warehouses.

Context: We use Linux and UNIX; the work draws on computers and electronics, design and mathematics.
System: [application, telehealth]
Symptoms: [errors, logs]

List likely causes and tests. Rank causes from most to least likely with a quick test for each, and flag safety risks.

I work as a data warehousing specialist. Part of my job is to create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.

Context: We use Microsoft SharePoint and Microsoft Word.
System: [network, data warehouse, hardware]
What to test: [functions, integration]

Draft test procedures, cases and expected results. Use plain language and headings where they help, and mark anything you had to guess with [CHECK].

I work as a data warehousing specialist. Part of my job is to 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.

Context: We use Microsoft SharePoint and Microsoft Word.
Data: [databases, archives, queries]
Needs: [access, backup, quality]

Draft procedures with roles, steps and controls. Use plain language and headings where they help, and mark anything you had to guess with [CHECK].

I work as a data warehousing specialist. Part of my job is to prepare functional or technical documentation for data warehouses.

Context: We use Microsoft SharePoint and Microsoft Word.
Procedure: [security, installation]
Notes: [paste]

Draft a clear documented procedure. Use plain language and headings where they help, and mark anything you had to guess with [CHECK].

I work as a data warehousing specialist. Part of my job is to 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.

Context: We use Microsoft SharePoint and Microsoft Word.
Data: [databases, archives, queries]
Needs: [access, backup, quality]

Draft procedures with roles, steps and controls. Use plain language and headings where they help, and mark anything you had to guess with [CHECK].

I work as a data warehousing specialist. Part of my job is to test software systems or applications for software enhancements or new products.

Context: We use C and Microsoft Azure software; the work draws on computers and electronics, design and mathematics.
Software: [describe the feature or change]
Acceptance criteria: [what it must do]

Write test cases (normal, edge, error) and automated test code where it fits. Propose the approach first, then the code with comments and tests, and point out security risks.