Senior Software Engineer- ETL

<p><span style="font-weight: 400;">BOLD is seeking an ETL Specialist who will help build the architecture and maintain a robust, scalable, and sustainable business intelligence platform. Assisted by the Data Team, this role will work with highly scalable systems, complex data models, and a large amount of transactional data.</span></p> <p><strong>ABOUT THIS TEAM</strong></p> <p><span style="font-weight: 400;">BOLD Business Intelligence(BI) team is a centralized team responsible for managing all aspects of the organization's BI strategy, projects and systems. BI team enables business leaders to make data-driven decisions by providing reports and analysis. The team is responsible for developing and manage a latency-free credible enterprise data warehouse which is a data source for decision making and input to various functions of the organization like Product, Finance, Marketing, Customer Support etc.</span></p> <p><span style="font-weight: 400;">BI team has four sub-components as Data analysis, ETL, Data Visualization and QA. It manages deliveries through Snowflake, Sisense and Microstrategy as main infrastructure solutions. Other technologies including Python, R, Airflow are also used in ETL, QA and data visualizations.</span></p> <p><strong>WHAT YOU’LL DO</strong></p> <ul> <li style="font-weight: 400;"><span style="font-weight: 400;">Architect, develop, and maintain a highly scalable data warehouse and build/maintain ETL processes.</span></li> <li style="font-weight: 400;"><span style="font-weight: 400;">Utilize Python and Airflow to integrate data from across the business into data warehouse.</span></li> <li style="font-weight: 400;"><span style="font-weight: 400;">Integrate third party data into the data warehouse like google analytics, google ads, Iterable </span></li> </ul> <p><strong>WHAT YOU’LL NEED</strong></p> <ul> <li style="font-weight: 400;"><span style="font-weight: 400;">Experience working as an ETL developer in a Data Engineering, Data Warehousing or Business Intelligence team</span></li> <li style="font-weight: 400;"><span style="font-weight: 400;">Understanding of data integration/data engineering architecture and should be aware of ETL standards, methodologies, guidelines and techniques </span></li> <li style="font-weight: 400;"><span style="font-weight: 400;">Hands on with python programming language and its packages like Pandas, NumPy</span></li> <li style="font-weight: 400;"><span style="font-weight: 400;">Strong understanding of SQL queries, aggregate functions, Complex joins and performance tuning</span></li> <li style="font-weight: 400;"><span style="font-weight: 400;">Should have good exposure of Databases like Redshift/SQL Server/Oracle/PostgreSQL (any one of these)</span></li> <li style="font-weight: 400;"><span style="font-weight: 400;">Broad understanding of data warehousing and dimensional modelling concepts </span></li> </ul> <p><strong>EXPERIENCE- </strong></p> <ul> <li><span data-sheets-value="{"1":2,"2":"ASE: 2 to 3 YRs\nSE: 3 to 4.5 Yrs\nSSE: 4.5 to 6 yrs"}" data-sheets-userformat="{"2":15293,"3":{"1":0},"5":{"1":[{"1":2,"2":0,"5":{"1":2,"2":0}},{"1":0,"2":0,"3":3},{"1":1,"2":0,"4":1}]},"6":{"1":[{"1":2,"2":0,"5":{"1":2,"2":0}},{"1":0,"2":0,"3":3},{"1":1,"2":0,"4":1}]},"7":{"1":[{"1":2,"2":0,"5":{"1":2,"2":0}},{"1":0,"2":0,"3":3},{"1":1,"2":0,"4":1}]},"8":{"1":[{"1":2,"2":0,"5":{"1":2,"2":0}},{"1":0,"2":0,"3":3},{"1":1,"2":0,"4":1}]},"10":2,"11":4,"12":0,"14":{"1":2,"2":0},"15":"Calibri, sans-serif","16":11}">Senior Software Engineer, ETL- 4.5 years+</span></li> </ul> <p><span data-sheets-value="{"1":2,"2":"ASE: 2 to 3 YRs\nSE: 3 to 4.5 Yrs\nSSE: 4.5 to 6 yrs"}" data-sheets-userformat="{"2":15293,"3":{"1":0},"5":{"1":[{"1":2,"2":0,"5":{"1":2,"2":0}},{"1":0,"2":0,"3":3},{"1":1,"2":0,"4":1}]},"6":{"1":[{"1":2,"2":0,"5":{"1":2,"2":0}},{"1":0,"2":0,"3":3},{"1":1,"2":0,"4":1}]},"7":{"1":[{"1":2,"2":0,"5":{"1":2,"2":0}},{"1":0,"2":0,"3":3},{"1":1,"2":0,"4":1}]},"8":{"1":[{"1":2,"2":0,"5":{"1":2,"2":0}},{"1":0,"2":0,"3":3},{"1":1,"2":0,"4":1}]},"10":2,"11":4,"12":0,"14":{"1":2,"2":0},"15":"Calibri, sans-serif","16":11}">#LI-Hybrid</span></p> <p> </p><div class="content-conclusion"><p><strong data-stringify-type="bold">About Bold</strong><br><strong>We Transform Work Lives</strong><br>As an established global organization, BOLD helps people find jobs. Our story is one of growth, success, and professional fulfillment. We create digital products that have empowered millions of people in 180 countries to build stronger resumes, cover letters, and CVs. The result of our work helps people interview confidently, finding the right job in less time. Our employees are experts, learners, contributors, and creatives.</p> <p><strong>We Celebrate And Promote Diversity And Inclusion</strong><br>We value our position as an Equal Opportunity Employer. We hire based on qualifications, merit, and our business needs. We don't discriminate regarding race, color, religion, gender, pregnancy, national origin or citizenship, ancestry, age, physical or mental disability, veteran status, sexual orientation, gender identity or expression, marital status, genetic information, or any other applicable characteristic protected by law.<br><br>Under San Francisco's Fair Chance Ordinance, qualified applicants with arrest and conviction records will be considered for the position.</p></div>