Futran Tech Solutions Pvt. Ltd.
Data Analyst
Futran Tech Solutions Pvt. Ltd., Dallas, Texas, United States, 75215
Job Description
Key Responsibilities: Interpret and analyze data from various source systems to support data integration and data reporting needs within XYZ. Identify, analyze, and interpret trends or patterns in complex data sets Work with team leads to prioritize business and information needs Prepare high-level ETL mapping specifications. Develop complex code data scripts (Primarily SQL and Golang, some Python) for ETL Troubleshoot & determine best resolution for data issues and anomalies Manage exploratory data analysis to support database and dashboard development, as well as advanced analytics efforts Assist in development of software technical documentation Design, specify, implement, and maintain systems using Agile scrum methodology. Person specification and skills required:
Hands-on experience in Data Platform / Warehouse / Lake engineering: source integration, pipeline development and analytics. Significant recent experience of Postgres (RDS) and Golang or Python. Excellent SQL skills, ideally PostgreSQL, PL/pgSQL. Knowledge of Indexing strategies and query tuning for performance (e.g. Explain Plans). Strong analytical skills with the ability to collect, organize, analyse, and disseminate significant amounts of information with attention to detail and accuracy Ability to clearly communicate capabilities, opportunities, and recommendations to both technical and nontechnical audiences Deep understanding of data architecture & data modelling best practices and guidelines for different data and analytic platforms.
Key Responsibilities: Interpret and analyze data from various source systems to support data integration and data reporting needs within XYZ. Identify, analyze, and interpret trends or patterns in complex data sets Work with team leads to prioritize business and information needs Prepare high-level ETL mapping specifications. Develop complex code data scripts (Primarily SQL and Golang, some Python) for ETL Troubleshoot & determine best resolution for data issues and anomalies Manage exploratory data analysis to support database and dashboard development, as well as advanced analytics efforts Assist in development of software technical documentation Design, specify, implement, and maintain systems using Agile scrum methodology. Person specification and skills required:
Hands-on experience in Data Platform / Warehouse / Lake engineering: source integration, pipeline development and analytics. Significant recent experience of Postgres (RDS) and Golang or Python. Excellent SQL skills, ideally PostgreSQL, PL/pgSQL. Knowledge of Indexing strategies and query tuning for performance (e.g. Explain Plans). Strong analytical skills with the ability to collect, organize, analyse, and disseminate significant amounts of information with attention to detail and accuracy Ability to clearly communicate capabilities, opportunities, and recommendations to both technical and nontechnical audiences Deep understanding of data architecture & data modelling best practices and guidelines for different data and analytic platforms.