What are the responsibilities and job description for the Enterprise Data Architect position at Colonial Group, Inc.?
Colonial Group, Inc. is a multigenerational, family-owned parent company of various subsidiaries. Our group offers a diverse portfolio of products and services, which, combined with strategic infrastructure and logistics capabilities, create significant value for our customers.
The Enterprise Data Architect is responsible for building and managing Colonial’s data strategy and architecture. This role designs, implements and maintains the technical systems that store, process and analyze our critical data. This is a crucial role for designing and managing Colonial’s enterprise data management frameworks, interpreting business requirements into technical requirements, and collaborating with various stakeholders to optimize data utilization.
This is a new role for Colonial with a critical opportunity to help us define data model designs, database development standards, consolidation of our data warehouses and ensure we build strategies to securely scale our data analytics systems.
JOB EXPECTATIONS/DUTIES
Key Responsibilities
Technology, Data Architecture & Strategy:
QUALIFICATIONS/REQUIREMENTS
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the job.
While performing the duties of this job, the employee is regularly required to sit, stand, walk, and may occasionally lift and/or move up to 20 pounds.
Eligibility Requirements
Hiring is contingent upon eligibility to work in the United States.
Colonial Group, Inc. is committed to creating an environment that values and supports diversity and inclusiveness across our organizations. We encourage applications from qualified individuals who will help us achieve this mission. Colonial Group, Inc. prohibits discrimination of and will receive consideration for employment without regard to race, color, religion, sex, age, national origin, sexual orientation, gender identity or expression, disability, veteran status, marital status, or any other legally protected status.
The Enterprise Data Architect is responsible for building and managing Colonial’s data strategy and architecture. This role designs, implements and maintains the technical systems that store, process and analyze our critical data. This is a crucial role for designing and managing Colonial’s enterprise data management frameworks, interpreting business requirements into technical requirements, and collaborating with various stakeholders to optimize data utilization.
This is a new role for Colonial with a critical opportunity to help us define data model designs, database development standards, consolidation of our data warehouses and ensure we build strategies to securely scale our data analytics systems.
JOB EXPECTATIONS/DUTIES
Key Responsibilities
Technology, Data Architecture & Strategy:
- Define and implement the enterprise data architecture standardizing on core platforms (specifically MS Fabric and Azure data tools).
- Develop data governance policies and best practices for data management and analytics.
- Define and support the development of data observability and data quality mechanisms to improve data platform reliability and enhance business trust.
- Manage data integration workflows using Cloud based ETL tools and integration tools ensuring seamless data flow between different systems.
- Oversee the design and implementation of ETL/ELT processes to ingest, transform, and store data from diverse sources.
- Oversee the development of reporting dashboards and data visualizations using Power BI to support data-driven decision-making.
- Implement self-service analytics capabilities for business users.
- Define a data security and compliance model with respect to applicable regulations, including access restrictions, encryption, and privacy laws.
- Ensure that the organization’s data infrastructure is designed and maintained with security best practices in mind, minimizing the risk of unauthorized access and data leaks.
- Stay current with industry regulations and standards, such as HIPAA for healthcare data and GDPR for personal information in the EU.
- Oversee cloud-based data solutions, with a focus on Microsoft Fabric’s capabilities for data storage and analytics.
- Optimize costs related to data storage and processing.
- Work closely with cross-functional teams including IT, business, and analytics teams to deliver data-driven solutions.
- Engage with external vendors and technology partners to assess new technologies and solutions.
QUALIFICATIONS/REQUIREMENTS
- Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field
- Master’s degree or certifications in cloud data platforms, data analytics, or similar is a plus
- 7-10 years of experience in data management, data analytics, and business intelligence, including 3 to 5 years of specialized experience in a leadership or senior role related to data architecture
- Experience directly, or indirectly, leading small Data & Analytics teams a plus
- Experience in data modeling, data warehousing, and cloud data architecture
- Expertise in building scalable data warehouses and supporting advanced analytics
- Strong proficiency in data integration and ETL workflows
- Experience managing cloud based data solutions for at least two years
- Experience delivering projects using Agile methodologies a plus
- Proven Experience architecting and developing with the following platforms and tools:
- Data platforms: Microsoft Fabric SQL based data warehousing (or Azure Synapse or Snowflake)
- ETL/ELT: Azure Data Factory or SQL Server Integration Services (or Boomi/Wherescape) etc.
- Reporting: Strong PowerBI or Tableau etc.
- Advanced knowledge of Power BI or similar tools for data visualization and self-service analytics
- Knowledge of other data platforms on AWS, Azure, GCP, SQL programming, Python, or other relevant data tools is a plus
- Experience using DevOps tools like Jira or Azure DevOps
- Knowledge of machine learning concepts and tools will be plus
- Strong leadership and project management skills
- Excellent problem-solving abilities and attention to detail
- Ability to communicate technical information clearly to both technical and non-technical stakeholders
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the job.
While performing the duties of this job, the employee is regularly required to sit, stand, walk, and may occasionally lift and/or move up to 20 pounds.
Eligibility Requirements
Hiring is contingent upon eligibility to work in the United States.
Colonial Group, Inc. is committed to creating an environment that values and supports diversity and inclusiveness across our organizations. We encourage applications from qualified individuals who will help us achieve this mission. Colonial Group, Inc. prohibits discrimination of and will receive consideration for employment without regard to race, color, religion, sex, age, national origin, sexual orientation, gender identity or expression, disability, veteran status, marital status, or any other legally protected status.
