10 Advanced Sql Jobs

About the Team As Business Analysts, its on us to dive into data and derive insights from it. These then become actionable solutions in the form of changes, improvements, upgrades and new features. As a Business Analyst at Meesho, you will play a crucial role in identifying, improving, and developing technology solutions that drive our strategic goals. This is a tremendous opportunity to learn about high-priority initiatives and collaborate with colleagues throughout the firm and across teams. We work at the intersection of business and technology, continuously developing our leadership, management and communication skills in the process. The exact team you will be working with will be decided during or after the hiring process. Regardless, you are sure to learn and grow and have fun doing so too. Each of our teams at Meesho has its own fun rituals from casual catch-ups to bar hopping, movies nights, and games. So, join us! About the Role As a Senior Business Analyst, you will work on improving the reporting tools, methods, and processes of the team you are assigned to. You will also create and deliver weekly, monthly, and quarterly metrics critical for tracking and managing the business. You will manage numerous requests concurrently and strategically, prioritising them when necessary. You will actively engage with internal partners throughout the organisation to meet and exceed customer service levels and transport-related KPIs. You will brainstorm simple, scalable solutions to difficult problems, and seamlessly manage projects under your purview. You will maintain excellent relationships with our users and in fact, advocate for them while keeping in mind the business goals of your team. What you will do Create various algorithms for optimizing demand and supply data Conduct analysis and solution-building based on insights captured from data Give insights to management and help in strategic planning Analyze metrics, key indicators and other available data sources to discover root causes of process defects Support business development and help to create efficient designs and solution processes Determine efficient utilization of resources Research and implement cost reduction opportunities Must have skills MBA in any discipline 2+ years of experience as a Business Analyst Proficiency in Advanced Excel and Advanced SQL (must-have) and Python(must have) Understanding of basic statistics and probability concepts Proven problem-solving skills

Role & responsibilities Design, develop, and optimize complex SQL queries, stored procedures, and data models for Oracle-based systems Create and maintain efficient data pipelines for extract, transform, and load (ETL) processes using Informatica or Python Implement data quality controls and validation processes to ensure data integrity Collaborate with cross-functional teams to understand business requirements and translate them into technical specifications Document database designs, procedures, and configurations to support knowledge sharing and system maintenance Troubleshoot and resolve database performance issues through query optimization and indexing strategies Preferred candidate profile 3+ years of experience with Oracle databases, including advanced SQL & PLSQL development Strong knowledge of data modelling principles and database design Proficiency with Python for data processing and automation Experience implementing and maintaining data quality controls

Job Description : Job Overview: We are seeking a highly skilled Data Engineer with expertise in SQL, Python, Data Warehousing, AWS, Airflow, ETL, and Data Modeling . The ideal candidate will be responsible for designing, developing, and maintaining robust data pipelines, ensuring efficient data processing and integration across various platforms. This role requires strong problem-solving skills, an analytical mindset, and a deep understanding of modern data engineering frameworks. Key Responsibilities: Design, develop, and optimize scalable data pipelines and ETL processes to support business intelligence, analytics, and operational data needs. Build and maintain data models (conceptual, logical, and physical) to enhance data storage, retrieval, and transformation efficiency. Develop, test, and optimize complex SQL queries for efficient data extraction, transformation, and loading (ETL). Implement and manage data warehousing solutions (e.g., Snowflake, Redshift, BigQuery) for structured and unstructured data storage. Work with AWS, Azure , and cloud-based data solutions to build high-performance data ecosystems. Utilize Apache Airflow for orchestrating workflows and automating data pipeline execution. Collaborate with cross-functional teams to understand business data requirements and ensure alignment with data strategies. Ensure data integrity, security, and compliance with governance policies and best practices. Monitor, troubleshoot, and improve the performance of existing data systems for scalability and reliability. Stay updated with emerging data engineering technologies, frameworks, and best practices to drive continuous improvement. Required Skills & Qualifications: Proficiency in SQL for query development, performance tuning, and optimization. Strong Python programming skills for data processing, automation, and scripting. Hands-on experience with ETL development , data integration, and transformation workflows. Expertise in data modeling for efficient database and data warehouse design. Experience with cloud platforms such as AWS (S3, Redshift, Lambda), Azure, or GCP. Working knowledge of Airflow or similar workflow orchestration tools. Familiarity with Big Data frameworks like Hadoop or Spark (preferred but not mandatory). Strong problem-solving skills and ability to work in a fast-paced, dynamic environment. Role & responsibilities Preferred candidate profile

