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 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. |
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 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 | 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. |
Skills | Proficiency Level |
---|---|
Business Acumen | Level 1 |
Analytical Thinking | Level 2 |
Critical Thinking | Level 2 |