WinnCompanies is looking for a Business Analytics Impact Systems Analyst to join our Corporate office in Boston, MA.
In this role, you will be responsible for automating reports from data acquisition through report development and delivery. Can also be responsible for complex components of large reporting platforms. Frequent client engagement with peers and managers is required as part of the day-to-day work. You will participate in client meetings to understand needs and occasionally is asked to contribute specialized knowledge. You will use proficient at tools and processes used to automate reports end to end. The selected candidate has good understanding of data gathering tools, proficient with business intelligence reporting tools such as Microsoft PowerBI. This role handles multiple priorities at once and requires strong communication skills. Also, requires demonstrating a strong leadership quality and consistently shows initiative.
Please note that this is a hybrid position with the following work schedule: Monday through Friday from 8:30AM to 5:30PM and 4 days in the office and one remote day.
Responsibilities
- Design and implement data schemas that align with Connected Communities Foundation (CCF) operational needs and workflows and facilitate efficient reporting for a variety of stakeholders including clients, community partners, funders, resident/community and investors.
- Work closely with CCF Program and Operations teams and stakeholders to understand workflow and reporting needs as they evolve, ensuring data architecture aligns with CCF’s strategic goals.
- Ensure architecture can scale with growing volume of data and reporting demands. Identify and implement system efficiencies to evolve user experience for both staff and residents (community surveys, automation and centralization of data intake, if/then workflows) to grow data capture from key operational touchpoints.
- Extract, clean, organize and design data flow from client property management platforms (RealPage, Yardi, MRI), 3rd party service provider platforms (AASC Online, Salesforce Family Metrics, FindHelp, Success Measures) and partner reporting platforms (Esusu, uAspire, Teledoc, etc.) to Winn data warehouse and CONNECT 360 with ETL (extract, transform, and load) processes.
- Transform and pair CONNECT 360 - generated data into a usable format for reporting.
- Cleanse and validate data during ETL process to maintain data accuracy, consistency and security. Ensure efficiency of ongoing SFTP process for new client adoption. Work closely with partners’ data teams to facilitate ongoing efficiencies in data integration.
- Maintain CONNECT 360 (Apricot 360) platform, serving as platform expert for team and partner support. Integrate new platform features and system capabilities as developed. Work closely with Program and Operations team members to develop and implement new use cases and subsequent workflows/ features as needed.
- Work with new clients to understand and implement their data and reporting needs. Implement data governance policies and practices to ensure ongoing security needs are met.
- Collaborate with CCF Program and Operations team, clients and partners to understand their storytelling needs and tailor visualizations of key performance indicators, workflows, and outcomes.
- Integrate visualizations into reports, presentations and other needed communication channels. Clearly articulate the insights derived from data visualizations, making information accessible to both technical and non-technical audiences.
- Create interactive dashboards and reports to effectively communicate complex impact insights to stakeholders. Consider end-user experience when designing visualizations to ensure clarity, ease of interpretation and engagement. Work toward standardization of reporting and visualization presentations across disparate client operations.
- Working with CCF Program and Operations staff, create client, stakeholder, and CCF board of directors’ outcomes reporting. Work in Microsoft PowerBI based on client needs to make data and evaluation visible, accessible in real-time, efficient and effective. Work with clients to facilitate direct social impact/KPI reporting to investors and stakeholders.
- Work toward direct integration of HUD, regulatory organization, Investor, and Funder reporting on a monthly, quarterly and annual basis, respectively.
- Participate in ongoing research conducted by clients, partners, and CCF, serving as a data and evaluation point of contact for CCF participation.
- Work to standardize user experience (staff, client, resident, partner) across disparate operating methods.
Requirements
- Bachelor’s degree.
- 3 - 5 years of related work experience.
- Advanced technical computer skills are required for technical support specific to functional area and related systems.
- Experience with computer systems, particularly Microsoft Office Suites.
- Outstanding verbal and written communication skills.
- Excellent customer service skills.
- Ability to manage multiple assignments and tasks.
- Knowledge of SQL and experience working with databases.
- Expertise in visualization libraries (e.g. Tableau, power BI, etc.)
- Proficiency in ETL processes.
- Advanced knowledge of Excel including advanced data modeling, creating interactive dashboard to optimize workflows and integrating excel with other data sources and software.
Preferred Qualifications
- Master's degree in a related field.
- Experience in impact measurement or social impact analytics.
- Knowledge of machine learning techniques and tools.
- Familiarity with cloud-based data platforms and tools.
#LI-BB1
Our Benefits:
Permanent full-time US employees are eligible to participate in the following benefits:
- Generous time off policies (including 11 paid holidays (12 for MA employees); Generous Accrued Time Off increasing with years of service; Generous paid sick time; Annual day of service; Floating Holiday)
- 401(k) plan options with a company match
- Various Comprehensive Medical, Dental, & Vision plan options
- Flexible Spending Account, Dependent Care Flexible Spending Account, Health Savings Account options with HSA annual employer contribution
- Long Term Disability and voluntary Short Term Disability; Basic Term Life Insurance and AD&D; optional supplemental life insurance
- Health Expense Reimbursement program (including gym memberships, equipment, and subscriptions)
- Tuition Reimbursement program and continuous training and development opportunities
- Wellbeing program (group challenges, seminars, opportunities to earn points to reduce medical premiums), Employee Assistance Program, & Commuter and Parking Reimbursement options
- Employee Corporate Discount Programs (Verizon Wireless, Home Depot Pro, Staples, and more!)
- Flexible and/or Hybrid schedules are available for certain roles
- Employee Relief Program supporting employees with unexpected hardships that place undue financial stress on them and their families
- To learn more, visit winnbenefits.com
Why WinnCompanies?
A job you can be proud of: WinnCompanies is a nationally recognized leader in apartment community management and development. Our team members are committed to helping people in the communities we serve and making a positive difference in their lives.
A job that challenges you: Our employees are responsible for our growth and success, and we challenge our team members to always be their best in our fast-paced, dynamic and rewarding workplace.
A job you can learn from: We offer multi-faceted leadership and learning opportunities to support our team members’ career growth and professional development.
A team that cares: We value teamwork, innovation, diversity and mutual respect. Through our recognition and rewards programs, we’re committed to celebrating and uplifting our team members.
About Us:
WinnCompanies is a mission-driven, national business focused on building and operating top quality affordable housing communities for individuals and families of all incomes, including members of the U.S. Armed Forces and their families. Our people are the source of our success – 4,300+ team members working together to create the best possible living communities in 27 states, Washington, D.C., and Puerto Rico.
Whether your skills are in operations, maintenance, leasing, compliance, marketing, IT, HR, accounting or finance, there’s a role for you at WinnCompanies. Your passion for excellence can help us make a positive impact in the lives of real people every day.
If you are a California Resident, please see our Notice of Collection here.
Salary will vary based on job responsibilities and scope, geographic location, candidate’s relevant experience, and other factors.
Current Winn employees should apply through this internal link.
Top Skills
What We Do
At WinnCompanies, we turn housing into homes. As a leader in property development and management, we’re creating a challenging, fast-paced workplace where teamwork, innovation and mutual respect are both valued and rewarded. We believe the relationships we build with each other are just as important as the work we do.
Explore your passion within one of our three business units – WinnDevelopment, WinnResidential and WinnMilitary. Operations, sales, compliance, maintenance, marketing, IT, HR, accounting and finance. No matter your expertise, your work will impact people who are more than just residents to us. They’re individuals, families and heroes.
Founded in 1971, we are committed to enhancing the lives of our communities. We fund college scholarships for residents; host community service and volunteer activities and more.
Come join our 3,800 team members in making a difference in your local community. With more than 600 sites in 23 states and D.C., there’s a place here for you to grow your career.