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.
ABOUT THIS TEAM
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.
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.
WHAT YOU’LL DO
- 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 data warehouse.
- Integrate third party data into the data warehouse like google analytics, google ads, Iterable
WHAT YOU’LL NEED
- Experience working as an ETL developer in a Data Engineering, Data Warehousing or Business Intelligence team
- Understanding of data integration/data engineering architecture and should be aware of ETL standards, methodologies, guidelines and techniques
- Hands on with python programming language and its packages like Pandas, NumPy
- Strong understanding of SQL queries, aggregate functions, Complex joins and performance tuning
- Should have good exposure of Databases like Redshift/SQL Server/Oracle/PostgreSQL (any one of these)
- Broad understanding of data warehousing and dimensional modelling concepts
EXPERIENCE-
- Software Engineer, ETL: 2.5 years+
Top Skills
What We Do
Since 2005, BOLD has established itself as a job seeker’s ally. Our goal is simple: We Transform Work Lives. We provide online products, tools, guidance, and support to help job seekers make their jobs, careers, and workplaces better.
BOLD’s more than 1,200 global team members in Engineering, Customer Engagement, Product, Marketing, Data Science, Design/UX, Research and Human Resources are passionate about helping people achieve their career dreams. Our team’s knowledge and expertise has resulted in award-winning AI-powered resume and cover letter builders, and job search tools that have empowered millions of job seekers in more than 180 countries to reach their professional goals.
From our headquarters in Puerto Rico, with remote and hybrid offices in India, Poland, and U.S. we’re a global organization on a path to change the career industry as we know it
