Business Analyst

1. Minimum 2.5 years of experience as a Python Developer.
2. Minimum 2.5 years of experience in any framework like Django/Flask/Fast API
3. Minimum 2.5 years of experience in SQL/ Postgress
4. Minimum 2.5 years of experience in Git/Gitlab/Bit-Bucket
5. Minimum 2+ years of experience in deployment (CICD with Jenkins)
6. Minimum 2.5 years of experience in any cloud like AWS/GCP/Azure

Job Responsibilities:

Excellent problem solving and analytical skills - ability to develop hypotheses,

understand and interpret data within the context of the product / business -

solve problems and distill data into actionable recommendations.

 Strong communication skills with the ability to confidently work with cross-

functional teams across the globe and to present information to all levels of the

organization.

 Intellectual and analytical curiosity - initiative to dig into the why, what & how.

 Strong number crunching and quantitative skills.

 Advanced knowledge of MS Excel and PowerPoint.

 Good hands on SQL

 Experience with in Google Analytics, Optimize, Tag Manager and other Google Suite tools

 Understanding of Business analytics tools & statistical programming languages - R, SAS, SPSS, Tableau is a plus

 Inherent interest in e-commerce & marketplace technology platforms and

broadly in the consumer Internet & mobile space.

 Previous experience of 1+ years working in a product company in

a product analytics role

 Strong understanding of building and interpreting product funnels.

Perquisites & Benefits:

 Opportunity to work with India's no.1 crowdfunding platform

 Be a part of a young, smart and rapidly growing team with management from Ivy League and Premier colleges

 Competitive compensation and incentives

 Fun, casual, relaxed and flexible work environment

Your key responsibilities

• Create and maintain optimal data pipeline architecture. Should have experience in building batch/real-time ETL Data Pipelines. Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources
• The individual will be responsible for solution design, integration, data sourcing, transformation, database design and implementation of complex data warehousing solutions.
• Responsible for development, support, maintenance, and implementation of a complex project module
• Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint
• Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation
• Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards
• Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support.
• complete reporting solutions.
• Preparation of HLD about architecture of the application and high level design.
• Preparation of LLD about job design, job description and in detail information of the jobs.
• Preparation of Unit Test cases and execution of the same.
• Provide technical guidance and mentoring to application development teams throughout all the phases of the software development life cycle

Skills and attributes for success

• Strong experience in SQL. Proficient in writing performant SQL working with large data volumes. Proficiency in writing and debugging complex SQLs.
• Strong experience in database system Microsoft Azure. Experienced in Azure Data Factory.
• Strong in Data Warehousing concepts. Experience with large-scale data warehousing architecture and data modelling.

• Should have enough experience to work on Power Shell Scripting

• Able to guide the team through the development, testing and implementation stages and review the completed work effectively
• Able to make quick decisions and solve technical problems to provide an efficient environment for project implementation
• Primary owner of delivery, timelines. Review code was written by other engineers.
• Maintain highest levels of development practices including technical design, solution development, systems configuration, test documentation/execution, issue identification and resolution, writing clean, modular and self-sustaining code, with repeatable quality and predictability
• Must have understanding of business intelligence development in the IT industry
• Outstanding written and verbal communication skills
• Should be adept in SDLC process - requirement analysis, time estimation, design, development, testing and maintenance
• Hands-on experience in installing, configuring, operating, and monitoring CI/CD pipeline tools
• Should be able to orchestrate and automate pipeline
• Good to have : Knowledge of distributed systems such as Hadoop, Hive, Spark

To qualify for the role, you must have

• Bachelor's Degree in Computer Science, Economics, Engineering, IT, Mathematics, or related field preferred
• More than 6 years of experience in ETL development projects
• Proven experience in delivering effective technical ETL strategies
• Microsoft Azure project experience
• Technologies: ETL- ADF, SQL, Azure components (must-have), Python (nice to have)

Ideally, you’ll also have

• Partnering with internal business owners (product, marketing, edit, etc.) to understand needs and develop custom analysis to optimize for user engagement and retention
• Good understanding of the underlying business and workings of cross functional teams for successful execution
• Design and develop analyses based on business requirement needs and challenges.
• Leveraging statistical analysis on consumer research and data mining projects, including segmentation, clustering, factor analysis, multivariate regression, predictive modeling, etc.
• Providing statistical analysis on custom research projects and consult on A/B testing and other statistical analysis as needed. Other reports and custom analysis as required.
• Identify and use appropriate investigative and analytical technologies to interpret and verify results.
• Apply and learn a wide variety of tools and languages to achieve results
• Use best practices to develop statistical and/ or machine learning techniques to build models that address business needs.

• 2 - 4 years  of relevant experience in Data science.
• Preferred education: Bachelor's degree in a technical field or equivalent experience.
• Experience in advanced analytics, model building, statistical modeling, optimization, and machine learning algorithms.
• Machine Learning Algorithms: Crystal clear understanding, coding, implementation, error analysis, model tuning knowledge on Linear Regression, Logistic Regression, SVM, shallow Neural Networks, clustering, Decision Trees, Random forest, XGBoost, Recommender Systems, ARIMA and Anomaly Detection. Feature selection, hyper parameters tuning, model selection and error analysis, boosting and ensemble methods.
• Strong with programming languages like Python and data processing using SQL or equivalent and ability to experiment with newer open source tools.
• Experience in normalizing data to ensure it is homogeneous and consistently formatted to enable sorting, query and analysis.
• Experience designing, developing, implementing and maintaining a database and programs to manage data analysis efforts.
• Experience with big data and cloud computing viz. Spark, Hadoop (MapReduce, PIG, HIVE).
• Experience in risk and credit score domains preferred.

• Experience implementing large-scale ETL processes using Informatica PowerCenter.
• Design high-level ETL process and data flow from the source system to target databases.
• Strong experience with Oracle databases and strong SQL.
• Develop & unit test Informatica ETL processes for optimal performance utilizing best practices.
• Performance tune Informatica ETL mappings and report queries.
• Develop database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.
• Hands-on Experience in Unix.
• Experience in Informatica Cloud (IICS).
• Work with appropriate leads and review high-level ETL design, source to target data mapping document, and be the point of contact for any ETL-related questions.
• Good understanding of project life cycle, especially tasks within the ETL phase.
• Ability to work independently and multi-task to meet critical deadlines in a rapidly changing environment.
• Excellent communication and presentation skills.
• Effectively worked on the Onsite and Offshore work model.

   3+ years of experience in deployment, monitoring, tuning, and administration of high concurrency MySQL production databases.

• Solid understanding of writing optimized SQL queries on MySQL databases
• Understanding of AWS, VPC, networking, security groups, IAM, and roles.
• Expertise in scripting in Python or Shell/Powershell
• Must have experience in large scale data migrations
• Excellent communication skills.