Designs and supports data warehouse systems, maintenance processes, and projects.
Designs and writes code for ETL data solutions. Plans and executes data warehouse implementations following system requirements and anticipated usage. Performs data extraction, ensures data accuracy, troubleshoots, and resolves bugs during data warehouse operations. Analyzes business intelligence data and designs and generates reports. Understands and utilizes ETL tools like Informatica and programming languages like Python. Acts as liaison between information technology and business units.
| Job Title | Job Description | |
|---|---|---|
| 1 | Data Analysis/Statistician I | The Data Analysis/Statistician I compiles reports, charts, and tables based on established statistical methods. Analyzes and interprets data from various sources. Being a Data Analysis/Statistician I typically reports to a supervisor or manager. Requires a bachelor's degree in area of specialty. Working as a Data Analysis/Statistician I typically requires 0-2 years of related experience. Works on projects/matters of limited complexity in a support role. Work is closely managed. |
| 2 | Data Governance Specialist II | The Data Governance Specialist II defines data elements and establishes policies and procedures related to the collection and accuracy of data, and performs tests on data systems. Coordinates an organization's quality, security, and maintenance of data. Being a Data Governance Specialist II requires a bachelor's degree. Ensures sufficient data quality is maintained so that the data can effectively support the business process. In addition, Data Governance Specialist II typically reports to a manager. Being a Data Governance Specialist II work is generally independent and collaborative in nature. Contributes to moderately complex aspects of a project. Working as a Data Governance Specialist II typically requires 4-7 years of related experience. |
| 3 | Data Analysis/Statistician II | The Data Analysis/Statistician II compiles reports, charts, and tables based on established statistical methods. Analyzes and interprets data from various sources. Being a Data Analysis/Statistician II typically reports to a supervisor or manager. Requires a bachelor's degree in a related area. Working as a Data Analysis/Statistician II typically requires 2 to 4 years of related experience. Gains exposure to some of the complex tasks within the job function. Occasionally directed in several aspects of the work. |
| 4 | Big Data Analyst I | The Big Data Analyst I performs data mining, cleaning, and aggregation processes to prepare data, implement data models, conduct analysis, and develop databases. Collects, analyzes, and interprets large data sets to identify trends, patterns, and provide key business insights. Being a Big Data Analyst I maintains continuous collaboration with teams to understand the underlying purpose, focus, and objective of each data analysis project to ensure alignment and support. Develops insights and reports from multiple structured and unstructured data sources using programming, statistical, and analytical techniques and tools. In addition, Big Data Analyst I designs, develops, and implements the most valuable data-driven solutions for the organization. May require a master's degree in computer science, mathematics, engineering. Typically reports to a manager. Being a Big Data Analyst I work is closely managed. Works on projects/matters of limited complexity in a support role. Working as a Big Data Analyst I typically requires 0-2 years of related experience. |
| 5 | Data and Information Architect I | The Data and Information Architect I develops strategies for warehouse implementation, data acquisition and access, and data archiving and recovery. Designs and builds relational databases for data storage or processing. Being a Data and Information Architect I may evaluate new data sources for adherence to the organization's quality standards and ease of integration. Builds data models and defines the structure, attributes and nomenclature of data elements. In addition, Data and Information Architect I typically requires a bachelor's degree. Typically reports to a supervisor or manager. Being a Data and Information Architect I works on projects/matters of limited complexity in a support role. Work is closely managed. Working as a Data and Information Architect I typically requires 0-2 years of related experience. |
| Skills | Proficiency Level |
|---|---|
| Business Acumen | Level 1 |
| Analytical Thinking | Level 2 |
| Critical Thinking | Level 2 |