Data Architect

Role: Data Architect
Location: Tallahassee, FL 32303
Duration: Long Term Contract



Job Description

• Work with stakeholders and development team to determine project scope and vision, gather and prioritize collected requirements.
• Designing and Implementing Data Architectures: Develop comprehensive data architectures that support the organization's business goals, using Azure Synapse Analytics, Azure SQL, and other Azure data services.
• Managing Dedicated SQL Pools: Efficiently manage and optimize Dedicated SQL Pools in Synapse to handle large-scale data warehousing and analytics workloads.
• Database Design and Management: Design, implement, and manage databases using Azure SQL and Azure Managed Instance, ensuring high performance, availability, and security.
• Data Integration and ETL Processes: Develop and manage ETL (Extract, Transform, Load) processes using Synapse Pipelines, ensuring efficient data flow from various sources to the data warehouse.
• Data Governance and Cataloging: Implement data governance practices and manage the data catalog to ensure data quality, consistency, and accessibility.
• Building and Maintaining Data Models: Create and maintain data models that accurately represent the data landscape, ensuring they are scalable and optimized for performance.
• Ensuring Data Security and Compliance: Implement and oversee data security measures, ensuring compliance with legal and regulatory standards.
• Maintain procedures manuals and system documentation.
• Research software solutions to support recommendations, analyzing current and future technology trends.

Required Skills

• 4+ years of experience in Synapse Analytics, Dedicated SQL Pools, Azure SQL Database, and Azure Managed Instance.
• 5+ years of experience in DDL, DML T-SQL skills, advanced stored procedure writing skills, tables, primary keys, foreign keys, constraints, indexes, transactions, process logging, and error handling.
• 4+ years of experience in data architecture design principles, methodologies, and best practices.
• 3+ years of experience in data governance principles and compliance requirements related to data security and privacy.
• 3+ years of experience in integrating data from various sources and managing large data pipelines.
• 2+ years of experience in cloud computing concepts, particularly in Microsoft Azure, including storage solutions and compute capabilities.
• 1+ years of Experience with programming languages such as Python or Scala.
• 1+ years of experience in Salesforce, Message MQ, and MuleSoft
• Strong analytical and problem-solving skills to address complex data challenges.
• bility to design and implement robust, scalable, and efficient data architectures.
• bility to provide excellent customer support; meticulous quality of work and work product

bout Us:

InterSources Inc , a Certified Diverse Supplier, was founded in 2007 and offers innovative solutions to help clients with Digital Transformations across various domains and industries. Our history spans over 16 years and today we are an Award-Winning Global Software Consultancy solving complex problems with technology. We recognize that our employees and our clients are our strengths as the diverse talents and opportunities they bring to the table enable us to grow as a global platform and they are causally linked with our success. We provide strategic and technical advice, and we have expertise in areas covering rtificial Intelligence, Cloud Migration, Custom Software Development, Data Analytics Infrastructure & Cloud Solutions, Cyber Security Services, etc. We make reasonable accommodations for clients and employees and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud partner company. We align strategy with execution and provide secure service solutions by developing and using the latest technologies that thrive our resources to deliver industry-leading capabilities to our clients and customers, making it convenient for our clients to do business with InterSources Inc. Our teams also drive growth by refining technology-driven client experiences that put the users first, providing an unparalleled experience. This results in strengthening the core technologies of clients, enabling them to scale with flexibility, create seamless digital experiences and build lifelong relationships.