Location
Us, 50250 | France
Job description
Position: Data Analyst
Location: Remote
Must have skills : Power BI (Capable) Python (Capable) SQL (Strong) SQL Server Snowflake
Job Description:
- General Experience and Skills
- 4 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 SQLAlchemy Requests (for API Requests)
- Basic Spark Experience & Concepts
- Comfort with SparkSQL and using Spark data frames
- Foundational experience with creating and updating YAMLbased configuration files
- Experience working in Jupyter Notebooks with SQL Python SparkSQL
- 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.
Job tags
Salary