Database Development, Administration and Business Intelligence Job Descriptions

The latest comprehensive database development, administration and business intelligence job descriptions.

Big Data Engineer/Architect

Provides clean, usable data to clients. Ensures that data pipelines are scalable, repeatable and secure. Builds high-performance algorithms and proof of concepts. Knowledgeable of coding languages and big data technologies. Usually reports to a supervisor. Requires a bachelor’s degree in area of specialty and 3-5 years of relevant experience.

Business Intelligence Specialist

Leads strategic design and implementation activities for business intelligence applications, including integration with databases and data warehouses. Responsible for ensuring business intelligence is available to enhance decision making through all support functions. Identifies, researches and resolves technical problems. Relies on extensive knowledge and professional discretion to plan and achieve goals. Manages others. Significant ingenuity and flexibility is expected. Usually reports to the head of a unit/department. Requires a bachelor’s degree in area of specialty and 5 years of relevant experience.

Business Intelligence Analyst

Analyzes data to extract market and business trends to increase profit, performance and efficiency. Develops and documents business objectives, data requirements, processing documentation and specifications. Possesses strong analytical, leadership, communication, and documentation skills. Usually reports to Business Intelligence Manager. Requires a bachelor’s degree in area of specialty and at least 5 years of relevant experience. An advanced degree in area of specialty may also be required.

Business Intelligence Developer

Responsible for the technical development of the company’s business intelligence applications. Builds solutions that enable clients to solve complex technical challenges through the use of SS&C technology. Primarily works with databases and different types of reporting, visualization or analytic software. Usually reports to Business Intelligence Manager. Requires a bachelor’s degree in area of specialty and at least 5 years of relevant experience. An advanced degree in area of specialty may also be required.

Business Intelligence Architect

Designs, develops and enforces standards and architecture for installing, configuring and using business intelligence applications. Works collaboratively with a team of senior software architects and developers to implement solutions. Designs specifications and standards for semantic layers and multidimensional models for complex business intelligence projects across all environments. Usually reports to Business Intelligence Manager or Director. Requires a bachelor’s degree in area of specialty and at least 8 years of relevant experience. An advanced degree in area of specialty may also be required.

Computer Systems Analyst

Understands the role of IT systems in an organization and determines the best technologies to increase an organization’s efficiency and effectiveness. Oversees the installation and configuration of systems to customize them to fit the organization’s needs. Tests systems and trains organization on how to use systems. Usually reports to a project manager. Requires a bachelor’s degree in area of specialty and 3-5 years of relevant experience.

Data Architect

Creates and implements a design for the storage and maintenance of data. Develops approaches for warehouse implementation, data acquisition and archive recovery. Deletes old data when necessary. May evaluate new data sources for adherence to quality standards and ease of integration. Significant ingenuity and flexibility is expected. May require a bachelor’s degree and 0-10 years of relevant experience.

Data Modeling Analyst

Creates and manages data models in accordance with an organization’s needs. Oversees the flow of information between departments through the use of relational databases. Eliminates data redundancies. Interfaces with stakeholders to understand an organization’s data needs. Relies on knowledge and professional discretion to achieve goals. Significant ingenuity and flexibility is required. May manage others. Usually reports to a manager. May require a bachelor’s degree and at least 5 years of relevant experience.

Data Scientist

Extracts and analyzes data and communicates conclusions that drive efficiency and process. Collaborates with data engineers and stakeholders on defining KPIs, data selection, preprocessing and formatting data sets for analysis. Possesses the ability to define, extract, analyze and implement insights within big data tools. Usually reports to Business Intelligence Manager or Director. Requires a bachelor’s degree in area of specialty and at least 5 years of relevant experience. An advanced degree in area of specialty may also be required.

Data Warehouse Developer

Designs, develops and manages information management strategies and solutions. Oversees the warehouse and all related activities, including data sourcing, migration, design, implementation and quality control. Relies on knowledge and professional discretion to achieve goals. Manages others. Significant ingenuity and flexibility is expected. Usually reports to senior management. Requires a bachelor’s degree with at least 7 years of relevant experience.

Data Warehouse Specialist

