HiPublic

We are looking for a Data Analyst for our products in the eSports industry.

Location: all over the world.

Team: Senior Data Analyst, BI Analyst.

Who will the candidate directly interact with: Head of Analytics.

Requirements:

• 3+ years of experience in Data Analytics / Business Intelligence with large-scale datasets.
• Advanced hands-on experience with SQL, ClickHouse, and relational databases.
• Strong experience building and optimizing dashboards and reports in Tableau.
• Experience delivering end-to-end analytics solutions and translating data into actionable business insights.
• Experience ensuring data quality, consistency, and governance standards.
• Experience owning analytics for a project or business unit.
• Experience in gaming, eSports, or high-load transactional environments is preferred.
• English- sufficient for professional communication and documentation.
• Ukrainian or Russian — Upper-Intermediate+ / Advanced (for internal communication).

Required education/Training background:

• Strong academic foundation in databases and SQL, statistics and probability, data analysis and modeling, and information systems architecture.

Will be an advantage:

• Proven experience integrating, transforming, and migrating data across multiple systems (ETL/ELT).

List of technologies:

• SQL (PostgreSQL, MySQL, SQL Server, Oracle).
• ClickHouse.
• ETL/ELT tools.

Responsibilities:

• Take full ownership of analytics for a specific project or business unit.
• Collect, clean, and transform data from multiple databases and sources.
• Design, create, and maintain database tables, views, queries, and data models.
• Integrate and migrate data across different systems and databases (ETL/ELT).
• Build, maintain, and optimize dashboards and reports in Tableau.
• Conduct in-depth data analysis and translate results into actionable business insights.
• Ensure data quality, consistency, and governance across all datasets.

Key Deliverables:

• High-quality dashboards and reports in Tableau.
• Analytical research and insights that inform business decisions.

What we could offer:

• 24 days of paid leave per year.
• 100% paid sick leave.
• Salary range: $2000-$5000 USD (depending on skills and experience).
• Full-time remote.
• Long-term collaboration.
• Sustainable business.
• Game and entertainment development company.

Stages:

• HR interview (1 hour).
• Test task.
• Technical interview (1 hour).

We are looking for a Copywriter for our product in the eSports industry.

Location: all over the world.

Team: SMM Lead, SMM Junior/Copywriter, Moder/Poster, Streamer, 3 Designers, Videomaker, 2 Account Managers.

Who will the candidate directly interact with: SMM Lead.

Requirements:

• 1+ year of experience in a similar role.
• Strong knowledge of mobile gaming and esports (Standoff 2, PUBG Mobile).
• Creating copy for social media, marketing newsletters, and push notifications.
• Strong understanding of "Gen Z" culture, trends, and communication style.
• Experience working with a specific target audience and understanding its needs.
• Collaborating with the SMM Manager on creatives, scripts, and accompanying copy.
• Participating in brainstorming sessions for planned content creation.
• Strong writing skills, attention to detail, and creativity.
• Flexible schedule with high availability and responsiveness.
• Excellent command of Ukrainian or Russian and strong writing skills.
• Strong English proficiency.

Will be an advantage:

• Relevant courses and related experience.
• Proficiency in Figma and cross-functional collaboration with designers on visual assets.

List of technologies:

• Advanced proficiency in Google Sheets, Google Forms, and Google Docs.
• Experience working with the Discord platform.

Responsibilities:

• Creating copy in accordance with the approved content plan.
• Writing copy for push notifications and pop-up messages.
• Participating in brainstorming sessions and co-developing content plans with the SMM team.
• Preparing copy for unplanned activities and project-related events.

What we could offer:

• 24 days of paid leave per year.
• 100% paid sick leave.
• Fixed-rate 700-800$.
• Full-time remote.
• Long-term collaboration.
• Sustainable business.
• Game and entertainment development company.

Stages:

• HR interview (1 hour).
• Test task.
• Technical interview (1 hour).

Hello, we are looking for a 2D-3D Designer for our products in the eSports industry.

Location: remotely.

Team: Head Of SMM, Team Lead Designer

Requirements:

• 2 years of commercial experience as a 2D-3D Designer.
• Advanced skills in Adobe Photoshop and Figma.
• Knowledge and experience with Adobe Illustrator and After Effects.
• Knowledge and experience with 3D instruments ( Blender 3D,  3ds Max).
• Experience working with AI-powered creative tools.
• Ability to create high-quality designs.
• Ability to work independently and in a team. 
• Manage multiple tasks with tight deadlines.
• English level: Intermediate or higher.
• Knowledge or experience with the CS2 sphere.

Responsibilities:

• Development of visuals for various marketing areas:
• Create promo materials, and marketing visuals for web projects, social media, and advertising campaigns.
• Development of templates and creatives for marketing departments:
• Design banners, landing visuals, icons, and other digital assets aligned with brand guidelines.
• Collaborate with cross-functional teams (design, marketing, development) to ensure cohesive brand visuals.

What we could offer:

• 24 days of paid leave per year.
• 100% paid sick leave.
• Fixed-rate + bonuses.
• Full-time remote.
• Long-term collaboration.
• Sustainable business.
• Game and entertainment development company.

Stages:

• Portfolio showcasing strong artistic and technical skills
• Test task.
• Technical interview.