Database Development, Administration, and BI

Below are the typical Database Development, Administration, and BI job descriptions staffed by Modis. View our other positions by visiting Job Categories or to inquire about a specific need, fill our brief contact form.

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 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 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.

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 analytics 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 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.

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 I

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. Relies on established guidelines and instructions to perform daily job functions. Works under immediate supervision and usually reports to a supervisor or manager. May require a bachelor’s degree and 0–2 years of relevant experience.

Data Architect II

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. Relies on knowledge and professional discretion to achieve goals. Works under general supervision and usually reports to a supervisor or manager. May require a bachelor’s degree and 2–4 years of relevant experience.

Data Architect III

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. Relies on knowledge and professional discretion to achieve goals. Significant ingenuity and flexibility is expected. Usually reports to a supervisor or manager. May require a bachelor’s degree and 4–6 years of relevant experience.

Data Architect IV

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. Relies on extensive knowledge and professional discretion to achieve goals. Significant ingenuity and flexibility is expected. Manages others, but usually reports to the head of a department. Require a bachelor’s degree and 6–8 years of relevant experience.

Data Architect V

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. Relies on extensive knowledge and professional discretion to achieve goals. Significant ingenuity and flexibility is expected. Manages others, but usually reports to the head of a department. Require a bachelor’s degree and 8–10 years of relevant experience.

Data Management Director

Ensures a smooth and effective data management infrastructure encompassing data warehouses, data stores, database architecture and other related systems. Responsible for overseeing data systems and ensuring they meet organizational requirements. Relies on extensive knowledge and professional discretion to achieve goals. Significant ingenuity and flexibility is expected. Manages others. Usually reports to senior management. Requires a bachelor’s degree and at least 10 years of field 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 Warehouse Manager

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 Programming Specialist

Oversees data warehouse design and configuration. Codes and documents procedures and tests and debugs data warehouses. Relies on knowledge and professional discretion to achieve goals. Some ingenuity and flexibility is expected. Usually reports to a manager or department head. Requires a bachelor’s degree with at least 2–4 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.

Data Scientist

Extracts and analyzes data and communicates conclusions that drive efficiency and process. Collaborates with data engineers and stakeholders on defining KPI’s, data selection, preprocessing and formatting datasets 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.

Database Administration Manager

Provides technical leadership for architecture, design, documentation and maintenance of an internal database and related systems. Oversees the evaluation, design and implementation of database enhancements and develops a long-term strategy for data storage. Establishes policies and procedures related to data security and integrity and monitors and limits database access as needed. Relies on extensive knowledge and professional discretion to achieve goals. Manages others. Significant ingenuity and flexibility is expected. Usually reports to top management. Requires a bachelor’s degree with at least 7 years of relevant experience.

Database Administrator

Provides technical support for the development, implementation and maintenance of an internal database. Maintains policies and procedures for ensuring database’s security and integrity. Implements data models, database designs, data access and table maintenance codes. Resolves database performance and capacity issues, and replication and other distributed data 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 I

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. Relies on established guidelines and instructions to perform daily job functions. Works under immediate supervision and usually reports to a manager. May require a bachelor’s degree in a related area and 0–2 years of relevant experience.

Database Analyst II

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. Relies on knowledge and professional discretion to achieve goals. Works under general supervision and usually reports to a manager, though some degree of ingenuity and flexibility is required. May require a bachelor’s degree in a related area and 2–4 years of relevant experience.

Database Analyst III

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. Relies on knowledge and professional discretion to achieve goals. Works under general supervision and may manage others. Significant ingenuity and flexibility is required. May require a bachelor’s degree in a related area and 4–6 years of relevant experience.

Database Analyst IV

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. Relies on knowledge and professional discretion to achieve goals. Usually reports to a manager or department head and manages others. Significant ingenuity and flexibility is required. May require a bachelor’s degree in a related area and 6–8 years of relevant experience.

Database Analyst V

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. Relies on knowledge and professional discretion to achieve goals. May offer consultation to senior management and often serves as the top-level expert in the field. May manage others. Significant ingenuity and flexibility is expected. May require a bachelor’s degree in a related area and 8–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, Sr.

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 come 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.

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.