Explore a career at ScatterPie

Role Summary:

Lead and drive the development in BI domain using SSAS eco-system with deep technical and BI ecosystem knowledge.  

The resource will be responsible for the SSAS model preparation and deployment.

Roles and Responsibilities:

• SQL Server Analysis Services (SSAS) Developer working on a Data Warehouse project.  
• SQL Server Analysis Services (SSAS) Developer will develop solutions required to support the business with robust solutions that provide data, analytics, and reports, which support numerous functions including metrics, dashboards and data discovery.  
• Designs analyzes, develops, codes, tests, debugs and documents solutions to satisfy business requirements.  
• Proficient in data warehouse development skills spanning multiple design techniques.  
• Experience in Analytics / OLAP Cube Development (Microsoft SSAS and MDX). Analyze, design, build, query, troubleshoot and maintain cubes. Knowledge/expertise in SSAS Tabular with DAX language, Proficient in MDX and DAX.  
• Develop and improve solutions spanning data processing activities from the data lake (stage) to star schemas and reporting view’s / tables and finally into SSAS.  
• Develop and improve Microsoft Analysis Services cubes (tabular and dimensional) Proficient in MDX and DAX.  
• Collaborate with other teams within the organization and be able to devise the technical solution as it relates to the business & technical requirements.  
• Will be expected to mentor colleagues and be proactive in developing colleague skill sets to have a better understanding of Analysis Services.  
• Maintain documentation for all processes implemented.  
• Adhere to and suggest improvements to coding standards, best practices, and contribute to the improvement of these best practices.

Candidate’s Profile Academics: 

• Bachelor’s degree preferable in Computer science.  
• Master’s degree would have an added advantage. Experience: Overall 3-5 Years of experience in SSAS.

Technology & Skills:  

• Hands-on expertise of Power BI, SSAS  
• Strong knowledge in SQL, PL/SQL and Data modeling. 
• Knowledge of databases like Microsoft SQL Server, Oracle, etc. 
• Exposure to alternate Visualization technologies like Tableau, QlikView, Spotfire etc. 
• Good communication & Analytical skills with excellent creative and conceptual thinking abilities. 
• Superior organizational skills, attention to detail/level of quality, Strong communication skills, both verbal and written.

Apply For This Role

Role Summary:

The Senior SQL Developer will be responsible for designing, developing, and maintaining complex SQL queries and stored procedures to support various business applications. The developer will collaborate with Client’s to understand business requirements and design solutions that meet their needs. They will work with the technical team to ensure the solutions align with best practices, standards, and security protocols.

Roles and Responsibilities:

• Design, develop, and maintain complex SQL queries and stored procedures to support various business applications.
• Collaborate with stakeholders to understand business requirements and design solutions that meet their needs.
• Work with the technical team to ensure the solutions align with best practices, standards, and security protocols.
• Develop and maintain database objects such as tables, views, indexes, and constraints.
• Optimize database performance by tuning queries and improving indexing strategies.
• Troubleshoot issues with SQL queries and stored procedures and work with the technical team to resolve them.
• Develop and maintain documentation related to database schema, design, and implementation.
• Provide guidance and support to other team members on SQL development best practices and use.
• Keep up-to-date with the latest industry trends and technologies related to SQL development and recommend new solutions as appropriate.

Requirements: 

• 7+ years of experience in developing complex SQL queries and stored procedures.
• Strong understanding of SQL development best practices and use.
• Experience with database management systems such as SQL Server, Oracle, or MySQL.
• Experience with ETL tools and data warehousing concepts.
• Excellent problem-solving and troubleshooting skills.
• Strong communication and collaboration skills.
• Experience with cloud platforms such as Azure, AWS, or GCP is a plus.
• Microsoft certification in SQL development is preferred.

Note: The above job description is not intended to be an exhaustive list of all duties, responsibilities, or qualifications associated with the job. Other duties may be assigned based on business needs.

Apply For This Role