Were seeking a Senior Software Engineer or a Lead Software Engineer to join one of our Data Layer teams. As the name implies, the Data Layer is at the core of all things data at Zeta. Our responsibilities include: Developing and maintaining the Zeta Identity Graph platform, which collects billions of behavioural, demographic, locations and transactional signals to power people-based marketing. Ingesting vast amounts of identity and event data from our customers and partners. Facilitating data transfers across systems. Ensuring the integrity and health of our datasets. And much more. As a member of this team, the data engineer will be responsible for designing and expanding our existing data infrastructure, enabling easy access to data, supporting complex data analyses, and automating optimization workflows for business and marketing operations. Essential Responsibilities: As a Senior Software Engineer or a Lead Software Engineer, your responsibilities will include: Building, refining, tuning, and maintaining our real-time and batch data infrastructure Daily use technologies such as Spark, Airflow, Snowflake, Hive, Scylla, Django, FastAPI, etc. Maintaining data quality and accuracy across production data systems Working with Data Engineers to optimize data models and workflows Working with Data Analysts to develop ETL processes for analysis and reporting Working with Product Managers to design and build data products Working with our DevOps team to scale and optimize our data infrastructure Participate in architecture discussions, influence the road map, take ownership and responsibility over new projects Participating in on-call rotation in their respective time zones (be available by phone or email in case something goes wrong) Desired Characteristics: Minimum 5-10 years of software engineering experience. Proven long term experience and enthusiasm for distributed data processing at scale, eagerness to learn new things. Expertise in designing and architecting distributed low latency and scalable solutions in either cloud and on-premises environment. Exposure to the whole software development lifecycle from inception to production and monitoring Fluency in Python or solid experience in Scala, Java Proficient with relational databases and Advanced SQL Expert in usage of services like Spark and Hive Experience with web frameworks such as Flask, Django Experience in adequate usage of any scheduler such as Apache Airflow, Apache Luigi, Chronos etc. Experience in Kafka or any other stream message processing solutions. Experience in adequate usage of cloud services (AWS) at scale Experience in agile software development processes Excellent interpersonal and communication skills Nice to have: Experience with large scale / multi-tenant distributed systems Experience with columnar / NoSQL databases Vertica, Snowflake, HBase, Scylla, Couchbase Experience in real team streaming frameworks Flink, Storm Experience in open table formats such as Iceberg, Hudi or Deltalake

Architect and develop apps (.NET Core, Angular, SQL Server) Design and optimize database schemas Ensure coding/testing best practices Conduct code reviews Collaborate with cross-functional teams Stay updated with new tech Troubleshoot complex issues

Design, develop, and implement data solutions using Azure Data Stack components . Write and optimize advanced SQL queries for data extraction, transformation, and analysis. Develop data processing workflows and ETL processes using Python and PySpark. Implement data solutions using Azure Data Stack components .

Design, develop, and implement data solutions using Azure Data Stack components . Write and optimize advanced SQL queries for data extraction, transformation, and analysis. Develop data processing workflows and ETL processes using Python and PySpark.

Proficient in T-SQL for complex database querying and optimization Expertise in Power BI desktop and service for report/dashboard development Hands-on experience with SQL Server database design and management Strong data modeling skills, including dimensional modeling and star schema Ability to transform raw data into meaningful, actionable information Preferred Skills ("Good to Have"): Experience with Azure Data Services (e.g., Azure SQL, Azure Synapse Analytics, Azure Data Factory) Knowledge of data warehousing concepts and best practices Familiarity with ETL processes and data integration tools Understanding of Power BI governance, security, and deployment strategies Exposure to agile software development methodologies Strong problem-solving and analytical skills Excellent communication and stakeholder management abilities Key Responsibilities: Design and develop interactive, visually appealing Power BI dashboards and reports Implement complex data models and DAX calculations to meet business requirements Optimize SQL queries for high performance and scalability Automate data refresh processes and implement data security protocols Collaborate with business stakeholders to understand reporting needs Provide technical guidance and training to end-users Continuously improve dashboard design, functionality, and user experience Stay up-to-date with the latest Power BI and MS-SQL Server features and best practices

