Data Architect
- Acumen Solutions, Inc.,
- Mclean, VA
- 2 weeks ago
Report
Rate
Job Description
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 combining the insight of our strategists, the vision of our innovators, and the ingenuity of our engineers to achieve 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 or on Twitter @AcumenSolutions.
We are looking to grow our team and currently have an opportunity for a Data Architect in the Virginia area!
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
Bachelor s degree required
Must be authorized to work for any U.S. employer
Willingness to travel up to 50%
Benefits
Acumen Solutions offers the opportunity for growth and advancement, as well as a competitive base salary, annual performance based incentives, medical, dental, and vision benefits, Paid Time Off, 401k, and more.
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
