Technical Architect

Score Code Technologies•Ohio City, OH

About The Position

The Technical Lead / Technical Consultant is a core member and focal point of the project team, responsible for the overall technical solution and day-to-day delivery. The role focuses on solution architecture, detailed technical design, coaching the development and implementation team, and governing technical delivery. It provides technical ownership from bid inception through implementation and client delivery, followed by after-sales support and best-practice advice. The role involves working with internal stakeholders and clients to explain technology solutions and understand business requirements so that the solution design meets client needs. The position designs simple-to-medium data solutions using GCP cloud architecture and supports clients, data scientists, and analytical consultants working on marketing solutions. It translates technical requirements into ETL and SQL application code, documents architecture and detailed designs, and contributes to proofs of concept and solution validation. The candidate must be willing to work overlapping hours with US-based teams, typically between 6:00 PM and 11:00 PM IST depending on project needs.

Requirements

  • Bachelor's or master's degree in Computer Science.
  • At least 7 years of IT experience.
  • Experience with one or more databases, such as MS SQL Server, Oracle, Cloud SQL, or Cloud Spanner.
  • Experience with one or more data warehouse technologies, such as BigQuery or Snowflake.
  • Experience with two or more ETL tools or services, such as Cloud Data Fusion, Dataflow, Dataproc, Pub/Sub, Composer, Cloud Functions, or Cloud Run.
  • Experience with GCP cloud platforms.
  • Python and PySpark skills.
  • Project and resource management skills.
  • Experience with SVN and JIRA.
  • Experience with workflow automation tools such as Composer, Cloud Scheduler, Apache Airflow, Tidal, Tivoli, or similar.
  • Strong understanding of data warehouses, data marts, data modeling, data structures, databases, and data ingestion and transformation.
  • Working knowledge of ETL and database skills and processes.
  • Strong understanding of relational and non-relational databases and when to use them.
  • Leadership and communication skills to collaborate with local leadership and global teams.
  • Strong project management and organizational skills.
  • Understanding of software development methodologies, including waterfall and agile.
  • Willingness to work overlapping hours with US-based teams, typically between 6:00 PM and 11:00 PM IST depending on project needs.

Nice To Haves

  • Unix shell scripting.
  • Snowflake or Redshift experience.
  • Familiarity with NoSQL databases such as MongoDB.
  • Experience with ETL tools such as Databricks, AWS Glue, AWS Lambda, Amazon Kinesis, Amazon Firehose, Azure Data Factory, DBT, Talend, Informatica, or IICS (Informatica Cloud).
  • Experience with AWS or Azure cloud platforms.
  • Client-facing skills.

Responsibilities

  • Design simple-to-medium client data solutions using GCP cloud architecture.
  • Own the technical solution from bid inception through implementation and client delivery, and provide after-sales support and best-practice advice.
  • Manage day-to-day technical delivery and govern the technical solution.
  • Coach the development and implementation team.
  • Explain technology solutions to clients and internal stakeholders, and use client business requirements to guide solution design.
  • Translate technical requirements into ETL and SQL application code.
  • Document project architecture, explain detailed design to the team, and create low-level and high-level designs.
  • Create technical documentation for ETL and SQL development using Visio, PowerPoint, and other Microsoft Office applications.
  • Engage with project managers, business analysts, and application DBAs to implement ETL solutions.
  • Perform mid- to complex-level tasks independently.
  • Support clients, data scientists, and analytical consultants working on marketing solutions.
  • Collaborate with cross-functional internal teams and external clients, including local leadership and global teams.
  • Lead one or two projects with teams of two to three members.
  • Manage code through code review and deployment processes.
  • Work with the QA/testing team to identify and implement defect-reduction initiatives.
  • Work with the architecture team to ensure architecture standards and principles are followed during development.
  • Perform proofs of concept on new platforms and validate proposed solutions.
  • Establish and reinforce disciplined software development processes, standards, and error-recovery procedures with the team.
  • Apply software development methodologies, including waterfall and agile.
  • Distribute and manage SQL development.
  • Work overlapping hours with US-based teams, typically 6:00 PM to 11:00 PM IST depending on project needs.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service