Data ETL

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