Data Architect

Role: Data Architect

Location: Tallahassee, FL (Onsite)

Duration: 1+ Year

Pay: DOE

Primary Job Duties and Tasks:

• Work with stakeholders, development team to determine project scope, vision, gather, prioritize collected requirements.
• Designing/Implementing Data Architectures: Develop comprehensive data architectures that support the organization s business goals, using Azure Synapse Analytics, Azure SQL, 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.

Experience:

• 4+ yrs of experience in Synapse Analytics, Dedicated SQL Pools, Azure SQL Database, 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.
• Ability to design and implement robust, scalable, and efficient data architectures.
• Ability to provide excellent customer support; meticulous quality of work and work product.

Skills:

• Communication: Able to clearly convey information, in both written and verbal formats, to individuals or groups in a wide variety of settings. Must have the ability to effectively listen and process information provided by others.
• Customer Service: Works well with clients and customers able to assess the needs of the customer, provide information or assistance to satisfy expectations or resolve a problem.

• Decision Making: Makes sound, well-informed, and objective decisions.
• Flexibility: Is open to change, new processes (or process improvement), and new information. Has the ability to adapt in response to new information, changing conditions, or unexpected obstacles. Ability to receive and give constructive criticism and maintain effective work relationships with others.
• Interpersonal: Shows friendliness, courtesy, understanding, and politeness to others.
• Leadership: Motivates, encourages, challenges others. Adapt leadership styles in a variety of situations.
• Problem-Solving: Able to identify, evaluate, and use sound judgment to generate and evaluate alternative actions, and make recommendations as accordingly.
• Team Building: Encourages, inspires, and guides others toward accomplishing the common go

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.