Senior Data Warehouse Engineer

B. F. Saul Company; Bethesda (MD); On-site; USD 120,000 - 140,000; Full time

Job summary

Join a leading real estate investment management firm as a Senior Data Warehouse Manager. This role offers an exciting opportunity to oversee the management and optimization of data warehouses, ensuring accurate reporting and data integration for core business functions. Collaborate with various teams to address data challenges, develop innovative solutions, and leverage modern technologies like AI. Enjoy a supportive work environment that values collaboration and offers competitive benefits, including health insurance, a 401(k) plan, and tuition reimbursement. If you're passionate about data and real estate, this is the perfect opportunity for you.

Benefits

Health/Medical Insurance

401(k) with company match

Paid time off

Bonus/Target Incentive

Tuition Reimbursement

Fitness center access

Dining center discounts

Employee Recognition Programs

Referral bonus

Pre-tax transportation options

Qualifications

• 5+ years of experience in data management and analytics.
• Expertise in SQL Server and Python for data integration.

Responsibilities

• Manage and optimize SQL Server data warehouse for reporting.
• Develop reports and visualizations for business teams.

Skills

Data Modeling

SQL Server

Python

Excel

PowerPoint

Tableau

Education

Bachelor of Science in Finance

Bachelor of Science in Computer Science

Bachelor of Science in Analytics

Tools

SQL Server

Tableau

Job description

Company Overview:

ASB Real Estate Investments, a division of ASB Capital Management LLC, is a leading U.S. real estate investment management firm with $10 billion in gross assets under management from over 310 institutional clients. Headquartered in the Washington, D.C. area, ASB invests in major markets across the United States, concentrating in industrial, multifamily, office, retail, and self-storage properties.

ASB has built success around talented, hard-working individuals who collaborate to gain a broad and integrated understanding of real estate disciplines to deliver attractive risk-adjusted returns. We encourage a culture of collaboration, and all members of our team engage in offering their points of view on major decisions in an extremely inclusive management process.

Job Purpose/Summary:

ASB Capital Management is one of the largest institutional investment management firms. This position has a deep domain knowledge in real estate private equity and will oversee day-to-day responsibilities on managing, maintaining, and reporting on our internal data warehouse that centralizes core business data, such as leasing, appraisals, financials, receivables, performance, and debt.

Summary of Competitive Benefits & Perks:

• Health/Medical Insurance including Dental and Vision
• 401(k) with company match
• Paid time off
• Bonus/Target Incentive
• Tuition Reimbursement
• Complimentary usage of modern in-house fitness center
• On-premise full-service dining center discounts
• Discounts via the company’s EAP
• Monthly Employee Recognition Programs
• Referral bonus
• Pre-tax transportation options
• Plus more!

Essential Job Functions of the Senior Data Warehouse Manager:

• Senior Data Warehouse Engineer will manage, maintain, and optimize on-premises SQL Server data warehouse for core business reporting.
• Manage monthly and quarterly business processes to generate and deliver timely and accurate reporting.
• Senior Data Warehouse Engineer develops reports, analyses, visualizations, integrations, and automation processes for business teams.
• Collaborate with business teams to understand data-related pain points and develop high-quality solutions.
• Build frameworks, workflows, and tools that create efficiencies for the Data and Analytics team.
• Achieve mastery of commercial real estate concepts and calculations, regarding leasing, financial accounting, appraisals, valuation, forecasting, budgeting, debt, derivatives and returns.
• Communicate technical concepts clearly and concisely to non-technical counterparts.
• Senior Data Warehouse Engineer will assist with non-technical tasks that support the mission of the Data and Analytics team and/or the firm.
• Research and advise on use cases for modern technologies, such as AI and cloud computing.

• Working Conditions/Physical Requirements

This position is based in an office environment with prolonged periods of sitting at a desk and working on a computer

Required Skills and Abilities of the Senior Data Warehouse Manager:

• Experience with data modeling for long-term commercial leases
• Building integrations with property management and appraisal systems
• Building financial statements from general ledger data

Required Education / Experience of the Senior Data Warehouse Manager:

• Bachelors of Science in Finance, Computer Science, or Analytics
• 5+ years of experience
• SQL Server
• Python (or VBA)
• Excel/ PowerPoint
• Tableau

Core Company Competencies:

• Perseverance
• Focus
• Accountability
• Empathy
• Social Responsibility

Core Job Competencies:

• Communication - Interact with employees at many levels of the organization and must have the ability to express ideas and information orally and in writing keeping in mind the intended audience.
• AnalysisSkills - Can be counted on to gather, understand, and process information that is critical to the organization’s operations.
• Planning & Organization - Accomplishing specific goal(s) while managing time and resources to meet deadlines and expectations.
• Attention to Detail - Focus on all areas of a project and paying close attention to all aspects of it.

$120,000 - $140,000 a year

The actual base pay offered is determined by several variables, including, as appropriate, the applicant's qualifications for the position, years of relevant experience, distinctive skills, level of education attained, certifications or other professional licenses held. Base pay is one component of ASB Investment Management's total compensation package, which also includes access to or eligibility for healthcare benefits, a 401(k) plan, short-term and long-term disability coverage, basic life insurance, bonus plans and more.

ASB Real Estate Investments is proud to be an equal opportunity workplace. We foster an environment that recognizes employees’ unique skillsets and ensure that all employees have an equal opportunity to grow and advance.

If you are a candidate in need of assistance or an accommodation in the application process, please [e-mail] 301-986-6000.

Equal Opportunity Employer/Veterans/Disabled