Database Analyst (5/4)

Job Title: Database Analyst
Job Location: Tallahassee, FL (on-site)
Job Duration: Contract through June + extension
Job Tasks and Activities:
The Database Analysts collect and translate business information needs into technical specifications and support the design, development, and optimization of data warehouse structures. 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. The analyst develops prototypes, performs testing, and evaluates proposed solutions to ensure alignment with business objectives. Additionally, 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.
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 Implementation:

• 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 Experience:

• 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. and
• Excellent verbal and written communication abilities, along with strong interpersonal skills.

Preferred Experience:

• 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.

Dexian stands at the forefront of Talent + Technology solutions with a presence spanning more than 70 locations worldwide and a team exceeding 10,000 professionals. As one of the largest technology and professional staffing companies and one of the largest minority-owned staffing companies in the United States, Dexian combines over 30 years of industry expertise with cutting-edge technologies to deliver comprehensive global services and support.

Dexian connects the right talent and the right technology with the right organizations to deliver trajectory-changing results that help everyone achieve their ambitions and goals.To learn more, please visit https://dexian.com/.

Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.