Data Architect

Mindex; City of Rochester (NY); On-site; USD 120,000 - 173,000; Full time

Benefits offered by this job

Health insurance

Paid holidays

Flexible time off

401k with company match

Dental insurance

Vision insurance

Life insurance

Job summary

Mindex in Rochester, NY seeks a Data Architect to shape data strategy and architecture supporting analytics, AI, and data-driven initiatives. You will lead architecture discussions, set data standards, and partner with data engineers, scientists, and business leaders to design robust data platforms.

Ideal candidates bring 8+ years in data engineering/architecture, strong Azure and Snowflake experience, and proven collaboration across technical and business teams.

Qualifications

• BS degree in Computer Science, Data Science, Engineering, or equivalent software/services experience required
• 8+ years of progressive experience in data engineering/architecture
• 5+ years designing modern data platforms using Snowflake, Databricks, Spark or similar systems
• Strong experience (5+ years) in Python, SQL, PySpark, R for large-scale data processing
• Proven experience architecting and optimizing complex data pipelines and ecosystems
• 3+ years designing cloud-based data architectures with Azure (Data Factory, Data Lake, Databricks, Spark, Cosmos DB)
• Demonstrated experience leading architecture decisions and establishing standards
• Experience with data governance, security, privacy, and compliance in enterprise environments
• Hands-on with Agile methodologies and design within Agile teams
• Experience with CI/CD, DevOps, and infrastructure-as-code (Azure DevOps, Terraform)
• Experience integrating enterprise systems (Salesforce FSC/Data Cloud)
• Mentor engineering teams and influence technical strategy

Responsibilities

• Design scalable, high-performance data architectures across cloud and hybrid environments
• Define and enforce data modeling standards (conceptual/logical/physical)
• Build and optimize enterprise data pipelines to support analytics and operations
• Architect data platforms using Snowflake, Databricks, Spark, and Azure services
• Collaborate with data engineers/scientists to translate business needs into data solutions
• Establish and maintain data governance, quality, and metadata management
• Ensure data privacy, security, and compliance across platforms
• Leading decisions for data storage (lakes/warehouses/real-time processing)
• Optimize performance and cost efficiency of data platforms
• Support Agile delivery, sprint planning, and architectural roadmaps
• Implement CI/CD and infrastructure-as-code for data solutions
• Evaluate emerging technologies and recommend data capability enhancements

Skills

Data architecture

SQL

Python

PySpark

Azure

CI/CD

Agile

Data governance

Security/compliance

Communication

Education

BS degree in CS/Engineering/Data Science

Tools

Snowflake

Databricks

Spark

Azure Data Factory

Data Lake

Cosmos DB

Job description

With more than 30 years of success, Mindex is a software development and cloud services company known for delivering innovative solutions. We've built products like SchoolTool, Advanced Analytics, and our Integrations Platform from the ground up, giving us deep expertise in developing and scaling modern software. Named the #1 Software Developer in the 2025 RBJ Book of Lists and ranked #80 in the Rochester Chamber Top 100, we're passionate about helping our clients succeed and creating opportunities for our team to grow and make an impact. We are looking for a Data Architect who enjoys solving complex business challenges and designing scalable, secure, and high-performing data solutions. This person will play a key role in shaping data strategy and architecture that supports analytics, reporting, artificial intelligence, and other data-driven initiatives. The ideal candidate is comfortable leading architecture discussions, establishing data standards and best practices, and partnering with both technical and business stakeholders. Strong communication skills are important, as you'll need to translate complex technical concepts into clear recommendations and guide teams toward effective solutions. In this role, you'll work closely with data engineers, data scientists, business leaders, and clients to design and optimize modern data platforms. You'll help ensure data systems are reliable, secure, scalable, and aligned with business goals while creating a strong foundation for future growth.

Essential Functions:?

• Design and implement scalable, high-performance data architectures across cloud and hybrid environments?
• Define and enforce data modeling standards, including conceptual, logical, and physical data models?
• Build and?optimize?enterprise data pipelines and data integration frameworks to support analytics and operational use cases?
• Architect and manage data platforms?leveraging?technologies such as Snowflake, Databricks, Spark, and Azure Data services?
• Collaborate with data engineers, data scientists, and business stakeholders to translate business needs into robust data solutions?
• Establish and?maintain?data governance, data quality, and metadata management frameworks?
• Ensure data privacy, security, and compliance requirements are met across all platforms and pipelines?
• Lead architecture decisions for data storage solutions including data lakes, data warehouses, and real-time data processing systems?
• Optimize?performance and cost efficiency of data platforms and workloads?
• Support Agile delivery frameworks and contribute to sprint planning, backlog grooming, and architectural roadmaps?
• Implement and oversee CI/CD pipelines and infrastructure-as-code practices for data solutions?
• Evaluate emerging technologies and recommend solutions to enhance data?capabilities?

Requirements

• BS degree in Computer Science, Data Science, Engineering, or equivalent software/services experience?required?
• 8+ years of progressive experience in data engineering, data architecture, or related disciplines, including enterprise-scale data solution design?
• 5+ years of hands‑on experience designing and implementing modern data platforms using technologies such as Snowflake, Databricks, Spark, or similar distributed data systems?
• Strong experience (5+ years) in Python, SQL,?PySpark, R, or comparable languages for large-scale data processing and analytics?
• Proven experience architecting, building, and?optimizing?complex data pipelines, data ecosystems, and large, multi‑source data environments?
• 3+ years of experience designing and supporting cloud‑based data architectures, with a strong preference for Microsoft Azure (e.g., Azure Data Factory, Data Lake, Databricks, Spark, Azure ML, Cosmos DB)?
• Demonstrated experience leading or influencing architecture decisions and?establishing'standards for scalable, secure, and high‑performing data solutions?
• Experience implementing data governance, data security, privacy, and compliance frameworks in enterprise environments?
• Hands‑on experience with Agile methodologies and leading technical design within Agile delivery teams?
• Experience with CI/CD, DevOps, and infrastructure‑as‑code practices (e.g., Azure DevOps, Terraform, ARM, GitHub Actions, Ansible Tower), including establishing automation and deployment standards?
• Experience integrating enterprise systems and platforms, including Salesforce FSC and/or Salesforce Data Cloud?
• Proven ability to mentor engineering teams and influence technical strategy, best practices, and architectural direction

Skills & Competencies:?

• Strong?expertise?in data architecture design, including data lakes, warehouses, and streaming systems?
• Advanced?proficiency?in SQL and distributed data processing frameworks (e.g., Spark, Databricks)?
• Experience with Microsoft Azure and modern cloud‑based data platforms?
• Knowledge of ETL/ELT design patterns and data integration best practices?
• Familiarity with data modeling techniques (dimensional, normalized, Data Vault, etc.)?
• Knowledge of CI/CD pipelines, infrastructure as code, and?MLOps?practices?
• Understanding of API integrations and enterprise system connectivity?

Benefits

• Health insurance
• Paid holidays
• Flexible time off
• 401k retirement savings plan and company match with pre‑tax and ROTH options
• Dental insurance
• Vision insurance
• Employer paid disability insurance
• Life insurance and AD&D insurance
• Employee assistance program
• Flexible spending accounts
• Health savings account with employer contributions
• Accident, critical illness, hospital indemnity, and legal assistance
• Adoption assistance
• Domestic partner coverage

The salary range for this role reflects a wide range of factors including skill set, experience, training, and internal equity. It is not typical for individuals to be hired at the top of the range. The salary range is $120,000 - $173,000. Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor, or take over, sponsorship of an employment Visa at this time.