Bachelor's or Master's degree in Computer Science, Information Technology, or related field.
8+ years of experience in data engineering, data modeling, or data architecture, with 2-3 years focused on data modeling or architecture work.
Strong data modeling skills with experience in tools like erwin, ER/Studio, or SqlDBM.
Hands-on experience with cloud data platforms such as Snowflake or Databricks, and familiarity with ETL and data catalog tools.
Advanced SQL skills.
Understanding of data governance, quality, and security concepts.
Strong analytical and problem-solving skills, able to communicate technical designs to diverse audiences.
Experience with Agile development practices, particularly Scrum.
Responsibilities
Design and document conceptual, logical, and physical data models for data warehousing platforms.
Translate business and analytical requirements into data architecture designs.
Define integration patterns for diverse data sources like Oracle and MongoDB.
Contribute to the design of batch and real-time ingestion architectures using various tools.
Develop and maintain architectural standards and reference architectures.
Support data governance through metadata management and data quality practices.
Review data engineering designs to ensure adherence to architectural standards and identify performance issues.
Troubleshoot complex data issues related to modeling or architecture.
Participate in Agile practices, including Scrum ceremonies and sprint planning.
Utilize AI-enabled tools for design and documentation tasks.
Benefits
Comprehensive medical coverage and virtual wellness classes.
Tuition reimbursement and 401(k) with employer match.
Paid time off, company holidays, and work-life balance programs.
Award-winning training and development programs for career growth.
Paid time off for volunteerism and support for community initiatives.
Full Job Description
Overview
As a Data Architect Level 1, you will help design and maintain the data architectures behind our analytics and operational platforms. You will turn business requirements into data models, integration patterns and architectural standards, and work closely with data engineering and software development teams to make sure solutions are scalable, secure, and well governed. You will use AI-enabled tools for design, documentation, and proof-of-concept (POC) work.
Responsibilities
Design and document conceptual, logical, and physical data models (dimensional, normalized and Data Vault) for data warehousing platforms such as Snowflake and Databricks.
Translate business and analytical requirements into data architecture designs, working with product owners, analysts, data engineering, and software development teams.
Define integration patterns for diverse data sources, including Oracle, SQL Server, MongoDB, and PostgreSQL.
Contribute to the design of batch and real-time ingestion architectures using tools like Informatica, DBT, Oracle GoldenGate, OpenFlow, Maia (Matillion) and Kafka.
Develop and maintain architectural standards, naming conventions, design patterns, and reference architectures.
Support data governance by applying metadata management, data cataloging, data lineage, data quality, and data security practices (for example, access controls and PII classification) using tools such as Atlan.
Review data engineering designs and pipelines to confirm they follow architectural standards and to find performance and scalability problems.
Help troubleshoot complex data issues where root causes involve data modeling or architecture.
Work within Agile practices: take part in Scrum ceremonies and backlog refinement, and give architectural input during sprint planning.
Use AI-enabled tools, such as GitHub Copilot, for design, documentation, and POC work.
Qualifications
Bachelor's or Master's degree in Computer Science, Information Technology or a related field.
8+ years of experience in data engineering, data modeling, or data architecture, with at least 2-3 years focused on data modeling or architecture work.
Strong data modeling skills and experience with modeling tools (e.g., erwin, ER/Studio, SqlDBM).
Hands-on experience with cloud data platforms such as Snowflake or Databricks, and familiarity with the ETL, streaming and data catalog tools listed in the responsibilities.
Advanced SQL skills.
Understanding of data governance, data quality, and data security concepts.
Strong analytical and problem-solving skills, with the ability to explain technical designs to both technical and business audiences.
Experience with Agile development practices, particularly Scrum.
Compensation
In the spirit of pay transparency, we are excited to share that the base pay range for this position is $111,000 - $174,500 per year. Please keep in mind that this range is the base pay only and does not consider other components that make up the total rewards package for the position. If you are hired at Paychex, your overall compensation will be determined based on factors such as geographic location, skills, education, and/or experience which may result in total compensation outside of this range.
What's in it for you?
We value your well-being: We provide over 21 comprehensive rewards, including medical coverage, virtual wellness classes, tuition reimbursement, 401(k) + employer match, adoption assistance, financial assistance, and much more.
We value your time: From paid time off to company holidays, culture days, and comprehensive work-life balance programs, we will ensure you have the flexibility you need to be your best.
We value your development: Our award-winning training and development programs empower our employees with ongoing learning opportunities to give you the building blocks to grow your career.
We value your perspective: Our company culture reflects the diversity of our employees. We want you to be you and your voice to be heard.
We value our communities: We offer paid time off for volunteerism and promote many company-wide and local initiatives that benefit organizations you care about.
Note: The benefits described apply to full-time employees. Benefits for part-time, contract, and intern roles may vary.
Not sure if you meet every requirement?
At Paychex, we know that great talent comes in many forms. If you're passionate about the role but don't check every box, we still encourage you to apply. You might be the right fit - either for this position or another opportunity with us.
About Paychex
Paychex, Inc. is a leading provider of integrated human capital management solutions for payroll, benefits, human resources, and insurance services. By combining its innovative software-as-a-service technology and mobility platform with dedicated, personal service, Paychex empowers small- and medium-sized business owners to focus on the growth and management of their business. Paychex is headquartered in Rochester, New York and has more than 100 locations across the United States and Europe.