On Site Data Architect (Oracle, PL/SQL, APEX, JAVA)

Global Information Systems - Tallahassee, FL

Full-time - Senior

Tallahassee, FL

Professional, Scientific, and Technical Services

About the position

The On Site Data Architect is responsible for enterprise-wide data design, focusing on optimizing data access while balancing batch loading and resource utilization factors. This role requires a deep understanding of designing and constructing data architectures, operational data stores, and data marts. The Data Architect will define data architecture standards, policies, and procedures for the organization, ensuring that the structure, attributes, and nomenclature of data elements are consistent and adhere to accepted data content standards. This position also involves business analysis, data acquisition, access analysis, and design, as well as optimizing Database Management Systems (DBMS), developing recovery strategies, and implementing load strategies. In this expert-level role, the Data Architect will define and plan database architectures for enterprise systems, working on multiple projects as a project leader or subject matter expert. The position requires handling projects and issues of high complexity that necessitate in-depth knowledge across various technical areas and business segments. The Data Architect will also coach and mentor junior technical staff, ensuring that they are equipped with the necessary skills and knowledge to succeed in their roles. The responsibilities of the Data Architect include controlling projects from start to finish to ensure high-quality, innovative, and functional designs. Collaboration with IT teams and management is essential to devise a data strategy that meets industry requirements. The Data Architect will build an inventory of data needed for architecture implementation, research new opportunities for data acquisition, and evaluate current data management technologies. They will create a comprehensive vision for data flow within the organization, develop data models for database structures, and design, document, construct, and deploy database architectures and applications, particularly large relational databases. Additionally, the Data Architect will integrate technical functionalities such as scalability, security, performance, data recovery, and reliability into the systems they design. Monitoring, refining, and reporting on the performance of data management systems is also a critical aspect of this role, along with maintaining a corporate repository of all data architecture artifacts and procedures.

Responsibilities

• Control project from start to finish to ensure high quality, innovative and functional design.
• Collaborate with IT teams and management to devise a data strategy that addresses industry requirements.
• Build an inventory of data needed to implement the architecture.
• Research new opportunities for data acquisition.
• Identify and evaluate current data management technologies.
• Create a fluid, end-to-end vision for how data flows through an organization.
• Develop data models for database structures.
• Design, document, construct and deploy database architectures and applications (e.g., large relational databases).
• Integrate technical functionality (e.g., scalability, security, performance, data recovery, reliability, etc.).
• Implement measures to ensure data accuracy and accessibility.
• Constantly monitor, refine, and report on the performance of data management systems.
• Meld new systems with existing warehouse structures.
• Produce and enforce database development standards.
• Maintain a corporate repository of all data architecture artifacts and procedures.

Requirements

• A minimum of 12+ years of experience with large and complex database management systems.
• Bachelor's or Master's Degree in Computer Science, Information Systems, or other related field, or equivalent experience.

Nice-to-haves

• 8+ years of experience with data architecture, large-scale data modeling, database design, and business requirements analysis.
• Technical leadership abilities in data architecture.
• Strong understanding of best practices in data modeling techniques, including normalization and dimensional modeling.
• Demonstrated experience in large scale enterprise and data warehouse initiatives involving multiple departments.
• Experience with data visualization, data migration, and data modeling.
• Familiarity with relational database management systems and DBMS software, including SQL Server.
• Knowledge of machine learning, predictive modeling, and natural language processing.
• Experience with data mining and modeling tools.
• Familiarity with data management and reporting technologies, predictive analytics, data visualization, and unstructured data.
• Creative and analytical problem-solving capabilities.
• Experience in database and cloud computing design, architectures, and data lakes.
• Strong knowledge transfer and mentoring skills; ability to communicate technical documentation effectively to both technical and non-technical team members.