Responsibilities:

Essential Functions

Designs and constructs large-scale, complex datasets that align with both business needs and technical requirements.

Identifies, designs, and implements well-structured, data-centric solutions, including:

Re-engineering infrastructure for enhanced scalability.

Improving data delivery processes.

Automating repetitive tasks and processes.

Developing strategies for effective data consolidation.

Creating data models and establishing the structure, attributes, and naming conventions of data elements.

Maintains a deep understanding of the ETL process and its development.

Oversees the design, management, and development of Data ODS, Data Warehouses, and standard data systems.

Creates the necessary infrastructure for efficient extraction, transformation, and loading (ETL) of data from various sources.

Develops analytical tools to use data pipelines, providing insights into crucial business performance metrics.

Works with stakeholders from data, design, product, and executive teams to maximize the value of their data.

Handles data analysis requests and manages report generation.

Collaborates with application developers, product owners, and business stakeholders to achieve desired results.

Participates in the design and creation of data warehouses.

Optimizes performance and fine-tunes queries using tools like Performance Monitor, SQL Profiler, and other related monitoring and troubleshooting tools.

Demonstrates a thorough understanding of index management, integrity checks, configuration, and patching.

Develops and resolves SQL code, including stored procedures, functions, tables, views, triggers, indexes, and constraints.

Evaluates new data sources for compliance with quality standards and integration feasibility.

Ensures optimal database performance by identifying and addressing issues in production and development environments, determining the best values for parameters, integrating new updates, maintaining systems, and assisting users.

Provides database support by writing utility programs, answering user questions, and resolving problems.

Stays updated with new industry developments by engaging in training, reading professional literature, networking, and participating in professional associations.

Supports the organization's mission and information systems by completing relevant tasks.

Develops custom functions to meet specific requirements.

Establishes best practices for database reporting and Business Intelligence (BI) tools.

Additional Specific Duties and Responsibilities

Identifies, tracks, and communicates technical risks, issues, progress, and outcomes to IT management.

Participates in design reviews and evaluates database scripts and code.

Qualifications:

Required Qualifications

Strong background in database design and architecture, with experience in both SQL and NoSQL databases, especially in cloud environments like AWS or Azure.

Experience in data warehousing, with the ability to effectively utilize big data; experience with Snowflake is advantageous.

Expertise in data transformation and ingestion, integrating large datasets into accessible formats (e.g., AWS Glue, Azure Data Factory).

Knowledgeable in managing high volumes of critical business data, with experience in data processing and buffering.

Proficiency with data deployment automation tools and operational automation.

Experience in designing systems for high availability, focusing on redundancy, failover, and resilience.

Good understanding of estimation techniques.

Bachelor’s degree in Business MIS, Computer Science, or equivalent work experience.

4+ years of experience in database administration for development.

4+ years of experience in technology or finance industries.

Certifications in SQL or other database technologies.

In-depth knowledge of database structures, theories, principles, and practices.

Experience in hands-on database tuning and troubleshooting.

Proficiency with data processing flowcharting techniques.

Strong understanding of the organization’s goals and objectives.

Knowledge of applicable data privacy laws and best practices.

Strong written and verbal communication skills.

Proficiency in technical documentation.

Strong interpersonal skills.

Ability to conduct research on database standards, issues, and products as needed.

Capability to present ideas in a user-friendly manner.

Highly self-motivated and driven.

Strong attention to detail.

Proven analytical and problem-solving skills.

Ability to effectively prioritize and manage tasks in a fast-paced environment.

Strong focus on customer service.

Experience working in a collaborative, team-oriented environment.