Data Analyst

Major Areas of Responsibilities

1. Strong fluency with Excel formulas and functions.

2. Strong analytical and data gathering skills.

3. Analyze financial data and create financial models for decision support.

4. Revenue analysis, strategizing for the growth of business.

5. Analyze past results, perform variance analysis, identify trends, and make recommendations for improvements.

6. Work closely with the accounting team to ensure accurate financial reporting.

7. Evaluate financial performance by comparing and analyzing actual results with plans and forecasts.

8. Guide the cost analysis process by establishing and enforcing policies and procedures.

Qualification

1. BE and Btech

2. MBAs are preferred

Skills

- Knowledge of Microsoft Excel, Word and Power Point.

- Great Analytical Skills 

Strong quantitative and analytical competenc

Role & Responsibilities:

• Ability to architect Azure cloud-based application modernization, Azure infrastructure setup, configuration and management
• Ability to create / recreate / rewrite or refactor applications based for cloud resource optimization.
• Make use of Azure Integration Services: Logic Apps, Service Bus, API Management and Event Grid.
• Assure that data is cleansed, mapped, transformed, and otherwise optimized for storage and use according to business and technical requirements.
• Solution design using Microsoft Azure services and tools including Data Factory, Data Lake, Synapse etc.
• Extracting data, troubleshooting and maintaining the data warehouse.
• Experience of SQL and Dataverse databases is mandatory.
• The ability to automate tasks and deploy production standard code (with unit testing, continuous integration, versioning etc.).
• Load transformed data into storage and reporting structures in destinations including data warehouse, high speed indexes, real-time reporting systems and analytics applications.
• Build data pipelines to collectively bring together data.
• Utilize Microsoft Azure PaaS and SaaS solution development technologies including Azure Functions, Azure Notifications Hub, Azure App Service and Key Vault
• Setup Fresh / Modify existing CI/CD pipelines development (YAML or Classic).
• Hands-on experience with automation tools, cloud computing platforms, and scripting languages
• Ability to learn and implement automation tools and technologies, such as Azure DevOps, Docker, and Terraform on the Azure platform.
• Knowledge of containerization and container orchestration, such as Kubernetes
• Experience with Azure monitoring and error logging tools, debugging skills, problem solving ability.

Requirements

Experience

• 5+ years of professional experience in implementing MLOps framework to scale up ML in production.
• Hands-on experience with Kubernetes, Kubeflow, MLflow, Sagemaker, and other ML model experiment management tools including training, inference, and evaluation.
• Experience in ML model serving (TorchServe, TensorFlow Serving, NVIDIA Triton inference server, etc.)
• Proficiency with ML model training frameworks (PyTorch, Pytorch Lightning, Tensorflow, etc.).
• Experience with GPU computing to do data and model training parallelism.
• Solid software engineering skills in developing systems for production.
• Strong expertise in Python.
• Building end-to-end data systems as an ML Engineer, Platform Engineer, or equivalent.
• Experience working with cloud data processing technologies (S3, ECR, Lambda, AWS, Spark, Dask, ElasticSearch, Presto, SQL, etc.).
• Having Geospatial / Remote sensing experience is a plus.

• Good experience on Power BI Visualizations, DAX queries in Power BI
• Experience in implementing Row Level Security
• Can understand data models, can implement simple-medium data models
• Quick learner to pick up the Application data design and processe

• Expert in SQL, Analyze current ETL/SSIS process
• Hands on experience in data modeling  
• Quick learner to pick up the Application data design and processes
• Data warehouse development and work with SSIS & SSAS (Good to have)

Designation: business analyst

Company name - promilo.com (sawara solutions pvt ltd)

Experience – 2 - 8 yrs.

Location: Bangalore

Mode – full time / work from office

About us:

Promilo is India’s 1st innovative platform which “pay to browse”

It is a b2b SaaS start-up that enables to accelerate  the business appointment funnel of the

Companies. We’re an SaaS based advertising platform that connects both users & advertisers. Users will be able to book an online appointment based on their interests with the advertiser, without compromising their data privacy and get rewarded for sharing their data and time. We’re registered and recognized by start-up India, start-up Karnataka & MSME companies. Also, the top 100 Google AppScale academy start-up

Job description:

We are looking for an experienced business analyst to join our team. The ideal candidate will have 2-8 years of experience in web & mobile user & client data analyst for start-ups, with a strong passion to help start-ups and a proven track record to bring the strong business insight to improve the sales, marketing, user, client, ui, ux of the organisation.

Responsibilities

