Acumen Solutions Logo

Acumen Solutions

Data (ETL) Architect with Salesforce.com Experience

Reposted 2 Months Ago
Be an Early Applicant
In-Office
New York, NY, USA
Mid level
In-Office
New York, NY, USA
Mid level
Lead data management projects and optimize data architecture for cloud and on-premise systems, focusing on integration with Salesforce.com and ETL tools.
The summary above was generated by AI
Company Description

Acumen Solutions drives excellence - not only in our performance, but also in the results we deliver for our clients. We are a global cloud consultancy that combines the insight of our strategists, the vision of our innovators, and the ingenuity of our engineers to achieve this extraordinary impact. The Fortune 500 trust us to build solutions focused on growing revenue and profits by amplifying competitive advantage and strengthening customer relationships. Our groundbreaking solutions in the public sector streamline operations and improve productivity. We apply this same focus on excellence to our unparalleled social responsibility program, generating sustainable impact across our local communities.

Engage with us at www.acumensolutions.com or on Twitter @AcumenSolutions.

Job Description

· Lead data management and migration projects 

· Develop, maintain, and review data processes and architecture for both on-premise and cloud-based data systems 

· Conduct team reviews and recommend data modeling, administrative, and design improvements 

· Demonstrate ability to learn and research advanced data technologies and concepts, learning new skills and software as necessary 

· Work closely with team members to optimize database queries 

· Demonstrate high-level knowledge of enterprise IT organizational, business, and technical environments 

· Produce highly detailed document artifacts and maintain them for the duration of projects 

· Assess all risks and offer mitigation strategies, communicating impacts to project across multiple channels 

· Interpret client functional and informational needs and turn them into data requirements, process models, and active systems 

· Support assigned systems throughout transition periods 

Qualifications

· Possess a client-focused attitude through conversations and documentation 

· Demonstrate deep data integration and/or migration experience with Salesforce.com and other cloud-enabled tools

· Demonstrate expertise in complex SQL statements and RDBMS systems such as Oracle, Microsoft SQL Server, PostGres 

· Experience with master data management, data governance, data security, data quality and related tools desired. 

· Demonstrate experience with complex coding through ETL tools such as Informatica, SSIS, Pentaho, and Talend 

· Demonstrate strong verbal and written communication skills across multiple levels of the organization 

· Coordinate management activities with others on the team 

· Experience with full-fledged data warehouse or data mart models 

· Experience with both dimensional and 3rd normal form data modeling, data integration, and reporting 

· Hands-on ability to set up reporting tools and build reports and ad hoc functionality 

· Experience with reporting / BI tools such as Business Objects, Cognos, or SSRS 

· Strong written and spoken communication skills 

· Related certifications in Informatica and Salesforce a plus 

· Experience with industry standards and frameworks such as TOGAF and DMBOK a plus 

· Previous experience in consulting is a plus 

Additional Information

Benefits

Acumen Solutions offers the opportunity for growth and advancement, as well as a competitive base salary, annual performance based incentives, medical benefits, and 401k.

About Us

As a leading management and technology consulting firm, Acumen Solutions offers a range of challenging and rewarding opportunities whether you’re just starting out in your career, looking to advance your career, or seeking a senior leadership position. Acumen Solutions employees are ambitious, committed, passionate problem solvers.

EOE M/F/V/D

VEVRAA Federal Contractor

Acumen Solutions New York, New York, USA Office

1460 Broadway, New York, NY, United States, 10036

Similar Jobs

A Minute Ago
Remote or Hybrid
United States
85K-143K Annually
Senior level
85K-143K Annually
Senior level
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Manages brand alignment and serves as the liaison between business stakeholders and creative teams. Oversees creative strategy, project scope, planning, execution, budgets, timelines, and delivery across marketing channels. Reviews campaign analytics to identify optimization opportunities, facilitates collaboration, presents work to internal clients, and supports performance marketing initiatives. Requires substantial creative agency experience, project management expertise, and the ability to use AI to improve operational efficiency.
Top Skills: AIFigmaMS OfficeMicrosoft TeamsSharepointWorkfront
A Minute Ago
Hybrid
New York, NY, USA
290K-500K Annually
Expert/Leader
290K-500K Annually
Expert/Leader
Fintech • Financial Services
Leads second-line operational risk oversight for Corporate and Investment Banking Markets, covering trading, sales, technology, trade processing, resilience, vendors, data, and AI-enabled activities. Reviews controls, risk assessments, loss events, emerging risks, issues, and strategic initiatives; escalates significant themes to executives and governance committees. Partners across risk, compliance, audit, technology, operations, and business teams while developing strategic risk insights. Manages and develops a geographically dispersed team of senior operational risk professionals.
Top Skills: AIAlgorithmic Trading PlatformsData ManagementElectronic Trading PlatformsMarket InfrastructureRegulatory Reporting Systems
A Minute Ago
Hybrid
New York, NY, USA
90K-150K Annually
Junior
90K-150K Annually
Junior
Fintech • Financial Services
Supports credit underwriting and portfolio monitoring for Wells Fargo’s Industrials corporate banking portfolio. Responsibilities include financial statement, industry, and projection analysis; preparing credit memoranda and leadership materials; supporting client credit needs, deal closings, and ad hoc portfolio analysis; and applying credit policies. The role requires collaboration with senior bankers and risk partners, ongoing training, FINRA licensing, background screening, and compliance with financial industry regulations.

What you need to know about the NYC Tech Scene

As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.

Key Facts About NYC Tech

  • Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
  • Key Industries: Artificial intelligence, Fintech
  • Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
  • Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account