Description
In this role, you will lead the data architecture initiatives, leveraging over 7 years of experience in data modeling, reporting, analysis, mining, design, development, migration, implementation, and testing of databases. You will work in a hybrid environment, primarily based in Iselin & Charlotte, and will be responsible for defining and maintaining data architecture aligned with business and data strategies.
Skills
- Proficient in E-R Modeling for OLTP and OLAP, utilizing Multi-Dimensional Data Modeling techniques such as Star Schema Modeling and Snow-flake Dimension Modeling.
- Strong understanding of normalization and de-normalization techniques for optimal performance in relational and dimensional database environments.
- Extensive experience with conceptual, logical, and physical data modeling, adhering to metadata standards.
- Familiarity with data transformation and mapping from source to target database schemas, including data cleansing.
- Proficient in performance analysis, including creating partitions, indexes, and aggregate tables as necessary.
- Experience with UNIX operating systems, shell scripting, and automation of ETL processes.
- Skilled in writing, testing, and implementing triggers, stored procedures, views, cursors, packages, and functions using PL/SQL.
- Knowledge of business intelligence software, performance tuning of databases, backup and recovery, and SQL Loader.
- Experience integrating various data sources such as Oracle, SQL Server, MS Access, and flat files into staging areas.
Responsibilities
- Define and maintain data architecture based on business and data strategy.
- Establish and uphold reference architecture for enterprise data assets and processes.
- Define standards and enterprise patterns for data movement and processing.
- Collaborate with business stakeholders to convert business requirements into technical specifications.
- Engage with the enterprise architecture team to define optimal solutions for existing challenges.
- Research next-gen and emerging technologies, documenting and recommending optimal solutions.
Qualifications
- Excellent communication skills and a strong team player mentality.
- Experience in financial services and other domains utilizing data modeling, extraction, transformation, loading, and reporting processes.
Employment Type: Full-Time