
BI Developer, SQL, Power BI
Posted 5 days ago

Posted 5 days ago
This is a fully remote position, open to applicants in Texas.
• Create reusable Power BI reports utilizing standardized, white-label templates along with configurations tailored to clients.
• Design and develop Power BI reports and semantic models.
• Produce custom visuals and client-specific KPIs, while identifying patterns that are suitable for productization.
• Write SQL queries for BigQuery, Snowflake, and Azure SQL.
• Construct star-schema models using data sourced from Yardi, MRI, VTS, Chatham, Argus, RealPage, and client submissions.
• Develop DAX expressions for budget vs. actual, T-12, and year-over-year calculations.
• Oversee DEV, UAT, and PROD Power BI Service workspaces within an embedded environment.
• Manage deployment pipelines, row-level security, refresh schedules, capacity, and performance optimization.
• Assist clients in utilizing templates within their own tenant.
• Maintain reports as PBIP files in GitHub, adhering to peer review and naming conventions.
• Employ AI coding assistants for modifications, testing, and documentation.
• Participate in requirements sessions, present dashboards, support UAT, and address data validation inquiries.
• Validate data discrepancies such as GL mapping issues, missing lease dates, and occupancy exceeding 100%.
• Track progress using Monday.com and JIRA.
• Manage Client Success escalations and contribute to user guides, demonstrations, and release testing.
• 3 to 5 years of experience in BI development or analytics engineering, preferably within real estate, prop-tech, or financial services.
• A portfolio of dashboards available for review.
• Bachelor’s degree in a relevant field or equivalent professional experience.
• Ability to handle confidential client financial information discreetly.
• Over 3 years of BI development experience with Power BI as the primary tool.
• Proficiency in advanced DAX, Power Query (M), and dimensional modeling.
• Strong SQL skills, including CTEs, window functions, and performance optimization techniques.
• Experience with Power BI Service, including workspaces, deployment pipelines, row-level security, and refresh processes.
• At least 2 years of experience with real estate data and metrics, such as rent roll, NOI, occupancy, leasing, capex, and budget vs. actual.
• Comfortable facilitating client working sessions and explaining metric logic to executives.
• A product-oriented mindset and a habit of validating data first.
• Hands-on experience with Yardi, MRI, RealPage, VTS, or Argus data and GL/chart of accounts mapping is a plus.
• Familiarity with Power BI Embedded or multi-tenant delivery; experience with PBIP, Git, and CI is advantageous.
• Knowledge of Snowflake, BigQuery, dbt, or Python is beneficial.
• PL-300 or DP-600 certification is a plus.
• Experience in B2B SaaS client delivery or implementation is an added advantage.
• Health, dental, and vision insurance.
• Retirement savings plan with a company match.
• Paid time off and holidays.
• Opportunities for professional development.
• Performance-based bonuses determined by position.
• Additional rewards, including an annual bonus and sales incentives, based on the applicable plan, role, and individual performance.
ASRC Federal
HR POD - Hiring Talent Globally
Cooperdyne Tech
TransPerfect
Get handpicked remote jobs straight to your inbox weekly.