Role Summary:

The Azure Solution Architect will be responsible for designing, implementing, and maintaining cloud solutions using Microsoft Azure. The architect will collaborate with Client’s to understand business requirements and design solutions that meet their needs. They will work with the technical team to ensure the solutions align with best practices, standards, and security protocols.

Roles & Responsibilities:

• Design, implement, and maintain cloud solutions using Microsoft Azure.
• Collaborate with stakeholders to understand business requirements and design solutions that meet their needs.
• Work with the technical team to ensure the solutions align with best practices, standards, and security protocols.
• Provide technical leadership and guidance to the team on Azure architecture and implementation.
• Design and implement infrastructure as code using tools such as ARM templates or terraform.
• Develop and implement cloud security best practices and governance frameworks.
• Monitor and optimize cloud solutions for performance, cost, and scalability.
• Develop and maintain documentation related to architecture, design, and implementation of Azure solutions.
• Keep up-to-date with the latest industry trends and technologies related to Azure and recommend new solutions as appropriate.

Experience and Skills:

• Bachelor’s degree in Computer Science or a related field.
• 5+ years of experience in designing and implementing cloud solutions using Microsoft Azure.
• Strong understanding of cloud architecture and implementation best practices.
• Experience with infrastructure as code tools such as ARM templates or terraform.
• Experience with cloud security best practices and governance frameworks.
• Strong knowledge of Azure services such as Azure Virtual Machines, Azure Storage, Azure SQL Database, Azure Cosmos DB, Azure Functions, and Azure DevOps.
• Excellent problem-solving and troubleshooting skills.
• Strong communication and collaboration skills.
• Microsoft Azure certification, such as Microsoft Certified: Azure Solutions Architect Expert, is preferred.

Note: The above job description is not intended to be an exhaustive list of all duties, responsibilities, or qualifications associated with the job. Other duties may be assigned based on business needs.

Apply For This Role

Role Summary:

The AWS Glue & Redshift Developer will be responsible for designing, developing, and maintaining ETL (Extract, Transform, Load) pipelines using AWS Glue to load data into Amazon Redshift data warehouse. The developer will collaborate with Client’s to understand business requirements and design solutions that meet their needs. They will work with the technical team to ensure the solutions align with best practices, standards, and security protocols.

Roles & Responsibilities:

• Design, develop, and maintain ETL pipelines using AWS Glue to load data into Amazon Redshift data warehouse.
• Collaborate with stakeholders to understand business requirements and design solutions that meet their needs.
• Work with the technical team to ensure the solutions align with best practices, standards, and security protocols.
• Develop and maintain data transformation scripts using PySpark.
• Optimize ETL performance by tuning scripts and improving partitioning strategies.
• Develop and maintain documentation related to ETL processes, schema, design, and implementation.
• Troubleshoot issues with ETL pipelines and work with the technical team to resolve them.
• Provide guidance and support to other team members on AWS Glue and Redshift best practices and use.
• Keep up-to-date with the latest industry trends and technologies related to AWS Glue and Redshift and recommend new solutions as appropriate.

Requirements:

• Bachelor’s degree in Computer Science or a related field.
• 5+ years of experience in developing ETL pipelines using AWS Glue and loading data into Amazon Redshift.
• Strong understanding of AWS Glue and Redshift best practices and use.
• Experience with data transformation scripts using PySpark.
• Experience with SQL and data warehousing concepts.
• Excellent problem-solving and troubleshooting skills.
• Strong communication and collaboration skills.
• AWS certification in Glue and Redshift is preferred.
• Experience with other AWS services such as S3, Lambda, and EMR is a plus.

Note: The above job description is not intended to be an exhaustive list of all duties, responsibilities, or qualifications associated with the job. Other duties may be assigned based on business needs.

Apply For This Role

Role Summary:

Lead and drive the Development in BI domain using Tableau eco-system with deep technical and BI ecosystem knowledge. The resource will be responsible for the dashboard design, and delivery of BI services using Tableau eco-system.

