SQL Data Analyst

2 weeks ago

New York, United States Velocity Search Group Full time

Our client a leading asset management firm, located in New York City is looking to hire a SQL Data Analyst. As a Data Analyst, your primary focus will be to develop and execute a comprehensive data strategy, establish robust data governance practices, and ensure efficient reporting solutions within our organization. You will play a pivotal role in shaping the data landscape, enabling data-driven decision-making, and optimizing data assets to drive business success. You will also work closely with the business to understand their data requirements and deliver solutions to support their needs. This is a Full Time Position. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor currently. Qualified candidates should send their resumes (Word Format) along with salary expectations to careers@velocitysgi.com .

MUST HAVE AZURE SSIS (AZURE SYNAPSE)

RESPONSIBILITIES

  • Design and implement a forward-looking data strategy that aligns with the organization's business objectives, incorporating industry best practices and emerging data technologies.
  • Define and maintain a scalable, efficient, and flexible data architecture that accommodates diverse data sources and formats, while enabling seamless data integration and access. Work closely with business stakeholders to align architecture with their requirements.
  • Design and develop robust ETL (Extract, Transform, Load) processes to efficiently move, cleanse, and transform data from various sources into a central data repository, meeting business needs.
  • Implement and manage master data management solutions to ensure data consistency, accuracy, and reliability across the organization, in collaboration with various departments.
  • Collaborate with business stakeholders to define reporting requirements and deliver business intelligence and reporting solutions that provide actionable insights. Work closely with various departments to understand their reporting needs.
  • Establish data quality standards, conduct data profiling, and implement data quality improvement processes to maintain data integrity, with consideration for business-specific data quality requirements.
  • Create and maintain comprehensive documentation of data assets, data flows, and data definitions, making it accessible to relevant business teams.
  • Continuously assess emerging data technologies and tools to keep the organization up-to-date and competitive.
  • Design and implement databases to reflect new and existing business requirements.
  • Evaluate current data designs and databases to determine needed, upgrades and improvements.
  • Design and automate various internal and external reports using SSRS, InDesign and Power BI.
  • Communicate with many different company stakeholders to assess needs and goals.
  • Interpret functional and business requirements, design and implement solutions and architecture suited to our current business model and enhance them.
QUALIFICATIONS
  • Bachelor's or Master's degree in Computer Science, Data Science, Information Systems, or a related field.
  • 2+ years working experience in IT at Financial Institutions.
  • 3+ years full stack development of enterprise applications and database solutions.
  • Hands on experience with SQL Server, Azure, SSRS, Power BI.
  • Experience in data architecture, data strategy, data governance, and reporting.
  • In-depth knowledge of database management systems, data modeling, ETL processes, and reporting tools
  • Excellent communication and interpersonal skills for collaboration with cross-functional teams and stakeholders
  • Knowledge of industry best practices and data management trends
  • Skills and Abilities:
  • Knowledge of business domain is recommended.
  • Proficiency in Azure data services and technologies.
  • Strong understanding of data architecture, data modeling, and data governance principles.
  • Knowledge of ETL processes and tools, particularly within the Azure ecosystem.
  • Experience with master data management (MDM) and data quality management.
  • Expertise in data reporting and analytics tools, especially those integrated with Azure.
  • In-depth knowledge of data security and compliance, including Azure security practices.
  • Excellent documentation and communication skills.
  • Expertise in T-SQL and SQL Server Data Management Services (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)Solid knowledge of T-SQL (SQL Server) which includes stored procedures, UDF's and query optimization.
  • Solid knowledge of ETL, SSRS and Power BI.
  • Experience in T-SQL, SSRS, Power BI and SQL Server database management system.
  • Good understanding of Azure environment and DevOps.
  • InDesign Automation a plus.
