Introduction A career in IBM Consulting is built on long-term client relationships and close collaboration worldwide. You'll work with leading companies across industries, helping them shape their hybrid cloud and AI journeys. With support from our strategic partners, robust IBM technology, and Red Hat, you'll have the tools to drive meaningful change and accelerate client impact.

At IBM Consulting, curiosity fuels success. You'll be encouraged to challenge the norm, explore new ideas, and create innovative solutions that deliver real results. Our culture of growth and empathy focuses on your long-term career development while valuing your unique skills and experiences.

In this role, you'll work in one of our IBM Consulting Client Innovation Centers (Delivery Centers), where we deliver deep technical and industry expertise to a wide range of public and private sector clients around the world. Our delivery centers offer our clients locally based skills and technical expertise to drive innovation and adoption of new technology.

Your Role and Responsibilities

Data Model Design & Development
- Design conceptual, logical, and physical data models.
- Translate business requirements into scalable data structures.
- Define entities, attributes, relationships, and business rules.
- Create data models for data warehouses, data lakes, and operational systems.
Data Architecture & Integration
- Collaborate with Data Architects to define enterprise data standards.
- Design schemas that support data integration across multiple sources.
- Establish data lineage and data flow mappings.
- Support modernization and cloud migration initiatives.
Database Design
- Develop normalized and denormalized database models.
- Design dimensional models (Star Schema and Snowflake Schema).
- Optimize databases for analytics and transaction processing.
- Define indexing and partitioning strategies.
Data Quality & Governance
- Establish data standards and naming conventions.
- Support master data management (MDM) initiatives.
- Ensure consistency and integrity across enterprise datasets.
- Identify and resolve data quality issues.
Analytics & Reporting Support
- Design analytical data structures for BI platforms.
- Enable efficient reporting and dashboard development.
- Support self-service analytics environments.
- Partner with Data Engineers and Data Analysts to improve data accessibility.
Performance Optimization
- Analyze database performance bottlenecks.
- Improve query efficiency and data retrieval performance.
- Optimize ETL/ELT processes and data pipelines.
- Implement best practices for large-scale data environments.
Documentation & Standards
- Maintain data dictionaries and metadata repositories.
- Document data definitions and business terminology.
- Produce technical design specifications and model documentation.
- Ensure compliance with enterprise governance requirements.
Collaboration
- Work closely with:
  - Business Analysts
  - Data Engineers
  - Data Architects
  - Database Administrators
  - BI Developers
  - Data Governance Teams
  - AI/ML Engineers

Required Education

Associate's Degree/College Diploma

Preferred Education

Bachelor's Degree

Required Technical and Professional Expertise

Data Modeling & Architecture
- Strong understanding of conceptual, logical, and physical data modeling techniques.
- Experience designing enterprise-scale data architectures.
- Ability to translate business requirements into data structures and models.
- Knowledge of data lifecycle management and data governance principles.
Business & Analytical Skills
- Strong analytical and problem-solving capabilities.
- Ability to understand complex business processes and map them to data solutions.
- Experience working with business stakeholders to define data requirements.
- Understanding of KPI, reporting, and analytics requirements.
Data Governance & Quality
- Knowledge of data governance frameworks and best practices.
- Experience with data quality management and data stewardship processes.
- Understanding of metadata management, data lineage, and master data management (MDM).
Communication & Collaboration
- Ability to collaborate with Data Architects, Engineers, Analysts, and Business Teams.
- Strong documentation and presentation skills.
- Experience participating in Agile/Scrum development environments.
- Ability to explain technical concepts to non-technical stakeholders.

Required Technical Expertise

Data Modeling
- Conceptual Data Modeling
- Logical Data Modeling
- Physical Data Modeling
- Entity Relationship (ER) Modeling
- Dimensional Modeling (Star and Snowflake Schemas)
- Data Vault Modeling
Database Management
- Advanced SQL development and optimization
- Database design and normalization
- Performance tuning and query optimization
- Experience with relational and non-relational databases
Data Warehouse & Analytics
- Data Warehouse design and implementation
- Fact and Dimension modeling
- Slowly Changing Dimensions (SCD)
- Data Mart design
- OLAP concepts
Data Platforms
- Experience with one or more of:
  - Microsoft SQL Server
  - Oracle Database
  - PostgreSQL
  - Snowflake
  - IBM Db2
  - Teradata
