Database Analyst

ABOUT CAPITAL TECHNOLOGY ALLIANCE

At Capital Technology Alliance, we believe changing the future of technology means valuing people. We are committed to building a collaborative, high-performing environment where professionals are empowered to deliver meaningful impact. Our teams work on challenging, often high-visibility initiatives that support mission-critical systems, enterprise modernization efforts, and data-driven decision-making.

CTA is proud to demonstrate a high renewal rate with our employees and contractors. We place a high value on expertise. That's why CTA is committed to paying top rates in the industry and connecting you with positions and flexible engagement options that match your skills and professional goals.

CTA'S FLEXIBLE ENGAGEMENT OPTIONS

We believe top talent deserves flexible engagement options. Every CTA opportunity offers flexible engagement models so you can choose the path that fits your goals, lifestyle, and financial preferences. Qualified candidates may choose between:

• Employee (W2) — Join CTA as a full-time team member with consistent pay, eligibility for benefits, long-term career growth, and the opportunity to build lasting relationships within a respected government and enterprise technology consulting firm.

• Staff Augmentation (1099 or Corp-to-Corp) — Prefer consulting flexibility? Partner with CTA while maintaining your independence and autonomy, working on high-impact projects that make a difference.

No matter which model you choose, you'll work alongside experienced professionals delivering mission-critical solutions to state, local, and enterprise clients. We focus on long-term partnerships, not transactional placements.

POSITION OVERVIEW

CTA is seeking experienced Database Analysts to collect and translate business information needs into technical specifications and to support the design, development, and optimization of data warehouse structures for a state government client. The role ensures data accuracy through validation and quality checks, conducts data mining and analysis to support decision-making, and collaborates with users to clarify reporting requirements and proper data use.

SCOPE OF WORK

The Database Analyst develops prototypes, performs testing, and evaluates proposed solutions to ensure alignment with business objectives. The position manages Extract, Transform, Load (ETL) processes, maintains data models, supports technical tools and warehouse environments, and continually improves data-related processes by applying best practices in data modeling, metadata management, and documentation.

KEY RESPONSIBILITIES

Business Information Analysis and Requirements Gathering

• Engage with business stakeholders to identify, understand, and document information needs.

• Translate business requirements into clear, detailed technical specifications that align with data warehouse architecture and reporting objectives.

Data Warehouse Development and Data Mining

• Design, develop, and enhance data warehouse structures, including data models, metadata, and repository frameworks.

• Perform data mining, analysis, and evaluation to support decision-making and optimize data utilization.

Data Validation and Quality Assurance

• Review and validate data loaded into the warehouse to ensure accuracy, consistency, and completeness.

• Conduct routine data quality checks, identify discrepancies, and perform data cleansing and refinement activities.

User Interaction and Reporting Support

• Partner with business users to understand reporting needs and deliver technical guidance.

• Provide consulting on proper data usage, highlight potential data conflicts, and promote best practices for accessing and interpreting warehouse data.

Prototyping, Testing, and Solution Evaluation

• Develop prototypes to validate data design and reporting concepts.

• Create and execute test scripts, conduct functional and system-level testing, and evaluate proposed solutions for alignment with business requirements.

• Identify solution gaps and coordinate remediation.

Data Integration and ETL Management

• Support and maintain ETL workflows, including data extraction, transformation, loading, and replication.

• Ensure data processes are efficient, scalable, and fully documented.

• Maintain enterprise data models supporting warehouse and data mart environments.

Technical Tooling and Environment Support

• Apply strong working knowledge of relevant software tools, scripting languages, and system environments used within the warehouse ecosystem.

• Support data warehouse operations across multiple operating systems and platforms.

Process Improvement and Best Practices

• Continuously evaluate and optimize data warehouse processes, recommending improvements where appropriate.

• Apply industry best practices in data modeling, metadata management, documentation, and data warehouse operations to strengthen organizational data capabilities.

REQUIRED QUALIFICATIONS

• Bachelor's degree from an accredited college or university in Computer Science, Information Systems, or other related field — OR four (4) years of equivalent work experience. Relevant experience may be substituted for education on a year-for-year basis.

• Strong skills in analyzing and documenting technical processes, mapping out business processes, identifying bottlenecks, and analyzing inefficiencies.

• Experience in Data Analysis and Management.

• Experience in data mapping, modeling, and integration across systems.

• Demonstrated experience and proficiency with Microsoft Visio.

• Excellent verbal and written communication abilities, along with strong interpersonal skills.

• Must successfully complete a background check.

PREFERRED QUALIFICATIONS

• Familiarity with business process mapping and defining current-state applications in requirements documentation.

• Experience facilitating sessions with business leadership, Subject Matter Experts (SMEs), and users within a business function.

• Skilled in understanding web applications and common application approaches to support business capabilities.

JOB SPECIFIC KNOWLEDGE, SKILLS, AND ABILITIES

• Knowledge of data warehouse architecture, data modeling, and metadata management practices.

• Knowledge of ETL workflow design, data quality assurance, and data lineage concepts.

• Skill in data mapping, modeling, and integration across heterogeneous systems.

• Skill in producing clear technical specifications from business requirements.

• Ability to facilitate working sessions with business leadership, SMEs, and end users.

• Ability to apply industry best practices in data modeling, metadata management, and documentation.

ADDITIONAL NOTES

• Successful candidate must complete client-required security awareness training within 30 calendar days of hire.

• Billable hours are limited to 40 per week unless pre-approved by designated client leadership.

• Travel is not reimbursable unless specifically authorized in writing by client leadership.