Remote Data Warehouse Jobs in Rochester, NY (NOW HIRING)

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.