SQL Server Data Management and Business Intelligence
2 weeks ago
Key skills: SQL Server (optimization, performance, data mapping, and cleaning), Transact SQL, Investment Banking (need strong business understanding and ability to communicate with users), Excel VBA, Power BI (or other visualization tools would be helpful)
- No more than 8 years of experience
- No more than 2 pages of a resume - the role requires a concise communicator
Local candidates strongly preferred
SQL Server Data Management and Business Intelligence Consultant
Investment & Corporate Banking - COO Office, Data Management and Business Intelligence Consultant Seeking a Data Management and Business Intelligence Associate to work in the Investment & Corporate Banking COO Office of a growing firm. This position plays a key function in the COO team managing data framework and driving automation efforts working in close partnership with business, reporting team and IT stakeholders.
The Data Management and Business Intelligence Associate will:
- Serve as the in-house expert for data mining, data processing, reconciliation and analysis
- Help to drive and implement a strategic data framework and solution working with IT to define, identify, test and implement automated solutions
- Responsible for understanding the use of data across multiple systems and departments, identify the trends and patterns to improve business operations efficiency
- Research, recommend and execute tactical approaches for improving management's access to analytics, including self-service methods, in parallel with implementation of any strategic platforms
- Lead aspects of data management; maintain and ensure the data integrity of client records included in CRM (Salesforce) and Client Data warehouse
- Maintain and Monitor daily data feed, and verify the accuracy of customer, facility and deal data
- Demonstrate intellectual curiosity and critical thinking by taking the initiative to explore company data independently and rigorously in order to expose underlying trends, performance drivers, and emerging issues
- Develop and maintain data controls that ensure accuracy, consistency and detail of management reporting data
- Assisting with the rollout and implementation of Power BI across COO team.
- Design and develop business requirements to build financial reports, dashboard ad visualizations in Power BI
Skills:
- Proven experience in data entry, data quality assurance, or similar roles, working with large and complex data sets.
- Exceptional attention to detail and a strong commitment to data accuracy
- Expertise in the design, creation, management of business application including data warehouse, performance metrics and dashboards
- Proficiency in data science, data analytics and business intelligence including visualization techniques
Minimum of 5 years of relevant experience with the following:
- Advanced MS Word / Excel (including nested formulas, macros, pivot tables, look-ups and VBA), SQL and Power BI Relational databases, online analytical processing (OLAP) tools, data mining, database queries, stored procedure writing
- SQL server integration services (SSIS), analysis services (SSAS), development is a plus
- Knowledge in Salesforce, Qlik, PowerBI, Dealogic, Capital IQ and SAS
- Working knowledge of investment and corporate banking and capital market products is a plus
- Customer service orientation and passion for helping business stakeholders define metrics to assess and drive performance
Education:
Bachelor's degree or above in data science, computer science, information systems or engineering
-
New York, United States Shulman Fleming & Partners Full timeJob DescriptionJob DescriptionSQL Server Data Management and Business Intelligence ContractorMUST be local to New York City. Position is Hybrid; 6 days per month working remoteSeeking a Data Management and Business Intelligence Associate for our Investment & Corporate Banking COO Office. Key responsibilities include:Expertise in data mining, processing, and...
-
New York, United States Logix Shapers Full timeJob DescriptionJob DescriptionPlease find the JD below!!SQL Server Data Management and Business Intelligence ConsultantLocal candidates from New York City will be preferredHybrid job mode No more than 8 years of experienceThe Data Management and Business Intelligence Associate will:Serve as the in-house expert for data mining, data processing, reconciliation...
-
Manager, Business Intelligence
3 days ago
New York, United States Wavemaker Global LLC Full timeManager, Business Intelligence & Data Visualization, Wavemaker Global LLC, New York, NY. Retrieve, compile, cleanse, and transform large volumes of data to create the intelligence layer for analysis and media investments optimization. Collect data requirements from client teams to build out custom databases and implement business logic for data stitching....
-
Junior Data Analyst- Business Intelligence
2 weeks ago
New York, United States Momentum Resource Solutions Full timeJob DescriptionJob DescriptionJunior Data Analyst- Business Intelligence3-5 years of experienceHybrid ScheduleSeeking a Data Management and Business Intelligence Associate to work in the Investment & Corporate Banking COO Office of a growing firm. This position plays a key function in the COO team managing data framework and driving automation efforts...
-
New York, United States SoHo Dragon Full timeJob DescriptionJob DescriptionSalary: SoHo Dragon represents an investment bank with offices in New York, NY that needs to hire a Data Management and Business Intelligence Consultant.Work Schedule: Hybrid to comply with Banking front office policy (6 days wfh per month).Skills:Proven experience in data entry, data quality assurance, or similar roles, working...
-
New York, United States Phaxis Full timePay Rate: $60.40 Investment & Corporate Banking - COO Office, Data Management and Business Intelligence Consultant: Seeking a Data Management and Business Intelligence Associate to work in the Investment & Corporate Banking COO Office of a growing firm. This position plays a key function in the COO team managing data framework and driving automation...
-
New York, United States Momentum Resource Solutions Full timeJob DescriptionJob DescriptionOur client, a Japanese Financial Organization, is searching for a Data Management and Business Intelligence Analyst. This is a permanent role where employees are required onsite 2 days per week. The full job description is as follows: Location: NYC (2 days per week onsite)Job Type: 6+ month renewable contract About the...
-
Manager, Business Intelligence
5 days ago
New York, New York, United States Wavemaker Global LLC Full timeManager, Business Intelligence & Data Visualization, Wavemaker Global LLC, New York, NY. Retrieve, compile, cleanse, and transform large volumes of data to create the intelligence layer for analysis and media investments optimization. Collect data requirements from client teams to build out custom databases and implement business logic for data stitching....
-
New York, United States NSD International, Inc. Full timeData Management and Business Intelligence Consultant: Investment & Corporate Banking - COO OfficeWe are seeking a Data Management and Business Intelligence Associate to work in the Investment and Corporate Banking COO Office of a growing firm. This position plays a key function in the COO team, managing the data framework and driving automation efforts,...
-
Enterprise Data Management
1 week ago
New York, United States Neuberger Berman Full timeSummary: The Enterprise Data Management (EDM) organization is comprised of multiple teams that are responsible for developing, executing, and delivering data products across a new cloud platform at Neuberger Berman. The Business Intelligence team within EDM is responsible for delivering analytics solutions that enable our stakeholders to make data driven...
-
SQL Server SME
2 weeks ago
New York, United States eTeam Full timeExperience: 10+ Years Skills : SQL Server, SSIS, SSRS, advanced performance tuning, SQL Optimization, SQL Stored proc, Cloud 10+ years hands on experience working with RDMS and Datawarehousing STRONG MS SQL Server Expert to manage large Transactional DB to do advanced performance tuning, Optimization/Write/ modify complex SQL queries, stored procedures,...
-
SQL Server SME
2 weeks ago
New York, United States Resource Logistics Full time10+ years hands on experience working with RDMS and Datawarehousing STRONG MS SQL Server Expert to manage large Transactional DB to do advanced performance tuning, Optimization/Write/ modify complex SQL queries, stored procedures, views and triggers in addition to the development of other SQL database objects Expert level experience exclusive hands on in...
-
Business Intelligence Architect
12 hours ago
New York, United States Brandon Consulting Associates, Inc. Full timeJob DescriptionJob DescriptionJob DescriptionThis position is responsible for performing the duties of Analytics & Reporting Lead working closely with onshore/offshore team.Responsibilities include:Lead the development and implementation of data engineering and analytics strategies to support bank-wide decision-making and performance improvement.Oversee the...
-
Business Intelligence Specialist II
2 weeks ago
New York, United States Aquent Full timeOverview Placement Type: Temporary Salary (USD): $52 to $58.50 Hourly Start Date: 05.22.2024 Job Description: Develop, implement and maintain technical structure for data warehouse and data mart. Develop, implement and maintain data extraction methods between SQL and data warehouse or source database. Maintain performance standards for data extraction....
-
Full Stack Data Developer
2 weeks ago
New York, United States Enternet Business Systems, Inc. Full timeTitle: Full Stack Data Developer (Day 1 Onsite)Duration: long termLocation: New York, NY Full Stack Data DeveloperPOSITION SUMMARY: We are looking for a Full Stack Data Developer to maintain and support various databases RESPONSIBILITIES:Maintain and support various databasesCreate and maintain logical and physical data models.Create and maintain ETL...
-
New York, New York, United States Michael Page Full timeAbout Our Client A Wealth Management Firm known for its extensive range of financial products and services, including asset management, risk management, and advisory services. Job Description Collaborate with IT to drive and implement strategic data solutions, including defining, identifying, testing, and implementing automated solutionsAnalyze data usage...
-
Business Intelligence Engineer
4 days ago
New York, New York, United States Randstad USA Full timejob summary: Looking for a BI Engineer (Sr./ Mid level) to join our entertainment client in NYC (or remotely). MUST HAVE Experience 4+ years of business intelligence development experienceSQL.with cloud-based data warehouses (such as Snowflake)in Tableauin managing ETL pipelines (such as using - Airflow) with Python.with Google BigQuery.with Adobe...
-
New York, United States Michael Page Full timeAbout Our Client A Wealth Management Firm known for its extensive range of financial products and services, including asset management, risk management, and advisory services. Job Description Collaborate with IT to drive and implement strategic data solutions, including defining, identifying, testing, and implementing automated solutionsAnalyze data usage...
-
New York, United States Michael Page Full timeThis role involves driving strategic data initiatives, collaborating with IT to implement automated solutions, understanding cross-system data usage to enhance operational efficiency. Additionally, it includes recommending tactical methods to enhance management's access to analytics and maintaining data integrity in CRM and client data warehouse, while also...
-
Senior Business Intelligence Developer
3 weeks ago
New York, United States eTeam Full timeTop 3 Skills: High proficiency in SQL(required), Proficiency in designing, developing, and managing SQL-based ETL pipelines using tools such as Airflow, dbt, or Databricks4+ years of business intelligence development experience including designing data models and developing BI dashboards, Proficiency in Tableau, Experience with cloud-based data warehouses...