Senior Power BI Developer

Your Impact:

Our People & Places Solutions business – reinforces our drive to improve the lives of people everywhere and epitomizes the “why” of what we do – the tremendous positive impact and value our solutions bring to our communities and society as a whole. From facilities delivering life-saving therapies and ensuring clean water to enabling the connection of people through all modes of transportation and providing access to technology – we’re integrating a multitude of these solution elements to build the smart environments of tomorrow.

Start your Jacobs career with a company that inspires and empowers you to deliver your best work so you can evolve, grow and succeed – today and into tomorrow.

At Jacobs, we know that when it comes to a world that’s smarter, more connected and more sustainable, digital solutions are an important thread linking it all together. 
 
In our digital advisory work, we’re leveraging innovative technologies and big data analytics to solve the world’s most critical challenges. From shaping the safer cities of tomorrow, to protecting against climate change – we’re combining diverse talents with deep client-application experience and digital intelligence to deliver solutions that connect people and places with the means to work smarter and live better, and make an enduring, positive difference in the world. 

• Supporting data warehousing, data modeling, data integration, business intelligence and ETL processes
• Use Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse
• As the senior most ETL developer, take leadership of ETL tasks and supervise other ETL developers and solve difficult problems
• Develops ETL’s using Informatica to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems.
• Responsible for installing, configuring, developing, support and maintenance of the BI APPS.
• Determine data storage needs – evaluate the exact storage needs to have clear picture of the current data situation and analyze different options to determine the best fit.
• Design and create a data warehouse – designs a data warehousing system that meets needs and work with a development team to build the warehouse – conceptual, logical and physical data models to include data conversion, data conversion and data mining.
• Extract, Transformation and Load data – extract necessary data and transfer it to new system.
• Test and troubleshoot – test designs of new system to ensure smooth operations and fix any issues that arise.
• Design schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built Business Model and established relationships & Foreign Keys (Physical & Logical) between tables
• Identify and capture lessons learned, best practices, and information gained during performance of tasks.

Here’s what you’ll need:

Bachelor’s degree in engineering, or a related scientific or technical discipline with at least 6-7 years of relevant experience
Experience extracting and summarizing data from a variety of data source types using Oracle SQL
Experience in using Oracle PLSQL or SQL Plus
Dimensional modeling experience
Experience interfacing with business users and understanding their requirements
Experience with Informatica 9.0.1 or higher, OBIEE, DAC ,Oracle 11.2.0.2 of higher
Ability to learn and implement new and different techniques
Strong Project Management skills
Must have Understanding of business intelligence development in the IT industry
Outstanding written and verbal communication skills
ETL routines, Database skills

Good to have:
Tableau, Power BI

Jacobs. A world where you can.

From our inclusive employee networks, to our positive mental health champions – we’re committed to driving a culture of caring where you can be you. Joining Jacobs not only connects you locally but globally – and together, our diverse perspectives and unique backgrounds power our collective strength. We collaborate and share! By supporting one another, we all succeed. 

With safety and flexibility always top of mind, we’ve gone beyond traditional ways of working so you have the support, means and space to maximise your potential. You’ll uncover flexible working arrangements, benefits and opportunties to do good too – from participating in our global giving and volunteering program, to exploring new and inventive ways to help our clients make the world a better place. No matter what drives you, you’ll discover how you can cultivate, nurture and achieve your goals – all at a single global company.  #ASIAID

Please note:  If you are being represented by a recruitment agency you will not be considered, to be considered you will need to apply directly to Jacobs.

#ASIAID #PHREC