← Back to jobs
Data Architect
Florida Avenue, Tallahassee, FL, USA
Posted On: 15+ days ago
Experience: 5+ years
Availability: Onsite
Openings: 1
Category: Data Architect
Tenure: Contract - Corp-to-Corp
Related Jobs
No related jobs found
Description
Scope of Work:
- Collaborate with stakeholders and development teams to define project scope, gather requirements, and prioritize deliverables.
- Design and implement data architectures that align with business objectives, leveraging Azure SQL Database, Azure Synapse Analytics, LLM integration, and related Azure data services.
- Manage and optimize Dedicated SQL Pools in Azure Synapse to support large-scale data warehousing and analytics workloads.
- Design, develop, and maintain databases using Azure SQL and Azure SQL Managed Instance, ensuring performance, scalability, availability, and security.
- Develop, optimize, and maintain complex SQL queries, stored procedures, functions, and views. Optimize database performance by analyzing queries, identifying bottlenecks, and implementing effective tuning and troubleshooting strategies to ensure reliability and efficiency.
- Build and manage ETL/ELT pipelines using Synapse Pipelines or equivalent tools to support reliable and efficient data integration.
- Create and maintain scalable data models to support reporting, analytics, and downstream applications.
- Implement data governance practices, including data quality, lineage, and cataloging.
- Ensure data security, privacy, and compliance with applicable standards and organizational policies.
- Monitor system performance, troubleshoot issues, and implement tuning strategies to improve efficiency.
- Support deployment processes, including CI/CD pipelines and version control for database objects.
- Maintain technical documentation, including system design, data flows, and operational procedures.
- Evaluate and recommend new technologies, tools, and best practices to improve data platform capabilities.
- Provide technical guidance and mentorship to junior team members and support cross-functional teams.
Submissions Must Include
- Candidate Resume(s) Include relevant experience, certifications, education, etc. related to the services requested in the Scope of Services.
- Exhibit E - Resume Self-Certification Form
- References Provide three (3) clients for which similar services were performed within the past three (3) years.
- Education, Certification and KSA’s Matrices
Education, Experience, and Skills Matrices
| Education (Required) | Degree / Date of Graduation | University / School |
| Bachelor’s or higher in Computer Science, Information Systems, or related field. Or equivalent work experience. |
| Certification (Highly Suggested) | Certification / Date of Certification | Certification # / Trainer |
| Salesforce | ||
| AI |
| Specific Knowledge, Skills and Abilities (KSAs) | Years of Experience | Year Skills Last Used |
| 5+ years of experience in Azure SQL Database, Synapse Analytics, ETL, Synapse pipeline/Azure Data Factory, and Dedicated SQL Pools. | ||
| 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 computing capabilities. | ||
| 1+ years of Experience with programming languages such as Python. | ||
| 1+ years of experience in LLM | ||
| 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. |
| General Knowledge, Skills and Abilities (KSAs) | Skill Level (See Below) |
| 1. Communication: Have the ability to clearly convey information, in both written and verbal formats, to individuals or groups in a wide variety of settings (i.e.; project team meetings, management presentations, etc.). Must have the ability to effectively listen and process information provided by others. | |
| 2. Customer Service: Works well with clients and customers (i.e.; business office, public, or other agencies). Able to assess the needs of the customer, provide information or assistance to satisfy expectations or resolve a problem. | |
| 3. Decision Making: Makes sound, well-informed, and objective decisions. | |
| 4. 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. | |
| 5. Interpersonal: Shows friendliness, courtesy, understanding, and politeness to others. | |
| 6. Leadership: Motivates, encourages, and challenges others. Can adapt leadership styles in a variety of situations. | |
| 7. Problem Solving: Able to identify, evaluate, and use sound judgement to generate and evaluate alternative actions, and make recommendations as accordingly. | |
| 8. Team Building: Encourages, inspires, and guides others toward accomplishing the common goal. |
Education
Any Gradute
Related Jobs
No related jobs found
Explore More Jobs
Jobs in Florida AvenueJobs in TallahasseeJobs in FLJobs in USAPython JobsCi/cd JobsAzure Data Factory JobsDdl JobsAi JobsSalesforce JobsAzure Sql Database JobsSynapse Analytics JobsJobs at iitjobsJobs at Intime Infotech IncData Architect JobsS3 JobsScrum JobsChatGPT JobsIoT JobsRollups JobsWeights & Biases JobsZero-Shot Learning JobsJWT JobsSSO JobsWAF Jobs
← Back to jobs