Roles & Responsibilities:

• Communication & interaction with Project Manager to understand the requirement ∙ Dashboard designing, and deployment using Tableau eco-system ∙ Ensure delivery within given time frame while maintaining quality
• Stay up to date with current tech and bring relevant ideas to the table
• Proactively work with the Management team to identify and resolve issues ∙ Performs other related duties as assigned or advised
• He/she should be a leader that sets the standard and expectations through example in his/her conduct, work ethic, integrity and character
• Contribute in dashboard designing, R&D and project delivery using Tableau Candidate’s Profile

Academics:

• Batchelor’s degree preferable in Computer science.
• Master’s degree would have an added advantage.

Experience:

• Overall, 2-5 Years of experience in DWBI development projects, having worked on BI and Visualization technologies (Tableau, QlikView) for at least 2 years.
• At least 2 years of experience covering Tableau implementation lifecycle including hands-on development/programming, managing security, data modelling, data blending, etc.

Technology & Skills:

• Hands on expertise of Tableau administration and maintenance
• Strong working knowledge and development experience with Tableau Server and Desktop ∙ Strong knowledge in SQL, PL/SQL and Data modelling
• Knowledge of databases like Microsoft SQL Server, Oracle, etc.
• Exposure to alternate Visualization technologies like QlikView, Spotfire, Pentaho etc. ∙ Good communication & Analytical skills with Excellent creative and conceptual thinking abilities
• Superior organizational skills, attention to detail/level of quality, Strong communication skills, both verbal and written

Note: The above job description is not intended to be an exhaustive list of all duties, responsibilities, or qualifications associated with the job. Other duties may be assigned based on business needs.

Apply For This Role

Role Summary:

Lead and drive the development in BI domain using Tableau eco-system with deep technical and BI ecosystem knowledge. The resource will be responsible for the dashboard design, development, and delivery of BI services using Tableau eco-system.

Roles & Responsibilities:

• 5+ years of experience as Tableau development with Strong Dashboarding experience.
• Excellent communication, collaboration, & interpersonal skills and should be able to handle stakeholders and drive the dashboarding initiative.
• Proven experience in technical leadership with good technical delivery skill.
• Producing support documentation and keep existing documentation up to date.
• Proven experience in coordination with Business executives to identify requirements, KPIs and produce visualizations.
• Proven experience in planning, design, estimation, coordination with offshore, reviews, build and implementation of dashboard.
• Proven experience in data analysis.
• Proven experience in working with data from any domain preferably with Annuities and Investment accounting data.
• Experience in visualization development.
• Experience with other BI tools (Business Objects, or Power BI is preferred).
• Solid RDMS experience and data modelling and advanced querying skills.
• Experience working with a data warehouse and/or analytics team.
• Good to have working knowledge of Tableau administration/architecture.
• Strong ability to extract information by questioning, active listening, and interviewing.
• Awareness of agile/iterative approaches.
• Strong understanding of SDLC process is needed.
• Strong analytical and problem-solving skills.
• Excellent writing skills, with the ability to create clear requirements, specifications, and documentation.
• Strong ability to communicate embed information, business process and system wide changes to a technical and non-technical audience.
• Ability to work on own initiative within agreed boundaries.
• Flexible and adaptable.
• Strong sense of teamwork and ability to both lead and execute work.
• Experience with Agile project is preferred.
• Good documentation skill is needed.
• Experience using JIRA / Confluence is needed.

Academics:

• Bachelor’s degree preferable in Computer science.
• Master’s degree would have an added advantage.

Technology & Skills:

• Hands on expertise of Tableau administration and maintenance
• Strong working knowledge and development experience with Tableau Server and Desktop
• Strong knowledge in SQL, PL/SQL and Data modelling
• Knowledge of databases like Microsoft SQL Server, Oracle, etc.
• Exposure to alternate Visualization technologies like QlikView, Spotfire, Pentaho etc.
• Good communication & Analytical skills with Excellent creative and conceptual thinking abilities
• Superior organizational skills, attention to detail/level of quality, Strong communication skills, both verbal and written

