Demo

Business Intelligence Data Analyst

Spinoso Real Estate Group
Syracuse, NY Full Time
POSTED ON 1/22/2025
AVAILABLE BEFORE 4/22/2025

Job Title : Data Analyst (SQL Reporting)

Location : North Syracuse, NY / Remote

Department : Business Intelligence

Reports to : Manager of Business Intelligence

Position Overview :

We are seeking a skilled Data Analyst with expertise in SQL to join our team. The primary responsibility of this role will be to design, write, and maintain SQL queries and reports to extract, analyze, and present data to support business needs. You will work closely with various stakeholders to ensure that reporting requirements are met, delivering accurate and actionable insights in a timely manner.

Key Responsibilities :

  • SQL Reporting & Query Writing :

Write, update, and optimize SQL queries to extract data from relational databases for business reporting needs. Develop and maintain custom SQL reports based on specific business requirements.

  • Report Maintenance & Automation :
  • Regularly update and optimize existing SQL-based reports to ensure they are aligned with evolving business needs. Identify and implement opportunities for report automation to improve efficiency and accuracy.

  • Data Extraction & Analysis :
  • Extract, manipulate, and analyze large datasets using SQL. Provide insights based on data analysis to support decision-making across different business functions.

  • Data Quality & Validation :
  • Ensure the accuracy, completeness, and consistency of the data being extracted through regular validation and troubleshooting of SQL queries. Perform data cleansing and ensure that reports reflect high-quality, error-free data.

  • Collaboration with Stakeholders :
  • Work closely with internal teams, including business analysts, product managers, and leadership, to understand reporting requirements. Translate business needs into technical specifications for report generation.

  • Performance Monitoring :
  • Monitor and optimize report performance, ensuring that SQL queries run efficiently, and reports are delivered on time. Troubleshoot and resolve performance issues as they arise.

    Key Qualifications :

  • Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field.
  • 2 or more years of working experience in a Data Analyst or similar role.
  • Proven experience as a Data Analyst or SQL Developer, with a focus on writing and maintaining SQL reports.
  • Strong proficiency in SQL (e.g., MySQL, PostgreSQL, SQL Server) for querying, reporting, and data manipulation.
  • Experience with report-writing tools and business intelligence (BI) platforms (e.g., Tableau, Power BI, or similar) is a plus.
  • Familiarity with database management systems, relational databases, and data warehousing concepts.
  • Strong analytical skills with attention to detail and accuracy.
  • Excellent communication skills to collaborate with non-technical and technical stakeholders.
  • Ability to handle large datasets and optimize queries for performance.
  • Preferred Qualifications :

  • Experience with advanced SQL concepts (e.g., joins, subqueries, stored procedures, functions).
  • Familiarity with cloud-based data platforms (e.g., AWS, Google Cloud, or Azure).
  • Understanding of data governance and security best practices.
  • Experience in commercial real estate or a similar field
  • Familiarity with Yardi Systems or similar property management software
  • Disclaimer : This job description is not all inclusive. Other duties and responsibilities may be required.

    EEO Statement : Spinoso Realty Group is an equal opportunity employer and is committed to providing a work environment that is free from discrimination and harassment. We value diversity and inclusion and believe that a diverse workforce enhances our ability to provide innovative solutions to our customers. We comply with the Americans with Disabilities Act (ADA) and will provide reasonable accommodations for qualified individuals with disabilities throughout the recruitment process. If you require accommodations for any part of the application and hiring process, please notify the Human Resources Department at abinaxas@spinosoreg.com. Reasonable accommodations will be determined on a case-by-case basis. It is the responsibility of the applicant to inform Spinoso Realty Group of any necessary accommodations needed during the recruitment process. Spinoso Realty Group will work with the applicant to assess the specific requirements and provide reasonable accommodations accordingly. Spinoso Realty Group is committed to ensuring that our workplace is accessible to individuals with disabilities. If you need assistance or an accommodation to perform the essential functions of the job, please let us know.

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Business Intelligence Data Analyst?

    Sign up to receive alerts about other jobs on the Business Intelligence Data Analyst career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $64,949 - $84,690
    Income Estimation: 
    $81,298 - $105,685
    Income Estimation: 
    $81,298 - $105,685
    Income Estimation: 
    $101,449 - $132,468
    Income Estimation: 
    $80,838 - $103,226
    Income Estimation: 
    $98,772 - $126,519
    Income Estimation: 
    $113,567 - $162,206
    Income Estimation: 
    $64,949 - $84,690
    Income Estimation: 
    $81,298 - $105,685
    Income Estimation: 
    $66,720 - $84,360
    Income Estimation: 
    $80,838 - $103,226
    Income Estimation: 
    $85,534 - $118,479
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Spinoso Real Estate Group

    Spinoso Real Estate Group
    Hired Organization Address Henderson, NV Full Time
    Summary The Marketing Manager will be responsible for conceptualizing, directing, and implementing all aspects of a stra...

    Not the job you're looking for? Here are some other Business Intelligence Data Analyst jobs in the Syracuse, NY area that may be a better fit.

    Business Intelligence Data Analyst

    Spinoso Real Estate Gro, Syracuse, NY

    Artificial Intelligence Analyst

    SUNY Upstate Medical University, Syracuse, NY

    AI Assistant is available now!

    Feel free to start your new journey!