Business Intelligence Developer

Overview:

Our BI team is growing and looking for a Business Intelligence Developer. We’re looking to hire someone to design and build effective and scalable Business Intelligence solutions, including Operational Reports, Data Visualizations, Dashboards, and ETL/Data Integration solutions. In this role, you will work among a collaborative team and support data-driven decision-making across the entire business. You’ll primarily leverage Power BI, SQL, and SSIS.

AMLI Residential was founded in 1980 as private real estate development, management, and investment company. We are a leader in sustainable LEED and ENERGY STAR Certified luxury apartment communities. In February 2006, AMLI became a private company again through a $2. 1 billion transaction with the PRIME Property Fund, a core commingled institutional fund managed by Morgan Stanley.

Hybrid office schedule: 3 days home and 2 days office. Our office is conveniently located in downtown Chicago, close to all public transportation.

Essential Functions of the Job:

• Design, develop, and maintain business intelligence solutions, including data warehousing, data integration, and reporting solutions.
• Work with business stakeholders to design and build visual reports and dashboards using modern Business Intelligence tools like Power BI.
• Works with a team to maintain and enhance the existing companywide BI Platform.
• Create and maintain the logical and physical data model for the Reporting and BI Platforms.
• Work with business users to continuously improve existing dashboards, reports, and datasets.
• Able to properly understand the business requirements and develop data models accordingly by taking care of the resources
• Develop and maintain ETL processes to ensure data accuracy and reliability.
• Develop processes and procedures to migrate data from third-party systems to the primary BI environment.

QUALIFICATIONS:

• College degree required; Information Technology or Business degree preferred.
• 4+ years of experience with SQL Server BI platform (Power BI and SSIS).
• Strong data warehousing process design, development, source control & performance tuning skills.
• Expert understanding of T-SQL, SSIS, Power BI, and DAX is required. Strong working knowledge of SQL and OLAP databases.
• Highly proficient in Microsoft Office applications.
• Experience with Azure DevOps is a plus.
• Excellent written and verbal communication skills
• Experience in multi-family real estate is a plus.

Thank you for your interest in a career at AMLI. Due to the volume of applications, not all applicants may be contacted. Please note that we may consider your resume for other positions as they become available. AMLI is an equal employment opportunity employer that encourages personal and professional growth. We are committed to fostering a diverse and representative workforce.