Data Architect

Job Purpose:

The Office of Information Technology Services (OITS) is seeking a Data Architect (C. Advanced) (STC Job #1410 Data Architect, C. Advanced).

About the Candidate:

Qualifications

Education - Bachelor s or Master s Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience. (Required).

Certifications - Microsoft Dynamics 365 Certification (Desired) and MS Dynamics Power Platform Certifications (Desired).

This position requires the following experience and/or knowledge:

1. 4 years of experience in Synapse Analytics, Dedicated SQL Pools, Azure SQL Database, and Azure Managed Instance.
2. 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.
3. 4 years of experience in data architecture design principles, methodologies, and best practices.
4. 3 years of experience in data governance principles and compliance requirements related to data security and privacy.
5. 3 years of experience in integrating data from various sources and managing large data pipelines.
6. 2 years of experience in cloud computing concepts, particularly in Microsoft Azure, including storage solutions and compute capabilities.
7. 1 years of Experience with programming languages such as Python or Scala.
8. 1 years of experience in Salesforce, Message MQ, and MuleSoft
9. Strong analytical and problem-solving skills to address complex data challenges.
10. Ability to design and implement robust, scalable, and efficient data architectures.
11. Ability to provide excellent customer support; meticulous quality of work and work product.

Primary Job duties and tasks

1. Work with stakeholders and development team to determine project scope and vision, gather and prioritize collected requirements.
2. 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.
3. Managing Dedicated SQL Pools: Efficiently manage and optimize Dedicated SQL Pools in Synapse to handle large-scale data warehousing and analytics workloads.
4. Database Design and Management: Design, implement, and manage databases using Azure SQL and Azure Managed Instance, ensuring high performance, availability, and security.
5. 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.
6. Data Governance and Cataloging: Implement data governance practices and manage the data catalog to ensure data quality, consistency, and accessibility.
7. Building and Maintaining Data Models: Create and maintain data models that accurately represent the data landscape, ensuring they are scalable and optimized for performance.
8. Ensuring Data Security and Compliance: Implement and oversee data security measures, ensuring compliance with legal and regulatory standards.
9. Maintain procedures manuals and system documentation.
10. Research software solutions to support recommendations, analyzing current and future technology trends.

About ArnAmy, Inc.:

ArnAmy, Inc. is a leading information technology consulting and software development firm in Tallahassee, FL since 2007. ArnAmy has been providing high quality services to clients and prides itself in implementing dependable solutions to ensure client's success. ArnAmy is formed and led by principle centered leaders with Subject Matter Expertise in all disciplines of Information Technology. Company has proven record of 100% successful projects and 100% satisfied clients, and employees. We are inviting bright professionals with integrity and have passion to achieve higher goals to join our award winning (Tallahassee s BEST in IT Solutions 2017 &2016) excellent and talented team.

ArnAmy, Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability or marital status. Women and Minorities are encouraged to apply.

PLEASE SEND RESUMES AND SALARY EXPECTATIONS TO THANK YOU!