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 | Dispatch Operations Specialist II | The Dispatch Operations Specialist II maintains contact with drivers to communicate updates, delays, or special instructions and relay delivery status to customers. Coordinates drivers and vehicles to convey freight or passengers to assigned destinations in a timely and efficient manner. Being a Dispatch Operations Specialist II ensures drivers are compliant with all DOT, state, local, and company regulations. Records driver assignments, delivery time, and other transportation data in a computer database to track metrics. In addition, Dispatch Operations Specialist II requires a high school diploma or equivalent. Typically reports to a supervisor. Being a Dispatch Operations Specialist II works under moderate supervision. Gaining or has attained full proficiency in a specific area of discipline. Working as a Dispatch Operations Specialist II typically requires 1-3 years of related experience, or may need 0 years of experience with additional specialized training and/or certification. |
| 2 | GIS Data/Insights Analyst, Intermediate | The GIS Data/Insights Analyst, Intermediate 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 an GIS Data/Insights Analyst, Intermediate provides maps and data sets to clients to supplement analysis. Recommends appropriate reactionary strategies in response to GIS analysis. In addition, GIS Data/Insights Analyst, Intermediate 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 an GIS Data/Insights Analyst, Intermediate 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. |
| 3 | 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. |
| 4 | 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. |
| 5 | 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. |
| Skills | Proficiency Level |
|---|---|
| Business Acumen | Level 2 |
| Analytical Thinking | Level 3 |
| Critical Thinking | Level 2 |