Business Intelligence Systems and Data Developer | Corporate Office
Camden Property Trust
Type: Full Time
Internal Number: 220817
Reporting to the Director of Business Solutions and functioning primarily within the Enterprise Analytics sub-Team within Business Solutions, you will be responsible for building-out Camden's Enterprise Analytics platform. As a BI Systems and Data Developer, you will implement the architectural data constructs from the strategic designs and models developed by the BI Systems and Data Specialist. This position will play a critical role in leveraging data as a strategic asset for Camden. Collaborating with the broader Camden Enterprise Analytics Team and other departmental Teams within Camden, this position translates the strategic use of data giving Camden competitive advantage among our REIT peers.
Collaborate with Stakeholders, formalizing requirements for data architectures hosting data of varying volume, velocity and granularity
Leverage data mining/data cleansing techniques to design and develop data integrations moving data from its Source of Truth to various consumer end points and finally its final destination the Camden Data Warehouse
Develop ad-hoc analysis and reports for special on-demand data requests
Consult with Business Stakeholders to identify data sources, required data elements and data validation
Implement best practices in data modeling, version control and test-driven development to develop database objects (i. e. tables, views, triggers, stored procedures, tabular and multi-dimensional data models, fact and dimension tables, etc.)
Develop templatized data analytics and visualizations shared throughout Camden, standardizing Camden's analytical User Experience
Anticipate data inconsistencies and analytical inaccuaracies by implementing and enforcing strict Master Data Management best practices
Troubleshoot in-place reporting solutions and engineers solutions or wholesale replacement of legacy reporting and analytics solutions using the intuitive tools minimizing or eliminating Stakeholder barriers
As a publicly traded company, we must be mindful of SOX governance. Adhering to all policies and procedures regarding computer usage, Change Management and Source Code Control, you are essential to ensuring data is accessible to ONLY the appropriate Teams within Camden
Be a liason between IT and other Camden departments. Keeping your Management Team and Stakeholders informed of all issues, you will ensure each is addressed and resolved within given Service Level Agreements (SLA's).
Bachelor's degree required, preferably in Computer Science, Data Science/Analytics, or related discipline
3 -5 years or more of experience in Data Analytics or Business Intelligence roles
Proficiency with Power BI (DAX), Microsoft Excel, SQL, SSRS, SSIS and SSAS (MDX)
Excellent listening, communication and presentation skills
Excellent time management skills and the ability to work on multiple projects simultaneously
Strong attention to detail, accuracy, and organization skills
Proficiency in Microsoft Office Suite
Experience working within Office 365 (MS Teams, OneDrive, Power Apps, Power Automate, etc.) is preferred
Multifamily housing /commercial real estate experience is preferred
And here's the fine print HR wants you to know:
Job is intermittently sedentary but requires mobility (i.e., climb stairs)
Will use some repetitive motion of hand-wrist in using computer and writing
Works in a typical office setting
Emotional stability and personal maturity are important attributes in this position
Must handle stressful, urgent, novel and diverse work situations on a daily basis
May require long hours and odd schedules (including weekends)
Position requires periodic travel by automobile to handle work-related activities
May require airline travel, out-of-town and /or overnight trips
Attendance and punctuality is essential for success in this position
Hazards can be minimized with proper lifting techniques, SDS, general safety training, and wearing appropriate PPE
Contact your HR team for the position's Physical Demands Analysis
This job description is not an all-inclusive list of duties and responsibilities. Camden may add or change responsibilities in order to meet business and organizational needs. Employees must meet qualification standards that are job-related and consistent with business necessity and must be able to perform the essential functions of the position, with or without reasonable accommodations.
Camden Property Trust is one of the largest publicly traded multifamily companies in the U.S. Operating as a Real Estate Investment Trust (REIT), we own, develop, acquire, sell and manage apartment communities in 15 major markets. Camden has more than 1,800 employees across the country and is headquartered in Houston, Texas.
Camden has been recognized by FORTUNE® Magazine as one of the "100 Best Companies to Work For" in the country! We are the only multifamily company to ever be included on FORTUNE's famous list. We are committed to the growth and success of everyone we work with, which is the foundation for building focused, effective teams and creating an exciting and impactful work environment. Our shared values (including our commitment to fun!) make Camden an industry-leader and one of the nation’s best employers.