Certsys

Designer

• Develop and maintain conceptual, logical and physical data models using SAP PowerDesigner.
• Model and evolve Oracle databases, ensuring integrity, consistency and standardization of structures.
• Perform reverse engineering and synchronization of data models with database environments.
• Produce and maintain technical documentation for models and data dictionaries.
• Generate and validate DDL scripts for creating and modifying database objects.
• Define and enforce modeling, naming and data governance standards.
• Support development, architecture and DBA teams in defining the best solutions for storing and organizing data.
• Analyze the impact of model changes and propose solutions to ensure performance, scalability and data quality.
• Ensure models comply with business rules and organization standards.
• Participate in system evolution projects, integrations and digital transformation initiatives.

Data Administrator – Oracle, PowerDesigner

Administration

• Administer, monitor, and provide support for Database Management Systems (DBMS).
• Ensure database availability, integrity, security, and performance.
• Analyze and optimize SQL queries to improve performance.
• Monitor application performance across development, staging (homologation), and production environments.
• Propose data modeling improvements to optimize performance.
• Perform data loading and migration between environments.
• Assess the impact of database changes and propose technical solutions.
• Support the implementation of database administration solutions.

DBMS Specialist, Database Administration

Software Engineer

• Join the development team, taking on work items for development in each Sprint.
• Perform development-related activities such as analysis and design, programming, testing, and requirements.
• Manage your own work, promptly notifying the team of any delays or other impediments.

Mainframe Developer, COBOL

Analyst

• Facilitation, mapping and proposing solutions for business needs.
• Collaborate in analyzing and documenting the client's business needs, proposing business solutions that best meet them.
• Assist the Product Owner in decomposing business needs by identifying system requirements generated/impacted and expressing them as user stories to start sprint execution.

Business Analyst

Backend Engineer

• Join the development team and take ownership of work items for each Sprint.
• Perform development activities such as analysis and design, programming, testing, and requirements.
• Manage your own work, promptly informing the team of any delays or other impediments.
• Be proficient in your primary programming language: .NET (VB.NET or C#).

.NET Developer

• Use best practices and available tools to elicit the functional and non-functional requirements the system to be developed must meet.
• Guide, monitor and direct developers regarding the use of requirements-process tools.
• Capture a common vocabulary; classify the system's critical processes; participate in prototyping.
• Define report specifications.
• Define audit trail logging.
• Describe the user interface.
• Develop supplementary specifications.
• Develop a requirements management plan.
• Document information classification.
• Prepare supplementary specifications.
• Prepare a glossary.
• Prepare a requirements list.
• Develop a system access profiles matrix.
• Prepare system messages.
• Specify functional requirements / use cases.
• Structure the use case model.
• Conduct the requirements approval meeting.
• Elicit, document and prioritize preliminary requirements.
• Maintain business rules.

Requirements Analyst

• Collect data from multiple sources, whether from databases or via data collection tools;
• Data cleaning and preparation: process raw data to ensure it is clean, consistent, and ready for analysis. At this stage, remove any duplicate, corrupted, or blank records that could distort analysis;
• Exploratory Data Analysis (EDA): perform exploratory analyses to understand data distributions and identify patterns and/or outliers that may indicate initial trends;
• Report and dashboard development: create visual reports and dashboards using Certsys tools and/or client-provided tools that highlight key insights identified during collection, cleaning, and EDA;
• Data modeling: actively participate in designing data models and database structures that support the organization’s analytical needs;
• Statistical analysis: apply basic statistical techniques to understand relationships between variables, perform hypothesis testing, and conduct comparative analyses based on business rules;
• Team collaboration: work with business teams, data scientists, and other professionals to gather analytical requirements and translate them into solutions;
• Understanding business objectives: maintain a solid understanding of the organization’s business goals to ensure data analysis is aligned with company objectives;
• Technical skill development: continuously improve technical skills, including programming languages such as SQL, Python, or R, and the latest data analysis tools;
• Communication of results: effectively communicate data analysis results to technical and non-technical stakeholders, ensuring insights are actionable and can influence business decisions;
• Identify opportunities to improve business processes based on data analysis findings.

Mid-Level Data Analyst

• Keep data models and logical and physical structures up to date;
• Ensure consistency, quality and governance of data and metadata;
• Participate in the evaluation and implementation of data-related automation solutions;
• Monitor the implementation of data models and the quality of databases;
• Work with BI, Big Data, data integration, metrics and dashboards;
• Support performance analysis and very large database (VLDB) environments.