Job Description
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
Qualifications
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
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.
