What are the responsibilities and job description for the Business Intelligence and Analytics Senior Analyst position at JLL?
Areas of Responsibility:
Business Intelligence Reporting & Analytics:
Perform data management analysis using SQL, including retrieving data from multiple sources, profiling, processing, validating, and migrating data to centralized data platforms.
Regularly work in SQL and be able to create views, tables, and develop queries to answer questions.
Design, develop and deploy BI solutions, including interactive dashboards in Tableau, sourcing data from internal SQL Server databases, Tableau published data sources, external sources, and leveraging ETL tools when needed.
Devise and promote creative data visualizations, reports, tools and dashboards to derive actionable real-time insights to business data pertinent to the audience (SSRS, Tableau, ect.)
Validate the calculations and results against known figures, other reports, peer reviews, etc.
Develops, executes and monitors simple to moderately complex data management / analytic processes to support ad hoc data and information delivery for assigned projects.
Proactively identify opportunities to optimize the performance and efficiency of existing processes/procedures.
Translate the business questions and hypothesis into a data analysis plan. Execute the analysis either autonomously or in collaboration with others, depending on what the task calls for. Translate the results of the analysis into actionable recommendations and concrete answers to the business questions.
Independently develop, execute, and monitor complex data management/analytic processes to ensure deadlines are met for all assigned deliverables.
Financial modeling, analysis and compilation of quantitative data
Forecast/trending of performance data.
Process mapping and efficiency analysis
Provide subject matter expertise for all data related processes and analysis.
Data Validation & Governance Assistance:
Leverage industry tools (i.e. Alteryx/SSMS) to assess data quality and assist to resolve data quality problems.
Assist the BI and Analytics team and Work Dynamic data governance leads to define and document data remediation activities, processes and quality rules.
Work with business line data stewards and other stakeholders to identify remediation actions when Critical data quality falls below the accepted threshold.
Validate and cleanup input data, ensure assumptions are correct, manage outliers appropriately, raise any questions or issues with the input data if any exists, and help find the root cause of those issues.
Interpersonal/Communication:
Present in front of management groups as the subject matter expert on specific reports or modeling.
Excellent presentation skills (verbal and written), Strong understanding of analytic/statistical concepts with the ability to explain them to others.
Collaborate with other analysts, data scientists and leaders to get to the best solution for complex questions.
Lead problem solving teams to develop recommendations based on data interpretation and analysis to transform behaviors and techniques.
Work closely with business stakeholders to understand business questions/requirements/opportunities, and to support the accurate business usage and interpretation of JLL data as well as provide insight/answers to meet the needs of the business.
Engage with colleagues and internal customers to reverse engineer existing business processes and identify core business requirements for new information deliverables and data infrastructure.
Distribute reports on a regular cadence as defined by the specific task.
Minimum Qualifications:
Bachelor's degree in Business Administration, Information Systems, Data Analytics, Information Technology, Construction or Project Management, or related field.
2 years of BI, business or data analyst experience required ideally in an enterprise environment across multiple application systems and business functions.
Must have 2 years of business experience in Corporate Real Estate, Construction Management, Transaction Management and Lease Brokerage, Property Management or related field.
High level of technical skills with demonstrated ability to manage, manipulate, analyze raw data, research data issues, draw conclusions, provide resolution, and develop actionable recommendations.
Strong SQL skills with experience developing complex queries and stored procedures.
Experience with data visualization tools.
Proficiency in ETL processes/tools.
Proficient user of Microsoft Office applications (Excel, Word, PPT).
Preferred Qualifications:
Experience with Tableau / Alteryx preferred.
Exposure to SharePoint Power Applications and SSRS (Report Builder) a plus.
Business analysis, consulting/advisory and/or project or client management experience will be a strong plus.
Behavioral Traits:
Comfortable with senior managers and clients; can present without undue tension and nervousness
Excellent interpersonal skills - Ability to collaborate across many levels
Excellent oral, written, and presentation communication skills.
Knowledge of data lifecycle and maintenance processes
Experience with Agile methodologies and framework a plus.
Must have demonstrated experience in building and analyzing reports and dashboards along with summarizing the data for business users - Able to take abstract ideas or requirements and work independently towards development of a report/dashboard.
Reliable, self-motivated, and self-disciplined individual capable of planning and executing multiple projects simultaneously within a fast-paced environment - works well in a remote environment.
Impeccable attention to details and never compromising attitude for data accuracy.
JLL Is an Equal Opportunity Employer JLL is committed to developing and maintaining a diverse workforce. JLL strongly believes in equal opportunity extended to all individuals in all aspects of the employment relationship, including recruitment, hiring, training, promotion, transfer, discipline, layoff, recall and termination without regard to race, color, religion, belief, creed, age, sex, pregnancy or maternity (including childbirth and related conditions), family responsibility (e.g. child care, elder care), nationality, ethnic or national origin or ancestry, citizenship, marital status, civil partner status, sexual orientation, gender identity or expression, transgender status, veteran’s status, genetic information, trade union membership, social position, political view or status as a qualified individual with a disability, protected leave status or any other protected characteristic in accordance with applicable law. The company also endeavors to make reasonable accommodations for known physical or mental limitations of otherwise qualified employees and applicants with disabilities unless the accommodations would impose an undue hardship on the operation of our business and ensures that employment decisions are based only on valid job requirements.
Business Intelligence Reporting & Analytics:
Perform data management analysis using SQL, including retrieving data from multiple sources, profiling, processing, validating, and migrating data to centralized data platforms.
Regularly work in SQL and be able to create views, tables, and develop queries to answer questions.
Design, develop and deploy BI solutions, including interactive dashboards in Tableau, sourcing data from internal SQL Server databases, Tableau published data sources, external sources, and leveraging ETL tools when needed.
Devise and promote creative data visualizations, reports, tools and dashboards to derive actionable real-time insights to business data pertinent to the audience (SSRS, Tableau, ect.)
Validate the calculations and results against known figures, other reports, peer reviews, etc.
Develops, executes and monitors simple to moderately complex data management / analytic processes to support ad hoc data and information delivery for assigned projects.
Proactively identify opportunities to optimize the performance and efficiency of existing processes/procedures.
Translate the business questions and hypothesis into a data analysis plan. Execute the analysis either autonomously or in collaboration with others, depending on what the task calls for. Translate the results of the analysis into actionable recommendations and concrete answers to the business questions.
Independently develop, execute, and monitor complex data management/analytic processes to ensure deadlines are met for all assigned deliverables.
Financial modeling, analysis and compilation of quantitative data
Forecast/trending of performance data.
Process mapping and efficiency analysis
Provide subject matter expertise for all data related processes and analysis.
Data Validation & Governance Assistance:
Leverage industry tools (i.e. Alteryx/SSMS) to assess data quality and assist to resolve data quality problems.
Assist the BI and Analytics team and Work Dynamic data governance leads to define and document data remediation activities, processes and quality rules.
Work with business line data stewards and other stakeholders to identify remediation actions when Critical data quality falls below the accepted threshold.
Validate and cleanup input data, ensure assumptions are correct, manage outliers appropriately, raise any questions or issues with the input data if any exists, and help find the root cause of those issues.
Interpersonal/Communication:
Present in front of management groups as the subject matter expert on specific reports or modeling.
Excellent presentation skills (verbal and written), Strong understanding of analytic/statistical concepts with the ability to explain them to others.
Collaborate with other analysts, data scientists and leaders to get to the best solution for complex questions.
Lead problem solving teams to develop recommendations based on data interpretation and analysis to transform behaviors and techniques.
Work closely with business stakeholders to understand business questions/requirements/opportunities, and to support the accurate business usage and interpretation of JLL data as well as provide insight/answers to meet the needs of the business.
Engage with colleagues and internal customers to reverse engineer existing business processes and identify core business requirements for new information deliverables and data infrastructure.
Distribute reports on a regular cadence as defined by the specific task.
Minimum Qualifications:
Bachelor's degree in Business Administration, Information Systems, Data Analytics, Information Technology, Construction or Project Management, or related field.
2 years of BI, business or data analyst experience required ideally in an enterprise environment across multiple application systems and business functions.
Must have 2 years of business experience in Corporate Real Estate, Construction Management, Transaction Management and Lease Brokerage, Property Management or related field.
High level of technical skills with demonstrated ability to manage, manipulate, analyze raw data, research data issues, draw conclusions, provide resolution, and develop actionable recommendations.
Strong SQL skills with experience developing complex queries and stored procedures.
Experience with data visualization tools.
Proficiency in ETL processes/tools.
Proficient user of Microsoft Office applications (Excel, Word, PPT).
Preferred Qualifications:
Experience with Tableau / Alteryx preferred.
Exposure to SharePoint Power Applications and SSRS (Report Builder) a plus.
Business analysis, consulting/advisory and/or project or client management experience will be a strong plus.
Behavioral Traits:
Comfortable with senior managers and clients; can present without undue tension and nervousness
Excellent interpersonal skills - Ability to collaborate across many levels
Excellent oral, written, and presentation communication skills.
Knowledge of data lifecycle and maintenance processes
Experience with Agile methodologies and framework a plus.
Must have demonstrated experience in building and analyzing reports and dashboards along with summarizing the data for business users - Able to take abstract ideas or requirements and work independently towards development of a report/dashboard.
Reliable, self-motivated, and self-disciplined individual capable of planning and executing multiple projects simultaneously within a fast-paced environment - works well in a remote environment.
Impeccable attention to details and never compromising attitude for data accuracy.
JLL Is an Equal Opportunity Employer JLL is committed to developing and maintaining a diverse workforce. JLL strongly believes in equal opportunity extended to all individuals in all aspects of the employment relationship, including recruitment, hiring, training, promotion, transfer, discipline, layoff, recall and termination without regard to race, color, religion, belief, creed, age, sex, pregnancy or maternity (including childbirth and related conditions), family responsibility (e.g. child care, elder care), nationality, ethnic or national origin or ancestry, citizenship, marital status, civil partner status, sexual orientation, gender identity or expression, transgender status, veteran’s status, genetic information, trade union membership, social position, political view or status as a qualified individual with a disability, protected leave status or any other protected characteristic in accordance with applicable law. The company also endeavors to make reasonable accommodations for known physical or mental limitations of otherwise qualified employees and applicants with disabilities unless the accommodations would impose an undue hardship on the operation of our business and ensures that employment decisions are based only on valid job requirements.
