Software Engineer/ Senior Software Engineer, ETL
BOLD is seeking for ETL Specialist who will help in building 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.
Job Description
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 to develop 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+
- Senior Software Engineer, ETL- 4.5 years+
products which provide great customer experience. As part of Product Delivery Group you will be working on any of our brands like MyPerfectResume.com, Resume-Now.com, LiveCareer.com which provide users with access to tools and resources to help them create and customize resumes, cover letters, and job applications. The team is responsible for delivering highly optimized and highly performant web applications using some of the latest technologies like React JS, Next JS, Node JS, .Net, PHP etc.
WHAT YOU’LL DO
- Design web-scale products following best coding principles, optimized coding practices and using open source tools & platforms.
- Routine day involves writing code for web applications using modern javascript frameworks, coding rest APIs, integrating apps with cloud platforms like Azure or third-party APIs.
- Actively participate in product review meetings and contribute to ideas for improvement.
- Develop new user-facing features.
- Build reusable code and libraries for future use.
- Ensure the technical feasibility of UI/UX designs
- Proactively identify potential problems and opportunities to improve applications and processes, with emphasis on usability, performance, and security
- Document the development process, architecture, and standard components
- Deployment of applications on AWS or similar platforms.
- Coordinate with the product team to create applications as per the requirement.
- Coordinate all stages of product development, from initial concept art, to finalization and distribution.
- Provide architecture guidance with strong focus on solution architecture, architecture artifacts, performance, scaling and security to produce scale-able, flexible, robust and efficient applications.
- Lead the technical design solution, conversation, choose the right frameworks for the business solution, and apply design patterns consistently.
- Manage and mentor junior team members
WHAT YOU’LL NEED
- Excellent experience in object-oriented programming language (C#).
- Experience in.Net core, SQL Server & Azure
- Having good experience in Web APIS
- Strong database MS SQL Server skills. (Writing complex queries and stored procedures)
- Having good experience in ASP.NET MVC as well.
- Experience with the full stack of software development
- Solid Object Oriented design and development skills
- Proficient in JavaScript and HTML5/CSS
- Experience with RESTful services
- Exposure to LINQ and Entity Framework
- Exposure to microservices architecture
WHAT’S GOOD TO HAVE
- Exposure to Azure.
- Exposure to NoSQL databases.
- Experience building modern web applications using the latest JavaScript frameworks like ReactJS, Angular JS (Basic knowledge)
- Versed in Agile methodology
- Understanding of design patterns and SOLID principals
- Sees things through-takes responsibility from workstation to production
- Good written/spoken English
- Applicant must be mature, responsible & technically outstanding
EXPERIENCE-
- Technical Lead-7 yrs+
#LI-SV1
Benefits
Outstanding Compensation
- Competitive salary
- Tax-friendly compensation structure
- Bi-annual bonus
- Annual/bi-annual appraisal
- Equity in company
100% Full Health Benefits
- Group Mediclaim, personal accident, & term life insurance
- Group Mediclaim benefit (including parents' coverage)
- Practo Plus health membership for employees and family
- Personal accident and term life insurance coverage
Flexible Time Away
- 24 days paid leaves
- Declared fixed holidays
- Paternity and maternity leave
- Compassionate and marriage leave
- Covid leave (up to 7 days)
Additional Benefits
- Internet and home office reimbursement
- In-office catered lunch, meals, and snacks
- Certification policy
- Cab pick-up and drop-off facility
About BOLD
We Transform Work Lives
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.
We Celebrate And Promote Diversity And Inclusion
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.