Senior Business Intelligence Analyst

POSITION SUMMARY:
Responsible for the design, development and maintenance of key business reports. Administers all aspects of the business intelligence and reporting infrastructure.

ESSENTIAL FUNCTIONS:
1. Collaborates with core business team and departmental leadership to define KPIs, develop and maintain dashboards, reports, and data visualizations on new and existing report solutions using business intelligence and data reporting tools. (Power BI, SSRS) (30%)
2. Works with team senior leaders to gather analyze and interpret data from multiple data sources to identify trends in corporate data and opportunities for the business. (25%)
3. Administers all aspects of the business intelligence hardware/software platforms, including upgrade strategies, environment management, disaster recovery/business continuity, and universe design. (25%)
4. Fulfills time-critical ad hoc requests and participates in on-going report administration, maintenance, trouble shooting, tuning, and business user support. (10%)
5. Leads efforts to define and document department reporting solutions. (10%)

Secondary Responsibilities:

• Maintains knowledge of industry trends, reporting concepts and best practices.
• Communicates with customers to stay abreast of industry or business trends.
• Maintains technical documentation and catalog of all reports.
• Conducts training on the use of new reports as required.
• Supports internal/external audit requests regarding the reporting environments.
• Perform other job-related duties as assigned.

Experience:

• 5-8 years of professional experience in an analytical position involving data management and modeling across multiple systems.
• Hands-on report and dashboard development experience using Power BI and SSRS reporting technology.
• Must possess strong knowledge of relational databases concepts, as well as strong SQL skills in complex query development.
• Ability to translate complex business requirements into detailed functional and/or technical requirements.
• Demonstrated ability to work both independently and collaboratively with others in a team environment.
• Ability to address complex problems and recommend the best solution to the business community.
• Must be able to meet with customers to gather, document and analyze report specifications and requirements.

Core Competencies (Other Requirements):

• Demonstrated proficiency in analytical thinking, strong problem-solving skills, and understanding of database concepts
• Excellent customer service, written and oral communication skills.
• Dashboard design and reporting architecture concepts
• Ability to multi-task and prioritize concurrent assignments.
• Experience in the commercial, retail, industrial and/or multi-family real estate industry preferred.
• Experience with Yardi Voyager, Yardi Elevate Modules and Yardi Spreadsheet Reporting a plus.
• Knowledge of Microsoft Fabric platform a plus

Qualifications

• Bachelor’s degree in Data Science, Business, or related field.
• Proficiency in SQL, Excel, and BI tools.
• Strong analytical and communication skills.
• Experience with data visualization and reporting.

All employee are subject to a pre-employment screening process including a background check and drug screen. 

Pay Range: $110,000 - $135,000

CDP proudly offers to all employees working a minimum of 30 hours per week market-leading health benefits including medical, dental, vision and prescription, etc.