CINC Systems
Data Architect
CINC Systems, Duluth, Georgia, United States, 30155
Data Architect
Atlanta, GA
CINC is a fully integrated cloud-based homeowners' association accounting and property management software system that develops accounting, payment, banking, and property management software solutions that support the running of the day-to-day activities of Homeowners Associations and Management Companies.
Job Overview
We are seeking an experienced Data Architect to join our team at CINC Systems, an industry leader in developing cutting-edge accounting and property management software solutions. The ideal candidate will design, optimize, and manage the organization's data architecture to support our core products, ensuring high performance, scalability, and data security. You will work closely with cross-functional teams, including developers, data engineers, product managers, and business analysts, to deliver reliable and efficient data-driven solutions that meet our clients' accounting and property management needs.
Key Responsibilities Design and develop data architecture: Create and manage the company's data architecture roadmap, ensuring that it aligns with both business and technology strategies. Data modeling: Design and maintain logical and physical data models that support complex accounting and property management systems and integrations, ensuring data accuracy and consistency. Database design and optimization: Architect scalable, high-performance relational databases that are optimized for our software's functionality and performance needs. Data governance: Establish and enforce data governance policies and standards, including data security, integrity, and quality for sensitive financial data. Collaboration: Work closely with the software development, product, and operations teams to understand business requirements and translate them into a functional data architecture. Data integration: Lead efforts to integrate data from various sources, including third-party applications, cloud platforms, and internal systems. Scalability and performance: Ensure the data architecture can handle growth in user data, transactions, and records, optimizing for both storage and query performance. Data security and compliance: Collaborate with security teams to implement robust security protocols, ensuring compliance with required regulations Application DBA: Assist developers in query performance tuning, including efficient query rewrite and proper indexing. System DBA: Assit IT in SQL Server management, including DB server performance tuning, database server upgrades, restore/backup, availability setup, storage configuration, and server performance/health monitoring. Documentation: Develop and maintain documentation for data architecture designs, data flow diagrams, and integration specifications. Required Skills and Qualifications
Experience: 12+ years of experience in data architecture, database design, and data management in the software industry Expertise in database technologies: Strong understanding of relational databases, especially in Microsoft SQL Server. Must understand how database engine inner works, including memory management, logical/physical storage, and network/disk Ios. Data modeling: Strong knowledge of relational data modeling, proficiency in data modeling tools, and experience in designing data models for complex business applications. Cloud platforms: Experience with cloud-based data architectures (e.g., AWS, Azure), including cloud databases, storage solutions, and security best practices Data integration: Expertise in designing data pipelines and integrations using ETL tools (e.g., SSIS, Talend, or similar) Data governance: Strong knowledge of data governance and data quality best practices, with experience implementing governance policies for financial and PII data. Database Management: Must have extensive experience with SQL Server management, including query performance tuning, server configuration tuning for performance (e.g., optimal storage architecture, memory configuration, and network/disk IO tunning), server upgrade, database backup/restore, availability clustering setup/configuration, log shipping/CDC, etc. Analytical mindset: Strong analytical skills to interpret business requirements and translate them into data solutions that meet both functional and performance goals. Problem-solving: Strong problem-solving skills, with a focus on anticipating potential issues and developing proactive solutions. Communication skills: Excellent verbal and written communication skills with the ability to explain complex data concepts to non-technical stakeholders. Very effective interpersonal skills including mentoring, coaching, collaborating, and team building Educational background: Bachelor's or master's degree in computer science, Information Technology, or a related field. Knowledge and experience of Microsoft Fabric/PowerBI is a big plus Knowledge of Big data and NoSql technologies are a plus
CINC is an Equal Opportunity Employer of women, minorities, protected veterans and individuals with disabilities.
Atlanta, GA
CINC is a fully integrated cloud-based homeowners' association accounting and property management software system that develops accounting, payment, banking, and property management software solutions that support the running of the day-to-day activities of Homeowners Associations and Management Companies.
Job Overview
We are seeking an experienced Data Architect to join our team at CINC Systems, an industry leader in developing cutting-edge accounting and property management software solutions. The ideal candidate will design, optimize, and manage the organization's data architecture to support our core products, ensuring high performance, scalability, and data security. You will work closely with cross-functional teams, including developers, data engineers, product managers, and business analysts, to deliver reliable and efficient data-driven solutions that meet our clients' accounting and property management needs.
Key Responsibilities Design and develop data architecture: Create and manage the company's data architecture roadmap, ensuring that it aligns with both business and technology strategies. Data modeling: Design and maintain logical and physical data models that support complex accounting and property management systems and integrations, ensuring data accuracy and consistency. Database design and optimization: Architect scalable, high-performance relational databases that are optimized for our software's functionality and performance needs. Data governance: Establish and enforce data governance policies and standards, including data security, integrity, and quality for sensitive financial data. Collaboration: Work closely with the software development, product, and operations teams to understand business requirements and translate them into a functional data architecture. Data integration: Lead efforts to integrate data from various sources, including third-party applications, cloud platforms, and internal systems. Scalability and performance: Ensure the data architecture can handle growth in user data, transactions, and records, optimizing for both storage and query performance. Data security and compliance: Collaborate with security teams to implement robust security protocols, ensuring compliance with required regulations Application DBA: Assist developers in query performance tuning, including efficient query rewrite and proper indexing. System DBA: Assit IT in SQL Server management, including DB server performance tuning, database server upgrades, restore/backup, availability setup, storage configuration, and server performance/health monitoring. Documentation: Develop and maintain documentation for data architecture designs, data flow diagrams, and integration specifications. Required Skills and Qualifications
Experience: 12+ years of experience in data architecture, database design, and data management in the software industry Expertise in database technologies: Strong understanding of relational databases, especially in Microsoft SQL Server. Must understand how database engine inner works, including memory management, logical/physical storage, and network/disk Ios. Data modeling: Strong knowledge of relational data modeling, proficiency in data modeling tools, and experience in designing data models for complex business applications. Cloud platforms: Experience with cloud-based data architectures (e.g., AWS, Azure), including cloud databases, storage solutions, and security best practices Data integration: Expertise in designing data pipelines and integrations using ETL tools (e.g., SSIS, Talend, or similar) Data governance: Strong knowledge of data governance and data quality best practices, with experience implementing governance policies for financial and PII data. Database Management: Must have extensive experience with SQL Server management, including query performance tuning, server configuration tuning for performance (e.g., optimal storage architecture, memory configuration, and network/disk IO tunning), server upgrade, database backup/restore, availability clustering setup/configuration, log shipping/CDC, etc. Analytical mindset: Strong analytical skills to interpret business requirements and translate them into data solutions that meet both functional and performance goals. Problem-solving: Strong problem-solving skills, with a focus on anticipating potential issues and developing proactive solutions. Communication skills: Excellent verbal and written communication skills with the ability to explain complex data concepts to non-technical stakeholders. Very effective interpersonal skills including mentoring, coaching, collaborating, and team building Educational background: Bachelor's or master's degree in computer science, Information Technology, or a related field. Knowledge and experience of Microsoft Fabric/PowerBI is a big plus Knowledge of Big data and NoSql technologies are a plus
CINC is an Equal Opportunity Employer of women, minorities, protected veterans and individuals with disabilities.