Technical Lead - Data

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

Job summary

Psiog is a software services specialist focused on data, analytics and technology solutions. Chennai-based, Psiog serves global customers with data engineering, BI and cloud analytics across multiple industries.

The role involves designing ETL/ELT data solutions, building data models and dashboards, and partnering with stakeholders to deliver enterprise analytics. Strong SQL, Python/Java and cloud DW skills are required for growth within a dynamic team.

Qualifications

• 4+ years of data engineering and BI experience designing, developing and testing data solutions.
• 1+ years exposure to PowerBI/Tableau or similar cloud data visualization tools.
• 2+ years with 2+ databases (Snowflake/Redshift/Azure Synapse/Oracle/SQL Server/MySQL) and data integration.
• ETL/ELT and SQL coding using cloud DBs (Azure SQL, Synapse, Redshift, Snowflake).
• Star schema data modelling and ETL/ELT jobs for business use cases.
• Back-end data pipelines and enterprise analytics reporting experience.

Responsibilities

• Design and develop ETL/ELT jobs and star schema models to support analytics use cases.
• Build and maintain dashboards and back-end data pipelines for enterprise analytics.
• Explain data architectures to business stakeholders and data consumers.
• Develop scalable ETL/ELT processes using tools like ADF, Informatica or SSIS.
• Collaborate with data engineers, architects, and project managers on solutions.

Skills

ETL/ELT

SQL coding

Python

Java

Data modelling

Star schema

Cloud data warehousing

Reporting dashboards

Tools

Azure Synapse

Snowflake

Redshift

Azure SQL

SQL Server

MySQL

PowerBI

Tableau

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 comparabletools 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 integratetables 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 typicalbusiness domains.
  
• Design/Develop using best-practices techniques across data modelling, use of table-driven control oftransformation 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, businessanalysts and project managers to design, develop and execute business use-cases.
  
• Interface with adjacent teams, including business users, report readers, report developers, and otherdata 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 collaborationwith Business heads, Data engineers, Data & Enterprise architectsd. 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 architectureand build a user-friendly consumption layer to enable self-service analytics.
  
• Advanced understanding of SQL development in both stored procedures and leveraging ETL/ELTtools, 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 workindependently 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 aclear roadmap of Professional and Competency growth geared towards a career path with rewardingleadership opportunities.
  
• A unique opportunity to work with an Enterprise Data Management Centre across spectrum of datarelated technologies, with exposure to multiple domains and diverse customers in varying stages oftheir 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 softwaredelivery Implement and enforce best technology practices across the SDLC.
  
• Plenty of scope to experiment and innovate with technologies and ideas, supported by mentoring.