Senior Database Designer

Must be authorized to work in the U.S. without the need for employment-based visa sponsorship now or in the future. We are unable to sponsor applicants for U.S. work visa status for this opportunity (no sponsorship is available for H-1B, L-1, O-1, E-3, H-1B1, F-1, J-1, OPT, CPT or any other employment-based visa).

The Senior Database Designer is responsible for building the organization's enterprise data models and database structures. The role is responsible for conceptual, logical, and physical data modeling that supports operational systems, analytical workloads, and harmonized data domains within the enterprise data ecosystem. The position will partner closely with business SMEs, data engineering, governance, and analytics teams to ensure that data structures are documented, standardized, scalable, performant, and aligned to corporate governance policies and integration standards. The successful candidate will bring deep expertise in dimensional and relational modeling, strong proficiency with modern cloud data platforms, and the ability to drive modeling best practices across the organization.

Key Responsibilities

Enterprise Data Modeling and Architecture

• Lead the design and delivery of conceptual, logical, and physical data models for enterprise data domains and data products (operational and analytic).
• Develop harmonized, reusable, and governed data models that support single-source-of-truth design principles.
• Establish and maintain modeling standards, including naming conventions, dimensional modeling patterns, SCD2 strategies, surrogate key methodologies, lineage documentation, and data enrichment frameworks.
• Design models to support high-volume incremental ingestion (CDC), complex history tracking, and auditable data transformations.
• Produce and maintain full metadata and lineage documentation through approved tools (e.g., ER/Studio, Unity Catalog).

Integration, Data Engineering Enablement, and Delivery

• Create detailed source-to-target mappings aligned to model definitions and business rules to support data engineering development.
• Partner with data pipeline engineering to validate build quality, ensure model fidelity in pipelines, and support UAT and performance testing.
• Contribute to database and datamart design for analytics solutions, including fact and dimension architectures, semantic layers, and data consumption optimization.

Performance, Quality, and Governance

• Validate data model performance characteristics; recommend indexing, partitioning, and clustering strategies for the data platform.
• Collaborate with Data Governance to ensure data definitions, standards, quality rules, and ownership are aligned to enterprise data strategy.
• Design models emphasizing security classification, access permissions, compliance obligations, and auditability.

Stakeholder Engagement

• Serve as a trusted advisor to product owners, business leaders, and analytics users, translating business requirements into data structures that support meaningful insights.
• Communicate tradeoffs and design alternatives when evaluating new use cases or changes to the enterprise model.
• Contribute to roadmap planning for enterprise data domains and long-term architectural evolution.

Qualifications

• Required
• Bachelor's or Master's degree in Computer Science, Information Systems, or a related discipline.
• 7+ years of progressive experience in data modeling, database design, and data architecture.
• Demonstrated expertise with relational and dimensional modeling (3NF and star schema design).
• Proficiency with cloud-based modern data stack environments (Azure preferred; Databricks experience highly valued).
• Strong proficiency with SQL for model validation, profiling, and optimization.
• Experience with data modeling tools such as ER/Studio, ERwin, DB Schema, or equivalent.
• Hands-on experience supporting data warehouses, datamarts, and metadata-driven modeling approaches.
• Experience supporting data ingestion and CDC design patterns and SCD2 data history strategy.
• Strong attention to detail regarding data quality, lineage, governance, and documentation.
• Excellent communication skills with proven ability to clearly articulate design rationale to technical and non-technical audiences.

Preferred

• Experience in the insurance or financial services industry with knowledge of policy, client, and revenue data structures.
• Familiarity with ETL/ELT orchestration tools (Fivetran, Airflow, MuleSoft) and distributed processing frameworks (Spark).
• Experience with semantic modeling layers (e.g., Tableau semantic layer, dbt metrics, or similar).
• Certification in cloud platforms (Azure Data Engineer, AWS Data Analytics, or equivalent).

IMPORTANT NOTICE:

• This position description is intended to describe the level of work required of the person performing in the role and is not a contract. The essential responsibilities are outlined; other duties may be assigned as needs arise or as required to support the organization. All requirements may be subject to reasonable accommodation to applicants and colleagues who need them for medical or religious reasons.

Click here for some insight into our culture!

The Baldwin Group will not accept unsolicited resumes from any source other than directly from a candidate who applies on our career site. Any unsolicited resumes sent to The Baldwin Group, including unsolicited resumes sent via any source from an Agency, will not be considered and are not subject to any fees for any placement resulting from the receipt of an unsolicited resume.