Data Analyst - Futran Tech Solutions Pvt. : Job Details

Data Analyst

Futran Tech Solutions Pvt.

Job Location : all cities,PA, USA

Posted on : 2024-11-07T19:34:29Z

Job Description :
Title - Data Analyst Location - Complete Remote (USA) Duration - 6 Months + possible extension Must have skills : SQL (Strong), Business Analyst mindset, Strong Communication skills, SQL Server Good to have skills: Python (Capable) Job Description :
  • 10+ years' experience in the data & analytics space Good communication skills.
  • Ability to articulate findings and challenges found in analysis and during SQL Development.
  • Ability to listen attentively to capture notes and feedback during requirements sessions, requirements Gathering & Business Acumen.
  • Experience collecting requirements from business stakeholders and translating into technical data requirements.
  • Ability to relate and understand how data supports business objectives and strategy.
  • Experience with building data analyst consumer facing data structures (tables, views, small data marts) Strong data analysis skills.
  • Experience with exploratory data analysis with new datasets.
  • Foundational descriptive statistics experience (e.g., mean, median, mode, standard deviation, skewness)
  • Experience with unit testing developed tables and views.
  • Experience with identifying and resolving data quality issues.
Technical Skills:
  • Strong general SQL experience & fluency CTEs, Window Functions, Joins, Group By, Where, Having, Stored Procedures / UDFs DDL/DML to create/alter/insert/delete tables and views.
  • AWS Cloud Data Analyst Experience Athena, S3, Glue, EMR Studio (for Jupyter Notebooks).
  • Foundational Data Modeling Knowledge & Concepts Star & Snowflake schema structures.
  • Slowly changing dimensions Normalization & Denormalization Data Warehouse / Data Lake / Data Lakehouse concepts.
  • Basic Python Experience Pandas, NumPy, SQL Alchemy, Requests (for API Requests).
  • Basic Spark Experience & Concepts Comfort with Spark SQL and using Spark data frames.
  • Foundational experience with creating and updating YAML-based configuration files.
  • Experience working in Jupyter Notebooks with SQL, Python, Spark SQL, Foundational API.
  • Experience Understanding of pagination and cursor concepts for retrieving multiple responses.
  • Experience using a tool like Postman, Curl statements, and/or the Python requests libraries to write requests (GET/POST) to retrieve and interpret sample payloads from APIs Basic Power BI. Experience Connecting to basic data sources (SQL Server, Snowflake, and ) Developing basic dashboard visualizations Connecting different data sources in the Power BI data model interface.
Apply Now!

Similar Jobs ( 0)