FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in data modeling, including conceptual, logical, and physical models, while ensuring data quality and governance. Proficient in SQL and various database management systems, with a strong focus on BI and Big Data applications.
Highest-signal resume keywords
Data ModelingSAP PowerDesignerSQL ProficiencyETL IntegrationAgile Methodologies
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Data ModelingSQLDDLDMLDCLTransaction SQLRelational DBMSNoSQL DBMSPerformance AnalysisTable Partitioning
Soft Skills
ConsultingMentoringCollaborationContinuous Process Improvement
Tools & Technologies
SAP PowerDesignerInformatica PowerCenterInformatica PowerExchangeInformatica Data QualityInformatica Metadata Management
Industry Keywords
Big DataBI Best PracticesMetadata QualityVLDBsAgile Methodologies
Tech Stack
Tools & technologiesApacheETLInformaticaMongoDBNoSQLOraclePostgresSQL
About the role
Key responsibilities & impact- Develop, propose, maintain, and update conceptual, logical, and physical data models using SAP PowerDesigner
- Ensure data structures are normalized by eliminating redundancies and guaranteeing logical consistency in the database
- Manage and ensure metadata quality, supporting the corporate data management and governance methodology
- Design and develop architecture for data services across relational, analytical, and NoSQL ecosystems, supporting BI and Big Data applications
- Collaborate with DBAs on physical implementation, table partitioning, and database performance optimization, including VLDBs
- Specify integration mechanisms, such as ETL processes, database links, and services
- Develop SQL scripts for validations and reporting
- Process and manipulate VSAM, CSV, TXT, JSON, XML, relational, and NoSQL data sources
- Provide consulting, support, and mentoring to business teams, promoting BI best practices and continuous process improvement
- Work on large-scale projects and complex corporate environments at Certsys, a technology company specializing in IT solutions and services
Requirements
What you’ll need- Proven experience in data modeling (conceptual, logical, and physical—relational and multidimensional)
- Practical proficiency with SAP PowerDesigner
- Proficiency in SQL, DDL, DML, DCL, Transaction SQL, and SQL*Plus
- Knowledge of and experience in administering and modeling relational and NoSQL DBMSs, including Oracle, DB2, Sybase, PostgreSQL, SQL Server, MongoDB, InfluxDB, and Apache HAWQ/Impala
- Experience using the Informatica suite: PowerCenter, PowerExchange, Data Quality, and Metadata Management
- Knowledge of and experience with integration architectures, including ETL specifications, database links, and DBMS-based services
- Experience with VLDBs, performance analysis techniques, and table partitioning
- Proficiency in agile methodologies: Scrum, Kanban, XP, and the Agile Manifesto
- Familiarity with statistics, predictive models, and probabilistic analysis
- This position is also open to applicants with disabilities
Benefits
Comp & perks- Bradesco Saúde National health plan with medical and dental coverage
- Swile meal card
- Transportation allowance
- Exclusive banking credit package
- Life insurance with 100% coverage at no additional cost
- Exclusive discounts on courses and educational institutions
- Gym access through Wellhub (formerly Gympass)
- Participation in projects that transform public administration
- Work with market-leading tools