IT Data Engineer

Company Overview

Berkshire Residential Investments is a people-first real estate investment company who values not only the impact we make as a company, but the time we spend together in our high-performing teams. We value individual skills and perspectives to allow us to best serve our employees, investors, residents, and other stakeholders.

If you’re interested in a workplace where everyone feels empowered to bring their full, authentic selves to work each day, come join our talented and growing team at Berkshire Residential Investments. Our environment of entrepreneurial spirit, culture of expertise and our people-first approach will allow you to thrive while continuing to grow in your career.

Position Summary

The IT Data Engineer will support Berkshire's data analytics initiatives working collaboratively across departments to provide solutions for a broad range of data projects including assisting with the implementation of a cloud-based data warehouse.

After the data warehouse is operational, the IT Data Engineer will work to expand the data engineering focus with programming skills for use in Berkshire’s data aggregation initiatives. This will involve building pipelines from internal and external sources, setting up centralized storage structures, and managing the warehouse and related databases.

ESSENTIAL FUNCTIONS:

Support the advancement of Berkshire’s data strategy by assisting with the design and construction of a modern technology stack to accommodate the business intelligence and reporting needs of the business. The IT Data Engineer will focus on the following core areas:

• Data Engineering
  • Design and construction of cloud data warehouse solution
    • Build out of data lake in Azure
    • Construct data pipelines
    • Design and management of cloud data warehouse
    • Assist in constructing end-to-end data solutions including automating data feeds, building ETLs, preparing data sets, and maintaining responsibility for data quality assurance and governance.
    • Establish best practices for engineering and data analysis.
  • Automation of data pipelines
    • Evaluate tools to facilitate data prep and automation.
    • Implement scheduled feeds and data connections to improve data logistics (e.g., setup of APIs and in-app scheduling abilities)
    • Develop workflows to orchestrate and automate processes.
• Business Intelligence
  • Translate business requirements into analytic products.
  • Assist with the build-out of foundational level business intelligence capabilities.
  • Partner with business users to design and build data visualizations.
  • Construct end-to-end solutions in Power BI
    • Cleanse and transform data into Power BI data sets.
    • Model relational data sets and construct DAX measures
    • Design dashboard visualizations
  • Aid with advanced Excel solutions for business users including Power Query and VBA
  • Assist team members across the organization with the utilization of existing business products in connection with data analytics initiatives.
• IT Team Support
  • Maintain systems and data.
  • Participate in tasks and projects to support the IT team, as needed.
  • Create custom reports in SQL.
• Other
  • Support current advanced Excel solutions as needed.
  • Assist with additional projects as assigned by Data Analytics Manager, AVP, Information Technology and SVP, Chief IT Officer

JOB QUALIFICATIONS AND REQUIREMENTS:

Knowledge/Experience/Education:

• 3+ years of professional experience in an analytical or data analysis role preferred, with experience maintaining data warehouses.
• Bachelors in computer science or an equivalent major required, Master’s preferred
• An understanding of U.S. real estate metrics and financial modeling is a plus.
• Flexible and willing to learn new technologies.

Technology:

• Requires experience designing and managing analytics solutions based on a cloud data warehouse (Snowflake/MS Synapse Analytics)
• Requires knowledge of Amazon Web Services and Microsoft Azure
• Requires experience with relevant coding languages (SQL, Python, Java, Spark, Scala) for reporting, data ingestion, and automation
• Requires experience with MS Azure Storage
• Requires experience with data warehouse internals and integration with other related technologies for data processing, management, and reporting
• Requires experience with API development
• Requires strong Power BI skills including Power Query, data modeling, DAX, and visual reporting
• Requires advanced Excel functions including PowerQuery, VBA, Power Pivot
• Experience with R/Python for statistical analysis is a plus.
• Experience with Yardi is a plus.

Project management:

• Reliable, self-motivated, and self-disciplined individual, capable of executing multiple projects simultaneously.
• Able to think logically, organize workflows efficiently, and solve problems independently.

Other:

• Aptitude for organizing, prioritizing, and managing multiple priorities, using critical thinking and problem solving.
• Demonstrated multi-modal communication style that reaches every stakeholder, specifically excellent verbal, and written communication.
• Ability to communicate with and manage up to senior management.
• Collaborative working style with inclusive work and thinking behaviors, commitment to excellence in teams and work product, with a strong work ethic.
• Proficiency and willingness to adopt new systems and processes.
• Demonstrate emotional intelligence in high pressure and sensitive situations.
• Demonstrated ability to make independent decisions and apply critical thinking on business matters when appropriate.
• Tenacity, patience, and perseverance to work with business deals from beginning to the end of the process.
• Represent the Berkshire employment brand well to candidates by seeking to understand the capabilities and insights of people with unique backgrounds, cultures, styles, and abilities.
• Maintain confidentiality of sensitive information and communications of information
• Develop productive working relationships with all team members including JV partners, property managers, project managers, and third parties.
• Demonstrated high level of ethics and integrity with a straightforward and honest approach.

Physical Requirements: (amount of standing, walking, sitting, typing, lifting etc.)

• Must adhere to Berkshire’s attendance and hybrid policy.
• Must be able to remain in a stationary position 50% of the time.

Vision Requirements: (visual needs for the position – color, small details, inspections etc.)

• Ability to observe details at close range, complete forms, read and review reports both paper and electronic.

Hearing Requirements: (hearing needs for the position –telephone, meetings, etc.)

• Ability to communicate information and ideas coherently using the telephone, remote/virtual meeting technology, and face to face interaction.
• Must be able to exchange accurate information in these situations.

Speaking Requirements: (clarity, customer interaction, presentations, etc.)

• Must be able to exchange accurate information during interactions with staff, colleagues, management, and clients.

Driving/Travel Requirements: (driving needs for the position from property to property, travel, etc.)

• Must have a valid driver’s license and auto insurance if renting a car.
• Must be able to travel independently.

Reasoning Requirements: (low, medium, or high for ability to apply logical thinking to defined problem solving)

• Must be able to use independent judgment and prioritize based on urgency.

Working Environment: (indoors, outdoors, special things to know about job)

• Must be able to tolerate distractions, multi-task, and work with interruptions while still meeting internal deadlines.

The Company may revise this job description from time to time as business needs require. It is not intended to be an exhaustive listing of all the functions of the job, nor is to limit the Company right to assign other functions to an employee in this position. This job description does not constitute a written or implied contract of employment.

Berkshire is proud to be an Equal Opportunity Employer. We do not discriminate on the basis of race, color, ancestry, national origin, religion or religious creed, mental or physical disability, genetic information, sex (including pregnancy, childbirth and related medical conditions), sexual orientation, gender identity, gender expression, age, marital status, military or veteran status, citizenship, or other characteristics protected by state or federal law or local ordinance We strive to create a workplace where everyone feels empowered to bring their full, authentic selves to work every day. Berkshire's Equal Employment Opportunity Policy encourages the commitment of every Supervisor. All employees are expected to participate in and actively support these efforts