Description:
A database developer who will be responsible for the design, development, implementation and on-going support of a data warehouse and broader reporting solution. Must be able to work on multiple projects simultaneously, including both enhancements as well as new project development. The database developer’s responsibilities will be to work directly with client leads to develop and deliver custom reporting solutions. The candidate must be a self-starter with a sense of urgency and a commitment to quality and professionalism.
Responsibilities:
> Analyze business requests and partner with stakeholders to provide a strategic solution
> Provide input on proposing, evaluating, and selecting appropriate design alternatives which meet requirements and are consistent with our current standards and processes
> Work with business support, project management and technical experts as required
> Extract, transform, and load data from multiple data sources using SSIS
> Design, Build, Test, Debug, Monitor, and Troubleshoot ETL and dashboard solutions
> Follow implementation standards
> Utilize source control tools
> Follow deployment process
> Serve as an escalation point for any issues that may arise
> Develop documentation and transfer of knowledge
Minimum Qualifications:
+ Minimum Bachelor’s Degree in Computer Sciences, Information Technology, or its equivalent
+ Minimum 5+ years’ experience with ETL and data warehouses
+ Minimum 2 - 3 years extensive work experience in the area of dashboard and static reports design, development, testing, and
support, preferably in an advertising/media agency
+ Minimum 2 - 3 years’ experience with SSIS/SSAS
+ Familiarity with cloud technologies such as Amazon Web Services (AWS)
+ Experience with complex processing logic
+ Experience with Business Intelligence software
+ Excellent data modelling skills and experience working with multiple datasets
+ Possession of strong communication and presentation skills as well as an analytical mindset
+ Good problem solving and testing skills
+ Advanced T-SQL programming skills (stored procedures, functions, etc.)
+ Experience working with big data technologies such as Hadoop(Hive) and MPP
+ Expert knowledge of Microsoft Excel, incl. Pivots, Word, PowerPoint
+ Possess a desire to work for a fast-paced, results-based company
+ Experience managing multiple projects simultaneously
+ Strong organizational skills & attention to detail
English Level: Upper intermediate
Shift time: Full time