Data (ETL) Architect with Salesforce.com Experience

Acumen Solutions; New York (NY); On-site; USD 100,000 - 140,000; Full time

Benefits offered by this job

Competitive base salary

Annual performance-based incentives

Medical benefits

401k

Job summary

Acumen Solutions is seeking a full-time Data (ETL) Architect in New York City. This role involves leading data management projects, developing robust data architecture, and utilizing advanced ETL tools, particularly with Salesforce.com integration.

Candidates must be proficient in complex SQL, RDBMS, and possess a client-focused attitude. Acumen Solutions offers competitive salaries, performance incentives, and comprehensive medical benefits.

Qualifications

• Demonstrate deep data integration and/or migration experience with Salesforce.com.
• Expertise in complex SQL statements and RDBMS systems.
• Experience with ETL tools such as Informatica, SSIS, Pentaho, and Talend.

Responsibilities

• Lead data management and migration projects.
• Develop and maintain data architecture for both on-premise and cloud-based systems.
• Produce detailed documentation artifacts for projects.

Skills

Data integration and migration with Salesforce.com

Complex SQL statements

ETL tools (Informatica, SSIS, Pentaho, Talend)

Data governance

Business Intelligence tools (Business Objects, Cognos, SSRS)

Education

Related certifications in Informatica and Salesforce

Tools

Oracle

Microsoft SQL Server

PostGres

Job description

Data (ETL) Architect with Salesforce.com Experience

Full-time

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.

Key Responsibilities and Qualifications

• 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
• 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

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