Sr. Data Engineer

JLL empowers you to shape a brighter way.  

Our people at JLL are shaping the future of real estate for a better world by combining world class services, advisory and technology for our clients. We are committed to hiring the best, most talented people and empowering them to thrive, grow meaningful careers and to find a place where they belong.  Whether you’ve got deep experience in commercial real estate, skilled trades or technology, or you’re looking to apply your relevant experience to a new industry, join our team as we help shape a brighter way forward.   

Data Engineer

Job Overview: As a Data Engineer, you will play a crucial role in analyzing and collecting data to provide actionable insights that drive strategic decision-making. Your primary responsibility will involve developing and maintaining data integration, automation, and monitoring using Power BI, Azure Databricks, Power Automate, and SmartSheets. You will collaborate with stakeholders from various departments to identify business requirements, design BI solutions, and deliver impactful data-driven solutions.

What is your day to day?  

• Collaborate with business users to identify, analyze, and document business requirements and key performance indicators (KPIs)

• Design, develop, and maintain data integration and automation using Power BI, Azure Databricks, Power Automate, and SmartSheets

• Collect and transform data from multiple sources into a structured format for analysis

• Develop and maintain data models and data sets for efficient and accurate reporting

• Create Power BI dataflows and shared semantic models to consolidate data model definitions

• Ensure data accuracy, integrity, and consistency within the BI solutions

• Provide training and support to Power BI developers to optimize data models in Power BI for their development needs

• Collaborate with IT teams to ensure data security, integrity, and compliance with data governance policies

• Stay up to date with the latest trends in business intelligence and analytics tools, techniques, and best practices

Desired experience and technical skills  

Required

• Bachelor's degree in Computer Science, Information Systems, Business Analytics, or a related field

• Proven experience of at least 3 years as a Data Engineer or similar role

• Strong proficiency in Power BI, specifically modeling, row-level-security, and complex DAX formulations

• Strong proficiency in Power Query, including writing M-code

• Solid understanding and practice of data modelling: relational models (ERD), star/snowflake schemas, slowly changing dimensions, referential integrity, etc.) and experience working with large datasets composed of unstructured/semi-structured/structured data

• Proficient in SQL and data manipulation languages

• Strong analytical and problem-solving skills with the ability to interpret complex data sets

• Excellent communication and collaboration skills to work effectively with cross-functional teams and stakeholders

• Ability to manage multiple projects simultaneously, prioritize tasks, and meet deadlines

Preferred

• Experience with data integration and ETL processes and software

• Experience with Power Apps, Power Automate Desktop and Cloud Flows

• Familiarity with Azure Databricks, Python, SQL

• Familiarity with data governance principles and practices

• Familiarity with advanced Power BI features and concepts such as Field Parameters, Calculation Groups, Time Intelligence derivation, Row-Level Security (RLS), and Workspace Security (including Application Audiences)

• Familiarity with advanced Power Query concepts such as sourcing data via Restful web APIs, performance tuning and optimizing data refreshes, and creating common utility functions

Join our team as a Data Engineer and contribute to driving data-driven decision-making by leveraging Power BI, Azure Databricks, and Microsoft Power Apps expertise!

This position does not provide visa sponsorship. Candidates must be authorized to work in the United States without sponsorship.

Estimated compensation for this position:

95,000.00 – 105,000.00 USD per year

This range is an estimate and actual compensation may differ. Final compensation packages are determined by various considerations including but not limited to candidate qualifications, location, market conditions, and internal considerations.

Location:

Remote –Atlanta, GA, Charlotte, NC, Chicag