8 Window Functions Jobs

As a Staff Cloud Support Engineer at Snowflake, you will be a crucial part of the Snowflake Support team, dedicated to providing high-quality resolutions to help customers achieve data-driven business insights and results. You will work with a team of subject matter experts to ensure customer success by listening, learning, and building strong connections with customers. Your responsibilities will include working on a variety of technical issues related to operating systems, database technologies, big data, data integration, connectors, and networking. Customers will rely on you for technical guidance and expert advice on the effective and optimal use of Snowflake Data Warehouse. You will also be the voice of the customer, providing valuable product feedback and suggestions for improvement to Snowflake's product and engineering teams. In addition to providing exceptional service to customers, you will play a key role in building knowledge within the team and contributing to strategic initiatives for organizational and process improvements. Depending on business needs, you may work with Snowflake Priority Support customers, understanding their use cases and helping them achieve the highest levels of continuity and performance from their Snowflake implementation. To excel in this role, you should have a Bachelor's or Master's degree in Computer Science or equivalent discipline, along with at least 8 years of experience in a Technical Support environment or a similar customer-facing technical role. You should possess excellent writing and communication skills in English, attention to detail, and the ability to work collaboratively across global teams. As a Staff Cloud Support Engineer, you will drive technical solutions to complex problems, adhere to response and resolution SLAs, and demonstrate strong problem-solving skills. You will utilize the Snowflake environment, connectors, and third-party partners for investigating issues, document solutions, and submit well-documented bugs and feature requests. Additionally, you will proactively identify recommendations for product quality improvement, customer experience enhancement, and team efficiencies. It is essential for you to have a clear understanding of data warehousing fundamentals and concepts, debug and troubleshoot complex SQL queries, and have strong knowledge of RDBMS, SQL data types, aggregations, and functions. Experience with database migration, ETL, scripting/coding in any programming language, and working knowledge of semi-structured data is also required. Proficiency in interpreting system performance metrics and understanding cloud service providers" ecosystems is beneficial. If you have experience working with distributed databases, troubleshooting various operating systems, understanding networking fundamentals, cloud computing security concepts, and proficiency in scripting languages such as Python and JavaScript, it would be a plus. Snowflake is looking for individuals who share their values, challenge conventional thinking, and drive innovation while contributing to the company's growth and success.,

The Tableau Developer is responsible for the design, development, and implementation of information delivery solutions. You should have a minimum of 3 to 5 years of experience building and optimizing Tableau Dashboards. In addition, you should have experience in Data Blending, Dual Axis Charts, Window Functions, and Filters. It is essential to have advanced working SQL knowledge and experience working with relational databases, query authoring (SQL), as well as working familiarity with a variety of databases. Hands-on experience with Tabcmd scripting and/or TabMigrate to manage content access various Tableau sites is required. Deployment knowledge to external servers outside Tableau online is also necessary. As a Tableau Developer, you will collaborate with business users and analyze user requirements. You will be responsible for creating Tableau-based BI solutions and required supporting architecture (e.g., data marts). It is crucial to create functional & technical documentation related to Business Intelligence solutions. Additionally, you will provide thought leadership, best practices, and standards required to deliver effective Tableau solutions.,

Data Modelling,Star/Snowflake schema, Normalisation/Denormalization Snowflake,Schema design,Performance tuning, Time Travel, Streams & Tasks,Secure & Materialised Views,SQL & Scripting: Advanced SQL (CTEs, Window Functions), Automation & optimisation

As a T-SQL Database Developer with over 10 years of experience in a Global US-based Bank, you will be responsible for supporting high-performance transactional data systems in a regulated, mission-critical environment. Your expertise in T-SQL programming, stored procedures, functions, triggers, and query optimization will be crucial for ensuring the efficient operation of multi-million row queries. Your deep understanding of schema design, normalization, transactions, locking mechanisms, and SQL Server tooling will play a key role in maintaining data integrity and performance. Your primary responsibilities will include: - Advanced T-SQL Programming: Utilizing joins, CTEs, window functions, and dynamic SQL to develop efficient and effective code. - Query Optimization & Execution Plans: Hands-on tuning of queries using indexing and execution plans to improve performance. - Schema Design & Normalization: Implementing best practices for schema design, normalization, key definitions, and indexing strategies. - Transactions, Locking & Concurrency: Managing isolation levels, nested transactions, deadlock handling, and concurrency control. - SQL Server Tooling: Leveraging SSMS, DMVs, Query Store, and Activity Monitor for diagnostics and performance analysis. - Code Quality & Peer Collaboration: Participating in code reviews, adhering to SQL coding standards, and collaborating with peers on development projects. Good-to-have skills that would be beneficial for this role include experience with Azure SQL/Synapse, CI/CD for SQL using Git and Azure DevOps, SQL unit testing using tSQLt framework, monitoring tools like Redgate or SentryOne, basic knowledge of SSIS/SSRS/SSAS, and familiarity with security and compliance standards such as SOX/GDPR, encryption, and access control. If you are a detail-oriented and collaborative individual with a passion for database development and a strong background in T-SQL, this role offers an exciting opportunity to contribute to the success of a leading financial institution.,

