Database Analyst
Role details
Job location
Tech stack
Job description
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.
Requirements
- 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.