Apply For This Role

Role Summary:

Lead and drive the development in BI domain using Power BI eco-system with deep technical and BI ecosystem knowledge. The resource will be responsible for the dashboard design, development, and delivery of BI services using Power BI eco-system.

Roles & Responsibilities:

• Experience in BI and Analytics: Minimum 5 years.
• A proven track record in BI consultancy/reporting role using data query and reporting/analysis tools.
• Extensive experience at building complex SQL queries (e.g., CTEs, sub queries, pivot queries etc.) using a SQL development /BI tool against Microsoft SQL Server and/or Oracle.
• Can demonstrate how these SQL skills are used in manipulating and cleansing data for the purposes of reporting and analysis.
• Experience in SQL Server Integration Services (SSIS) or Azure Data Factory, Azure Data bricks, or Informatica etc. would an added advantage.
• Knowledge of SQL profiling and analyzing query execution plans to help optimize queries.
• Strong analytical capability with an inclination for problem solving.
• Excellent communication skills particularly written and verbal in English.
• Excellent teamwork skills.
• Highly cooperative and yet self-sufficient.
• The ability to work well with others as well as independently.
• Action oriented and collaborative team player.
• Self-motivated, proactive, accountable with continuous learning approach; willing to learn and understand evolving technologies.
• Ability to multitask in an ambiguous environment.
• A high level of attention to detail.
• Have a reputation for honesty and accuracy that reinforces the sense of urgency that must be conveyed.

Academics:

• Bachelor’s degree preferable in Computer science.
• Master’s degree would have an added advantage.

Experience:

Overall, 5-9 Years of experience in DWBI development projects, having worked on BI and Visualization technologies (Power BI, Tableau) for at least 2 years.

Apply For This Role

Role Summary:

We are looking for experienced Power BI developers with hands on experience of delivering medium to large scale Technology Projects. Resource would be expected to also support build the Tech Stack for AI/ML solutions being developed at ScatterPie.

Key functions:

• The person would be working from either ScatterPie office (Pune) or client location. He will be involved in the following:
• This Role will be responsible for managing and implementation of BI & Dashboard projects to be implemented in Power BI (Cloud platform).
• The BI & Data will consist of multiple concurrently running major BI Projects with their own project implementation cycles.
• The purpose of this role is to implement multiple BI & Data Analytics projects by working with key stakeholders specially Finance teams.
• The job holder will manage all future major/minor development enhancements and define architectural requirements in BI and Analytics.

Roles and Responsibility:

• Main responsibility of the job holder is to design, develop and maintain Power BI dashboards in cloud with other BI Major/Minor enhancement Projects and contribute skills to Analytics project as and when required.
• Lead planning and implementation of BI projects. Job holder will actively participate in the requirement gathering & analysis and design. Understanding of end-to-end BI solution architectures, testing and implementation phases enabling performance of the entire platform.
• Work with IT project manager to determine project missions, goals, tasks, timelines and resource requirements; manage the overall Project Plan; resolve or assist in the resolution of conflicts within and between BI projects or functional areas; develop methods to monitor project’s overall progress; and provide corrective supervision if necessary.
• Job Holder role is responsible for conceptualizing complex Institutional problems, discovering business insights through visualization techniques. Should be well adapting to develop and execute database queries and conduct analysis.
• Knowledge of ETL/ELT tools, cube design, platform enabling configuration is essential.
• The role requires job holder to be a creative thinker and able to propose innovative ways to look at business problems by proper analysis of data to Identify the co-relations and defining proper KPIs and metrics so as to benefit Business teams with the entire workflow.
• Also, BI Specialist will need to present back their findings to the business and conduct wireframe sessions or user walkthrough of the platform. One of the key responsibilities of this role is to work on the analytics opportunities to support digital transformation initiatives.
• Need to perform Business Analysis of BRD to make sure business and IT team clearly understands the scope and requirements.
• Review functional solution documents prepared by the IT team to make sure they meet the business requirements.
• In addition to the normal roles of project management, job holder is also expected to work closely with the business teams and interpret their BI needs in technical terms and define the same to ensure adherence to all BI standards and best practices.
• Should have a very good understanding of data and ability to answer complex analytic questions to help organization shape its products and services in a better way.
• Embark on exploratory data analysis projects to achieve better understanding of phenomena as well as to discover untapped areas of growth and optimization.
• Work on projects that promote data-based decision across business strategy, product design, campaign management and customer service and work out data driven solutions, create significant value addition
• Work with business team to document the business requirements, anticipated benefits, success criteria for analytics initiatives.

