Reporting and Data Analyst

At IDSolutions - 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. 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 junior to mid-level Database Administrator (DBA), Power BI & SQL Data Analyst to support and enhance our business intelligence and reporting capabilities.

This is an excellent opportunity for an early-career professional looking to build expertise in Microsoft SQL Server environments, database optimization, business intelligence, and data analytics technologies.


The successful candidate will assist in maintaining, optimizing, and supporting enterprise database systems while contributing to reporting, data transformation, and performance improvement initiatives across the organization.

Key Responsibilities

• Support the administration, monitoring, and maintenance of Microsoft SQL Server databases
  
  • Assist with database performance tuning, optimization, and troubleshooting activities
  • Monitor system health, backups, data integrity, and security compliance
  • Work with development and analytics teams to support Analysis Services (SSAS) solutions
  • Develop and maintain Power BI dashboards and reporting solutions
  • Perform data transformation and ETL-related activities using SQL and related tools
  • Help optimize queries, indexes, stored procedures, and database structures for improved performance
  • Participate in database upgrades, migrations, and patching activities
  • Document database configurations, procedures, and operational processes
  • Support disaster recovery and business continuity planning
  • Analyze system performance metrics and recommend improvements
• Required Qualifications (Mid-Level)
• 2-3 years of experience in database administration including hands-on experience with Microsoft Power BI, data modeling, MDX/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

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.