Data Architect

Job Summary:

The Data Architect role is to lead the design, development, and optimization of scalable, high-performing modern data solutions across Software-as-a-Service and Platform-as-a-Service environments. This role blends deep technical expertise with strategic thinking and hands-on problem-solving — including modernization of legacy systems, integration of emerging technologies, and cross-functional collaboration to support enterprise-wide data initiatives.

Supervisory Responsibilities:

None

Duties/Responsibilities:

1. Design and maintain enterprise data architecture, including conceptual, logical, and physical models to support both operational and analytical workloads.
2. Understand, document, and enhance moderately complex, disparate legacy systems—ensuring they evolve to meet modern standards.
3. Reverse-engineer and improve legacy T-SQL code by applying newer, more efficient techniques and industry best practices.
4. Evaluate and recommend tools, technologies, and processes to improve data delivery —including opportunities for automation, low code / no code solutions, AI, and machine learning integration.
5. Architect and support cloud-based and hybrid data platforms (e.g., Azure, Microsoft Fabric, AWS, Amazon RDS, Databricks, or similar), ensuring scalability, availability, and performance.
6. Develop robust batch and streaming pipelines for large-scale data ingestion and processing.
7. Implement and enforce standards for data quality, lineage, governance, security, and cataloging.
8. Collaborate with business and technical stakeholders to understand requirements, solve complex problems, and deliver data-driven solutions.
9. Support business intelligence and analytics initiatives (Power BI, Paginated Reports, SSRS) by ensuring reliable, timely access to curated data through data warehouses, lakes, and marts.
10. Lead initiatives in performance tuning, disaster recovery, data compliance, and data observability.
11. Stay up to date on industry trends and emerging technologies to drive continuous improvement.

Required Skills/Abilities: 

1. 10 years of experience in Information Technology, with 7 years as a Data Architect.
2. 5 years of experience with cloud platforms (Azure preferred, AWS acceptable).
3. Demonstrated ability to modernize legacy systems and codebases, especially in T-SQL and SQL Server environments.
4. Expertise in data modeling (ER, dimensional / cube, data lakes), data integration (ETL/ELT), and pipeline orchestration (e.g., Azure Data Factory, SSIS, or similar tools).
5. Hands-on experience with modern data architecture patterns, including data lakes and lake houses.
6. Proficient in SQL and scripting for automation and performance optimization.
7. Familiar with DevOps tools and CI/CD pipelines (Bitbucket, Azure Dev Ops Platform), and scheduling and alerting systems.
8. Strong understanding of data governance, cataloging, and metadata management.
9. Ability to effectively communicate with both technical and business audiences; skilled at presenting architectural decisions and trade-offs.

Physical Requirements and Work Environment

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. 

Physical Requirements

1. Ability to navigate stairs within the office.
2. Prolonged periods of sitting at a desk and working on a computer.
3. Ability to use standard office equipment such as a computer, keyboard, and mouse.
4. Occasional lifting of office supplies and materials.

Travel

Minimal travel required, depending on business needs and specific role requirements.

Work Environment

1. Office-based role with a majority of time spent on a computer.
2. Participation in virtual meetings.
3. Standard office environment with typical office noise levels.

EEO Statement

The Company provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

This job description is not an employment agreement or contract. Management has the exclusive right to alter this job description at any time without notice. These statements are intended to describe the general nature and level of work involved for this job. It is not an exhaustive list of all responsibilities, duties and skills required of this job. The employee is expected to adhere to all company policies and to act as a role model in the adherence to policies.