About this role: Wells Fargo is seeking a Analytics Consultant In this role, you will: Consult with business line and enterprise functions on less complex research Use functional knowledge to assist in non-model quantitative tools that support strategic decision making Perform analysis of findings and trends using statistical analysis and document process Present recommendations to increase revenue, reduce expense, maximize operational efficiency, quality, and compliance Identify and define business requirements and translate data and business needs into research and recommendations to improve efficiency Participate in all group technology efforts including design and implementation of database structures, analytics software, storage, and processing Develop customized reports and ad hoc analyses to make recommendations and provide guidance to less experienced staff Understand compliance and risk management requirements for supported area Ensure adherence to data management or data governance regulations and policies Participate in company initiatives or processes to assist in meeting risk and capital objectives and other strategic goals Collaborate and consult with more experienced consultants and with partners in technology and other business groups Required Qualifications: 2+ years of Analytics experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education Desired Qualifications: Bachelors degree or higher in a quantitative field such as computer sciences, engineering, applied math, accounting, finance, economics, econometrics with a quantitative emphasis. Experience in one or a combination of the following: Data quality, reporting, analytics. Prior experience in an internal/external consultative role and/or investment banking/corporate banking support experience is preferred. Prior experience in handling small or medium complexity projects individually, complex or large-scale project participation, experience with matrix managed teams is a plus Candidates should have a solid mastery of Advanced SQL, Advanced Excel, Power BI, knowledge in performing ETL tasks using SQL / Python, Microsoft PowerPoint skills The successful candidate will have a very strong interest in developing both business and technical skills while navigating a dynamic business environment. Excellent verbal, written, and interpersonal communication skills Strong analytical skills with high attention to detail and accuracy Experience with and knowledge of relational databases and concepts Ability to interact and build relationships with senior leaders, peers and key support partners. Ability to work creatively, analytically and independently in a dynamic environment. Exceptional oral and written communication skills and ability to communicate effectively with both business unit (non-technical) and development (technical) personnel. Experience documenting processes and reporting workflows Job Expectations: Strong Individual contributor with excellent communication skills for a variety of audiences (other technical staff and senior management) both verbally and in writing Experience in problem analysis, solution implementation, and change management Must make timely and independent judgment decisions while working in a fast-paced and results-driven environment Ability to articulate issues, risks and proposed solutions to various levels of staff and management Capability to multi-task and finish work within strict timelines and provide timely requests for information and follow-up questions Skill in managing relationships with key stakeholders Eagerness to contribute collaboratively on projects and discussions Perpetual interest in learning something new, but being comfortable with not knowing all the answers Attention to detail in both analytics and documentation Connects with customers to understand and document business processes workflow. Develop understanding of business processes and recommend efficiency based on technical and architectural knowledge Provide both technical consulting to business leaders at an appropriate level of information encapsulation Apply critical thinking skills and perform advanced analytics with the goal of solving complex and multi-faceted business problems. Develop reports using Power BI, SQL, Tableau, Python, Excel or various other tools Having SSRS knowledge will be added advantage Verify accuracy of reports, reconciling data and producing data/information within established timelines Generate deep insights through the analysis of data and understanding of operational processes and turn them into actionable recommendations Work with technology partners to managing tables, views and other database structures to adapt to changing business needs and in compliance with embedded IT policies. Answer ad hoc questions from customers including confirming data, populating templates provided to the group or creating new reports/extracts as requested by customers Collaborate with team members to operate at higher level of dimensionality to innovate and bring in game changing ideas to fruition Partner with business stakeholders in the development of key business reporting (e.g. Portfolio level dashboard, Productivity, regulatory reporting etc.) and optimal delivery channels for the distribution of the reporting solutions

We are looking for a skilled Intermediate Quest One Identity Manager Developer with 3 to 8 years of experience to join our team. The ideal candidate will have expertise in custom connector development, advanced workflow configurations, and optimizing synchronization processes for large-scale identity management. ### Roles and Responsibility Design and implement custom workflows using designer and Object Browser for complex provisioning tasks. Develop and maintain custom connectors for integrating with external systems using Synchronization Editor and APIs. Write advanced SQL stored procedures, triggers, and custom queries for data reconciliation and manipulation within One Identity’s database. Configure and optimize Job Service and DBQueue to handle high-volume job processing and resolve performance bottlenecks. Develop complex VBScript and PowerShell scripts to implement business logic. Implement and configure role mining and role lifecycle management processes, ensuring role compliance and SoD policy enforcement. Extend the functionality of the Web Portal by customizing UI forms, adding new fields, and configuring specific approval workflows for access requests. Perform advanced troubleshooting using Job Queue Info, analyzing detailed logs, and debugging synchronization and provisioning failures. Implement and maintain the attestation process, ensuring compliance through periodic certification of user roles and entitlements. Lead efforts to implement custom reporting using SSRS or One Identity Reporting Module to deliver access governance insights. Integrate One Identity Manager with cloud services (e.g., Azure AD, AWS IAM) and on-prem applications using custom-developed connectors. ### Job Requirements In-depth knowledge of Quest One Identity Manager architecture, including Application Server, Job Server, and Data Governance Edition. Advanced SQL skills for writing stored procedures, views, and triggers. Proficiency in VBScript, PowerShell, and knowledge of One Identity Manager API. Strong experience with Synchronization Editor for developing custom connectors. Deep understanding of Active Directory, LDAP, HR systems, Azure, and other integrated systems. Familiarity with SoD policies, role mining, and advanced RBAC configuration.