Senior Analyst, Project Support - Strategic Operations
Skills
Front-End DevelopmentAdoptionAmazon RedshiftBusiness IntelligenceMicrosoft SurfaceModelingSchemas
What the job involves
The main requirements, responsibilities and hiring steps.
Requirements
- Three years professional experience in analytics or data-engineering roles
- Experience authoring complex SQL in Redshift SQL Server or MySQL and stored procedures
- Two years coding development experience with macros automation and PivotTables
- Proficient in Python including ETL frameworks pandas and NumPy
- Advanced Excel skills including Power Query and functions
- Experience eliciting requirements for KPI frameworks and reporting structures
- Ability to travel up to 10 percent
Nice to have
- Cross-functional mindset
- Analytical thinking
- Knowledge sharing
- Project management
- Data modeling awareness
- BI tool familiarity
Day to day
- Develop Python-based ETL pipelines to create reports and analytical tools.
- Write complex SQL queries and stored procedures for data extraction aggregation and reporting.
- Build Excel-based financial and operational tools using VBA macros and Power Query automation.
