Senior ETL Developer

About the Company

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.

Job Summary

Qualys is seeking a skilled BI ETL Developer with 4-7 years of proven experience in Data Warehousing, ETL, and Business Intelligence. This role is crucial for designing data solutions, optimizing data pipeline architecture, and developing infrastructure for data collection. The ideal candidate will possess strong proficiency in data analysis, troubleshooting, and writing complex SQL queries, coupled with in-depth ETL development experience and knowledge of Multidimensional Data Modeling. Experience with Tableau or other reporting tools and Cloud based DWH & ETL Tools is highly valued. This position directly contributes to building essential reports, dashboards, and analytics, significantly impacting company growth and profitability.

About the Role

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.

Key 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.