Data Architect

Company: Idexcel
Location: Herndon
Posted on: January 16, 2022

Job Description:

Job Title: Data ArchitectLocation: Herndon, VADuration: Full TimeEssential duties and responsibilities:Develop and maintain MS-SQL Server database environment supporting client-oriented data productionDevelop and maintain AWS Cloud database environment i.e. Redshift, supporting client-oriented data production -Drive evolution of database environment including all necessary jobs, packages, scripts, and processesProvide technical leadership, coaching and mentoring to production analysts, vendors and solution developers.Review market available technical solutions and advise team on how it could be adoptedWill ensure the clients data structure, data flows, business processes, features, and usability are all best practice and will liaise with internal technical teams to ensure that all enhancements and document solutions are robust and consistent with best practice.Lead and participate in database design review sessions, technical specifications and solution design. Design and implement broad automation of current deliverablesWork with the Operations team and the reporting business analyst to implement solid, extensible warehouse models that supports new analytics requirements.Will work towards expanding the technical framework including and not limited to Data Warehousing, Cloud, Big Data implementations, Application and Database developmentSustained focus on improving performance, scalability and stability of large databasesYou will have the opportunity to write and review Functions and Procedures in SQL Server as well as in AWS Cloud in support of existing/new application infrastructure. Job might sometimes require administration of SQL Server and Redshift DatabasesRequirements/Qualifications:Minimum 8 to 10 years of professional experience (Preferably in Information technology)5+ years of Relational Database Development or Data Modeling experience (Preferably with SQL Server 2012 and after)Work experience of AWS Cloud environment migration and development. Hands on experience with AWS S3, Redshift, EC2, etc. or other Cloud environment applicationsAnalytics software exposure- SAS, R, Tableau would be good (although no hands-on knowledge is needed)Strong understanding of database structures, theories, principles, and practicesExperience using Windows/DOS scripting to execute scheduled tasksSignificant experience in application development, website and big data architectures. Knowledge of servers and configurations for specific needs.Ability to conduct research into database issues, standards and products as required .Proven analytical and problem-solving abilitiesBachelor's degree in a technical field (such as Computer Science, Information Systems, or Engineering) -Must be able to quickly understand business logic and be able to translate into technical implementationExperience and familiarity with web-based applications or Experience with Object Oriented application frameworks is a plus (.Net)Ability to work in a collaborative, entrepreneurial environment on really interesting problems - Must be able to use sound judgment to develop effective solutions from loosely stated requirementsMUST HAVEs: SQL Server 2014 or above, SAS 9.1 and above (exposure), File Transfer Protocol Experience, Linux/Unix Operating System Working Knowledge, Servers and their configuration, SQL Server Database Maintenance knowledge, ETL process building and Data Analysis/Reporting tools-Tableau, SSRS, etc. AWS Cloud certified is a plusType: Direct HireCategory: Other Area(s)

Keywords: Idexcel, Germantown , Data Architect, Other , Herndon, Maryland