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 | The Data Governance Specialist 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 typically 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 typically reports to a manager. Being a Data Governance Specialist contributes to moderately complex aspects of a project. Work is generally independent and collaborative in nature. Working as a Data Governance Specialist typically requires 4 to 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 | Data Scientist/Analytics, Entry | The Data Scientist/Analytics, Entry interprets results from multiple sources using a variety of techniques, ranging from simple data aggregation via statistical analysis to complex data mining independently. Identifies business trends and problems through complex big data analysis. Being a Data Scientist/Analytics, Entry prepares big data, implements data models and develops database to support the business solutions. Designs, develops and implements the most valuable business solutions for the organization. In addition, Data Scientist/Analytics, Entry may require an advanced degree. Typically reports to a manager. Work is closely managed. Works on projects/matters of limited complexity in a support role. Typically requires 0-2 years of related experience. Being a Data Scientist/Analytics, Entry work is closely managed. Works on projects/matters of limited complexity in a support role. Working as a Data Scientist/Analytics, Entry typically requires 0-2 years of related experience. |
4 | Data Scientist/Analytics, Expert Advisory | The Data Scientist/Analytics, Expert Advisory interprets results from multiple sources using a variety of techniques, ranging from simple data aggregation via statistical analysis to complex data mining independently. Identifies business trends and problems through complex big data analysis. Being a Data Scientist/Analytics, Expert Advisory prepares big data, implements data models and develops database to support the business solutions. Designs, develops and implements the most valuable business solutions for the organization. In addition, Data Scientist/Analytics, Expert Advisory typically requires an advanced degree. Typically reports to a manager or head of a unit/department. 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. Typically requires 10+ years of related experience. Being a Data Scientist/Analytics, Expert Advisory 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 Data Scientist/Analytics, Expert Advisory typically requires 10+ 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 2 |
Analytical Thinking | Level 3 |
Critical Thinking | Level 3 |