Software Engineer/Senior Software Engineer- ETL

Role Overview: As an ETL Specialist at BOLD, you will be responsible for building the architecture and maintaining a robust, scalable, and sustainable business intelligence platform. Working closely with the Data Team, you will be handling highly scalable systems, complex data models, and a large amount of transactional data. Key Responsibilities: - Architect, develop, and maintain a highly scalable data warehouse and build/maintain ETL processes - Utilize Python and Airflow to integrate data from across the business into the data warehouse - Integrate third party data into the data warehouse like Google Analytics, Google Ads, Iterable Qualifications Required: - Experience working as an ETL developer in a Data Engineering, Data Warehousing, or Business Intelligence team - Understanding of data integration/data engineering architecture and familiarity with ETL standards, methodologies, guidelines, and techniques - Proficiency in Python programming language and its packages like Pandas, NumPy - Strong understanding of SQL queries, aggregate functions, complex joins, and performance tuning - Exposure to Databases like Redshift/SQL Server/Oracle/PostgreSQL (any one of these) - Broad understanding of data warehousing and dimensional modeling concepts Additional Details: At BOLD, the Business Intelligence (BI) team is responsible for managing all aspects of the organization's BI strategy, projects, and systems. The BI team enables business leaders to make data-driven decisions by providing reports and analysis. It plays a crucial role in developing and managing a latency-free credible enterprise data warehouse, serving as a data source for decision-making across various functions of the organization. The team comprises sub-components focusing on Data analysis, ETL, Data Visualization, and QA, leveraging technologies like Snowflake, Sisense, Microstrategy, Python, R, and Airflow for operations. About BOLD: BOLD is a global organization that helps people find jobs and transform their work lives. The company creates digital products that empower individuals worldwide to build stronger resumes, cover letters, and CVs. With a strong focus on diversity and inclusion, BOLD celebrates and promotes a culture of growth, success, and professional fulfillment for its employees.,