Seeking a Sigma Developer to build dashboards, optimize SQL, integrate with JS frameworks, connect to cloud warehouses, ensure BI security, and support CI/CD. Must excel in Sigma, data modeling, and cross-team collaboration for data-driven insights. Required Candidate profile Bachelor’s in CS/Data field, 2+ yrs in Sigma/BI tools, SQL expert, experience with embedding, cloud warehouses (Snowflake/BigQuery), data modeling, BI security, and building responsive dashboards

Bachelors Degree plus at least 5-7 years of experience with minimum 3+years in SQL development Strong working knowledge on advanced SQL capabilities like Analytics and Windowing function Working knowledge of 3+ years on some RDBMS database is must have Exposure to Shell scripts for invoking the SQL calls Exposure to the ETL tools would be good to have Working knowledge on Snowflake is good to have

Role & responsibilities Work with internal stakeholders to fully understand their business problem and design solutions to meet their needs Design efficient data models and dashboards using Salesforce, Tableau, and other tools Write SQL queries to extract data from Microsoft SQL Server database for ad-hoc requests Design and automation of reoccurring report deliverables with Tableau or Microsoft SQL Server Reporting Services (SSRS) Ensure high level of accuracy and quality in all produced work Create, improve, manage reporting across multiple clients, tools and data sources Identify trends in data and provide insights to internal stakeholders Provide necessary data points for Weekly, Monthly, and Quarterly Business Reviews Skills & Qualifications: Bachelors degree or equivalent experience in MIS, IT, business, marketing, statistics, computer science or mathematics related fields Proficiency of SQL language (on any relational database platform) a plus Demonstrable relational database practices and techniques Experience in Cloud Data platforms like Snowflake a plus 7+ years working in a data or technology focused position, with preference given to database or reporting jobs Ability to explain and use joins, aggregations, pivots and windowed functions when writing queries Must have experience building and publishing dashboards in Tableau or another dashboard tool Experience building reports and dashboards within Salesforce Experience with Tableau CRM/Einstein Analytics a plus Good demonstrable data visualization skills Expertise of Microsoft Excel, including charting, functions, and pivot tables Excellent oral and written communication skills Detail oriented with strong organizational skills, ability to multitask and work in a dynamic, fast paced environment.

Who is an ideal fit for us? We seek professionals who are analytical, demonstrate self-motivation, exhibit a proactive mindset, and possess a strong sense of responsibility and ownership in their work. What will you get to work on? As a member of the Implementation & Analytics team, you will: Design, develop, and optimize complex SQL queries to extract, transform, and analyze data Create advanced reports and dashboards using SQL, stored procedures, and other reporting tools Develop and maintain database structures, stored procedures, functions, and triggers Optimize database performance by tuning SQL queries, and indexing to handle large datasets efficiently Collaborate with business stakeholders and analysts to understand analytics requirements Automate data extraction, transformation, and reporting processes to improve efficiency What do we expect from you? For the SQL/Oracle Developer role, we are seeking candidates with the following skills and expertise: Proficiency in SQL (Window functions, stored procedures) and MS Excel (advanced Excel skills) More than 2 years of relevant experience Java / Python experience is a plus but not mandatory Strong communication skills to interact with customers to understand their requirements Capable of working independently with minimal guidance, showcasing self-reliance and initiative Previous experience in automation projects is preferred Work From Office: Bangalore/Navi Mumbai/Pune/Client locations Why join us? Discover unparalleled professional and financial growth by joining our dynamic team, where we offer: A remarkable team of industry experts with a proven track record for driving impact Competitive compensation packages and a generous Employee Stock Ownership Plan Opportunities to work with leading customers across diverse industries An engaging and enjoyable work environment that fosters collaboration and innovation