Role: Technical Business Analyst with Strong SQL Queries Location: Connecticut (Onsite - Hybrid) Mode: Long-term Contract Key Skill: SQL queries, Data warehousing, Data analysis, Data mapping Secondary skill: Banking /cards domain exposure Skills: · Undergraduate degree with 5-10 years of relevant experience as a BSA in data warehousing environments · Strong Experience in SQL programming languages · Experience in ETL Informatica · Expertise in using analytical software tools, data analysis methods and reporting techniques. · Expertise in data storage and movement, including relational and big data · Strong analytical and problem-solving skills · Proficient to analyze, organize and prioritize work while meeting multiple deadlines. · Proficient to work cooperatively and independently as part of a Scaled Agile pod · Effective communication skills (oral and written) with the ability to build positive relationships across teams ------------------------------------------------------------------------------------ Please share your profile if interested - kedar@techtalentnet.com & Jigar@techtalentnet.com
Technology Talent Network LLC’s Post
More Relevant Posts
-
During the #laidoff trends, we are #hiringnow for our clients. Check out the below role, like and share with your network to help others during this difficult time. If you are #opentowork ,then follow out page immediately as we are still #hiringpost #hiring
#allitsolutions #c2c #c2crequirements #dataanalytics #dataanalyst #dataarchitecture #dataanalystjobs #datawarehouse #datawarehousing Hi Professionals, Greetings from All IT Solutions LLC, One of Our Client hiring resources for following Project Data Warehouse Developer/Analyst (9+ years with Mortgage/House loans domain) NYC, NY (100% Onsite) Long Term Contract Tax Terms: C2C Prior experience in the Home Loans, Mortgages, loans origination and servicing or related projects is required. Job Description Experience on design and development of Data Warehouse Architecture for Enterprise Data Warehouse (EDW), Operational data Store (ODS), Operational Data Marts and Data Marts. Experience in defining metadata standards for the enterprise data warehouse. Experience in design and development of: ETL processes using Dimensional Modeling for ROLAP and MOLAP. ETL technical architecture. BI load dependency plan, job scheduling and cycle management. Experience in developing end-to-end Data warehouse ETL routines. Experience in using SQL in advanced analytical functions. Experience in writing complex PL/SQL packages stored Procedures, functions, cursors, triggers, views, and materialized views. Experience developing optimal approach for obtaining data from diverse source system platforms and moving it to the Enterprise Data Warehouse. Experience in Logical and Physical data Models for enterprise data warehouse and applications. Experience developing and configuring Interactive Dashboards with drill-down capabilities, links/images, HTML objects and folders. Proficient in using the time-series functions to support historical time comparison analysis. Experience with Calculated Measures and assigned Aggregation levels based on Dimension Hierarchies. Bachelor's degree; MBA or relevant technical degree preferred. A strong background in technology, analysis and critically evaluating information gathered from multiple sources. Experience decomposing high-level information into details, distinguishing user requests from the underlying true needs, and developing solution ideas from requirements. Strong experience writing business requirements documentation (BRDs) and functional requirements documentation (FRDs). Proven experience successfully working in a team setting and ability to reconcile conflicts. Minimum seven 7-10 years of experience in related professional business/project analyst capacity. Excellent oral and written communication skills. Excellent experience with MS Office 2013/2016 and above as well as design tools and flowcharting tools Thanks & Regards, Ishan Shukla Technical Recruiter All IT Solutions LLC +1 609-503-7881 || ishan@allitsolutions.us
To view or add a comment, sign in
-
During the #laidoff trends, we are #hiringnow for our clients. Check out the below role, like and share with your network to help others during this difficult time. If you are #opentowork ,then follow out page immediately as we are still #hiringpost #hiring
#allitsolutions #c2c #c2crequirements #dataanalytics #dataanalyst #dataarchitecture #dataanalystjobs #datawarehouse #datawarehousing Hi Professionals, Greetings from All IT Solutions LLC, One of Our Client hiring resources for following Project Data Warehouse Developer/Analyst (9+ years with Mortgage/House loans domain) NYC, NY (100% Onsite) Long Term Contract Tax Terms: C2C Prior experience in the Home Loans, Mortgages, loans origination and servicing or related projects is required. Job Description Experience on design and development of Data Warehouse Architecture for Enterprise Data Warehouse (EDW), Operational data Store (ODS), Operational Data Marts and Data Marts. Experience in defining metadata standards for the enterprise data warehouse. Experience in design and development of: ETL processes using Dimensional Modeling for ROLAP and MOLAP. ETL technical architecture. BI load dependency plan, job scheduling and cycle management. Experience in developing end-to-end Data warehouse ETL routines. Experience in using SQL in advanced analytical functions. Experience in writing complex PL/SQL packages stored Procedures, functions, cursors, triggers, views, and materialized views. Experience developing optimal approach for obtaining data from diverse source system platforms and moving it to the Enterprise Data Warehouse. Experience in Logical and Physical data Models for enterprise data warehouse and applications. Experience developing and configuring Interactive Dashboards with drill-down capabilities, links/images, HTML objects and folders. Proficient in using the time-series functions to support historical time comparison analysis. Experience with Calculated Measures and assigned Aggregation levels based on Dimension Hierarchies. Bachelor's degree; MBA or relevant technical degree preferred. A strong background in technology, analysis and critically evaluating information gathered from multiple sources. Experience decomposing high-level information into details, distinguishing user requests from the underlying true needs, and developing solution ideas from requirements. Strong experience writing business requirements documentation (BRDs) and functional requirements documentation (FRDs). Proven experience successfully working in a team setting and ability to reconcile conflicts. Minimum seven 7-10 years of experience in related professional business/project analyst capacity. Excellent oral and written communication skills. Excellent experience with MS Office 2013/2016 and above as well as design tools and flowcharting tools Thanks & Regards, Ishan Shukla Technical Recruiter All IT Solutions LLC +1 609-503-7881 || ishan@allitsolutions.us
To view or add a comment, sign in
-
#Hiring SAS Fraud Management Developer #sas #fraudmanagement #sasdeveloper #sasprogrammer share resume at rsingh@reqroute.com ONSITE (Riverside, Illinois) If candidate is stellar, may be able to negotiate with client on remote. Top 3 Must Have's: 1. SAS Fraud management – more back end developer 2. JAVA 3. Unix Shell Scripting JD from HM: SAS Fraud Management Programming and Development: Develop, optimize, and maintain SAS programs and scripts for data extraction, transformation, and analysis. SAS Backend developer who can able to implement the software installations, understand different component of SAS FM, and how they work with each other. Java experience Unix shell scripting experience. Convert existing SAS FM code into SAS Visual Analytics reports and dashboards. Data Manipulation and Transformation: Perform data cleansing, transformation, and integration to prepare data for analysis. Connect to new data sources and maintain data integrity. Analytics and Insights: Implement statistical and predictive models using SAS to derive insights and solve complex business problems. Create informative and interactive data visualizations using SAS or similar tools. Collaboration and Documentation: Work closely with cross-functional teams, including data scientists, analysts, and business stakeholders, to understand their requirements and provide analytical solutions. Document SAS code, processes, and methodologies to ensure reproducibility and knowledge sharing within the team. Performance Optimization and Quality Assurance: Identify opportunities to optimize code and processes for efficiency and scalability. Conduct quality checks and testing to ensure data accuracy and model reliability. Compliance and Security: Adhere to data privacy and security guidelines while handling sensitive information.
To view or add a comment, sign in
-
Hello Everyone, Looking for.... Only USC or GC, Need Locals or who can relocate Title: Data Analyst With Data Migration Exp Location: Deerfield Beach, Florida - Hybrid Duration 6 months+ MUST NEED: · Data migration and conversion of Data from Mainframes to Azure · Strong in Azure SQL · Strong in Data Validation and Data Extraction Must need: Data quality work closely on the data migration and SME on the business side. Look at data to see if they want to convert all the data. How many distinct values? Maybe we don’t need all of them. The project is a migration from the mainframe to another tool. This role will help with data migration. Look at data on the mainframe, data quality, and opportunities for improvement. Business rules, to convert data Extract data Data validation Query the source and target Run validations to make sure data was moved properly Reconciliation Strong SQL, need to be able to write SQL Azure SQL is a big plus (azure will be the source for the conversions) Talk to businesses, about their findings, asking for guidance, such as do you want to covert all this data, etc. Convert data from one system to another. It’s not determined yet. Staging data in Azure/Cloud. Please share your resumes at kiran.vaddi@3coresystems.com #DataAnalyst #Analyst #Migration #Azure #DataMigration #SQL #jobs #C2C #W2
To view or add a comment, sign in
-
Founder & President @ Nigel Corneal BDM Service Network Inc. | Helping Job Seekers & Employers to Get Hired & Hire in Canada and USA
#OpportunityAlert: Know someone for this job? Could you tag them in the comments to share with them? #hiring #jobseekers #careerists #jobs #careers #jobopportunity #jobopportunities #careeropportunity #careeropportunities courtesy https://lnkd.in/eJFHduU
Data Analyst III Duration-12-24 Months Location-Must be local to Houston and willing to go downtown madhuri.p@connectpinnacle.com Visa: Only USC || GC || GC-EAD || H4-EAD Data Analyst must have 6-7 years’ experience as a Data Analyst and experience Data profiling of SORs and understanding how the data should be extracted to support use cases The main function of a Data Analyst is to coordinate changes to computer databases, test, and implement the database applying knowledge of database management systems. Job Responsibilities: Work with senior management, technical and client teams in order to determine data requirements, business data implementation approaches, best practices for advanced data manipulation, storage and analysis strategies Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions Design, implement, automate and maintain large scale enterprise data ETL processes Modify existing databases and database management systems and/or direct programmers and analysts to make changes Test programs or databases, correct errors and make necessary modifications Required: Experience with database technologies Knowledge of the ETL process Knowledge of at least one scripting language Strong written and oral communication skills Strong troubleshooting and problem solving skills Demonstrated history of success Desire to be working with data and helping businesses make better data driven decisions Education/Experience: Bachelor's degree in a technical field such as computer science, computer engineering or related field required 5-7 years applicable experience required With Submittal Include Resume and All of Below Full Legal Name of Candidate as Appears on License Status in the US-Green Card or US Citizen Last 4 of Social Security Number a MUST Birth Month and Day City and State where reside Email of Candidate Phone of Candidate Avail. to Interview Availability-Date they can start Corporation Name Corporation Contact Corporation Contact Direct Phone and Email Corp Address Thanks & Regards sujith.a@connectpinnacle.com
To view or add a comment, sign in
-
Title: Sr. Data Analyst Location: Everett, MA (Need Locals) Employment Type: W2 Responsibilities: 1. Collaborate with business research analysts to identify data needs. 2. Create and document data marts and queries for business data needs, ensuring that resulting data match existing reports with fidelity. 3. Write and review documentation to contribute to a business rules data handbook, capturing data rules in user- friendly language. 4. Reverse engineer schemas and queries using available tools and methodologies, with the goal of understanding and documenting business rules that are applied in existing data loading processes. 5. Translate complex problems into detailed specifications and design solutions using data processing systems. 6. Create and maintain entity-relationship diagrams (ERDs) and perform database modeling, including logical, physical, and presentation tiers. 7. Provide technical and database support for in-house applications, ensuring optimal performance and user satisfaction. 8. Contribute to the knowledge base, sharing best practices and lessons learned with the Edwin team. 9. Maintain code in GitHub, ensuring proper version control and adherence to coding standards. 10. Accurately and promptly log all work, including estimates and time spent, in JIRA. 11. Facilitate the adoption of efficient coding practices and innovative solutions. Required qualifications: 1. Understand data warehouse concepts and needs. 2. Expert knowledge of databases, Snowflake a plus, also Oracle and SQL Server. 3. Excellent communication skills with a demonstrated ability to communicate ideas clearly in both technical and user-friendly language, both in writing and orally. 4. Strong attention to detail and troubleshooting skills for QA; able to identify errors/discrepancies, isolate the cause, apply solutions and validate the resulting data. 5. Experience with dimensional modeling and knowledge of proper data structures for analytical reporting from an enterprise data warehouse. 6. Good knowledge of applicable data privacy when handling sensitive personal information. 7. Team player who enjoys being part of a supportive team, with a willingness to learn and share knowledge among team members. Preferred qualifications: 1. Experience using database reporting tools such as PowerBI and Tableau. 2. Experience using data cataloging tools such as Alation and Socrata. 3. Experience mentoring other analysts and teaching SQL. 4. Confidence recommending policies and procedures to improve database operations and overall computer systems efficiency. 5. Ability to diagram complex data structures. 6. Ability to perform tasks such as analyzing, moving, and loading data, as well as developing T-SQL, PL/SQL, ANSI SQL, or other proprietary SQL languages. Please reach me at: agundabathula@encloudservices.com
To view or add a comment, sign in
-
Python | SQL | Power BI | SSIS| LLMOPS | AZURE |Driving Data-Driven Solutions to Elevate Business Operations and Fuel Growth📊📃
SQL Topics to Learn for Data Analyst/Business Analyst Roles 1. Basic: * SELECT statements * WHERE clause * JOINs (INNER, LEFT, RIGHT, FULL) * GROUP BY and HAVING * ORDER BY * Basic Aggregate Functions (COUNT, SUM, AVG, MIN, MAX) 2. Intermediate: * Subqueries * CASE statements * UNION and UNION ALL * Common Table Expressions (CTEs) * Window Functions (ROW_NUMBER, RANK, DENSE_RANK, OVER) * Data Manipulation (INSERT, UPDATE, DELETE) * Indexes and Performance Tuning 3. Advanced: * Advanced Window Functions (LEAD, LAG, NTILE) * Complex Subqueries and Correlated Subqueries * Advanced Performance Tuning #SQL #Data Analyst
To view or add a comment, sign in
-
Role: Senior Business data Analyst Location: NYC NY(Only Locals) 3 Days Hybrid from Day 1 Client: Jefferies Try for Local Candidates Looking for strong Investment Banking Domain experience. BA Domain: Investment Banking and Capital Markets Strong SQL Data Mart and Data Warehouse (DWH) projects. BI/Reporting concepts Cloud technologies or NoSQL databases Client Interview feedback for your reference: Candidate: 1 He has no exposure or hands-on experience with Data Mart and Data Warehouse (DWH) projects. He was unable to explain basic DWH and Data Mart concepts using real-time examples from his projects. It appears that he has primarily worked on data migration projects. His SQL skills are weak. He struggled with writing queries using basic SQL clauses. He mentioned that before joining BNY Mellon, he did not use SQL extensively and had minimal exposure to it. He also stated that he began learning and working with SQL at BNY Mellon. His data analysis skills are below average. His data profiling skills are passable, but not strong. He has always worked with deliverables that have a monthly release cadence, not biweekly or weekly. I don't believe he will be able to handle deliverables at Jefferies' pace. He has no exposure to any Cloud technologies or NoSQL databases, which are key components of our upcoming tech stack in Reporting and a crucial tech stack in MDP. He has no exposure to Entity-Relationship Diagrams (ERDs). Lacks IB & CM domain experience as well Candidate: 2 His relevant Tech BA experience is only 3.5 years. Additionally, he could not provide information about any other tools except Jira or elaborate on his roles and responsibilities as a Tech BA. He Is not a fit with Jefferies' work environment and culture. He is very passive, lacks enthusiasm, and could potentially disengage others within a few minutes. He has never played a lead role. He won’t be able to handle business stakeholders and delivery timelines He speaks at a very high level and was unable to share details despite my attempts to dig deeper. Although he mentioned using Azure, he could not name even a single Azure service. He could not use a simple example to explain DataMart. He lacks depth in basic SQL and could not perform basic joins. Candidate: 3 She doesn't understand what a Data Mart, dimensions, and measures are. She has never worked with Data Mart or Data Warehouse projects, or any other data-intensive projects. Her SQL skills are very weak. For sorting records, she used the GROUP BY clause and could not use basic functions like MIN(), MAX(), and GROUP BY clauses. For BI Reporting projects, she mentioned that she worked as a Scrum Master, not a Business Analyst, and so she does not have hands-on experience there as well. lucky.ns@quadrantiq.com
To view or add a comment, sign in
-
Hello👋🏻 #connections Unison Consulting is hiring 📢 Whatsapp me your CV at +60 19-994 5806 (Vahini UnisonTechMY) or email me at (vahini@unisontech.my #HIRING #IMMEDIATEHIRING #MALAYSIAHIRING (SN 53) Domain : Data Sub Domain : FRR RFP Role : System Analyst Years of experience : "L4 (>10 years) Platform Product : "TD with FSLDM Server Database : "Teradata, Hadoop , Oracle - Good to know Language : "Must-Have - TD with FSLDM 1. SA/ BA Role - 3yrs minimum in Domain knowledge in Data Modeler, Data Modeling/Profiling/Mapping and Marts 2. Banking experience in functional (any one or two) Business Analysis / Business Acumen - Finance Analytics - Financial Reconciliation, Allocation, Performance Management & Regulatory Reporting - Credit Risk Analytics - Credit Risk Exposure Reporting (Industry, Disclosures, Country of Risk), NPL, Counterparty Risk Reporting - Credit Scoring & Decision Support Systems – Behavior Scores, Collection, Customer Segmentation - Product Knowledge - Treasury & Wealth Management (Murex) - Product Knowledge - Trade Finance & Accounts Receivable Management (FITAS, ARF) - Product Knowledge - Retail Bank, Cards (Silver Lake, Cardpac) - Data Modeling (FSDM / Data Marts) Finance-GL, Risk, Wholesale, Retail, Core, wealth, trade, insurance, deposits, Customer management, Credit management, Tax, Compliance, Regulatory, Credit risk reporting, GL/Finance-Recon, BCBS 239, Basel etc Good understand on data modeling concepts in Banks & has exposure in Hadoop & Data lakes. Knowledge & exposure in AI/ML development, DB2, AS400, QLIK sense, Query Surge, Microsoft Power BI, Business Objects, PUTTY, Aldon, control-M Good-to-Have -Banking Domain Knowledge New Mandatory - Should be certified in any two technoligies listed, and should have worked in Banking domain as per below roles/profile requirements 1. Database: Teradata DB or Hadoop Hive (Certified in any one) with Oracle backend knowledge. 2. Data warehousing: Teradata (SQL, FSLDM/FSD, GCFR, TD Studio, IFX, MDM, View Point, TASM) 3. ETL: Informatica or SAS (Certified in any one) 4. Big Data/Data Science/Discovery platfrom: HDFS/Hive/HUE/Scala & AI/ML(Certified Developer) 5. Data Analytics: SAS or Qlik Sense or PowerBI or Splunk/R Studio/Python (Certified in any) 6. CI/CD or DevOps - tools JIRA or Jenkins or Bit Bucket or Query Surge 7. Red Had OpenShift (core knowledge in managing containers through hands-on experience with containers, Kubernetes, and the Red Hat OpenShift Container Platform) Applies for CPM only AS400, TeraData (TD Studio, IFX, MDM, FSLDM/GCFR, View Point ), JIRA, Oracle SQL Developer, Informatica - BDM, IDQ, IDL , Query Surge, Cloudera - Data Science workbench, Spark , HUE, Hive, Impala, Kafka, Microsoft R, SAS, Jenkins, Bit Bucket, SonarCube, QLIK sense , Query Surge, Microsoft Power BI, Business Objects, PUTTY, Aldon, control-M" OS : "Linux/Windows/AIX/ Unix Other requirements : "Good-to-have: SDLC, PLC, CI/CDt, DevOps, Agile practices..
To view or add a comment, sign in
7,088 followers