Lead Business Intelligence Developer
Open the door to your dream job and join #TeamMainStreet. With more than 22,000 homes in 30 markets, Main Street Renewal is one of the largest providers of single-family rental homes across the country. We understand that our employees are the invaluable drivers of our success. That's why we hire the most talented, passionate individuals who enjoy contributing to a growing, winning team. Here, you'll be a part of a fast-growing company dedicated to providing a best in class leasing and customer service experience to our residents.
Amherst is revolutionizing the way U.S. real estate is priced, managed and financed in order to unlock opportunities for all market participants. Driven by data, analytics, and technology, Amherst has a 20-year history of anticipating where the next risks and opportunities are likely to emerge and designing actionable strategies for investors to capitalize on opportunities across residential real estate, commercial real estate and public securities. Amherst, along with its affiliates and subsidiaries, has more than 900 employees, $5 billion under management and approximately $15 billion under advisement and oversight. www.amherst.com.
The Data Analytics & Visualization team within the Amherst Technology Group empowers its business partners to make better decisions through real-time, data-driven insights and strategic recommendations. We are looking for a Lead Business Intelligence Developer to provide analytics support to the Amherst Capital Management, Asset Management, and Investor Relations teams. This role will have 2-3 direct reports and will report to the Head of Data Analytics & Visualization within the Amherst Technology Group.
Responsibilities:
Collaborate directly with peers and business leaders in developing descriptive, diagnostic, predictive, and prescriptive analytics solutions
Tackle complex business problems by converting raw data into meaningful and actionable business insights.
Utilize Microsoft SQL Server for extraction and analysis of data from multiple sources with demonstrated ability to effectively decipher, analyze and report data
Develop reports and dashboards using Tableau or other tools for internal and external customers
Leverage analytic problem-solving skills in working with large disparate, datasets to report portfolio operational metrics and performance
Present findings and recommendations to business leadership
Assist with preparation and automation of recurring /ad-hoc reporting assignments
Lead junior business intelligence analysts and data analysts
Required Experience:
Bachelor’s degree in Management Information Systems, Finance, Mathematics, Economics, Computer Science, Engineering or related quantitative discipline; or equivalent work experience
4-7 years experience analyzing data, drawing conclusions, and making recommendations; consulting or financial services industry experience is a plus
Strong SQL query writing and optimization skills required. Experience working in a Microsoft SQL Server environment is preferred.
Prior experience as a team lead or prior supervisory experience preferred
Experience with creating and presenting management dashboards and reports
Experience with data visualization and business intelligence tools such as Tableau, WebFOCUS, TIBCO Spotfire, Qlikview, Microstrategy. Experience with Tableau is preferred.
Strong Microsoft Excel skills
Knowledge of at least one other data analytics programming language such as Python or R. Experience with Python and analytics libraries such as Pandas, NumPy, Matplotlib etc. is preferred.
Ability to be flexible and work in a fast-paced environment while meeting established timelines
Excellent written and verbal communication
Analytical mindset and passion for gleaning actionable insights from raw data
Strong team player
Strong communication skills, with an ability to express relevant, technical concepts in a clear and concise manner
Ability to see the big picture and effectively analyze complex issues
Strong technical ability, willingness to learn and evolve your skills with advances in Technology
Nice-to-have experience:
Bonus points for experience with data architecture, data modeling, and/or data governance initiatives
Knowledge of data warehousing and ETL concepts
Experience with Big Data technologies such as Hadoop and Hive
Familiarity with agile project management
Knowledge of advanced data science concepts such as machine learning and AI
Our full-time employee benefits include:
- A competitive compensation package, annual bonus, 401k match
- Flexible PTO including 7 paid holidays, 1 floating holiday, and 1 volunteer day
- Employer-paid benefits (medical, dental, vision, health savings account)
- Professional career development and reimbursement
- Up to 16 weeks paid maternity leave; up to 4 weeks of paid parental leave
- Backup childcare offered through Bright Horizons
- Relaxed casual environment with virtual office events
Main Street Renewal is proud to be an Equal Opportunity Employer and committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, national origin, gender, pregnancy, sexual orientation, gender identity, age, physical or mental disability, genetic information or veteran status, and encourage all applicants to apply.