Data Architect

Psiog; Chennai District; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Psiog, a Chennai-based software services specialist, is seeking a data engineering and BI-focused professional. You will design and implement data solutions, dashboards and analytics pipelines across cloud platforms, partnering with stakeholders and engineering teams.

The role emphasizes building scalable ETL/ELT processes, data modelling, and enterprise reporting using tools like Power BI/Tableau and cloud warehouses.

Qualifications

• Minimum 4 years building data solutions in BI and data engineering.
• Experience with cloud data warehousing, visualization tools and multiple DB systems.
• Strong SQL skills and programming in Python/Java are preferred.

Responsibilities

• Design, develop, test and deploy data solutions for BI and analytics.
• Build star schemas, ETL/ELT jobs and data pipelines across domains.
• Develop dashboards and reporting solutions for enterprise analytics.
• Collaborate with stakeholders, data engineers and architects on designs.

Skills

Data engineering

Business intelligence

Power BI

Tableau

Azure Synapse

Snowflake

Redshift

SQL

Python

Java

Tools

ADF

Matillion

Informatica

SSIS

Job description

Psiog is a pure play software services specialist focusing on delivering technology services & solutions in the areas of operational efficiency & customer experience. Headquartered in Chennai, India, Psiog services global customers in North America, EMEA, ANZ & APAC across a variety of industries such as Manufacturing, Energy & Utilities, Hi-Tech, Financial Services, Retail and Automobile. Psiog’s core expertise is in building, implementing, testing, integrating & maintaining applications leveraging a variety of cutting‑edge tools & technologies.

Key service offerings for the mid‑market segment are:

• Has a minimum of 4 years of experience in Data engineering and business intelligence - designing, developing, testing, and implementing data solutions.
  
• 1+ years using/exposure to any of PowerBI/Tableau/Analysis Services data solutions, or comparable tools in in the cloud data warehousing, transformation, and visualization space.
  
• 2+ years of experience with more than 1 database system, such as Snowflake/Redshift, Azure Synapse, BigQuery, Oracle, SQL Server, MySQL Create and manage data source connections and integrate tables into Tabular models.
  

Required skills:

Technical:

• ETL/ELT and SQL coding using cloud‑based database solutions such as Azure SQL, Synapse, Redshift, Snowflake or similar tools.
  
• Design and develop star schema data models, and ETL/ELT jobs, to support use cases across typical business domains.
  
• Design/Develop using best‑practices techniques across data modelling, use of table‑driven control of transformation jobs, and dynamic ETL/ELT jobs that scale for expanding use cases.
  
• Establish and maintain reporting dashboard solutions for enterprise‑wide and executive analytics, including maintenance of back‑end transformation layers and data pipelines.
  
• Exposure to Programming languages, i.e., Python, Java, etc.
  

Non-Technical:

• Has worked closely with customer & business stakeholders, solution/technical architects, business analysts and project managers to design, develop and execute business use‑cases.
  
• Interface with adjacent teams, including business users, report readers, report developers, and other data engineers to establish a consistent and polished approach to coping, design, development & rollout of BI & Analytics solutions.
  
• Has taken part in high level design (HLD) and low‑level design (LLD) phases in close collaboration with Business heads, Data engineers, Data & Enterprise architects d. Experience handling client requirements and communication directly.
  
• Exceptional communication, analytical, conceptual, and problem‑solving abilities.
  

Requirements

Preferred skills:

Technical:

• EAI or designing/developing a distributed systems architecture experience a plus.
  
• Knowledge & implementation of role and row‑based security across all layers of the data architecture and build a user‑friendly consumption layer to enable self‑service analytics.
  
• Advanced understanding of SQL development in both stored procedures and leveraging ETL/ELT tools, such as ADF, Matillion, Informatica, SSIS.
  
• Knowledge of API‑led connectivity, Microservices, events‑based integration a plus.
  

Non-Technical:

• Ability to work with abstract problem statements in ambiguous customer environments and work independently and provide technical leadership to the IT team.
  
• Ability to work on solutioning, technical architecture, high‑level design and low‑level design for cloud & on‑prem databases & applications and systems’ integration.
  

What Psiog offers:

• Be a part of a niche Technology focused unit called TAC (Technology advisory council) offering a clear roadmap of Professional and Competency growth geared towards a career path with rewarding leadership opportunities.
  
• A unique opportunity to work with an Enterprise Data Management Centre across spectrum of data related technologies, with exposure to multiple domains and diverse customers in varying stages of their data management journey.
  
• Play a role across projects to help with technology mentoring, troubleshooting, architecture design, code reviews.
  
• Research, evaluate and recommend tools, technologies, and processes to ensure high quality software delivery Implement and enforce best technology practices across the SDLC.
  
• Plenty of scope to experiment and innovate with technologies and ideas, supported by mentoring.