About the Client:
Veritas Investments Inc. is a technology-enabled real estate investment and management company that specializes in sustainably operating mixed-use multifamily properties in major West Coast markets.
Veritas leverages technology to offer a superior rental living experience to a frequently overlooked population: residents in small- to medium-size buildings. With innovation at the core of our resident experience and operating platform Veritas s tech-inspired management platform reinvents how classic apartments are designed leased and managed.
Job Responsibilities:
- Understand business requirements and design a data model to transform raw data into meaningful insights.
- Build data transformations using SQL Server integration services (SSIS).
- Design and develop SQL Server stored procedures functions triggers and views to be used during ETL process.
- Documentation of solutions (e.g. data models configurations and setup).
- Data warehouse development and working with SSIS and SSRS reporting.
- Convert business requirements into technical specifications and implement them through reports that support decision-making.
- Analyzing the current ETL process defining and designing new systems
- Use Power BI and SSRS to create dashboards interactive visual reports.
- Collaborate with users and team members at various levels for suggestions and improvement.
Requirements
- At least 5 years of experience in data-related roles
- Experience in BI tools and systems such as Power BI (desired) SSRS etc.
- Knowledge of Microsoft BI Stac
- Familiarity with Data Analysis
- Competent in developing SSIS-based integrations with external data sources via APIs (RESTful SOAP JSON GraphQL etc.) and CSV/flat file downloads.
- Familiarity with Salesforce data integration approaches is desired.
- Familiarity with Yardi is a plus.
Benefits
WHAT WE OFFER:
Great Place to Work-Certified Company
Premium HMO
Holistic employee experience
Work-from-home and hybrid work setup
Rewards and incentives
Monthly engagement activities
Career advancement opportunities
Paid referral program
Experience in BI tools and systems such as Power BI , SSRS, etc. Knowledge of Microsoft BI Stac Familiarity with Data Analysis SSIS-based integrations with external data sources, via APIs (RESTful, SOAP, JSON, GraphQL, etc.) and CSV/flat file downloads. Salesforce data integration Familiarity with Yardi is a plus.