Data Engineer (Technology Consultant)

Ernst & Young Advisory Services Sdn Bhd; Daerah Khusus Ibukota Jakarta; On-site; IDR 200.000.000 - 300.000.000; Full time

Job summary

A leading consulting firm in Jakarta is seeking a Data & Analytics Consultant to help clients navigate business and technology transformations. Ideal candidates have 6-10 years of experience in data engineering, strong skills in ETL design, and a bachelor’s degree in a relevant discipline. The role offers opportunities to work on diverse client projects and develop innovative solutions.

Benefits

Continuous learning opportunities

Transformative leadership coaching

Diverse and inclusive culture

Qualifications

• 6-10 years of experience in Data engineering and architecture.
• Proficient in ETL design, optimization, and development.
• Strong communication and strategic thinking skills.

Responsibilities

• Design data models and ETL logic based on specifications.
• Automate data quality error resolution and enforce rules.
• Provide business and technology perspectives to clients.

Skills

Data management

Database design

ETL design

BI development

Data engineering

Data quality management

Education

Bachelor’s Degree in Information Systems or related

Tools

Talend

Hadoop

MapR

Job description

EY, a global leader operating in more than 150 countries delivers unparalleled service in Consulting and assists clients to transform and upskill their capabilities.

We serve our clients to build a better working world, helping them to create long-term value for people and society and build trust in the capital markets. That starts with a culture that believes in giving you the training, opportunities, and creative freedom to make things better. Whenever you join, however long you stay, the exceptional EY experience lasts a lifetime. And with a commitment to hiring and developing the most passionate people, we work towards our ambition to be the best employer.

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture, and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

The exceptional EY experience. It’s yours to build.

We look forward you to joining us in the Data & Analytics Consultant team:

For Managerial level

Years of experience: 6-10 solid years of Data engineering and architecture background.

Experience

• Design the Logical Data Model based on technical specification requirement.
• Design ETL logic to transform raw data from source into target table as per the Logical Data Model.
• Design big data ingestion, loading, and unloading data into a data lake.
• Automate data quality error resolution and enforce rules.
• Prepared test cases and test plan based on the Logical Data Model, Data Mapping and technical specification.

Technical skill

Proficient in data management, database design, ETL design, optimization and development.

Proficient in BI development and visualization (optional).

Tools

• Packaged ETL tools, i.e. Talend, HIVE and Hadoop, MapR platform.
• Any database and ETL tools.

Years of experience: 3-5 solid years of Data engineering background.

Experience

• Translate and develop Physical data model design of transactional and master tables.
• Data cleansing and data profiling (basic).
• Develop big data ETL jobs, loading, and unloading data into a data lake.
• Implement the delivery of enhancements for an existing Data Warehouse for a new data source system.
• ETL Unit testing and data validation.

Technical skill

Proficient in data management, database design, ETL design, optimization and development.

Proficient in BI development and visualization (optional).

Tools

• Packaged ETL tools, i.e. Talend, HIVE and Hadoop, MapR platform.
• Any database and ETL tools.

The opportunity

You will help our clients navigate the business and technology transformation vision. We’ll look to you to provide our clients with a unique business and technology perspective on how technology can transform and improve their entire organization – starting with key business issues they face. This is a high-growth, high-visibility area with plenty of opportunities to enhance your skill set and build your career.

Your key responsibilities

You’ll spend most of your time working with a wide variety of clients and your colleagues to deliver the latest trends, practices, technologies, and architecture to design, build and maintain scalable and robust solutions that unify, enrich, collaborate and deliver value.

Skills and attributes for success

• Outstanding team player.
• High level of motivation.
• Strong work ethic.
• Self-starting attitude.
• Independent and able to manage and prioritize workload.
• Ability to quickly and positively adapt to change.
• Excellent written and verbal communication, presentation, client service, and technical writing skills, coupled with excellent executive presence.
• Significant experience in managing and delivering medium to large teams on complex programs and projects.
• Assessing, designing, architecting, and developing solutions leveraging the latest technologies and trends to exceed the business requirements.
• Unifying, enriching, and delivering value to derive insights and opportunities.
• Leveraging in-house and partners - platforms and solutions as needed and recommending and building new platforms/solutions as required to exceed business requirements.
• Communicating findings, recommendations, and opportunities to improve platforms and solutions.
• Demonstrating a deep understanding of technology, concepts, tools, features, functions, and benefits of different approaches.
• Seeking out information to learn about emerging methodologies and technologies.
• Clarifying problems by driving to understand the true issue.
• Looking for opportunities for improving methods and outcomes.
• Collaborating, influencing, and building consensus through constructive relationships and effective listening.
• Solving problems by incorporating data into decision making.
• Proven track record of sales and delivery in a consulting context with established client relationships and experience.

Ideally, you must have

• Bachelor’s Degree or above in Information Systems, Computer Science, Electronics and Communications, or related disciplines.
• Minimum three (3) years of experience (for Senior level) and 5 to 7 years for Manager or Senior Manager level.

What we look for

We’re interested in passionate individuals with a strong vision and a desire to stay on top of trends. If you have a genuine passion for helping businesses achieve their full potential, then these role(s) are for you.

What we offer

• Continuous learning: You’ll develop the mindset and skills to navigate whatever comes next.
• Success as defined by you: We’ll provide the tools and flexibility, so you can make a meaningful impact, on your way.
• Transformative leadership: We’ll give you the insights, coaching, and confidence to be the leader the world needs.
• Diverse and inclusive culture: You’ll be embraced for who you are and empowered to use your voice to help others find theirs.

If you can demonstrate that you meet the criteria above, please contact us as soon as possible.