Specialist, BI

JLL•Albany, NY

13h•Remote

About The Position

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. About the job What your day-to-day will look like: Design, develop, and deploy BI solutions, including interactive dashboards in Tableau and tabular reports in SSRS, sourcing data from internal Azure Databricks schemas. Develop, execute, and monitor moderate to complex data management / analytic processes to support ad hoc data and information delivery for assigned projects Demonstrate ability to efficiently handle and deliver high-quality results for ad hoc requests with tight deadlines. Translate business questions and hypotheses into a data analysis plan. Leverage industry tools (i.e. Databricks/SSMS/VS Code) to assess data quality and assist in resolving data quality problems Maintain Team’s playbook to document critical processes, achieving internal consistency and business continuity Validate and clean input data, ensure assumptions are correct, manage outliers appropriately, raise any questions or issues with the input data if any exist, 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

5+ 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
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 and Power BI
Proficiency in ETL processes/tools - Databricks
Strong SQL skills with experience developing complex queries and some Python
Bachelor’s degree in Statistics, Economics, Business Administration, Information Systems, MIS, Computer Science, Data Analytics, Information Technology, or a 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

Nice To Haves

Business analysis, consulting/advisory, and/or project or client management experience will be a strong plus
Exposure to SharePoint Power Applications 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

Responsibilities

Design, develop, and deploy BI solutions, including interactive dashboards in Tableau and tabular reports in SSRS, sourcing data from internal Azure Databricks schemas.
Develop, execute, and monitor moderate to complex data management / analytic processes to support ad hoc data and information delivery for assigned projects
Demonstrate ability to efficiently handle and deliver high-quality results for ad hoc requests with tight deadlines.
Translate business questions and hypotheses into a data analysis plan.
Leverage industry tools (i.e. Databricks/SSMS/VS Code) to assess data quality and assist in resolving data quality problems
Maintain Team’s playbook to document critical processes, achieving internal consistency and business continuity
Validate and clean input data, ensure assumptions are correct, manage outliers appropriately, raise any questions or issues with the input data if any exist, 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