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 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. |
| 2 | Geographic Information Systems Analyst III | The Geographic Information Systems Analyst III extracts data from GIS software and uses varying analysis methods to arrive at results. Utilizes Geographic Information System techniques to provide a better understanding of certain variables in a given geographic location. Being a Geographic Information Systems Analyst III provides maps and data sets to clients to supplement analysis. Recommends appropriate reactionary strategies in response to GIS analysis. In addition, Geographic Information Systems Analyst III knowledgeable of GIS software and technology. Works in conjunction with CADD drafters and technicians. Requires a bachelor's degree in area of specialty. Typically reports to a supervisor or manager. Working as a Geographic Information Systems Analyst III typically requires 4 to 7 years of related experience. Contributes to moderately complex aspects of a project. Work is generally independent and collaborative in nature. |
| 3 | 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. |
| 4 | 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. |
| 5 | Big Data Analyst V | The Big Data Analyst V 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 V 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 V designs, develops, and implements the most valuable data-driven solutions for the organization. Typically requires a master's degree in computer science, mathematics, engineering. Typically reports to a manager. Being a Big Data Analyst V works autonomously. Goals are generally communicated in "solution" or project goal terms. May provide a leadership role for the work group through knowledge in the area of specialization. Works on advanced, complex technical projects or business issues requiring state of the art technical or industry knowledge. Working as a Big Data Analyst V typically requires 10+ years of related experience. |
| Skills | Proficiency Level |
|---|---|
| Business Acumen | Level 2 |
| Analytical Thinking | Level 3 |
| Critical Thinking | Level 3 |