Cloud Data Technologies
- Microsoft Azure Data Services
- Microsoft Fabric
- Azure Synapse Analytics
- Azure Data Factory
- Azure Databricks
- AWS Redshift
- Google BigQuery
Data Integration
- ETL / ELT frameworks
- Informatica
- IBM DataStage
- SSIS
- Azure Data Factory
- Apache Airflow
Programming & Automation
- SQL (Expert Level)
- Python
- PySpark
- Spark SQL
- JSON, XML, and API integrations
Data Governance Tools
- Microsoft Purview
- Collibra
- Informatica Data Quality
- Enterprise Data Catalog solutions
Visualization & Analytics Support
- Power BI
- Tableau
- Cognos Analytics
- Semantic Models and Data Mart design

Preferred Technical and Professional Experience

Data Warehousing Knowledge: Exposure to data warehousing concepts and architectures, with an understanding of how data models integrate with data warehouses.
Advanced Data Modeling: Experience with advanced data modeling techniques, including data governance and data quality, to develop and refine data models that meet business objectives.
Big Data Technologies: Exposure to big data technologies, including Hadoop and NoSQL databases, with an understanding of how data models can be applied to these technologies.

About Business Unit IBM Consulting is IBM's consulting and global professional services business, with market leading capabilities in business and technology transformation. With deep expertise in many industries, we offer strategy, experience, technology, and operations services to many of the most innovative and valuable companies in the world. Our people are focused on accelerating our clients' businesses through the power of collaboration.

We believe in the power of technology responsibly used to help people, partners and the planet.

Your Life @ IBM In a world where technology never stands still, we understand that dedication to our clients' success, innovation that matters, and trust and personal responsibility in all our relationships, lives in what we do as IBMers as we strive to be the catalyst that makes the world work better.

Being an IBMer means you'll be able to learn and develop yourself and your career; you'll be encouraged to be courageous and experiment every day, all whilst having continuous trust and support in an environment where everyone can thrive whatever their personal or professional background.

Our IBMers are growth minded, always staying curious, open to feedback and learning new information and skills to constantly transform themselves and our company. They are trusted to provide on-going feedback to help other IBMers grow, as well as collaborate with colleagues keeping in mind a team-focused approach to include different perspectives to drive exceptional outcomes for our customers. The courage our IBMers have to make critical decisions every day is essential to IBM becoming the catalyst for progress, always embracing challenges with resources they have to hand, a can-do attitude and always striving for an outcome-focused approach within everything that they do.

Are you ready to be an IBMer?

About IBM IBM's greatest invention is the IBMer. We believe that through the application of intelligence, reason, and science, we can improve business, society, and the human condition, bringing the power of an open hybrid cloud and AI strategy to life for our clients and partners around the world.

Restlessly reinventing since 1911, we are not only one of the largest corporate organizations in the world, we're also one of the biggest technology and consulting employers, with many of the Fortune 500 companies relying on the IBM Cloud to run their business.

At IBM, we pride ourselves on being an early adopter of artificial intelligence, quantum computing, and blockchain. Now it's time for you to join us on our journey to being a responsible technology innovator and a force for good in the world.

IBM is proud to be an equal-opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, genetics, pregnancy, disability, neurodivergence, age, or other characteristics protected by the applicable law. IBM is also committed to compliance with all fair employment practices regarding citizenship and immigration status.

Other Relevant Job Details All our positions are eligible for people with disabilities PwD or rehabilitated.

Important Notice to Candidates IBM does not charge any fees or request any kind of payment from candidates to participate in its recruitment processes. This includes, but is not limited to, application fees, costs for sending documents, or any payment related to the application or interviews. If you receive any request for payment in the name of IBM, we strongly recommend that you do not proceed and report it immediately through the company's official channels.

Locations: RIO DE JANEIRO, Rio de Janeiro, Brazil

Data Engineer - STUDENT CONVERSION

Descrição da vaga

Explorar mais

Relacionado

Relacionado