Project Lead-ETLat BOLD (View all jobs)
Noida, Uttar Pradesh, India
BOLD is an established and fast-growing product company that transforms work lives. Since 2005, BOLD has delivered award-winning career services that have a meaningful and positive impact on job seekers and employers. BOLD’s robust product line includes a professional resume and cover letter writing services, scientifically validated career tests, and employer tools that help companies hire, onboard, and communicate with their staff.
BI (Business Intelligence) is all about making dry figures accessible and useful to the right audience. Our team is working on latest tools for ETL, reporting, analysis and is providing performance monitoring and insights via dashboards, scorecards and ad hoc analysis which help create Customer Engagement reporting and modelling using our event stream.
- Architect, develop, and maintain a highly scalable data warehouse and build/maintain ETL processes.
- Utilize Python and Airflow to integrate several heterogeneous operational systems across the business into cloud based data warehouse (snowflake/redshift).
- Integrate third party data like google analytics, google ads, bing ads, email marketing platform (like Iterable, hubspot and blueshift) , customer contact platforms (like Five9, Avaya, Salesforce)
- Responsible for High level & low-level Data flow design.
- Collaborate in dimension model design and data layer for end user querying.
- Co-ordinate with upstream system owners and downstream system owners to keep data warehouse implementation and changes in synch.
- Lead, train and mentor a team of data engineers.
- 7+ years of experience in understanding of best practices for building and designing ETL code
- Experience working as an ETL resource 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/Snowflake/SQL Server/Oracle/PostgreSQL (any one of these)
- Broad understanding of data warehousing and dimensional modelling concepts
- Good to have experience on Apache Airflow for scheduling the data pipeline jobs.
BOLD is a fast-paced, product company founded by two entrepreneurs passionate about helping people achieve their dreams. We stand together as a team empowering people to reach their professional aspirations. With our headquarters in Puerto Rico and offices in San Francisco and India, we’re a global organization on a path to change the career industry . Our vision is to revolutionize the online career world by creating transformational products that help people find jobs and companies hire the best candidates. A career at BOLD promises great challenges, opportunity, culture and the environment and you forge your own path ahead. Join us and discover what a great place BOLD is!
WHAT WE DO...
Since 2005, we’ve helped more than 10,000,000 folks from all over America (and beyond!) to reach higher and to do better. With multiple online destinations providing successful and effective products and services, we’re partners along the way- from building successful resume to interviewing with confidence and landing the offer.
WHAT MAKE US BOLD
We at BOLD share the same passion and commitment for what we do. We collaborate and strive to achieve the perfect balance between our work life and our personal life. Because for us at BOLD, working is not work. It’s a lifestyle, an experience and a culture. And this culture is infectious, original and driven by passion.
WHAT DEFINE US
- SOLVE REAL PROBLEMS: We are focused on solving significant problems that matter to us and our customers. We don't chase ideas and trends.
- CODE TODAY, DEPLOY TOMORROW: We make bold decisions, move fast and iterate quickly. We push ourselves and others to consistently deliver the best.
- BE WITH THE BEST: We surround ourselves with the best people, technology, tools to achieve something special together.
- STAY LEAN: We focus on doing less to achieve more. We embrace constraints and simplicity. We adapt quickly to the changing environment.
- EXPONENTIAL GROWTH: We never stop learning and career growth.
- TOOLS OF THE TRADE: We are working on the best in class technology and tools for your work.
PERK AND BENEFITS
- CAFÉ: Catered meals and an unlimited supply of snacks and beverages.
- ATTRACTIVE COMPENSATION: Highly competitive salary by industry standards.
- MEDICAL INSURANCE: Comprehensive medical insurance for you and your family.
- VACATION: 24 days of paid vacation and 10 national holidays.
- RELOCATION ASSISTANCE: We'll fly you in, help you move & give accommodation for 2 weeks.
- FRIENDLY CULTURE: Open plan office, flat organizational structure, comfy office space and fun-loving people.
- TEAM OUTINGS: We have team outings, annual picnic and Annual party for you and your family.