Data Analyst: Insights & Dashboards (SQL/Python)

CBRE; Madison (WI); On-site; USD 90,000 - 105,000; Full time

Benefits offered by this job

401(K)

Dental insurance

Health insurance

Life insurance

Vision insurance

Job summary

CBRE Data Analyst role located in the Madison area requires performing basic data analysis to support business conclusions with thorough data research. The role is part of Data Science & Analytics and involves building dashboards, data models, and reporting systems to drive insights.

You will use SQL and Python to pull data from multiple sources, develop insights, and present a clear data story to stakeholders while collaborating with the agile development team.

Qualifications

• Bachelor’s degree in computer science, Information Systems, or a related field with up to 1-4 years of relevant experience.
• In-depth experience with SQL, data visualization tools, ETL pipelines, and database management systems.
• Strong programming skills, with experience in Python, utilizing it for data analysis and evaluation tasks.
• Ability to use existing procedures to solve standard problems.
• Experience with analyzing information and standard practices to make judgments.
• Organizational skills with a strong inquisitive mindset.

Responsibilities

• Use SQL and other scripting languages to develop and maintain complex queries that pull and curate data from multiple sources.
• Develop and maintain data dashboards and associated assets including scripts, tables, workflows, and supporting processes in accordance with team standards.
• Apply fundamental data structures and algorithms to solve complex problems.
• Define basic data requirements and gather information using judgment and statistical tests.
• Use programming and evaluation tools (e.g. Python), including open-source programs to plan models and extract insights.
• Apply modeling and optimization methods to improve business performance.
• Develop and maintain data models, data automation systems, low-code solutions, and reporting systems and performance metrics support.
• Develop ad-hoc reporting based on the review of existing data sources.
• Exhibit rigor, judgment, and ability to present a detailed 'data story' to a business line.
• Confirm the quality and integrity of existing data sources.
• Collaborate with the agile development team to provide recommendations and communications on enhancing existing or new processes and programs.

Skills

SQL

Python

Data analysis

ETL pipelines

Database management

Education

Bachelor's degree in computer science or Information Systems

Tools

Data visualization tools

Job description

CBRE Data Analyst role located in the Madison area requires performing basic data analysis to support business conclusions with thorough data research. The role is part of Data Science & Analytics and involves building dashboards, data models, and reporting systems to drive insights.

You will use SQL and Python to pull data from multiple sources, develop insights, and present a clear data story to stakeholders while collaborating with the agile development team.