Skip to content
×

Senior Data Architect

Job in Plano, Collin County, Texas, 75086, USA
Listing for: Amerch
Full Time, Part Time position Listed on 2026-11-13
Job specializations:
Salary/Wage Range or Industry Benchmark: 140000 - 210000 USD Yearly USD 140000.00 210000.00 YEAR

Job Description & How to Apply Below

WE ARE LOOKING FOR GREAT PEOPLE TO JOIN OUR TEAM- just like you! Our associates have a lot in common. They have great interpersonal skills, enjoy working independently, are self-motivated, and have a relentless drive. Did we mention that while they are working hard, they also like to have fun? We offer flexible hours, competitive pay, and great benefits for both full and part-time associates.

If this sounds like a good fit for you, come join our team!

As an Anderson Merchandisers Associate, you may be eligible for these benefits*.

  • Flexible work schedules
  • 401(k) retirement plan
  • Health Insurance - including Dental and Vision
  • Telehealth
  • Health Savings Account
  • Accident Insurance
  • Critical Illness Insurance
  • Life Insurance
  • Long Term Care
  • Short Term Disability
  • Long Term Disability
  • Associate Assistance Fund
  • Anderson Cares Natural Disaster Fund
  • Associate Savings Plan
  • Anderson Cares Fund
  • Paid Time Off
  • Discounts - Cell Phone, Vehicle, Pet Insurance
  • Training & Career Development

All benefits subject to eligibility per company policy.

A Senior Data Architect at Anderson Merchandisers will design, build, and continuously improve the architecture underlying our analytics and transactional data platforms. This senior-level, individual-contributor role reports to the Director of Information Systems and is expected to set technical direction and standards that the broader Software Development team follows, rather than manage people day-to-day. They will lead the design of our Google Big Query analytics data warehouse- defining schema, partitioning and clustering strategy, and data modeling standards that support reporting, dashboards, and ad hoc analysis across the business.

They will also serve as the senior technical advisor on our Google Cloud Spanner database layout as we consolidate our MySQL and Microsoft SQL Server transactional systems onto Spanner as our new system of record, consulting with development teams on schema design, indexing strategy, and scalability. They will partner with the Software Development Manager, Software Developers, ETL/Data Pipeline developers, analysts, and business stakeholders to ensure data is modeled consistently, efficiently, and securely across our Dash Management (PHP web UI), ETL, Salesforce, Workday, Dash Execution (Flutter mobile UI), and Big Query - our analytics reporting destination and Spanner (alongside MySQL and Microsoft SQL Server during the consolidation) as our primary transactional source systems.

They will design and develop our medallion (bronze/silver/gold) data architecture in Big Query and build the ETL/ELT pipelines needed to move and transform data from these source systems through each layer. They will serve as the primary liaison between the Information Systems department and the Analytics team, translating analytics reporting needs into IS-supported data architecture and keeping both groups aligned as requirements evolve.

What

would you do in this role?

Responsibilities and Duties
  • Designing and maintaining the Big Query analytics data warehouse layout, including dataset organization, table schema, partitioning, and clustering strategies to optimize query performance and cost.
  • Designing and developing a medallion (bronze/silver/gold) data architecture within Big Query, defining the structure and quality standards for each layer.
  • Writing and maintaining the ETL/ELT pipelines needed to move and transform data from Spanner, Salesforce, and Workday (and MySQL/Microsoft SQL Server during the consolidation) into Big Query's bronze, silver, and gold layers.
  • Consulting with development teams on Cloud Spanner database schema design, indexing, and interleaving strategy as our system of record, so it can support both transactional workloads and clean, reliable extraction into Big Query.
  • Advise on the consolidation of MySQL and Microsoft SQL Server transactional data onto Spanner, ensuring the resulting schema supports efficient downstream ETL/ELT into Big Query.
  • Defining and enforcing data modeling standards and naming conventions across analytics and operational databases.
  • Reviewing proposed schema changes across systems for downstream impact on reporting, analytics, and reconciliation processes.
  • Collaborating with business stakeholders and analysts to translate reporting requirements into sound, scalable data models.
  • Acting as the primary liaison between the Information Systems department and the Analytics team, facilitating regular communication and ensuring analytics needs are reflected in IS-supported data…

Position Requirements

10+ Years work experience
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction

Search for further Jobs Here:

SEARCH JOBS: 10+ Million Listings
(Try combinations for better Results! Or enter less keywords for broader Results)
Education Level
Experience Level (years)
Posted in last:
Salary