Senior Platform Developer

Job Title: Senior Platform Developer

Role Overview

The Senior Platform Developer will lead the design, analysis, and optimization of enterprise-grade data models and database architectures supporting transactional systems, analytics platforms, and regulatory reporting environments. This role requires deep expertise in relational and dimensional modeling, advanced SQL analysis, and database performance optimization across multiple RDBMS platforms.

You will collaborate closely with application architects, data engineers, business analysts, and data governance teams to ensure scalable, performant, and compliant data structures aligned with regulatory and business needs.

Key Responsibilities

Data Modeling & Architecture

• Design and develop conceptual, logical, and physical data models for new initiatives and legacy system modernization
• Create and maintain Entity-Relationship Diagrams (ERDs) using tools such as Erwin or PowerDesigner
• Reverse-engineer existing databases to document undocumented or inherited data structures
• Define entities, attributes, keys, relationships, constraints, and normalization standards
• Ensure data consistency, integrity, and alignment with architectural standards

Relational & Dimensional Database Design

• Architect relational database schemas for high-volume transactional systems using:
• Microsoft SQL Server
• Oracle
• MySQL
• Design dimensional models (Star & Snowflake schemas) to support analytics and BI reporting
• Partner with analytics and reporting teams to optimize performance, usability, and extensibility

Data Profiling, Quality & Lineage

• Perform data profiling and data quality analysis using advanced ANSI SQL
• Identify anomalies, integrity issues, and validate business rules across datasets
• Analyze relationships across multiple source systems to establish systems of record
• Document data lineage, metadata, and source-to-target mappings to support governance and audits

Database Performance & Optimization

• Optimize database performance through:
• Index design
• Query tuning
• Execution plan analysis
• Diagnose and resolve database design and performance issues
• Recommend architectural improvements to support scalability, reliability, and long-term maintainability

Key Deliverables

Data Modeling Artifacts

• Conceptual, logical, and physical data models with complete ERDs
• Reverse-engineered models of legacy systems with modernization documentation

Database Implementation Assets

• Database DDL scripts for schema and table creation
• Stored procedures, views, functions, and triggers
• Indexing strategies aligned with workload patterns

Data Quality & Governance Documentation

• Data profiling and quality assessment reports
• Data lineage diagrams and metadata documentation
• Source-to-target mapping specifications

Performance & Scalability Outputs

• Database performance tuning reports
• Index and query optimization scripts
• Capacity planning and scalability analysis

Required Skills & Expertise

• Strong expertise in data modeling methodologies (3NF, dimensional modeling)
• Advanced proficiency in ANSI SQL
• Hands-on experience with:
• SQL Server
• Oracle
• MySQL
• Extensive experience with Erwin, PowerDesigner, or similar tools
• Proven ability to analyze, optimize, and troubleshoot complex database environments

Preferred Qualifications

• Experience supporting government or regulated enterprise systems
• Familiarity with data governance, metadata management, and compliance frameworks
• Strong documentation and communication skills for both technical and business audiences