General Duties
· 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
Skills & Experience
· 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
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