Data Engineer

Psiog; Chennai District; On-site; INR 900,000 - 1,500,000; Full time

Benefits offered by this job

Career growth

Mentoring

Enterprise data management exposure

Tech mentoring

Job summary

Psiog is seeking a Data Engineering and BI specialist to design, develop, test, and implement data solutions across cloud platforms, delivering enterprise analytics.

You will build star schemas and ETL/ELT pipelines, create dashboards with PowerBI/Tableau, and work with data engineers, architects, and stakeholders to enable self-service analytics and informed decision making. This role offers mentoring and exposure to diverse domains within Psiog.

Qualifications

• Experience designing, developing, testing and implementing data solutions.
• Experience with cloud data warehousing, transformation and visualization.
• Hands-on experience with multiple databases and data source integration.
• Strong communication with stakeholders and project managers.

Responsibilities

• Design star schemas and ETL/ELT jobs to support analytics.
• Establish and maintain dashboards and data pipelines for enterprise analytics.
• Collaborate with architects, data engineers and business users on use cases.
• Contribute to high- and low-level design in cloud and on-prem environments.

Skills

ETL/ELT

SQL coding

Python

Stakeholder collaboration

Cloud data experience

Tools

PowerBI

Tableau

Azure Synapse

Snowflake

Redshift

BigQuery

SSIS

Informatica

Matillion

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.