Designs, models and implements data warehousing activities. Programs and configures databases and provides support to end users. Responsible for verifying data accuracy, implementing business rules and supporting the data warehouse. Relies on knowledge and professional discretion to achieve goals. Usually reports to a supervisor. A certain degree of ingenuity and flexibility is required. Requires a bachelor’s degree and at least 2 years of field experience.

Database Administrator

Provides technical support for the development, implementation and maintenance of an internal database. Maintains policies and procedures for ensuring database security and integrity. Implements data models, database designs, data access and table maintenance codes. Resolves database performance, capacity, replication and distribution issues. Relies on knowledge and professional discretion to plan and achieve goals. Works under general supervision and usually reports to a supervisor, though some ingenuity and flexibility is required. May require a bachelor’s degree in a related area and 2-4 years of relevant experience.

Database Analyst

Maintains data storage and access by evaluating, designing and implementing company database(s). Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. Writes codes for database access, modifications and constructions. Significant ingenuity and flexibility is required. May require a bachelor’s degree in a related area and 0-10 years of relevant experience.

Database Report Writer

Responsible for developing, documenting and supporting reporting activity utilizing software. Supports research teams or management by evaluating raw data and reporting results. Works with other stakeholders to achieve desired results. Relies on experience and professional discretion to achieve goals. Usually reports to a supervisor. Some degree of ingenuity and flexibility is expected. Requires a bachelor’s degree in area of specialty and 2-4 years of relevant experience.

Database Warehouse Analyst

Assesses business information needs and identifies system requirements. Evaluates business intelligence data and produces reports. Acts as liaison between IT and business units. Ensures data accuracy. Assesses data extraction, report generation and bugs appearing in operations involving the data warehouse. Relies on extensive knowledge and professional discretion to achieve goals. Performs a variety of tasks. Significant ingenuity and flexibility is expected. Usually reports to a supervisor or department head. Significant creativity is expected. Requires a bachelor’s degree in area of specialty and 4-6 years of relevant experience.

Management Analyst

Finds ways to make an organization more efficient and profitable through reduced costs and increased revenues. Conducts analyses of organization’s structure and processes to identify problems and makes recommendations for solutions. Creates oral and written reports on findings. Usually reports to a department head. Requires a bachelor’s degree and minimum of 3-6 years of relevant experience. Certified Management Consultant (CMC) designation recommended.

Oracle Database Administrator

Implements and executes policies to ensure the security, integrity and operability of an Oracle database. Installs and upgrades Oracle server and application tools. Creates database storage structures, resolves database issues and maintains system security. Relies on limited knowledge and professional discretion to plan and accomplish goals. Works under general supervision and usually reports to a supervisor, though some ingenuity and flexibility is required. May require a bachelor’s degree in a related area and 3-5 years of relevant experience.

Report Developer

Responsible for database administration, data consolidation, data analysis and management reporting. Utilizes software to generate metrics and develop actionable recommendations. Supports research teams and management by collecting and analyzing data and reporting results. Collaborates with various functional teams such as marketing, research and IT to achieve business results. Relies on experience, judgment and familiarity with practices and procedures to achieve goals. A certain degree of creativity and latitude is expected. Typically reports to a supervisor or manager. Requires a bachelor’s degree in area of specialty and 2-4 years of experience in the field or in a related area.

Reporting Analyst

Analyzes and evaluates a wide array of data-related business processes and reporting. Develops data-gathering strategies to create reports within Crystal Reports and Tableau. Familiar with SQL and servers to design databases for securing a company’s data. Ability to troubleshoot these systems. May require a bachelor’s degree in a related field.

Software Developer, Big Data

Develops new systems and tools for use with big data intake and analysis. Manages data extraction and builds new data pipelines from various sources, both structured and unstructured. Designs, develops and executes solutions to solve operational and strategic problems. Develops automation for setup and maintenance of big data platform. Usually works under a supervisor, though some flexibility is required. Requires a bachelor’s degree in area of specialty and a minimum of 5-8 years of relevant experience.

SQL Server Database Administrator

Primary owner and maintainer of all SQL server databases. Monitors and maintains database to maximize stability and uptime across production and testing environments. Performs routine backup and recovery testing to ensure data recoverability. Conducts routine server audits to monitor compliance. Troubleshoots SQL Server service outages. Usually reports to a department head. Requires a bachelor’s degree in area of specialty and a minimum of 5 years of relevant experience.