Job Knowledge Skills and Experience:

• Enterprise scale technical experience with cloud and hybrid infrastructures, architecture designs, database migrations, dashboard development and Technology management. Required
• Breadth of technical experience and knowledge, with depth / Subject Matter Expertise in the following required:
• 3 – 7 years of hands-on experience in design and development of dashboard, reports, data model using Power BI, particularly Power BI Cloud based development
• Extensive experience of working with products like Microsoft SQL Server Analysis Services (SSAS) tabular Cube development, String SSIS, Server Reporting Services (SSRS) and Azure Data Lake, synapse and runtime.
• Very strong SQL skills for querying and creation of views/tables, functions and stored procedures
• Experience in Data Warehouse, ETL processing, Tabular models, DAX and M query
• Experience with Multidimensional concepts, data modeling and MDX query
• Development or Coding experience with C#, Web API, Net, PowerShell, SQL NoSQL. Databases including OSS (Maria, Mongo etc.), Cosmos DB
• Exposure to working/ building cubes for huge datasets (required)
• Knowledge of Visual Studio (SSDT)
• Working experience in banking sector or in a leading solution vendor for banking products. (required)
• Working experience within Finance team (desirable)
• Exploratory data analysis experience
• Strong written and verbal communication skills
• Strong analytical skills with the ability to collect, organize, analyses, and disseminate significant amounts of information with attention to detail and accuracy.
• Knowledge of the following to facilitate the development of custom visuals: (desirable)
• Typescript development tools
• D3 JavaScript libraries
• Scalable Vector Graphics (SVG)

Job Knowledge Skills and Experience:

• Great initiative; proven ability to support growth with a can-do attitude.
• Proven experience in operating within a global environment.
• Comfortable with working in a complex matrix environment.

Business impact: Very strong verbal and written English skills.

Education: Strong academics with Bachelors in Engineering or equivalent.

Apply For This Role

Role Summary:

Our growing company needs an experienced and resourceful Business Development Executive to develop and implement growth opportunities in existing and new markets. We’re searching for professionals that have a solid track record of creating long-term value for organizations.

Candidates should have strong communication and leadership skills, as well as the ability to design and implement a strategic sales plan that expands the company’s customer base and ensure its strong presence in the BI space.

Essential Functions & Key Responsibilities:

• Design and implement the customized targeted sales strategies to expand the company’s customer base for both contracting and consulting business verticals.
• Identify potential clients in the target market and complete appropriate research on the prospective client’s business needs and pitching services of the company.
• Create contract-winning proposals for the current and prospective client. Negotiate contract terms with clients and communicate terms to stakeholders.
• Communications & interactions with prospects during the entire lifecycle of business development while keeping track of the progress and maintaining relevant records.
• Develop and implement new sales initiatives, strategies, and programs to capture key demographics.
• Collaborate with Technical and HR teams to ensure contracted services are executed on time and as agreed. Other Functional, operational, and/or admin support during deliveries & fulfillment process.
• Coordination with technical and/or delivery team as and when required for relevant updates with delivery perspective.
• Maintain fruitful relationships with clients and address their needs effectively. Post deliveries and other aspects of Client Relationship Management
• Become a subject matter expert on our business products, services, processes, and operations, and remain up-to-date on industry news
• Keeping on top of business operations tasks – such as updating CRM, delivery progress, billing & collections
• Work closely with Presales and senior management to identify and manage risks.
• Research and identify new market opportunities
• Prepare and update documents, forms, templates, and other relevant collaterals
• Entry of business leads and relevant information in a proper IT system and CRMs for ready reference and analysis.
• Other functional or administrative assistance may be required for an efficient & effective teamwork environment.

