Senior DWH Developer

Industry: Media & Entertainment

Location: Bucharest

Experience: Senior Level

Job type: Full Time

Who we are looking for

We are looking for individuals whose highest motivation comes from doing their best work, who are passionate about technology and have their eyes and minds open to fresh perspectives.

We enjoy working with people who enjoy solving problems, who love to get things done and move the product forward. That means contributing your own ideas, balancing perfectionism with efficacy and efficiency, and working as part of the team towards our shared goals.

The markets we play in are ever changing, so we expect you to do your part so that our team stays agile, expects the unexpected and never gives up.

The position

As a Senior DWH Developer you will be working with the latest cloud technologies to design and implement the next generation data pipelines, analytics and BI platform to support our innovative media platform covering video analysis and transcoding, behavior analytics and recommendation engines, bridging the gap between content and consumers.
This is a place where you will have the opportunity to take your knowledge to the next level and challenge yourself to become a full stack BI.

Primary Duties and Responsibilities:

• Maintain, design, and enhance our Data Warehouse
• Work on end-to end projects and flows from requirement to report
• Support and advise the Product and Project Manager team
• Keep up to date with the latest technologies and lead adoption initiatives

• Ensure and maintain data security and quality

• Participate in solutions design and review proposed solutions to ensure they meet accuracy, performance, usability, and business requirements
• Participate and contribute to the architecture design process
• Review other people’s code and design

Our technology and tools

• We build our infrastructure using Terraform and Serverless Framework
• We are a fully cloud-based company with a strong relationship with AWS, all our infrastructure is deployed in AWS
• We manage our code on GitHub
• We track our requirements and work using JIRA and Confluence
• Our cloud data warehouse is based on AWS Redshift
• We use AWS Redshift Spectrum and AWS Athena to analyze data from S3
• We also work with PostgreSQL
• Our data visualization tool is AWS QuickSight
• We use AWS API Gateway to ingest real time events
• We use AWS Lambda for serverless processing
• We use AWS Kinesis to collect, process, and analyze real-time, streaming data
• We use AWS Glue for ETL/ELT, schema introspection and orchestrator
• We use Python, PySpark, Spark and Node.js to build our ETL/ELT and processing services
• We also use SNS, SQS, Secrets Manager, IAM, CloudWatch, EventBridge, Step Functions, S3, etc

Your needed qualifications

• You have 5+ years’ experience of working in a similar position
• You have strong SQL Developer skills
• You have strong analytical and troubleshooting skills
• You are fluent in modeling, managing, scaling and performance tuning of high-volume data warehouse environments
• You have experience in working with structured and unstructured data
• You have experience with dimensional data modeling
• You can translate business questions and requirements into technical specifications
• You have excellent communication skills
• Language: Fluent written and spoken English

Preferred Qualifications:

• Experience with NoSQL databases
• Experience in development of data lake solutions
• BS/MS in Computer Science or equivalent
• Experience with analytics services from AWS
• Experience with Terraform, Serverless
• Experience working with external APIs to extract and import data
• Experience with languages such as TypeScript/JavaScript, Bash, Python, Spark, PySpark or other similar programming languages
• Experience and passion about data storytelling with appealing graphics and visualizations
• Experience with report development (SSRS, Power BI, Tableau, QuickSight, Excel, etc.)
• Self-learner and eager to learn new software tools/technologies

About Ateliere Creative Technologies (OWNZONES)

Ateliere began in 2010 as a content company focused on breaking the industry conventions of bundled linear content (much like today’s Amazon channels). After creating, launching, and operating over 400 digital channels, managing over 5 million assets, and distributing to over 25 countries, we realized our key to success was in the technologies we built and now offer as a solution. These products have made us the leader in cloud-based video supply chain solutions. Our transformative platform is built by a team of experts with decades of combined experience at companies such as Amazon, HBO, Netflix and Microsoft.

More at www.ateliere.com