What are the responsibilities and job description for the Sr. Business Intelligence Analyst position at JLL?
Job duties
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 (Alteryx) when needed
Develops, executes and monitors simple to moderately complex data management / analytic processes to support ad hoc data and information delivery for assigned projects
Translate business questions and hypotheses 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
Leverage industry tools (i.e. Alteryx/SSMS) to assess data quality and assist to resolve data quality problems
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
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
Requirements
2 years of BI, business or data analyst experience required ideally in an enterprise environment across multiple application systems and business functions.
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.
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.
Excellent presentation skills (verbal and written), Strong understanding of analytic/statistical concepts with the ability to explain them to others.
Experience with data visualization tools, Tableau preferred
Proficiency in ETL processes/tools - Alteryx Preferred
Strong SQL skills with experience developing complex queries and stored procedures
Preferred
Bachelor's degree in Statistics, Economics, Business Administration, Information Systems, MIS, Computer Science, Data Analytics, Information Technology, or related field
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
Business analysis, consulting/advisory and/or project or client management experience will be a strong plus
Exposure to SharePoint Power Applications and SSRS (Report Builder) a plus
Having a broad understanding of the Corporate Real Estate business is a plus
Experience with Agile methodologies and knowledge of development lifecycle is a plus
Comfortable with senior managers and executives; can present without undue tension and nervousness
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.
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 (Alteryx) when needed
Develops, executes and monitors simple to moderately complex data management / analytic processes to support ad hoc data and information delivery for assigned projects
Translate business questions and hypotheses 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
Leverage industry tools (i.e. Alteryx/SSMS) to assess data quality and assist to resolve data quality problems
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
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
Requirements
2 years of BI, business or data analyst experience required ideally in an enterprise environment across multiple application systems and business functions.
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.
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.
Excellent presentation skills (verbal and written), Strong understanding of analytic/statistical concepts with the ability to explain them to others.
Experience with data visualization tools, Tableau preferred
Proficiency in ETL processes/tools - Alteryx Preferred
Strong SQL skills with experience developing complex queries and stored procedures
Preferred
Bachelor's degree in Statistics, Economics, Business Administration, Information Systems, MIS, Computer Science, Data Analytics, Information Technology, or related field
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
Business analysis, consulting/advisory and/or project or client management experience will be a strong plus
Exposure to SharePoint Power Applications and SSRS (Report Builder) a plus
Having a broad understanding of the Corporate Real Estate business is a plus
Experience with Agile methodologies and knowledge of development lifecycle is a plus
Comfortable with senior managers and executives; can present without undue tension and nervousness
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.
Analyst, Business Intelligence
American Water Resources LLC -
Naperville, IL
Business Intelligence Analyst
VirtualVocations -
Chicago, IL
Business Intelligence Analyst
The Sterling Choice -
Bartlett, IL