Academic Qualification:

• MBA/ PGDM/ Post graduation in similar courses preferable

Experience:

• 2 to 4 years’ experience in Business Development in B2B, preferably in any IT Business.

Academic Qualification:

• Successful previous experience as a sales representative or sales executive, consistently meeting or exceeding targets
• · Proven ability to drive the sales process from plan to close
• · Excellent communications & interpersonal skills to communicate and deal effectively at all levels.
• · Strong business sense and industry expertise
• · The business development-oriented mindset with good knowledge of client relationship management.
• Aptitude for acquiring new knowledge & up-skilling.
• A versatile personality with a professional approach & attitude is the prerequisite for the position.
• The knack for dealing with people, external agencies, and vendors.
• Willing to travel
• 2-4 Years of sales experience (IT preferred, but not mandatory in exceptional cases)
• Languages to speak (More the better)

Apply For This Role

Role Summary:

The Oracle Technology Specialist will be responsible for designing, developing, and implementing solutions using Oracle technology stack. The specialist will collaborate with Client’s to understand business requirements and design solutions that meet their needs. They will work with the technical team to ensure the solutions align with best practices, standards, and security protocols.

Key Responsibilities:

• Design, develop, and implement solutions using Oracle technology stack, including Oracle Database, Oracle Middleware, and Oracle Applications.
• Collaborate with stakeholders to understand business requirements and design solutions that meet their needs.
• Work with the technical team to ensure the solutions align with best practices, standards, and security protocols.
• Develop and maintain database schemas, stored procedures, triggers, and functions.
• Troubleshoot issues with databases and applications and work with the technical team to resolve them.
• Monitor database performance and make adjustments as needed.
• Provide guidance and support to other team members on Oracle technology best practices and use.
• Keep up-to-date with the latest industry trends and technologies related to Oracle and recommend new solutions as appropriate.

Requirements:

• Bachelor’s degree in Computer Science or a related field.
• 3+ years of experience in designing and developing solutions using Oracle technology stack.
• Strong understanding of Oracle database architecture, middleware, and applications.
• Experience with PL/SQL and SQL development.
• Strong knowledge of one or more programming languages such as Java or Python.
• Experience with Oracle Fusion Middleware, including Oracle WebLogic Server and Oracle SOA Suite.
• Excellent problem-solving and troubleshooting skills.
• Strong communication and collaboration skills.
• Experience with Oracle Cloud Infrastructure (OCI) is a plus.
• Oracle certification is preferred.

Note: The above job description is not intended to be an exhaustive list of all duties, responsibilities, or qualifications associated with the job. Other duties may be assigned based on business needs.

Apply For This Role

Role Summary:

Lead and drive the development in the BI domain using Qlik Sense eco-system with deep technical and BI ecosystem knowledge. The resource will be responsible for the dashboard design, development, and delivery of BI services using the Qlik Sence eco-system.

Key functions & responsibilities:

• QlikView/Qlik Sense Data Architect (possibly certified) with extensive knowledge of QlikView and Qlik Sense including best practices for data modeling, application design, and development.
• Familiarity with the use of GeoAnalytics, NPrinting, extensions, widgets, mashups, ODAG, and various other advanced features used in Qlik Sense development.
• Good knowledge of working with Set Analysis.
• Experience working with Qlik Sense sites and the Qlik Management Console, creating rules, and managing the streams, as well as user and application security.
• Knowledge of Active Directory, proxies, load balancers, etc.
• Experience in troubleshooting connectivity, configuration, performance, etc.
• Strong communication and presentation skills. Candidate’s Profile Academics:
• Bachelor’s degree preferable in Computer science.
• Master’s degree would have an added advantage.

