Data (ETL) Architect with Salesforce.com Experience

Acumen Solutions, Inc

• $120K — $145K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Client-focused attitude in interactions and documentation
  • Deep experience in data integration and migration with Salesforce.com and other cloud tools
  • Expertise in complex SQL and RDBMS systems like Oracle and Microsoft SQL Server
  • Desired experience in master data management and data governance
  • Strong verbal and written communication skills with stakeholders at all levels
  • Experience with data warehouse and data mart models
  • Hands-on ability to create reports using BI tools
  • Certifications in Informatica and Salesforce preferred

Responsibilities

  • Lead data management and migration projects to ensure successful execution
  • Develop and maintain data processes for both on-premise and cloud systems
  • Conduct team reviews to recommend improvements in data modeling and design
  • Learn and research advanced data technologies and incorporate them into projects
  • Work with team members to optimize database queries for efficiency
  • Produce detailed documentation artifacts for project clarity and tracking
  • Assess risks and communicate impacts effectively to multiple stakeholders

Benefits

  • Opportunity for growth and advancement within the company
  • Competitive medical benefits package
  • Annual performance-based incentives
  • 401k retirement plan options
Full 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.

Similar Jobs

More Jobs at Acumen Solutions, Inc

More Information Technology Jobs

Find similar Data (ETL) Architect with Salesforce.com Experience jobs: