Hi there, welcome to Hana. Backed by CBRE's decades of real estate experience, we're leading the way in creating spaces where companies and individuals, like yourself, can collaborate and thrive. We're building a world-class product and team that is redefining the flexible work space and beyond. At Hana, we focus on the details that drive success – a professional environment, thoughtful designs and courteous service – just to name a few. We believe in fostering a culture that drives accomplishment through adaptability, professionalism and thoughtfulness. And, we like to have a bit of fun too. If you are a detail-oriented, curious, self-starter interested in joining a fun and fast-paced team, we hope you will apply.
Maintains data storage and access by designing physical databases. Confirms project requirements by studying user requirements; conferring with others on project team. Maintains data dictionary by revising and entering definitions.
Maintains client confidence and protects operations by keeping information confidential.
Maintains technical knowledge by attending educational workshops; reviewing publications; establishing personal networks; in technical societies.
Ensures operation of equipment by completing preventive maintenance requirements; following manufacturer's instructions; troubleshooting malfunctions; calling for repairs; evaluating new equipment and techniques.
Contributes to team effort by accomplishing related results as needed. Determines changes in physical database by studying project requirements; identifying database characteristics, such as location, amount of space, and access method.
Changes database system by coding database descriptions. Protects database by developing access system; specifying user level of access.
Maintains user reference by writing and rewriting database descriptions.
Interpret and analyze data from various source systems to support data integration and data reporting needs within CBRE HANA
Identify, analyze, and interpret trends or patterns in complex data sets
Work with team leads to prioritize business and information needs
Prepare high-level ETL mapping specifications.
Develop complex code data scripts (Primarily SQL) for ETL
Troubleshoot & determine best resolution for data issues and anomalies
Manage exploratory data analysis to support database and dashboard development, as well as advanced analytics efforts
Established leadership experience in large organizations comparable to CBRE HANA Proven ability to effect organizational change.
Possesses expertise across multiple architecture domains, forward- thinking, and well-versed in emerging technologies and trends.
Have a strong, pragmatic approach to leading architecture and development solutions, with a proven record in technology planning and delivery
Ability to prioritize and co-ordinate tasks efficiently ensuring all deadlines are met.
Experience of managing product delivery is desirable
Excellent interpersonal skills across all levels of the organization
8-10 years of broad experience in the information technology to include business architecture, information architecture & strategy, IT strategic planning in a large global corporation.
At least 3 years in an architectural or design capacity for 'large scale' enterprise systems.
Must possess strong organizational, facilitation and critical thinking abilities, to assess complex problems, analyze options, navigate diverse perspectives and objectives and develop acceptable Enterprise application and governance solutions.
Strong business acumen and successful track record in aligning diverse groups and opinions.
Bachelor's degree in Computer Science or related area, or equivalent work experience.
Technical certifications (e.g. AWS) desirable
Technical Skills Required:
Advanced SQL skills - Adept at queries (SQL, PL/SQL/ PostGres SQL), Shell Scripting, report writing and presenting findings
Expertise in Data Extraction, Transformation, Loading, Data Analysis, Data Profiling, and SQL Tuning
Metadata management, Conceptual and Logical Data Modelling, Dimensional Modelling
Experience in Golang, Docker, Postgres, Mesos, Git ), AWS cloud technologies, Agile methodologies and DevOps is a big plus.
Expertise in translating business requirements to project design, development, and execution
Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
Ability to clearly communicate capabilities, opportunities, and recommendations to both technical and nontechnical audiences
Strong knowledge and experience with reporting, databases and database programming ( SQL)
Experience in understanding the source data from various platforms and mapping them into Entity relationship model(ER) for data integration and reporting.
Has deep understanding of data architecture & data modeling best practices and guidelines for different data and analytic platforms.
CBRE Hana, LLC is a wholly-owned subsidiary of CBRE Group, Inc., the world's largest commercial real estate services and investment firm (based on 2017 revenue). Hana partners with real estate owners to develop and operate integrated, scalable, flexible workspaces. Each unit contains office suites (Hana Team), conference rooms and event space (Hana Meet) and co-working (Hana Share). Hana provides property owners increased transparency, control over their asset environment, and a valuable offering for companies that desire to maintain their culture and brand while leveraging the benefits of a flexible space offering. More information is available at www.hanaspaces.com .
Internal Number: 19011482
With broader and deeper capabilities than any other company, CBRE is the leading full-service real estate services and investment organization in the world.
CBRE Group, Inc. is the world’s largest commercial real estate services and investment firm, with 2017 revenues of $14.2 billion and more than 80,000 employees (excluding affiliate offices). CBRE has been included in the Fortune 500 since 2008, ranking #214 in 2017. It also has been voted the industry’s top brand by the Lipsey Company for 17 consecutive years, and has been named one of Fortune’s “Most Admired Companies” in the real estate sector for six years in a row. Its shares trade on the New York Stock Exchange under the symbol “CBRE.”
CBRE offers a broad range of integrated services, including facilities, transaction and project management; property management; investment management; appraisal and valuation; property leasing; strategic consulting; property sales; mortgage services and development services.