Explore a career at ScatterPie

Surround yourself with intelligent, aspirational, and driven individuals to advance your career.

Role Summary:

• 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.

Academics:

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

• 2+ 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.

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:

• 1+ years of experience in Tableau development with Strong Dashboarding experience.
• Excellent communication, collaboration, & interpersonal skills and should be able to handle stakeholders and drive the dashboarding initiative.
• Dashboard designing, and deployment using Tableau eco-system
• Ensure delivery within given time frame while maintaining quality
• Proven experience in technical leadership with good technical delivery skills.
• Producing support documentation and keeping existing documentation up to date.
• Proven experience in data analysis.
• Experience in visualization development.
• Experience with other BI tools (Business Objects or Power BI is preferred).
• Solid RDMS experience and data modeling 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.
• A 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 and embed information, business process, and system-wide changes to a technical and non-technical audience.
• Flexible and adaptable.
• Experience with Agile projects 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.

Experience:

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

Technology & Skills:

• Hands-on expertise in Tableau administration and maintenance
• Strong working knowledge and development experience with Tableau Server and Desktop ∙ Strong knowledge in SQL, PL/SQL, and Data modeling
• 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 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:

• 4+ years of experience in 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 skills.
• Producing support documentation and keeping 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, building, and implementation of dashboards.
• 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 modeling 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.
• A 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 and 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 projects 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 modeling
• 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:

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.

Roles and Responsibility:

• 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.
• The resource 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.
• The resource will be 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.
• 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.
• 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.
• 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)
• Exploratory data analysis experience
• 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)

Academics:

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

Apply For This Role

Role Summary

We are looking for an experienced data engineer, who uses their expertise in data engineering and programming to build systems that collect, manage and convert raw data into usable information for business analysts.

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 servers, Oracle, and 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;
• At least 2 years of working experience in Spark

Academics:

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

Apply For This Role