Baldwin Risk Partners, LLC
Senior Database Designer page is loaded## Senior Database Designerlocations:
Tampa, Florida, UStime type:
Full timeposted on:
Posted 2 Days Agojob requisition id:
JR108783Must 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
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.The Baldwin Group (previously Baldwin Risk Partners) is a cohesive group of experts in business insurance, employee benefits, retirement planning, and all areas of private and personal insurance. Since 2011, we’ve evolved from a local business into a national firm with a vast network of specializations serving two million clients across the country.At The Baldwin Group, we provide solutions so our clients can pursue what’s possible for themselves, their families, and their businesses. Whether renting a first apartment, opening a small business or taking a company public, we offer solutions to support clients at every step of their journey giving them peace of mind to pursue their purpose, passion, and dreams.
We Protect the Possible.*The Baldwin Group is an equal employment opportunity firm and strives to comply with all laws prohibiting discrimination based on race, color, religion, age, sex (including sexual orientation and gender identity), national origin or ancestry, disability, military status, marital status, and any other category protected by federal, state, or local laws. All such discrimination is unlawful, and all persons involved in the operations of the firm are prohibited from engaging in this conduct.* #J-18808-Ljbffr
Tampa, Florida, UStime type:
Full timeposted on:
Posted 2 Days Agojob requisition id:
JR108783Must 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
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.The Baldwin Group (previously Baldwin Risk Partners) is a cohesive group of experts in business insurance, employee benefits, retirement planning, and all areas of private and personal insurance. Since 2011, we’ve evolved from a local business into a national firm with a vast network of specializations serving two million clients across the country.At The Baldwin Group, we provide solutions so our clients can pursue what’s possible for themselves, their families, and their businesses. Whether renting a first apartment, opening a small business or taking a company public, we offer solutions to support clients at every step of their journey giving them peace of mind to pursue their purpose, passion, and dreams.
We Protect the Possible.*The Baldwin Group is an equal employment opportunity firm and strives to comply with all laws prohibiting discrimination based on race, color, religion, age, sex (including sexual orientation and gender identity), national origin or ancestry, disability, military status, marital status, and any other category protected by federal, state, or local laws. All such discrimination is unlawful, and all persons involved in the operations of the firm are prohibited from engaging in this conduct.* #J-18808-Ljbffr