Senior Business Intelligence (BI) Developer with Experience with Commercial / Investment Real Estate

OverviewWe are seeking a skilled and detail-oriented Business Intelligence Developer to join our dynamic team. In this role, you will be responsible for designing, developing, and maintaining business intelligence solutions that facilitate data-driven decision-making across the organization. You will work closely with stakeholders to understand their data needs and translate them into actionable insights through effective reporting and analytics.itle: Senior Business Intelligence (BI) developer
Location: San Antonio, TX (Complete onsite)
Duration: 12 months contract
Must have: Experience with Commercial / Investment Real Estate tools such as Yardi, MRI, Argus, Juniper Square and VTS. Strong experience with SQL, SSRS & PowerBI. Experience in VBA, Python and/or Pyspark programming languages. Power Query, DAX, Git, Agile & SDLC…
Job Description
As the Senior Business Intelligence (BI) developer, you will be instrumental in creating a variety of reports based on our Azure Synapse Data Warehouse and additional data sources. You will enhance and maintain our enterprise data and analytics environment by collaborating with business users to gather their requests, understand their requirements, and develop meaningful reports and dashboards. Working alongside other team members, you will advocate for standardization and consistency within data models. Your expertise in SQL, M, Power Query, and DAX will ensure that you can develop both interactive Power BI reports and print-ready paginated reports. By delivering business intelligence solutions, you will foster a data-driven culture that meets the organization’s current and future needs. Staying updated on current and emerging technologies in business intelligence is essential for creating sustainable solutions and achieving success in your role.
Responsibilities:
· Collaborate with end-users to gather requirements and make certain that reporting solutions effectively address their needs.
· Collaborate with data engineers, data architects, analysts, and business stakeholders to understand data requirements and translate them into technical solutions.
· Designing and Developing Power BI Interactive Reports, Paginated Reports and Dashboards
· Leverage Power BI to collect data from multiple sources such as Excel, APIs, SQL, and SharePoint. Develop visually compelling, interactive visualizations that convey key insights to stakeholders and facilitate informed decision-making.
· Collaborate with team members to share best practices, provide technical guidance, and support the adoption of Power BI and other platform tools.
· Train and Mentor team members and Power Users on using Power BI, SQL server T-SQL, and other tools for their respective needs.
· Stay up to date with technical updates and features related to Power BI and other technologies to maintain best practices.
· Monitor and optimize the performance of business intelligence solutions.
· Document and communicate complex technical concepts to both technical and non-technical audiences.
· Exhibit strong interpersonal, verbal, and written communication abilities to foster productive work relationships.
All potential candidates must have the following:
· Bachelor’s degree in computer science, Information Technology, or a related field
· 10+ years of experience in designing and developing business intelligence reporting solutions
· Expertise in MS SSRS, MS Power BI, Excel, and Analysis Services
· Proficient in writing SQL queries, stored procedures, DAX queries, and M queries
· Proficient in performance tuning and query optimization
· Superb communication, collaboration, and problem-solving skills
The ideal candidate will also have the following:
· Experience with Commercial/Investment Real Estate tools (e.g., Yardi, MRI, Argus, Juniper Square, VTS).
· Proven experience in developing enterprise-wide business intelligence solutions for complex environments.
· Skilled in designing custom paginated reports and generating diverse report types, such as on-demand, drill-down, drill-through, parameterized, cascading, conditional, sub-reports, and dynamic grouping, in various formats using SQL Server Reporting Services (SSRS) or Power BI Report Builder.
· Experience in VBA, Python and/or Pyspark programming languages.
· Good understanding of Git as well as Agile & SDLC methodologies.
Duties

Develop and implement ETL processes to extract, transform, and load data from various sources into data warehouses.
Design and optimize databases to ensure efficient data storage and retrieval.
Create interactive dashboards and reports using BI tools to visualize data trends and key performance indicators.
Collaborate with cross-functional teams to gather requirements and deliver tailored BI solutions.
Utilize SQL for querying databases and performing complex data analysis.
Implement RESTful APIs for seamless integration of BI applications with other systems.
Maintain documentation of BI processes, systems, and procedures for future reference.
Stay updated on industry trends and emerging technologies related to business intelligence.

Skills

Proficiency in ETL tools and methodologies.
Experience with AWS cloud services for data storage and processing.
Strong knowledge of SQL for database querying and management.
Familiarity with programming languages such as Java and VBA for automation tasks.
Understanding of linked data concepts and their application in BI solutions.
Experience in database design principles to create scalable solutions.
Ability to work with RESTful services for application integration.
Strong analytical skills with the ability to vaticinate future trends based on historical data.
Excellent communication skills to effectively collaborate with stakeholders at all levels.

Join us as a Business Intelligence Developer, where your expertise will contribute significantly to our mission of leveraging data for strategic advantage.
Job Types: Full-time, Contract
Pay: $100,162.00 - $130,213.00 per year
Work Location: In person