Technical Architect

Score Code Technologies•Ohio City, OH

About The Position

The Technical Lead / Technical Consultant is a core role and focal point of the project team responsible for the whole technical solution and managing the day-to-day delivery. The role will focus on the technical solution architecture, detailed technical design, coaching of the development/implementation team, and governance of the technical delivery. Technical ownership of the solution from bid inception through implementation to client delivery, followed by after-sales support and best practice advice. Interactions with internal stakeholders and clients to explain technology solutions and a clear understanding of client s business requirements through which to guide optimal design to meet their needs.

Requirements

Database (one or more of MS SQL Server, Oracle, Cloud SQL, Cloud Spanner, etc.)
Data Warehouse (one or more of Big Query, SnowFlake, etc.)
ETL tool (two or more of Cloud Data Fusion, Dataflow, Dataproc, Pub/Sub, Composer, Cloud Functions, Cloud Run, etc.)
Experience in Cloud platforms – GCP
Python, PySpark
Project & resource management
SVN, JIRA, Automation workflow (Composer, Cloud Scheduler, Apache Airflow, Tidal, Tivoli or similar)
Bachelor's or Master's Degree in Computer Science
>= 7 years of IT experience

Nice To Haves

UNIX shell scripting
SnowFlake
Redshift
Familiar with NoSQL such as MongoDB, etc
ETL tool (Databricks / AWS Glue / AWS Lambda / Amazon Kinesis / Amazon Firehose / Azure Data Factory / ADF / DBT / Talend, Informatica, IICS (Informatica cloud) )
Experience in Cloud platforms – AWS / Azure
Client-facing skills

Responsibilities

Design simple to medium data solutions for clients by using cloud architecture using GCP
Strong understanding of DW, data mart, data modeling, data structures, databases, and data ingestion and transformation.
Working knowledge of ETL as well as database skills
Working knowledge of data modeling, data structures, databases, and ETL processes
Strong understanding of relational and non-relational databases and when to use them
Leadership and communication skills to collaborate with local leadership as well as our global teams
Translating technical requirements into ETL/ SQL application code
Document project architecture, explain the detailed design to the team, and create low-level to high-level design
Create technical documents for ETL and SQL developments using Visio, PowerPoint, and other MS Office package
Engage with Project Managers, Business Analysts, and Application DBA to implement ETL Solutions
Perform mid to complex-level tasks independently
Support Clients, Data Scientists, and Analytical Consultants working on marketing solution
Work with cross-functional internal teams and external clients
Strong project management and organization skills
Ability to lead 1 – 2 projects of team size 2 – 3 team members.
Code management systems which include Code review, deployment, cod
Work closely with the QA / Testing team to help identify/implement defect reduction initiatives
Work closely with the Architecture team to make sure Architecture standards and principles are followed during development
Performing Proof of Concepts on new platforms/validating proposed solutions
Work with the team to establish and reinforce disciplined software development, processes, standards, and error recovery procedures are deployed
Must understand software development methodologies including waterfall and agile
Distribute and manage SQL development
Work across the team
Willing to work during overlapping hours with US-based teams to ensure effective collaboration and communication, typically between [e.g., 6:00 PM to 11:00 PM IST], depending on project needs.