North Carolina Staffing
VP, Data Modeler and Platform Architect
North Carolina Staffing, Durham, North Carolina, United States, 27703
Data Platform Architect & Modeler
Banc of California, Inc. (NYSE: BANC) is a bank holding company headquartered in Los Angeles with one wholly-owned banking subsidiary, Banc of California (the "bank"). Banc of California is one of the nation's premier relationship-based business banks focused on providing banking and treasury management services to small, middle-market, and venture-backed businesses. Banc of California offers a broad range of loan and deposit products and services, with full-service branches throughout California and Denver, Colorado, as well as full-stack payment processing solutions through its subsidiary, Deepstack Technologies. The bank is committed to its local communities by supporting organizations that provide financial literacy and job training, small business support, affordable housing, and more. At Banc of California, our success is driven by our people, and we take pride in fostering an environment where everyone can reach their full potential. We embrace a culture of empowerment, progressive thinking, and entrepreneurial spirit, ensuring our team members have an opportunity to make an impact and play an important role in the future of Banc of California. Our core values Entrepreneurialism, Operational Excellence, and Superior Analytics empower us in creating a dynamic and inclusive workplace. We are committed to supporting your growth and well-being with comprehensive benefits, career development programs, a variety of employee resource groups, and more. The Opportunity
We are seeking a Data Platform Architect & Modeler to design, validate, and optimize data models that support our organization's analytics, reporting, and operational data needs. This role will actively contribute to building and maintaining data models while ensuring they align with business requirements and best practices. The ideal candidate will have experience working in Snowflake, dbt, data observability, DataOps, and DevOps, supporting our cloud-based data strategy and modernization efforts. How You'll Make a Difference
Data Modeling: Work with functional business owners to understand business process and data elements that tie to the process. Design conceptual models to showcase the entities/data elements and relationships. Design models in 3NF, Star schema and snowflake schema as appropriate. Design, build, and maintain conceptual, logical, and physical data models to support analytics, reporting, and operational workloads. Ensure dimensional and relational data models support data warehousing and self-service analytics. Develop and optimize data structures in Snowflake DB to ensure performance, scalability, and business alignment. Utilize dbt to build and manage transformations for clean, structured, and reusable data models. Conduct POCs to evaluate new tools, methodologies, and modeling techniques to improve performance, efficiency, and scalability. Establish and enforce data standards, governance, and best practices for data across the organization. Ensure data models comply with regulatory, security, and compliance requirements. Platform Architecture: Design and implement small-scale prototypes and evaluations to test approaches for data modeling, performance running, and architecture improvements. Assess and compare data modeling techniques, integration strategies, and observability tools to recommend the best solutions for the enterprise. Work closely with data engineering and analytics teams to assess new methodologies before full-scale implementation. Document findings from evaluations and provide technical guidance on their adoption. Implement data observability tools to monitor data health, lineage, and anomalies across pipelines. Integrate DataOps principles to automate data quality checks, validation, and governance processes. Work with DevOps teams to ensure CI/CD pipelines support automated deployments and version control for data models. Define and enforce data validation, monitoring, and alerting mechanisms to proactively address issues before they impact stakeholders. Partner with teams to identify and resolve data inconsistencies, drift, and performance bottlenecks. Partner with business teams to understand reporting and analytics needs, translating them into scalable data models. Work with data engineers, BI teams, and application developers to optimize data structures for various use cases. Collaborate with data governance teams to define metadata, lineage, and data quality standards. Provide technical guidance on data modeling, DataOps, and best practices for data architecture. Evaluate and recommend modern data modeling tools and methodologies to improve efficiency and scalability. Stay up-to-date on industry trends and cloud data technologies to enhance data architecture. Support the data foundation initiative, contributing to the modernization of enterprise data platforms. What You'll Bring
8+ years of experience in data modeling, platform architecture, or database design. 6 - 8 years of experience in banking and financial services (commercial banking preferred). Experience with data modeling tools ER Studio, Erwin or similar). Experience on creating conceptual, logical and physical data models using various normal forms, star and snowflake schema. Expertise in dimensional (OLAP) and relational (OLTP) data modeling techniques. Proficiency in SQL and experience optimizing queries for performance and scalability. Hands-on experience with Snowflake, dbt, and data observability tools. Experience implementing DataOps and DevOps practices in a data environment. Strong understanding of data governance, data quality, and metadata management. Strong problem-solving skills and ability to work independently on technical implementations. Excellent communication skills to collaborate with technical and non-technical stakeholders. Experience with ETL/ELT frameworks and data pipeline best practices. Knowledge of Python, Spark, or other data transformation tools. Must be able to prioritize multiple projects and objectives in rapidly changing environment. How We'll Support You
Financial Security: You will be eligible to participate in the company's 401k plan which includes a company match and immediate vesting. Health & Well-Being: We offer comprehensive insurance options including medical, dental, vision, AD&D, supplemental life, long-term disability, pre-tax Health Savings Account with employer contributions, and pre-tax Flexible Spending Account (FSA). Building & Supporting Your Family: Banc of California partners with providers that offer adoption, surrogacy, and fertility assistance as well as paid parental leave and family support solutions including care options for your family. Paid Time Away: Eligible team members receive paid vacation days, holidays, and volunteer time off. Career Growth Opportunities: To support career growth of our team members, we offer tuition reimbursement, an annual mentorship program, leadership development resources, access to LinkedIn Learning, and more. The base salary ultimately offered is determined through a review of education, industry experience, training, knowledge, skills, abilities of the applicant in alignment with market data and other factors. Banc of California is an equal opportunity employer committed to creating a diverse workforce. All qualified applicants will receive consideration for employment without regard to age, ancestry, color, religious creed, denial of Family and Medical Care Leave, disability, marital status, medical condition, genetic information, military and veteran status, national origin, race, sex, gender, gender identity, gender expression, and sexual orientation. If you require reasonable accommodation as part of the application process, please contact Talent Acquisition. Equal Opportunity Employer PacWest Bancorp and its affiliates are fully committed to the principles of equal opportunity and diversity. We take pride in building a workplace culture where all employees feel supported and respected, and have equal access to career and development opportunities without regard to race, religion/creed, color, national origin, age, marital status, ancestry, sex, gender (including pregnancy, childbirth, breastfeeding and medical conditions related to pregnancy, childbirth or breastfeeding), gender identity/expression, sexual orientation, veteran status, physical or mental disability, medical condition, military status, genetic information, or any other characteristic protected by federal, state or local laws.
Banc of California, Inc. (NYSE: BANC) is a bank holding company headquartered in Los Angeles with one wholly-owned banking subsidiary, Banc of California (the "bank"). Banc of California is one of the nation's premier relationship-based business banks focused on providing banking and treasury management services to small, middle-market, and venture-backed businesses. Banc of California offers a broad range of loan and deposit products and services, with full-service branches throughout California and Denver, Colorado, as well as full-stack payment processing solutions through its subsidiary, Deepstack Technologies. The bank is committed to its local communities by supporting organizations that provide financial literacy and job training, small business support, affordable housing, and more. At Banc of California, our success is driven by our people, and we take pride in fostering an environment where everyone can reach their full potential. We embrace a culture of empowerment, progressive thinking, and entrepreneurial spirit, ensuring our team members have an opportunity to make an impact and play an important role in the future of Banc of California. Our core values Entrepreneurialism, Operational Excellence, and Superior Analytics empower us in creating a dynamic and inclusive workplace. We are committed to supporting your growth and well-being with comprehensive benefits, career development programs, a variety of employee resource groups, and more. The Opportunity
We are seeking a Data Platform Architect & Modeler to design, validate, and optimize data models that support our organization's analytics, reporting, and operational data needs. This role will actively contribute to building and maintaining data models while ensuring they align with business requirements and best practices. The ideal candidate will have experience working in Snowflake, dbt, data observability, DataOps, and DevOps, supporting our cloud-based data strategy and modernization efforts. How You'll Make a Difference
Data Modeling: Work with functional business owners to understand business process and data elements that tie to the process. Design conceptual models to showcase the entities/data elements and relationships. Design models in 3NF, Star schema and snowflake schema as appropriate. Design, build, and maintain conceptual, logical, and physical data models to support analytics, reporting, and operational workloads. Ensure dimensional and relational data models support data warehousing and self-service analytics. Develop and optimize data structures in Snowflake DB to ensure performance, scalability, and business alignment. Utilize dbt to build and manage transformations for clean, structured, and reusable data models. Conduct POCs to evaluate new tools, methodologies, and modeling techniques to improve performance, efficiency, and scalability. Establish and enforce data standards, governance, and best practices for data across the organization. Ensure data models comply with regulatory, security, and compliance requirements. Platform Architecture: Design and implement small-scale prototypes and evaluations to test approaches for data modeling, performance running, and architecture improvements. Assess and compare data modeling techniques, integration strategies, and observability tools to recommend the best solutions for the enterprise. Work closely with data engineering and analytics teams to assess new methodologies before full-scale implementation. Document findings from evaluations and provide technical guidance on their adoption. Implement data observability tools to monitor data health, lineage, and anomalies across pipelines. Integrate DataOps principles to automate data quality checks, validation, and governance processes. Work with DevOps teams to ensure CI/CD pipelines support automated deployments and version control for data models. Define and enforce data validation, monitoring, and alerting mechanisms to proactively address issues before they impact stakeholders. Partner with teams to identify and resolve data inconsistencies, drift, and performance bottlenecks. Partner with business teams to understand reporting and analytics needs, translating them into scalable data models. Work with data engineers, BI teams, and application developers to optimize data structures for various use cases. Collaborate with data governance teams to define metadata, lineage, and data quality standards. Provide technical guidance on data modeling, DataOps, and best practices for data architecture. Evaluate and recommend modern data modeling tools and methodologies to improve efficiency and scalability. Stay up-to-date on industry trends and cloud data technologies to enhance data architecture. Support the data foundation initiative, contributing to the modernization of enterprise data platforms. What You'll Bring
8+ years of experience in data modeling, platform architecture, or database design. 6 - 8 years of experience in banking and financial services (commercial banking preferred). Experience with data modeling tools ER Studio, Erwin or similar). Experience on creating conceptual, logical and physical data models using various normal forms, star and snowflake schema. Expertise in dimensional (OLAP) and relational (OLTP) data modeling techniques. Proficiency in SQL and experience optimizing queries for performance and scalability. Hands-on experience with Snowflake, dbt, and data observability tools. Experience implementing DataOps and DevOps practices in a data environment. Strong understanding of data governance, data quality, and metadata management. Strong problem-solving skills and ability to work independently on technical implementations. Excellent communication skills to collaborate with technical and non-technical stakeholders. Experience with ETL/ELT frameworks and data pipeline best practices. Knowledge of Python, Spark, or other data transformation tools. Must be able to prioritize multiple projects and objectives in rapidly changing environment. How We'll Support You
Financial Security: You will be eligible to participate in the company's 401k plan which includes a company match and immediate vesting. Health & Well-Being: We offer comprehensive insurance options including medical, dental, vision, AD&D, supplemental life, long-term disability, pre-tax Health Savings Account with employer contributions, and pre-tax Flexible Spending Account (FSA). Building & Supporting Your Family: Banc of California partners with providers that offer adoption, surrogacy, and fertility assistance as well as paid parental leave and family support solutions including care options for your family. Paid Time Away: Eligible team members receive paid vacation days, holidays, and volunteer time off. Career Growth Opportunities: To support career growth of our team members, we offer tuition reimbursement, an annual mentorship program, leadership development resources, access to LinkedIn Learning, and more. The base salary ultimately offered is determined through a review of education, industry experience, training, knowledge, skills, abilities of the applicant in alignment with market data and other factors. Banc of California is an equal opportunity employer committed to creating a diverse workforce. All qualified applicants will receive consideration for employment without regard to age, ancestry, color, religious creed, denial of Family and Medical Care Leave, disability, marital status, medical condition, genetic information, military and veteran status, national origin, race, sex, gender, gender identity, gender expression, and sexual orientation. If you require reasonable accommodation as part of the application process, please contact Talent Acquisition. Equal Opportunity Employer PacWest Bancorp and its affiliates are fully committed to the principles of equal opportunity and diversity. We take pride in building a workplace culture where all employees feel supported and respected, and have equal access to career and development opportunities without regard to race, religion/creed, color, national origin, age, marital status, ancestry, sex, gender (including pregnancy, childbirth, breastfeeding and medical conditions related to pregnancy, childbirth or breastfeeding), gender identity/expression, sexual orientation, veteran status, physical or mental disability, medical condition, military status, genetic information, or any other characteristic protected by federal, state or local laws.