Salary 100-120k

  • SQL Data Analyst

    4 days ago

    New York, United States PruTech Solutions, Inc. Full time

    Job Duties:• Collaborate with relevant teams to gather data related to IT service performance, including operational metrics and customer feedback.• Monitor and analyze service performance data to identify trends, anomalies, and areas for improvement. Conduct in-depth analysis of service performance data, generate reports, and provide actionable insights...

  • SQL Data Analyst

    4 days ago

    New York, United States PruTech Solutions, Inc. Full time

    Job Duties:• Collaborate with relevant teams to gather data related to IT service performance, including operational metrics and customer feedback.• Monitor and analyze service performance data to identify trends, anomalies, and areas for improvement. Conduct in-depth analysis of service performance data, generate reports, and provide actionable insights...

  • Data Analyst

    2 months ago

    New York, New York, United States Dash techology Full time

    Job briefWe are looking for a passionate certified Data Analyst. The successful candidate will turn data into information information into insight and insight into business decisions.Data Analyst Job DutiesData analyst responsibilities include conducting full lifecycle analysis to include requirements activities and design. Data analysts will develop...

  • Data Analyst

    2 months ago

    New York, United States Dash techology Full time

    Job briefWe are looking for a passionate certified Data Analyst. The successful candidate will turn data into information information into insight and insight into business decisions.Data Analyst Job DutiesData analyst responsibilities include conducting full lifecycle analysis to include requirements activities and design. Data analysts will develop...

  • Data Analyst

    7 days ago

    New York, United States Tata Consultancy Services Full time

    Position: Data Analyst LeadLocation: New York, NY/ Jersey City, NJ/Tampa, FL / Irving, TX (Onsite)Duration: FTEJob Description:6-10 Years of Experience.Key Skills: ETL, SQL, Data warehouse, Data Analyst• Hands-on experience on Data Analyst role preferable with BFSI domain• ETL, Power BI, SAS, SQL, Tableau, Excel Pivot or some sort of analytical tool...

  • Data Analyst

    2 months ago

    New York, United States Wipro Limited Full time

    Experience Bachelor’s Degree in Mathematics or Computer Engineering 0-2 years of experience as a Data Analyst on a BI team or complex BI initiative working closely with business stakeholders. 1+ years’ Data mining experience a plus Advanced knowledge of Microsoft Excel Ability to understand formulas and aggregations from any Excel source Strong...

  • Data Analyst

    2 months ago

    New York, New York, United States Wipro Limited Full time

    Experience Bachelor's Degree in Mathematics or Computer Engineering 0-2 years of experience as a Data Analyst on a BI team or complex BI initiative working closely with business stakeholders. 1+ years' Data mining experience a plus Advanced knowledge of Microsoft Excel Ability to understand formulas and aggregations from any Excel source Strong knowledge...

  • Financial Data Analyst

    4 days ago

    New York, United States Amtex Systems Inc. Full time

    Title: Financial Data AnalystLocation: Queens, NYDuration: Indefinite· Minimum of 2 years of relevant experience in financial reporting, advanced analytics and delivering actionable insights from data using SQL and Microsoft Excel· Understands data relationships among various tables in SQL Data warehouse · Cleans, manipulates and analyzes large sets of...

  • Financial Data Analyst

    4 days ago

    New York, United States Amtex Systems Inc. Full time

    Title: Financial Data AnalystLocation: Queens, NYDuration: Indefinite· Minimum of 2 years of relevant experience in financial reporting, advanced analytics and delivering actionable insights from data using SQL and Microsoft Excel· Understands data relationships among various tables in SQL Data warehouse · Cleans, manipulates and analyzes large sets of...

  • Investment Data Analyst

    4 weeks ago

    New York, United States Innovative Management Solution Full time

    **Title : Investment Data Analyst** **Location : Wellesley, MA / New York city, NY (Hybrid 3 days onsite/ 02 days remote)** **Duration: 10 Months Contract** **Required Skills**: - Oracle/SQL Skills - Experience with client onboarding projects for Investment Operations outsourcing. - Perform business analysis activities such as requirements gathering,...

  • Financial Data Analyst

    2 weeks ago

    New York, United States Amtex Systems Inc. Full time

    Title: Financial Data AnalystLocation: Queens, NYDuration: IndefiniteDescription:Looking for Financial Analyst with 5+ Years of ExperienceExperience with Financial Data Analysis is neededStrong Experience with SQL is needed

  • Financial Data Analyst

    2 weeks ago

    New York, United States Amtex Systems Inc. Full time

    Title: Financial Data AnalystLocation: Queens, NYDuration: IndefiniteDescription:Looking for Financial Analyst with 5+ Years of ExperienceExperience with Financial Data Analysis is neededStrong Experience with SQL is needed

  • Technical Data Analyst

    2 weeks ago

    New York, United States Mondo Staffing Full time

    Apply now: Technical Data Analyst, location is Remote. The start date is ASAP for this 12+month contract position. Job Title: Technical Data Analyst Location-Type: Remote Start Date Is: ASAP Duration: 12+month contract Compensation Range: $50-$75/hr Job Description: We are seeking a highly skilled Technical Data Analyst to join our team on a remote basis....

  • Technical Data Analyst

    2 weeks ago

    New York, United States Mondo Full time

    Job DescriptionJob DescriptionApply now: Technical Data Analyst, location is Remote. The start date is ASAP for this 12+month contract position.Job Title: Technical Data AnalystLocation-Type: RemoteStart Date Is: ASAPDuration: 12+month contractCompensation Range: $50-$75/hrJob Description:We are seeking a highly skilled Technical Data Analyst to join our...

  • Programmer Data Analyst

    2 months ago

    New York, United States Atechstar Full time

    Responsibilities Review business and functional requirements Assist in producing high quality prototypes to demonstrate the viability of the solution Work with developers data analysts business analysts and architects to guide the implementation and validation of the solutions at scale in a big data production environment Review the model output results...

  • Programmer Data Analyst

    2 months ago

    New York, New York, United States Atechstar Full time

    Responsibilities Review business and functional requirements Assist in producing high quality prototypes to demonstrate the viability of the solution Work with developers data analysts business analysts and architects to guide the implementation and validation of the solutions at scale in a big data production environment Review the model output results with...

  • Data Analyst

    4 days ago

    New York, United States Atlas Search Full time

    We are working with a professional soccer league sanctioned by the US Soccer Federation. They are actively looking to hire a Data Analyst to join their Finance Department for a hybrid, contract assignment. The candidate in this role will review data based on parameters provided, conduct thorough analysis of large data sets, clean data within Excel and...

  • Data Quality Analyst

    6 days ago

    New York, United States Balyasny Asset Management L.P. Full time

    LoadingSorry to interruptCSS Error Data Quality Analyst PostedPosted 90 Days Ago CodeREQ5559 We are actively seeking a Data Quality Analyst with a strong background in statistics or data science to join our Data Intelligence Group’s centralized Data Quality team. The ideal candidate will have a robust technical skill set with expertise in Python and...

  • Data Analyst III

    1 day ago

    New York, United States Alpha Net Full time

    Job DescriptionJob DescriptionData Analyst - HR TechnologyThe Insights Analyst is responsible for sourcing data and producing accurate timely reporting in support of the Privacy, Risk Compliance Group as well as other ad hoc analytics assignments. The candidate should be skilled in SQL (Presto/Hive), Tableau, Excel/Sheets. They should apply their technical...

  • Business Analyst

    4 days ago

    New York, United States Highbrow Full time

    Job Title: Business Analyst – SQL Job Location: NYC, NY # Positions: 1 Employment Type: W2 Candidate Constraints: Duration: Long term # of Layers: 0 Work Eligibility: All Work Authorizations are Permitted – No Visa Transfers Key Technology: AWS Cloud, SQL, Agile (SAFE), ETL, API Job Responsibilities: Interact with business stakeholders and SMEs to...