• Requirement gathering and analyzing
• Conduct gap analysis, assess scope & suggest solutions
• Responsible for technical proposal writing and time and cost analysis for web and mobile application development
• Preparing rfp/rfq
• Would be involved in presales activities
• Work as liaison between client and technical team
• Create wireframe | prototype | feature list | srs | brd & flow diagrams as per the client's requirement
• High it literacy proven use of web and associated technologies (excel, power point, google apps).
• Previous experience with data visualization tools (tableau, power bi, etc.), is strongly preferred.
• Cleanse and curate sourced data into standardized reporting templates
• Create, document, validate and ensure delivery of ad hoc, daily weekly, and monthly reports to internal stakeholders
• Create, validate and deliver tracking links for the marketing department
• Assist in the creation, qa, validation and reporting of a/b and multivariate tests
• Proactively monitor the marketing kpis and ua data on a daily basis
• Analyze marketing ua performance and conduct deep dive analysis to answer hypotheses and questions posed by the team
• Gather, transform, and analyze digital marketing data, including paid media, search, social, website, and conversion funnel analytics
• Analyze marketing data searching for top of funnel growth opportunities
• Analyze product data searching for insights to increase app engagement, conversion, and retention
• Analyze ltv/cac drivers to support overall business growth
• Partner with marketing, product, and growth teams
• Present findings to stakeholders and make recommendations for spend targets and campaign strategies
• Pov on ios 14 and upcoming android privacy changes and we can navigate tracking in light of these changes
• Pov on transition to skan 4.0
• Working knowledge of statistical techniques (regression, k-means clustering, pca)
• Experience with lift studies and marketing mix modeling working experience with python, r, & dbt
• Experience at a small company
• Experience with a subscription business
• Analyze website and mobile app data on traffic sources and patterns. Provide insight on data trends and anomalies, making recommendations where appropriate to improve business performance.

Qualification

• Master's or bachelor degree in computer science
• Well-versed with its technologies
• 2+ years of business analysis or project analysis experience
• Tech-savvy with proficiency in Microsoft office, google apps, and other web and mobile applications
• Excellent written and verbal communication skills
• Self-motivated, flexible, and comfortable with a fast-paced startup environment
• Advanced experience with Excel, google sheets including an understanding of visualizations, pivot tables, vlookup, and other key functions
• Experience with adobe analytics, google analytics, tableau, SQL, and data grid is a plus.
• Strong analytical and problem-solving skills, with clear attention to detail
• Ability to prioritize and work under tight deadlines
• Fast learner, able to master new concepts, theories, ideas, and processes with ease
• Experience creating user acquisition reports and dashboards
• Deep understanding of mobile attribution, cohort analysis, customer segmentation, and ltv modeling
• Experience pulling data and creating databases using an API of at least one of these ad platforms; Facebook, Snapchat, TikTok, google ads, applovin
• Experience with the architecture and deployment of mobile tracking solutions, including SDK integration, ad platforms APIs, server-postbacks, and mmp providers such as Appsflyer, adjust, kochava

If you are data driven individual with a passion for start-ups and have experience in business analytics, we encourage you to apply for this position. We offer a competitive salary package, flexible working hours, and a supportive work environment that fosters growth and development.

Company - Tekclan Software Solutions

Position – SQL Developer

Experience – Minimum 4+ years of experience in MS SQL server, SQL Programming, ETL development.

Location - Chennai

We are seeking a highly skilled SQL Developer with expertise in MS SQL Server, SSRS, SQL programming, writing stored procedures, and proficiency in ETL using SSIS. The ideal candidate will have a strong understanding of database concepts, query optimization, and data modeling.

Responsibilities:

1. Develop, optimize, and maintain SQL queries, stored procedures, and functions for efficient data retrieval and manipulation.

2. Design and implement ETL processes using SSIS for data extraction, transformation, and loading from various sources.

3. Collaborate with cross-functional teams to gather business requirements and translate them into technical specifications.

4. Create and maintain data models, ensuring data integrity, normalization, and performance.

5. Generate insightful reports and dashboards using SSRS to facilitate data-driven decision making.

6. Troubleshoot and resolve database performance issues, bottlenecks, and data inconsistencies.

7. Conduct thorough testing and debugging of SQL code to ensure accuracy and reliability.

8. Stay up-to-date with emerging trends and advancements in SQL technologies and provide recommendations for improvement.

9. Should be an independent and individual contributor.

Requirements:

1. Minimum of 4+ years of experience in MS SQL server, SQL Programming, ETL development.

2. Proven experience as a SQL Developer with a strong focus on MS SQL Server.

3. Proficiency in SQL programming, including writing complex queries, stored procedures, and functions.

4. In-depth knowledge of ETL processes and hands-on experience with SSIS.

5. Strong expertise in creating reports and dashboards using SSRS.

6. Familiarity with database design principles, query optimization, and data modeling.

7. Experience with performance tuning and troubleshooting SQL-related issues.

8. Excellent problem-solving skills and attention to detail.

9. Strong communication and collaboration abilities.

10. Ability to work independently and handle multiple tasks simultaneously.

Preferred Skills:

1. Certification in MS SQL Server or related technologies.

2. Knowledge of other database systems such as Oracle or MySQL.

3. Familiarity with data warehousing concepts and tools.

4. Experience with version control systems.

Senior Data Engineer

Responsibilities:

●      Clean, prepare and optimize data at scale for ingestion and consumption by machine learning models

●      Drive the implementation of new data management projects and re-structure of the current data architecture

●      Implement complex automated workflows and routines using workflow scheduling tools 

