Senior Data Engineer
USA-CORP Westmont IL-Westmont - 700 Oakmont
JLL
JLL ist bestens mit dem Immobilienmarkt vertraut & bietet sachkundige Beratung. Kontaktieren Sie uns bei allen Angelegenheiten rund um Gewerbeimmobilien.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.
Responsibilities
- Act as a Senior Data Engineer to drive project solutions and the team & mentoring them on technical expertise as required.
- 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 8 to 10 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 Data Factory
- Azure DevOps CI/CD
- 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
- Perform support activities including some weekends.
- 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
Location:
On-site –Chicago, IL, Westmont, ILIf this job description resonates with you, we encourage you to apply, even if you don’t meet all the requirements. 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. Some of these benefits may include:
401(k) plan with matching company contributions
Comprehensive Medical, Dental & Vision Care
Paid parental leave at 100% of salary
Paid Time Off and Company Holidays
Flexible and Remote Work Arrangements may be available
JLL Privacy Notice
Jones Lang LaSalle (JLL), together with its subsidiaries and affiliates, is a leading global provider of real estate and investment management services. We take our responsibility to protect the personal information provided to us seriously. Generally the personal information we collect from you are for the purposes of processing in connection with JLL’s recruitment process. We endeavour to keep your personal information secure with appropriate level of security and keep for as long as we need it for legitimate business or legal reasons. We will then delete it safely and securely.
For more information about how JLL processes your personal data, please view our Candidate Privacy Statement.
For additional details please see our career site pages for each country.
For candidates in the United States, please see a fully copy of our Equal Employment Opportunity and Affirmative Action policy here.
This position may require you to be fully vaccinated against COVID-19. If required, you’ll be asked to provide proof that you’re fully vaccinated upon your start date. You’re considered fully vaccinated two weeks after you receive the second dose of a two-dose vaccine series (e.g., Pfizer or Moderna) or two weeks after a single-dose vaccine (e.g., Johnson & Johnson/Janssen). Failure to provide proof of vaccination may result in termination.
Jones Lang LaSalle (“JLL”) is an Equal Opportunity Employer and is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation because of a disability for any part of the employment process – including the online application and/or overall selection process – you may contact us at Accommodation Requests. This email is only to request an accommodation. Please direct any other general recruiting inquiries to our Contact Us page > I want to work for JLL.
Pursuant to the Arizona Civil Rights Act, criminal convictions are not an absolute bar to employment.
Pursuant to Illinois Law, applicants are not obligated to disclose sealed or expunged records of conviction or arrest.
Pursuant to Columbia, SC ordinance, this position is subject to a background check for any convictions directly related to its duties and responsibilities. Only job-related convictions will be considered and will not automatically disqualify the candidate.
Accepting applications on an ongoing basis until candidate identified.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Azure CI/CD Computer Science Databricks Data management Data quality Data warehouse DevOps ETL Informatica Kafka MS SQL Privacy PySpark Python SDLC Security Shell scripting SQL Testing
Perks/benefits: Career development Flex hours Flex vacation Health care Medical leave Parental leave Startup environment
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Intern jobs
- Open Lead Data Analyst jobs
- Open Data Engineer II jobs
- Open Power BI Developer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Science Manager jobs
- Open Marketing Data Analyst jobs
- Open MLOps Engineer jobs
- Open Junior Data Scientist jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Business Data Analyst jobs
- Open Product Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Data Analyst Intern jobs
- Open Sr Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Data Engineering Manager jobs
- Open Junior Data Engineer jobs
- Open Big Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Research Scientist jobs
- Open Azure Data Engineer jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Data quality-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Data visualization-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open NLP-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open LLMs-related jobs
- Open APIs-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open Snowflake-related jobs
- Open Consulting-related jobs
- Open Hadoop-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open Airflow-related jobs