Capital Technology Alliance · 17 hours ago
Data Architect
Tallahassee, FL
Contract
Onsite
Senior Level
7+ years expCapital Technology Alliance is seeking a Data Architect to enhance their data management capabilities. The role involves analyzing existing data models, designing new data structures, and improving ETL processes to ensure data quality and integration, while collaborating with development teams and stakeholders.
Information Technology & Services
Responsibilities
Analyze and verify existing Work Program Datamart and General Ledger data models to assess impacts related to changes in Chart of Account data elements due to the Florida PALM Project
Evaluate the existing data models for dependencies on current Chart of Account structures and assess the scope of necessary changes
Conduct impact analysis on reporting and application usage of data models to ensure business outcomes are not disrupted by the transition to PALM
Provide a comprehensive design of data models, incorporating new Chart of Account data elements introduced by the PALM system
Ensure that the redesigned data models are scalable, robust, and aligned with best practices in data management, supporting both current and future business needs
Analyze existing ETL (Extract, Transform, Load) jobs to identify inefficiencies and potential areas for enhancement
Design and implement robust data quality measures to ensure the timeliness, accuracy, and completeness of production data on a scheduled basis, including nightly, hourly, or less frequent intervals as needed
Collaborate with development teams to automate and streamline ETL processes to support efficient data flow and integration
Provide expertise in data visualization and reporting, offering best practices to support the business’s ability to analyze and interpret financial data effectively
Develop strategies to enhance existing reporting frameworks, ensuring that they are compatible with the new data models and data structures
Work closely with existing development teams to deploy new and revised data models, verifying that the implementation aligns with functional requirements and business goals
Act as a liaison between technical and non-technical stakeholders, ensuring clear communication regarding data model changes, system impacts, and timelines
Qualification
Required
Analyze and verify existing Work Program Datamart and General Ledger data models to assess impacts related to changes in Chart of Account data elements due to the Florida PALM Project
Evaluate the existing data models for dependencies on current Chart of Account structures and assess the scope of necessary changes
Conduct impact analysis on reporting and application usage of data models to ensure business outcomes are not disrupted by the transition to PALM
Provide a comprehensive design of data models, incorporating new Chart of Account data elements introduced by the PALM system
Ensure that the redesigned data models are scalable, robust, and aligned with best practices in data management, supporting both current and future business needs
Analyze existing ETL (Extract, Transform, Load) jobs to identify inefficiencies and potential areas for enhancement
Design and implement robust data quality measures to ensure the timeliness, accuracy, and completeness of production data on a scheduled basis, including nightly, hourly, or less frequent intervals as needed
Collaborate with development teams to automate and streamline ETL processes to support efficient data flow and integration
Provide expertise in data visualization and reporting, offering best practices to support the business's ability to analyze and interpret financial data effectively
Develop strategies to enhance existing reporting frameworks, ensuring that they are compatible with the new data models and data structures
Work closely with existing development teams to deploy new and revised data models, verifying that the implementation aligns with functional requirements and business goals
Act as a liaison between technical and non-technical stakeholders, ensuring clear communication regarding data model changes, system impacts, and timelines
Strong knowledge of financial management business processes, including accounting, ledger management, and budget reporting
In-depth understanding of data modeling principles, including relational and dimensional modeling techniques
Familiarity with the Florida PALM system or similar state or federal financial management systems
Proficiency in database management systems (DBMS) such as Microsoft SQL Server and DB2
Comprehensive understanding of ETL processes and data integration tools like Informatica, Talend, or Microsoft SSIS
Knowledge of cloud-based data integration platforms (e.g., Azure, Snowflake) and cloud-first strategies
Familiarity with data quality management practices, data governance frameworks, and best practices
Knowledge of data visualization tools (e.g., Power BI) and reporting best practices
Understanding of data security, privacy regulations, and compliance requirements
Proficiency in SQL and scripting languages for database querying and data manipulation
Strong analytical and problem-solving skills, with the ability to conduct complex systems analysis and identify areas for improvement
Skill in designing scalable and robust data models that support business processes and reporting needs
Ability to work with ETL tools to streamline and automate data extraction, transformation, and loading processes
Skilled in verbal and written communication, with the ability to explain technical concepts to non-technical stakeholders
Competency in project management, including the ability to plan, prioritize, and manage multiple tasks effectively
Strong collaboration and interpersonal skills to work effectively with cross-functional teams and stakeholders
Skilled in conducting data impact assessments and presenting findings to management and development teams
Ability to lead and mentor technical teams, providing guidance on best practices in data architecture, integration, and quality management
Ability to conduct detailed analysis of existing systems and identify opportunities for optimization and modernization
Capability to develop comprehensive data models and ETL processes that align with business requirements and organizational goals
Ability to translate user requirements into technical specifications and scalable data solutions
Ability to integrate research, trends, and industry best practices into continuous improvement efforts
Ability to communicate effectively with stakeholders at all levels, ensuring alignment between technical solutions and business needs
Ability to adapt to changing requirements and priorities, maintaining a focus on quality and project deadlines
Strong organizational skills and attention to detail, with the ability to document data architecture, processes, and standards
Ability to ensure data solutions comply with security, privacy, and compliance standards
A minimum of 7 years of experience with large and complex database management systems
A minimum of 7 years of experience as a data architect or senior data analyst, with extensive experience in designing, implementing, and maintaining data models and ETL processes
10+ years of broad experience working with database management systems (such as Oracle, SQL Server, or DB2) and data integration tools
Strong background in financial data systems, including data modeling, data governance, and data quality management
Proven experience with ETL tools, data warehousing, and automation of data processes to ensure accuracy, timeliness, and completeness of data
Experience in data visualization and reporting best practices, with familiarity with tools like Power BI, Tableau, or similar platforms
Familiarity with cloud-based data integration solutions, such as Azure or Snowflake
Bachelor's or Master's Degree in Computer Science, Information Systems, or other related field. Work experience can substitute on a year for year basis for the degree
Preferred
Experience with Informatica, Cloud Data Governance and Catalog, Cloud Data Integration, or other modern data integration platforms
Strong analytical skills and the ability to translate business requirements into technical specifications
Excellent communication and collaboration skills, capable of working effectively with technical and non-technical stakeholders
Company
Capital Technology Alliance
At Capital Technology Alliance, we are committed to pioneering the future of technology consulting.
2-10 employees
H1B Sponsorship
Capital Technology Alliance has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
Funding
Current Stage
Early StageLeadership Team
Andrew Morton, MBA, PMP®, CSM®
Co-Founder
Company data provided by crunchbase