●      Build continuous integration, test-driven development and production deployment frameworks

●      Drive collaborative reviews of design, code, test plans and dataset implementation performed by other data engineers in support of maintaining data engineering standards 

●      Anticipate, identify and solve issues concerning data management to improve data quality

●      Design and build reusable components, frameworks and libraries at scale to support machine learning products 

●      Design and implement product features in collaboration with business and Technology stakeholders 

●      Analyze and profile data for the purpose of designing scalable solutions 

●      Troubleshoot complex data issues and perform root cause analysis to proactively resolve product and operational issues

●      Mentor and develop other data engineers in adopting best practices 

●      Able to influence and communicate effectively, both verbally and written, with team members and business stakeholders

Qualifications:

●      8+ years of experience developing scalable Big Data applications or solutions on distributed platforms

●      Experience in Google Cloud Platform (GCP) and good to have other cloud platform tools

●      Experience working with Data warehousing tools, including DynamoDB, SQL, and Snowflake

●      Experience architecting data products in Streaming, Serverless and Microservices Architecture and platform.

●      Experience with Spark (Scala/Python/Java) and Kafka

●      Work experience with using Databricks (Data Engineering and Delta Lake components) 

●      Experience working with Big Data platforms, including Dataproc, Data Bricks etc

●      Experience working with distributed technology tools including Spark, Presto, Databricks, Airflow

●      Working knowledge of Data warehousing, Data modeling

●      Experience working in Agile and Scrum development process

●      Bachelor's degree in Computer Science, Information Systems, Business, or other relevant subject area

Role:

Senior Data Engineer

Total No. of Years:

8+ years of relevant experience 

To be onboarded by:

Immediate

Notice Period:

Skills

Mandatory / Desirable

Min years (Project Exp)

Max years (Project Exp)

GCP Exposure 

Mandatory Min 3 to 7

BigQuery, Dataflow, Dataproc, AI Building Blocks, Looker, Cloud Data Fusion, Dataprep .Spark and PySpark

Mandatory Min 5 to 9

Relational SQL

Mandatory Min 4 to 8

Shell scripting language 

Mandatory Min 4 to 8

Python /scala language 

Mandatory Min 4 to 8

Airflow/Kubeflow workflow scheduling tool 

Mandatory Min 3 to 7

Kubernetes

Desirable 1 to 6

Scala

Mandatory Min 2 to 6

Databricks

Desirable Min 1 to 6

Google Cloud Functions

Mandatory Min 2 to 6

GitHub source control tool 

Mandatory Min 4 to 8

Machine Learning

Desirable 1 to 6

Deep Learning

Desirable Min 1to 6

Data structures and algorithms

Mandatory Min 4 to 8

1. Sr. Data Engineer:

 Core Skills – Data Engineering, Big Data, Pyspark, Spark SQL and Python

Candidate with prior Palantir Cloud Foundry OR Clinical Trial Data Model background is preferred

Major accountabilities:

• Responsible for Data Engineering, Foundry Data Pipeline Creation, Foundry Analysis & Reporting, Slate Application development, re-usable code development & management and Integrating Internal or External System with Foundry for data ingestion with high quality.
• Have good understanding on Foundry Platform landscape and it’s capabilities
• Performs data analysis required to troubleshoot data related issues and assist in the resolution of data issues.
• Defines company data assets (data models), Pyspark, spark SQL, jobs to populate data models.
• Designs data integrations and data quality framework.
• Design & Implement integration with Internal, External Systems, F1 AWS platform using Foundry Data Connector or Magritte Agent
• Collaboration with data scientists, data analyst and technology teams to document and leverage their understanding of the Foundry integration with different data sources - Actively participate in agile work practices
• Coordinating with Quality Engineer to ensure the all quality controls, naming convention & best practices have been followed

Desired Candidate Profile :

• Strong data engineering background
• Experience with Clinical Data Model is preferred
• Experience in
• SQL Server ,Postgres, Cassandra, Hadoop, and Spark for distributed data storage and parallel computing
• Java and Groovy for our back-end applications and data integration tools
• Python for data processing and analysis
• Cloud infrastructure based on AWS EC2 and S3
• 7+ years IT experience, 2+ years’ experience in Palantir Foundry Platform, 4+ years’ experience in Big Data platform
• 5+ years of Python and Pyspark development experience
• Strong troubleshooting and problem solving skills
• BTech or master's degree in computer science or a related technical field
• Experience designing, building, and maintaining big data pipelines systems
• Hands-on experience on Palantir Foundry Platform and Foundry custom Apps development
• Able to design and implement data integration between Palantir Foundry and external Apps based on Foundry data connector framework
• Hands-on in programming languages primarily Python, R, Java, Unix shell scripts
• Hand-on experience in AWS / Azure cloud platform and stack
• Strong in API based architecture and concept, able to do quick PoC using API integration and development
• Knowledge of machine learning and AI
• Skill and comfort working in a rapidly changing environment with dynamic objectives and iteration with users.

 Demonstrated ability to continuously learn, work independently, and make decisions with minimal supervision