Experience:

• 2-7 years of experience in Qlik Sense designing and development

Apply For This Role

Role Summary:

The Snowflake Developer will be responsible for designing, developing, and maintaining data pipelines, data warehouses, and data models using Snowflake. They will collaborate with data analysts, data scientists, and business Clients to ensure that the data architecture meets the needs of the organization.

Key Responsibilities:

• Develop, design, and maintain data pipelines, data warehouses, and data models in Snowflake
• Create and manage ETL processes to move data from various sources into Snowflake
• Ensure data quality, integrity, and consistency across all data sources and data models
• Work with clients to identify requirements and design solutions that meet their needs
• Optimize Snowflake performance and troubleshoot issues as they arise
• Develop and maintain documentation of data architecture, data models, and ETL processes
• Stay up-to-date with Snowflake updates, new features, and best practices
• Participate in code reviews, testing, and debugging activities
• Collaborate with data analysts and data scientists to design and implement analytics solutions Qualifications:
• Bachelor’s degree in Computer Science, Information Systems, or related field
• Minimum of 2 years of experience in designing and developing data warehouses and data models using Snowflake
• Strong understanding of SQL and experience with database technologies such as Oracle, SQL Server, MySQL, etc.
• Knowledge of ETL tools and processes such as Informatica, Talend, etc.
• Experience with scripting languages such as Python, Perl, etc.
• Familiarity with data modeling tools such as ERwin, ER/Studio, etc. ▪ Strong problem-solving and analytical skills
• Excellent written and verbal communication skills
• Ability to work independently and in a team-oriented environment Preferred Qualifications:
• Experience with cloud technologies such as AWS, Azure, or Google Cloud Platform
• Certification in Snowflake or related technology
• Experience with Big Data technologies such as Hadoop, Spark, etc.
• Experience with data visualization tools such as Tableau, Power BI, etc.
• Familiarity with Agile development methodologies

Note: This job description is not intended to be all-inclusive. The employee may perform other related duties as negotiated to meet the ongoing needs of the organization.

Apply For This Role

Role Summary:

The Data Bricks Specialist will be responsible for designing, developing, and implementing big data processing solutions using Databricks. The specialist will collaborate with the Client to understand business requirements and design solutions that meet their needs. They will work with the technical team to ensure the solutions align with best practices, standards, and security protocols.

Key Responsibilities:

• Design, develop, and implement big data processing solutions using Databricks.
• Collaborate with stakeholders to understand business requirements and design solutions that meet their needs.
• Work with the technical team to ensure the solutions align with best practices, standards, and security protocols.
• Develop and maintain data pipelines to ensure data is processed accurately and on time.
• Troubleshoot issues with data pipelines and work with the technical team to resolve them.
• Monitor data pipelines to ensure they are performing optimally and make adjustments as needed.
• Provide guidance and support to other team members on Databricks best practices and use.
• Keep up-to-date with the latest industry trends and technologies related to big data processing and recommend new solutions as appropriate.

Requirements:

• Bachelor’s degree in Computer Science or a related field.
• 3+ years of experience in designing and developing big data processing solutions using Databricks.
• Strong understanding of big data processing concepts and techniques.
• Experience with data engineering concepts, data warehousing, and ETL tools.
• Strong knowledge of one or more programming languages such as Python or Scala.
• Experience with cloud platforms such as Azure, AWS, or GCP.
• Excellent problem-solving and troubleshooting skills.
• Strong communication and collaboration skills.
• Experience with Git and Agile methodologies is a plus.
• Databricks certification is preferred.

Note: The above job description is not intended to be an exhaustive list of all duties, responsibilities, or qualifications associated with the job. Other duties may be assigned based on business needs.

