Data Architect
: Job Details :

Position Title: Data Architect

Department: Development/Engineering

Reports To: CEO

Supervises: Yes

FLSA Status: Exempt

Shift: Day

Work Location: On-site

Position Summary:

The Data Architect will be responsible for designing, implementing, and maintaining data architecture and solutions to meet the organization's data management and analytics needs. The Data Architect will collaborate with cross-functional teams to define data requirements, develop data models, and ensure the integrity and security of data assets.

Essential Duties and Responsibilities:

The essential duties of the position include the following, and other duties may be assigned:

• Define and document the organization's data architecture vision, strategy, and principles.
• Collaborate with business stakeholders and technical teams to understand data requirements and translate them into robust data architecture solutions.
• Develop conceptual, logical, and physical data models to support data integration, storage, and retrieval.
• Design data flows, data pipelines, and data transformation processes to enable efficient data movement and processing.
• Develop and maintain data models that represent the organization's data assets and support business requirements.
• Design and optimize relational and non-relational database schemas for performance, scalability, and data integrity.
• Define data standards and naming conventions to ensure consistency and uniformity across databases.
• Collaborate with database administrators and developers to implement and maintain databases and data structures.
• Establish data governance policies, processes, and frameworks to ensure data quality, privacy, and compliance.
• Define data classification, access controls, and data retention policies in collaboration with security and compliance teams.
• Implement data protection measures, such as encryption, data masking, and anonymization techniques.
• Monitor data usage and access patterns, identifying and mitigating data security risks.
• Design and implement data integration strategies and solutions to facilitate seamless data flow across systems.
• Develop Extract, Transform, Load (ETL) processes and workflows to extract data from various sources, transform it to meet business requirements, and load it into target systems.
• Identify and implement data integration patterns, including real-time and batch processing, data synchronization, and data replication.
• Ensure data quality and consistency throughout the integration process.
• Collaborate with business intelligence and analytics teams to define data requirements for reporting, dashboards, and data visualization.
• Design data marts, data warehouses, and data lakes to support analytics and reporting needs.
• Develop data models and structures optimized for analytical processing and query performance.
• Implement data aggregation, summarization, and transformation techniques to enable efficient analytics.
• Collaborate closely with cross-functional teams, including business stakeholders, data scientists, developers, and infrastructure teams, to ensure alignment of data architecture with business goals.
• Communicate complex data concepts and solutions to non-technical stakeholders in a clear and concise manner.
• Participate in project planning, requirements gathering, and technical discussions.
• Provide guidance and mentorship to junior data team members.

Supervisory Responsibilities:

Yes

Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education/Experience:

Bachelor's degree in computer science, Information Systems, or a related field (relevant experience may substitute for formal education). Minimum of 7 years of professional experience in data architecture or related roles. Proven experience in designing and implementing data architecture solutions, including data models, database design, and data integration strategies. Strong expertise in relational databases, SQL, and database design principles. Minimal exposures on cloud Techstacks -AWS/Azure ADFs - Preferably in AWS ETLs Glue and Warehouse/database - AWS Redshift. 7+ years of experience on SQL Server Instance Maintenance or advance SQL query engine tuning(Trino) or Postgres. Familiarity with NoSQL databases, data lakes, data warehouses, and 5+ years of experience with big data technologies. 7+ years of experience with data integration tools and technologies (e.g., ETL, ELT, data integration platforms). Knowledge of data governance principles, data privacy regulations, and best practices. Proficiency in data modeling tools and techniques.

Language Ability:

Ability to read and comprehend instructions, correspondence, and memos. Ability to write moderately complex correspondence. Ability to effectively converse and present information in one-on-one and small group situations to customers, clients, and other employees of the organization.

Math Ability:

Strong proficiency in advanced mathematics, including linear algebra, statistics, and probability theory. Ability to develop and optimize complex algorithms. Competence in data modeling, data mining, and quantitative analysis. Familiarity with mathematical methods for data analysis and pattern recognition. Experience with statistical software and tools (e.g., R, MATLAB, SAS). Capability to translate mathematical concepts into practical applications for data architecture and analysis. Problem-solving skills to address data-related challenges and optimize performance.

Reasoning Ability:

Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret feedback from non-skilled technical system users to uncover the source of problems and persistence to efficiently provide solutions. Extreme attention to detail is required to ensure proper documentation of facts. Ability to adapt well in the face of workplace stressors such as customer service complaints, maintaining the security of data, competing priorities of high significance to the successful function of the department.

Computer Skills:

Proficiency in SQL and database management systems (e.g., Oracle, MySQL, PostgreSQL). Experience with data warehousing solutions (e.g., Amazon Redshift, Snowflake). Strong knowledge of data modeling tools (e.g., Erwin, PowerDesigner). Familiarity with big data technologies (e.g., Hadoop, Spark). Competence in programming languages (e.g., Python, Java, Scala). Understanding of ETL processes and tools (e.g., Informatica, Talend). Experience with cloud platforms and services (e.g., AWS, Azure, Google Cloud). Knowledge of data governance and data security best practices.

Certificates and Licenses:

None

Travel:

This position does not require travel. 25% travel is possible.

Work Environment:

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job in an office environment. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. A typical, climate-controlled office environment exists. The worker is not substantially exposed to adverse environmental conditions.