CompIQ Solutions is a software and full-service provider focusing on the property and casualty medical bill review market. We provide an end-to-end solution for our clients leveraging our proprietary technology and software platforms in the delivery of our solutions and services. We focus our efforts on our three key stakeholders, in this order: 1) Clients; 2) Colleagues; 3) Company.
About This Role
The Database Designer will be responsible for creating and implementing sound database schema and data models that support our SaaS platform’s scalability, performance, and maintainability. This role will refactor our existing fragmented and non-normalized databases into a cohesive, well-structured model, while guiding developers to adopt best practices moving forward.
While the primary focus will be schema and data model design in SQL Server, experience with ETL, reporting, and data warehouse design is a plus. The ideal candidate can also provide occasional DBA coverage during absences, ensuring operational continuity.
Duties and Responsibilities
Analyze current database structures to identify and resolve design flaws, redundancies, and normalization issues.
Redesign and refactor schemas to align with best practices for scalability, maintainability, and performance.
Consolidate multiple databases into logical schemas where appropriate.
Collaborate closely with developers to ensure application features align with the data model.
Define and enforce database design standards, naming conventions, and documentation practices.
Work with the DBA to ensure designs are operationally sound, secure, and maintainable.
Assist in ETL process design, reporting architecture, and data warehouse modeling (as needed).
Provide coverage for the DBA during planned absences, including monitoring, maintenance, and basic administrative tasks.
Document all schemas, relationships, and design decisions in a maintainable format (e.g., data dictionaries, ER diagrams).
Requirements
Required Qualifications
5+ years of experience in database design, data modeling, or equivalent role.
Strong proficiency in SQL Server (schema design, indexing strategies, constraints, T-SQL queries).
Proven experience normalizing databases and consolidating schemas in production environments.
Familiarity with data modeling tools (ER/Studio, ERwin, SQL Server Data Tools, etc.).
Strong understanding of relational database theory and best practices for OLTP environments.
Ability to collaborate with developers to translate business requirements into efficient data structures.
Preferred Qualifications
Experience with ETL tools, reporting platforms (e.g., SSRS, Power BI), or data warehouse design.
Understanding of database performance tuning and query optimization.
Familiarity with SaaS environments and multi-tenant database design considerations.
Experience with SQL Server administration tasks (backup/restore, indexing, performance monitoring).
Soft Skills
Strong communication skills — able to explain database concepts to both technical and non-technical stakeholders.
Detail-oriented with a commitment to quality and accuracy.
Comfortable challenging existing designs and advocating for best practices.
Self-motivated and able to work independently while collaborating in a team environment.
What We Offer
CompIQ Solutions provides our full-time, regular team members with the below benefits:
Fair and Competitive Salary
Flexible schedule in a hybrid or remote-work environment (depending on location)
Flexible Paid Time Off
Paid Parental Leave
Tuition Reimbursement
Identity Theft Protection
Medical, Dental, and Vision Insurance
100% Company-paid Short-Term and Long-Term Disability
100% Company-paid Life Insurance with additional voluntary enrollment options
Employee Assistance Programs including counseling with up to 6 complimentary sessions
Monthly Wellness (Gym Membership) Stipend
Health Spending Account (HSA) and Flexible Spending Account (FSA) Programs
CompIQ Solutions is proud to be an Equal Employment Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law. EOE/M/F/D/V
Questi cookie sono necessari per il funzionamento del sito e non possono essere disattivati nei nostri sistemi. È possibile impostare il proprio browser in modo da bloccare questi cookie, ma alcune parti del sito potrebbero non funzionare.
Sicurezza
Esperienza dell'utente
Cookie orientati al gruppo target
Questi cookie sono impostati attraverso il nostro sito web dai nostri partner pubblicitari. Possono essere utilizzati da queste aziende per profilare i vostri interessi e mostrarvi pubblicità pertinenti altrove.
Google Analytics
Google Ads
Utilizziamo i cookie
🍪
Il nostro sito web utilizza i cookie e tecnologie simili per personalizzare i contenuti, ottimizzare l'esperienza dell'utente e per indvidualizzare e valutare la pubblicità. Facendo clic su Ok o attivando un'opzione nelle impostazioni dei cookie, l'utente accetta questo.
Le migliori offerte di lavoro da remoto via e-mail
Unisciti alle oltre 5'000+ persone che ricevono notifiche settimanali sulle offerte di lavoro da remoto!
