30 Advanced Sql Jobs - Page 2

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.