Software Data Architect

Role Overview:

As a Data and Application Architect at Transflo, you will play a critical role in designing and updating architectures utilizing both relational and non-relational databases. You will collaborate closely with cross-functional teams to ensure that our data management systems are optimized for performance, scalability, and reliability. This role will involve working with technologies such as .Net Core running in AWS EKS as microservices, Lambda functions, and Angular.

Job Responsibilities:

• Database Architecture Design: Design and develop scalable and efficient database architectures for both relational and non-relational databases, ensuring high performance and reliability.
• Technology Evaluation and Selection: Evaluate and select appropriate database technologies and tools based on project requirements, performance considerations, and industry best practices.
• Data Modeling: Create and maintain conceptual, logical, and physical data models to support application development and data management processes.
• Performance Optimization: Identify and implement strategies to optimize database performance, including indexing, query optimization, and caching mechanisms.
• Data Security and Compliance: Implement security best practices and compliance standards to ensure the confidentiality, integrity, and availability of data stored in databases.
• Collaboration and Communication: Collaborate with cross-functional teams including developers, DevOps engineers, and business stakeholders to understand requirements and translate them into effective database solutions. Communicate architectural decisions and recommendations clearly and effectively.
• Continuous Improvement: Stay updated with emerging trends and technologies in database management and application development. Drive continuous improvement initiatives to enhance the efficiency and effectiveness of database architectures.
  
  
  

Qualifications and Experience:

• Bachelor's or Master's degree in Computer Science, Information Technology, or related field.
• Proven experience (5 years) as a Data Architect, Application Architect, or similar role, with a focus on designing and implementing database architectures.
• In-depth knowledge of relational database management systems (e.g., SQL Server, PostgreSQL, MySQL) and non-relational databases (e.g., MongoDB, DynamoDB).
• Hands-on experience with .Net Core, AWS EKS, Lambda functions, and Angular.
• Strong understanding of microservices architecture and its implementation in cloud environments.
• Experience with data modeling tools and techniques.
• Solid understanding of data security, compliance, and privacy regulations.
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration skills.
• AWS certification (e.g., AWS Certified Solutions Architect) is a plus.
  
  
  

Qualifications and Experience:

• Bachelor’s Degree (preferably within a technical discipline)
• 10+ years of software development experience
• Proven knowledge of C# .Net 4.5 or higher
• Proven knowledge of C# .Net Core
• Solid understanding of WebApi Web Services
• Solid understanding of ASP.Net or MVC
• Visual Studio & VSTS
• SQL (prefer SQL Server’s Transact-SQL)
• Good knowledge of Operating Systems including Microsoft Windows 7, 8, 10, Windows Server 2016, 2019
• Business/Requirements Analysis skills
• Broad and extensive knowledge of the software development process and its technologies
• Knowledge of architectural styles and design patterns
• Understanding of various coding methods and computer languages
• Data modeling and database design experience
• Experience with software development lifecycle (SDLC) processes
• Experience with service oriented architecture (SOA)
  
  
  

Preferred additional skills:

• Understanding and/or experience of SDLC using Agile/Scrum methodologies
• Transportation Industry knowledge
• Document Imaging experience
  
  
  

Individual Qualities:

• Results oriented
• Independently reliable; performs tasks without close supervision
• Organized; detail-oriented, methodical and consistently demonstrates ability to successfully and timely complete assignments.
• Follows-Up; consistently performs this in a positive, proactive manner
• Logical problem-solving skills
• Quality conscious; consistently demonstrates commitment to customers & quality
• Demonstrates timeliness & urgency
• Team work; individual contributor that works well with other team members and consistently promotes a strong team environment work ethic
• Goal setting; sets/achieves goals and consistently demonstrates a willingness/dedication to process improvement
• Responsible; takes responsibility for personal actions and consistently demonstrates a willingness to accept greater project responsibilities
• Professionally candid communications
• Focused on key success factors
• Professional attitude; consistently demonstrates ability to accept criticism and manage the conversation appropriately
• Street smart; can apply knowledge and life experiences in business
• Positive attitude
• Flexible & adaptable
• Resourceful