• Share this Job

Data Architect - Annapolis

Location : Annapolis, MD
Job Type : Direct
Hours : Full Time
Required Years of Experience : 5
Required Education : Bachelor's Degree Required
Travel : No
Relocation : No

Job Description :

Veritas Partners has an immediate opening for a full-time Data Architect to join our team in the Annapolis, MD area! This is an excellent opportunity for a mid-senior level Data Architect to make an immediate impact on a company dedicated to climate change solutions and renewable energy!


 


The successful candidate will be responsible for the design, development, implementation, and support of mission-critical enterprise data solutions. You will work with cross-functional teams, participate in gathering and documenting data, integration, and development requirements to meet business needs.


Using your skills and experience as a data architect, you will design, develop, test, and implement database and ETL solutions to transmit, transform, and store data into data warehouse(s)/data mart(s), integrate disparate systems, web-based APIs, and other unparsed/semi-structured sources.


 


Responsibilities:


· Participate in business analysis activities to gather required data requirements.


· Translate business requirements into specifications that will be used to implement the required data structures and relationships including data imports/exports, transformations, and associated processes.


· Manage and support production databases, data warehouses, and ETL processes including security, backups, and upgrades.


· Provide support as required to ensure the availability and operation of applications and ETL processes.


· Ensure proper configuration management and change controls are executed to policy.


· Prepare accurate database design and architecture reports for management and executive teams.


· Oversee the migration of data from legacy systems to new solutions.


· Monitor the system performance by performing regular tests, troubleshooting, and integrating new features.


· Recommend solutions to improve new and existing database systems.


· Provide training and assistance to users for using any developed systems or processes.


· Design and implement technology using best practices and guidelines such that implementations are efficient, manageable, understandable, reliable, and well documented.


 


Qualifications:


· Bachelor’s degree in computer science, computer engineering, or relevant field


· 5+ years’ experience designing and developing SQL Server (T-SQL) and Oracle databases


· 4+ years’ experience designing and developing data warehouses.


· 3+ years’ experience using modern data warehouse technologies (ex. Snowflake, Redshift, etc)


· 3+ years’ experience developing and deploying ETL solutions.


· 3+ years’ experience developing Python.


· 3+ years’ experience developing SSIS or with other ETL services (ex. Azure Data Factory, AWS Data Pipeline/Glue, Stitch, Talend, FiveTran, Matillion, etc.)


· Strong knowledge of logical and physical data modeling concepts (relational and dimensional)


· Experience performance tuning for large complex data sets


· Experience working with version control systems (ex. Git)


· Experience working with structured and unstructured data sources.


· Familiarity with DevOps and Database Deployment Automation tools (ex. SSDT, etc.)


· Excellent interpersonal (verbal and written) English language communication skills are required to support working in project environments that includes internal, external, and customer teams.


· Strong analytical, conceptual, and problem-solving abilities required.


· Must be able to quickly learn and adapt to new technologies.


· Ability to manage multiple priorities and assess and adjust quickly to changing priorities.


 
Required Qualifications :
 
Powered by AkkenCloud
www.hireveritas.com