Position: Data Analyst/ DWH Developer
Company: Art2Hire
Category: Data Engineer
Experience required: 5y
English level: upper

Our client, a technology company dedicated to simplifying digital security for consumers, is now looking for Data Analyst/DWH Developer to join their team.

Location: Ukraine
Type: Remote, full-time
Start date: ASAP
About company and role:

It's a US-based technology company dedicated to simplifying digital security for consumers. Committed to creating a unified platform of services,  uses adaptive technology to enable customers to manage disparate cybersecurity needs with ease.

Trusted by more than 2 million customers, the company has a team of more than 450 people worldwide and revenues of over $200 million. Most importantly, this trajectory continues to show momentum and is supported by strong organic growth in addition to strategic customer acquisition. The company`s leadership team has seen similar success before, having grown a start-up to a valuation of over $3 billion before exit. 

We are now looking for a data analyst who designs, develops, and maintains data warehouse and analytics architecture to meet an enterprise’s business analysis and reporting needs. 

Responsibilities include but are not limited to:

Datamart development in accordance with internal data architecture
Design of robust data transformation process from raw logs to aggregate tables, ready to use by analysts
Maintenance of Daily ETL and alerting system in order to ensure that up to date reporting is providing
Developing a process around the unification of different data sources (API, S3 files, G sheet data, etc.)
Requirements:
Proficient in SQL with 5+ years of experience
Excellent interpretation of complex statistical data
Strong knowledge of statistics, data analysis and databases
Experience with at least one RDBMS (MySQL, PostgreSQL, SQL Server, Oracle, DB2)
Experience in ETL/ELT processes design, development, and maintenance
Experience in DWH modeling and Data Mart design
Knowledge of at least one of the programming languages(Python/Scala will be a plus)
Experience with at least one VCS (Git, SVN, etc.)
Experience working in an Agile/Scrum development process
Experience transforming data in various formats, including JSON, XML, CSV, and zipped files;
Upper intermediate or above level of English
Detailed oriented/self-motivated with the ability to learn and deploy new technology quickly.
English - Upper Intermedia+