Apply For This Role

About ScatterPie Analytics

ScatterPie Analytics is a company focused on modernizing business intelligence through the implementation of technologies that companies need today to succeed in the market. We bring together the best of open source and blend it with the best of enterprise tools to build intelligence that is powerful, cost-effective, and flexible.

About the Job Description

ScatterPie is looking for a Data Engineer for the Mumbai location with excellent Spark skills to build and maintain complex and reliable data pipelines in PySpark for our clients.

In this role, you should have a background in data engineering, Spark, Python and SQL. You should be analytical and an excellent communicator.

If you also have business acumen and problem-solving aptitude, we’d like to meet you.

Ultimately, you will enhance our client’s business intelligence system by delivering fast and reliable data pipelines to be used by the data analysis team.

Roles and Responsibilities:

• Design, develop and modify relational and multidimensional database structures, relationships, data flows and data interfaces within the data warehouse as needed.
• Ability to do Data Modelling.
• Develops and maintains scalable data pipelines to support continuing increases in data volume and complexity.
• Understand thoroughly the architecture, data structures and fundamental design principles of the data warehouse.
• Develop Dynamic packages using ETL tool and implement Incremental Data Loading.
• Modify the data load ETL processes as needed to Extract, Transform and Load data from various data sources into the data warehouse.
• Collaborates with analytics and business teams to improve data models that feed business intelligence tools, increasing data accessibility and fostering data-driven decision making across the organization.
• Implements processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it.
• Designs data integrations framework.

Technical Skills:

Must have

• Programming skills: SQL, R, Python, Java.
• Should have good experience in writing SQL queries – DDL, DML, DCL.
• Create complex functions, view, stored procedures and triggers.
• Should have worked on databases like SQL server, oracle, MySQL.
• Should have worked on any of the ETL Pipelines tools – SSIS, Alteryx, Informatica, ADF

Good to have

• Big data: Hive, Pig, Spark, Hadoop, MapReduce.
• Cloud: Amazon Web Services (AWS), Microsoft Azure;
• You are an ideal candidate for application if you (MUST Have)
• Have a Bachelors or above degree in computer science
• Total 4 years or more working experience
• At least 2 year of working experience in Spark
• Enjoy writing code in Python
• Love to automate things
• Like to build reliable software engineering solutions

What we offer

• A challenging career road map for a modern BI analyst
• Thought stimulating project work
• An open, transparent and flat structured working environment
• 15 Holidays in a year
• Health insurance benefit *Free Access to premium learning platforms like Pluralsight, Data Camp, A Cloud Guru, Maven Analytics, and more
• Company-sponsored passes to conferences relevant to your job
• Company-paid certifications relevant to your job

Apply For This Role

Role Summary:

We are seeking a talented Technology SSAS Developer to join our team. The Technology SSAS Developer will be responsible for designing, developing, and implementing multidimensional databases using Microsoft SQL Server Analysis Services (SSAS) as well as providing technical support for our clients.

Key Responsibilities:

• Design, develop and implement multidimensional databases using SSAS
• Provide technical support to clients, resolving any issues they may have with SSAS or related technologies
• Develop and maintain ETL processes using SQL
• Collaborate with other members of the development team to ensure the successful delivery of projects
• Stay up-to-date with new technologies and industry trends to ensure that our solutions are cutting-edge and innovative
• Document all work in accordance with company policies and procedures

Requirements:

• Bachelor’s degree in Computer Science or a related field
• 3+ years of experience in developing multidimensional databases using SSAS
• Strong knowledge of SQL and ETL processes
• Experience in providing technical support for clients
• Excellent communication and problem-solving skills
• Ability to work independently and as part of a team
• Experience with other BI tools such as Power BI or Tableau is a plus
• Knowledge of cloud-based data warehousing solutions such as Azure Synapse Analytics or AWS Redshift is a plus.

Apply For This Role