Project & Position Overview:
Our client will be developing and implementing a new TBD SAS or custom built system that is flexible and can support the unique needs for the companies across the business lines. LingaTech is seeking a Data Architect for data modeling and writing database migration scripts for our client.
POSITION SUMMARY
A Data Architect, or an Enterprise Data Architect, designs and manages centralized, end-to-end data architecture solutions. Their duties include determining strategic data requirements, creating designs according to these requirements, and ensuring that a company’s data architecture aligns with its business needs.
Core Responsibilities
- Creating diagrams that show key data entities and creating an inventory of the database tables, procedures, etc. needed to implement solutions
- Experience with database design, data integration/aggregation, metadata management, database administration, and performance tuning within Microsoft Azure Cloud and Microsoft SQL databases. The current database is MS SQL Server 2012 and the plan is to move to the modern database.
- Formulate the organizational data strategy, including standards of data quality, the flow of data within an application solution, and security of data.
- Examine and identify database structural necessities by evaluating business requirements, applications, and programming.
- Oversee and execute the migration of data from legacy systems to new solutions.
- Write database migration scripts to migrate data from multiple legacy databases.
- Monitor the system performance by performing regular tests, troubleshooting, and integrating new features.
- Prepare accurate database design and architecture reports for management and executive teams.
- Install and organize database to guarantee company functionality.
- Create and maintain a repository of all data architecture artifacts.
- Adhere to Agile principles and philosophies in fulfillment of the role.
- Educate staff members through training and individual support of the database structure.
- Performance tuning and optimization of the new platform
- Administration and configuration of database security of the new platform
- Administration and configuration of database backups of the new platform
Desired Skills:
- A minimum of 5-8 years' experience in a similar role.
- Dataverse expeirence
- Experience in using data modeling tools
- Database scripting experience
- Strong knowledge of database structure systems and data mining.
- Excellent organizational and analytical abilities.
- Excellent communication skills for working with technical and business users.
- MS Dynamics and Dataverse experience.
Education and Certifications
- Bachelor’s degree in computer science, computer engineering, or relevant field.
Top Skills
What We Do
LingaTech, Inc., a minority owned business, NMSDC MBE Certified, and is PA Small Diverse Business (SDB) Verified since 2014. We are a member of the Harrisburg Regional Chamber of Commerce & CREDC, and are registered with Hireveterans.com & PurplePlacement.com.
We believe in technology innovation and customer partnership to deliver world class IT consultants, products and services. We provide high end consultants to partner with your organization to maximize your growth and achieve your IT goals. As your technology partner, when your business grows we grow with you.
We offer software services in three major areas – Product development, Custom software development and Project Management. With professionals having more than 15 years of experience in software industry, our clients are assured of products/services that are of great quality.
