Sr. Data Engineer

JLL is a leading global provider of real estate and investment management services, and they are seeking a Data Engineer to analyze and collect data for actionable insights that drive strategic decision-making. The role involves developing and maintaining data integration, automation, and monitoring, while collaborating with various stakeholders to deliver impactful data-driven solutions.

Responsibilities:

• 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

Requirements:

• 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
• 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