Sr ETL Developer

Qualys, Inc is a pioneer and leading provider of disruptive cloud-based IT, security and compliance solutions with over 10,000+ active customers in more than 130 countries, including a majority of each of the Forbes Global 100 and Fortune 100. Qualys helps organizations streamline and consolidate their security and compliance solutions in a single platform and build security into digital transformation initiatives for greater agility, better business outcomes, and substantial cost savings.

The Qualys Cloud Platform and its integrated Cloud Apps deliver businesses critical security intelligence continuously, enabling them to automate the full spectrum of auditing, compliance, and protection for IT systems and web applications across on premises, endpoints, cloud, containers, and mobile environments.

As a BI ETL Developer, you’ll be responsible for designing data solutions, optimizing our data pipeline architecture, as well as developing infrastructure for data collection to support cross functional teams in the BI & Analytics Organization. You will also contribute towards building reports, dashboards and analytics for the entire organization including Product, Pricing, Finance, Sales and Marketing Teams. Your ability to creatively collaborate and execute team goals will affect scalability and directly contribute to the company growth and profitability.

Responsibilities

Plan, design, develop, test, implement, and maintain BI ETL pipeline in DWH environment.

Build the data model for optimal extraction, transformation, and loading of data from a wide variety of data sources.

Analyze source data using complex SQL queries to come up with best possible data model design and development.

Debug and tune ETLs, reports and dashboards by analyzing relevant SQL queries.

Optimize data systems to support our data initiatives, increase operational efficiency, improve collaboration and knowledge sharing.

Gather, analyze, and document business requirements and translate into technical specifications, prototypes, and end state products.

Work closely with Executive Management, Software Engineers, Data Engineers, Quality Engineers, and various cross functional team members to design, build, test, and maintain analytics solutions.

Requirements

4-7 years of proven experience in Data Warehousing, ETL and Business Intelligence.

Highly proficient in data analysis and troubleshooting skills with ability to write complex SQL queries.

Advanced SQL knowledge and in-depth ETL development experience.

Strong knowledge of Data Warehousing and Multidimensional Data Modeling.

Tableau or other reporting tool experience preferred.

Cloud based DWH & ETL Tool experience good to have

Strong ability to multi-task and meet deadlines.

Excellent verbal and written communication skills.

Work independently and self-learning without much guidance.

Experience in gathering and understanding requirements from executive management.

A successful history of integrating source systems and delivering self-serve Business Intelligence.

Education : BE, B.Tech, MCA in Computer Science, Engineering, Information Technology / Systems or another related discipline. Additional technical certifications are a plus.