Reporting and Data Analyst

At IDS – Integrated Default Solutions, we provide technology solutions that support the mortgage servicing and default management industries. We offer software development, web-based solutions consulting, and network infrastructure support to enhance efficiency and compliance for servicers, investors, and financial institutions.

Headquartered in San Diego, with team members across multiple states, we offer opportunities for both on-site and remote work. At IDS, we prioritize collaboration, problem-solving, and continuous improvement, ensuring a supportive environment for professional growth.

Employees enjoy competitive compensation, performance-based incentives, and a comprehensive benefits package designed to support well-being and career development.

Summary:  We are seeking a mid-level Power BI & SQL Data Analyst to support and enhance our business intelligence and reporting capabilities. This role is ideal for a professional with strong hands-on experience in Power BI and SQL who can independently deliver production-ready reports and dashboards while collaborating with business stakeholders and senior technical staff.

Key Responsibilities

• Develop and maintain Power BI reports and dashboards used by operational teams and leadership
• Write, optimize, and maintain T-SQL queries, views, and stored procedures in Microsoft SQL Server and MS Analysis Services.
• Support and enhance existing data models used for reporting and analytics
• Assist with ETL processes (SSIS or similar tools) to load and transform data from source systems
• Work with business stakeholders to gather reporting requirements and translate them into Power BI solutions
• Validate data accuracy and troubleshoot reporting, data quality, or performance issues
• Document reports, datasets, and data flows to support ongoing maintenance and knowledge sharing
• Collaborate with senior team members on larger BI and data initiatives

Required Qualifications (Strong Mid-Level)

• 4–5 years of experience in a Power BI, Business Intelligence, or SQL-focused data role
• Strong hands-on experience with Microsoft Power BI, including data modeling, Power Query, and intermediate DAX
• Solid proficiency in Microsoft SQL Server (T-SQL), including complex queries, stored procedures, and basic performance tuning
• Experience supporting production BI reports and dashboards used by business stakeholders or leadership
• Working knowledge of data warehousing concepts and reporting best practices
• Ability to independently gather reporting requirements and translate them into effective, user-friendly Power BI solutions
• Comfortable troubleshooting data quality, performance, and reporting issues in an existing environment
• Strong communication skills with the ability to explain data insights to non-technical users

Preferred / Nice-to-Have Skills

• Experience with SSIS or other ETL and data integration tools
• Familiarity with performance tuning and working with large datasets
• Background in professional services, legal, finance, or regulated industries

Work Schedule:

The work week is typically Monday through Friday, with business hours from 8:00 AM to 5:00 PM. After an initial 90-day training period and upon management approval, there will be some flexibility for remote work.

Salary Range:

The salary for this position typically ranges from $24.00-30.00 per hour, depending on qualifications, experience, and other factors. Please note that the final offer may differ based on the candidate's specific qualifications, skills, and experience, as well as internal equity and business needs.

Benefits:

Integrated Default Solutions and affiliated companies promote work/life balance with a robust wellness program, PTO, remote work, and flexible schedules (where available). Full-time employees become eligible for benefits following a 30-day waiting period, with benefit offerings that include medical, dental, vision, life, AD&D, EAP, STD, and LTD. Additionally the firm provides parental leave for both primary and non-primary caregivers as well. Also available are voluntary income protection benefits such as supplemental life, accident, critical illness, and short and long-term care insurances, as well as a 401(k)-retirement plan with a company match. Part-time employees may have access to some of these benefits, which may be on a pro-rated basis.

Security Requirement:

While performing the duties of this job, the employee is required to ensure the security and confidentiality of all sensitive information, including but not limited to threats or hazards to the security or integrity of sensitive information that could result in any harm or inconvenience to any customer, employee or company.

Work Environment:

A corporate office environment with a professional setting, characterized by a quiet to moderate noise level. Employees may work in individual or shared workspaces, with standard office equipment such as computers, printers, and telephones. Occasional meetings, collaborative discussions, and business activities may contribute to variations in noise levels.

Notices:

The above information on this job description has been described to indicate the general nature and level of work performed by incumbents. Other duties and responsibilities not specifically described may be assigned from time to time, consistent with knowledge, skills and abilities of the incumbent. Integrated Default Solutions and our affiliate companies are Equal Opportunity Employers. We are committed to providing a work environment free from discrimination and harassment. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law. We celebrate diversity and are dedicated to creating an inclusive environment for all employees. Integrated Default Solutions and our affiliate companies will consider qualified applicants with a criminal history pursuant to the San Diego County Fair Chance Ordinance and the California Fair Chance Act. You do not need to disclose your criminal history or participate in a background check until a conditional job offer is made to you. After making a conditional offer and running a background check, if Integrated Default Solutions and our affiliate companies are concerned about conviction that is directly related to the job, you will be given the chance to explain the circumstances surrounding the conviction, provide mitigating evidence, or challenge the accuracy of the background report. Find out more about the Fair Chance Ordinance by visiting the San Diego County Office of Labor Stands and Enforcement webpage. As part of our commitment to maintaining a lawful and compliant workforce, Integrated Default Solutions and our affiliate companies participate in the E-Verify program. All candidates who accept a job offer will be required to complete the E-Verify process to verify their employment eligibility in the United States. 

Applications will be accepted until 03/31/2026.