Address JLL supports the Whole You, personally and professionally.
Our people at JLL are shaping the future of real estate for a better world by combining world class services, advisory and technology to our clients. We are committed to hiring the best, most talented people in our industry; and we support them through professional growth, flexibility, and personalized benefits to manage life in and outside of work. Whether you’ve got deep experience in commercial real estate, skilled trades, and technology, or you’re looking to apply your relevant experience to a new industry, we empower you to shape a brighter way forward so you can thrive professionally and personally.
Data Engineer 2
JLL Technologies Centre of Expertise
What this job involves:
#JLLTechAmbitions
About the role
JLL, an international real estate management company, is seeking an Data Engineer to join our JLL Technologies Team. We are seeking candidates that are self-starters who can work in a diverse and fast-paced environment. We are looking for a candidate to provide Azure Databricks, Python, PySpark, SparkSQL, Azure functions, Delta Lake, Azure DevOps CI/CD along with Informatica PowerCenter, Data Quality, Control M, SSMS expertise to design and build the required Solutions for our Clients.
Responsibilities
Independently plans, designs, develop, executes and monitor complex data integration activities to support project delivery and daily operation.
Expert in defining, implementing, debugging and optimizing data integration mappings and scripts from a variety of data sources.
Spearheads development of ETL code, metadata definition and models, queries, scripts, schedules, work processes and maintenance procedures and identify opportunities to optimize the sizing, performance and efficiency of existing processes/procedures.
Mentors less experienced analysts on proper standards/techniques to improve their accuracy and efficiency.
Perform the unit testing, system integration testing, regression testing and assist with user acceptance testing.
Articulates business requirements in a technical solution that can be designed and engineered.
Consults with the business to develop documentation and communication materials to ensure accurate usage and interpretation of JLL data.
Develops technical understanding of how the data flows from various source systems and source types to fine tune data integration solution.
Work independently or as part of a team to deliver data warehouse ETL projects.
Adhere to established standards and best practices and provide input for improvement of those processes.
Self-motivated team player who can work with minimal supervision and can adapt to a quickly changing environment.
Maintain a high-volume data warehouse application.
Ability to work on multiple tasks simultaneously, ability to switch between tasks and work in conflicting priorities
Sounds like you? To apply you need to be:
Experience & Education
At least 3 to 8 years of relevant experience is desired.
Having a Bachelors/Master’s degree in Computer Science/Information Systems from a reputed University
Strong computer science fundamentals.
Strong in communications with business stakeholders:
Requires strong ability to communicate and manage stakeholders, and to drive collaboration between the business team and the various project teams including application support teams, network teams, database teams, and storage and server teams across the regions.
Excellent technical, analytical, and organizational skills.
Effective written and verbal communication skills, including technical writing.
Technical Skills & Competencies
Azure Databricks
ETL knowledge
SQL knowledge
Python
PySpark
SparkSQL
Azure functions
Delta Lake
Azure DevOps CI/CD
Azure Data Factory
Good to have knowledge on ADLS Gen2, Kafka stream processing
Good communication
Self-starter and willingness to learn other technology including Informatica and Go Anywhere
Must have hands-on experience with commercial Integration products including Informatica PowerCenter 10.x, Data Integration Hub, Power Exchange, Informatica Cloud, Data Quality, Master Data Management, Address Doctor
Must have experience in Windows PowerShell / UNIX Shell Scripting, Control-M to automate the job runs.
Must have basic hands on MSSQL Server Database development experiences including:
Stored Procedures
Explain Plans
Constraints
Views
Materialized Views
Export/Import Utilities
Must have strong knowledge of Software Development Life Cycle including requirement analysis, design, development, testing, and implementation. Hands on experience in performance tuning of sources, targets, mappings and sessions.
Support:
Ability to identify critical system health issue and flag them for discussion and resolution.
Constantly questioning due to fluid processes and complexity of environment.
Proven experience in common support activities including
User Management
Access management
Object management (folder, connections, rules etc..)
Backing up the repositories
Code migration across multiple environments
Performance diagnosis/improvement
Ability to handle and co-ordinate Sev1 tickets
Maintaining standards:
Proven experience in following standards and helping other adopt standards
Making sure that code is sync across all three environments.
Ensure development teams are following appropriate standards
What we can do for you:
At JLL, we make sure that you become the best version of yourself by helping you realise your full potential in a fully entrepreneurial and inclusive work environment. If you harbour passion for learning and adapting new technologies, JLL will continuously provide you with platforms to enrich your technical domains. We will empower your ambitions through our dedicated Total Rewards Program, competitive pay and benefits package. It’s no surprise that JLL has been recognized by the Ethisphere Institute as one of the 2021 World’s Most Ethical Companies for the 14th consecutive year.
Apply today!
If this job description resonates with you, we encourage you to apply even if you don’t meet all of the requirements below. We’re interested in getting to know you and what you bring to the table!
Personalized benefits that support personal well-being and growth:
JLL recognizes the impact that the workplace can have on your wellness, so we offer a supportive culture and comprehensive benefits package that prioritizes mental, physical and emotional health.
About JLL –
We’re JLL—a leading professional services and investment management firm specializing in real estate. We have operations in over 80 countries and a workforce of over 102,000 individuals around the world who help real estate owners, occupiers and investors achieve their business ambitions. As a global Fortune 500 company, we also have an inherent responsibility to drive sustainability and corporate social responsibility. That’s why we’re committed to our purpose to shape the future of real estate for a better world. We’re using the most advanced technology to create rewarding opportunities, amazing spaces and sustainable real estate solutions for our clients, our people, and our communities.
Our core values of teamwork, ethics and excellence are also fundamental to everything we do and we’re honored to be recognized with awards for our success by organizations both globally and locally.
Creating a diverse and inclusive culture where we all feel welcomed, valued and empowered to achieve our full potential is important to who we are today and where we’re headed in the future. And we know that unique backgrounds, experiences and perspectives help us think bigger, spark innovation and succeed together.
