SAVVY Technology Solutions LLC · 4 hours ago
Senior Data Platform Developer
Springfield, IL
Full-time
Onsite
Senior LevelSAVVY Technology Solutions LLC is seeking a Senior Platform Developer responsible for designing, analyzing, and optimizing enterprise-grade data models and database architectures. This role requires deep expertise in relational and dimensional modeling, advanced SQL-based data analysis, and database performance optimization across multiple RDBMS platforms.
Business IntelligenceConsultingProfessional ServicesProject Management
Responsibilities
Design and develop conceptual, logical, and physical data models for both greenfield initiatives and legacy system modernization efforts, ensuring alignment with business processes and technical architecture standards
Create and maintain Entity-Relationship Diagrams (ERDs) using industry-standard tools such as Erwin and Power Designer, including reverse engineering of existing databases to document undocumented or inherited data structures
Define entity attributes, primary and foreign keys, relationships, normalization standards, constraints, and referential integrity rules to ensure consistency and data accuracy across systems
Architect robust relational database schemas for enterprise platforms including Microsoft SQL Server, Oracle, and MySQL, supporting high-volume transactional workloads
Design dimensional data models using star and snowflake schemas to enable efficient analytics, reporting, and business intelligence solutions
Partner with reporting and analytics teams to ensure data models meet performance, usability, and extensibility requirements
Conduct comprehensive data profiling and data quality assessments by writing complex ANSI SQL queries to analyze data distributions, detect anomalies, identify data integrity issues, and validate business rules
Analyze data relationships across multiple source systems to establish authoritative sources of truth and clearly defined ownership
Document data lineage, metadata, and source-to-target mappings to support governance, auditability, and downstream system integration
Optimize database performance through strategic index design, query tuning, and metadata management across heterogeneous database platforms
Diagnose and resolve database design and performance issues by reviewing execution plans, storage strategies, and schema configurations
Recommend and implement architectural enhancements and operational improvements to support scalability, reliability, and long-term maintainability
Act as the SQL / Oracle Subject Matter Expert (SME), providing authoritative technical analysis across complex legacy relational database environments
Perform comprehensive legacy system analysis, including reverse-engineering database schemas, relationships, constraints, indexes, and embedded business logic across SQL Server, Oracle, and MySQL platforms
Develop and maintain high-fidelity documentation of current-state (“as-is”) data architectures, including data models, lineage, dependencies, and integration touchpoints
Create and validate conceptual, logical, and physical data models in alignment with 3NF and dimensional modeling standards using enterprise modeling tools
Author and analyze advanced ANSI SQL to support data profiling, validation, reconciliation, lineage assessment, and performance evaluation
Assess data quality, structural integrity, and performance characteristics of legacy databases, document risks, gaps, and optimization opportunities with clear technical recommendations
Partner with solution and enterprise architects to support future-state data architecture planning, modernization assessments, and migration strategies
Translate detailed legacy-state findings into actionable inputs for architectural decision records (ADRs) and long-term platform roadmaps
Communicate complex technical findings clearly and concisely to cross-functional stakeholders through documentation-first deliverables, workshops, and reviews
Operate in a documentation-first, analysis-driven role with minimal to no hands-on application development, focusing on technical advisory and architectural enablement
Qualification
Required
Deep expertise in relational and dimensional modeling
Advanced SQL-based data analysis
Database performance optimization across multiple RDBMS platforms
Design and develop conceptual, logical, and physical data models for both greenfield initiatives and legacy system modernization efforts
Create and maintain Entity-Relationship Diagrams (ERDs) using industry-standard tools such as Erwin and Power Designer
Define entity attributes, primary and foreign keys, relationships, normalization standards, constraints, and referential integrity rules
Architect robust relational database schemas for enterprise platforms including Microsoft SQL Server, Oracle, and MySQL
Design dimensional data models using star and snowflake schemas
Conduct comprehensive data profiling and data quality assessments by writing complex ANSI SQL queries
Analyze data relationships across multiple source systems
Document data lineage, metadata, and source-to-target mappings
Optimize database performance through strategic index design, query tuning, and metadata management
Diagnose and resolve database design and performance issues
Recommend and implement architectural enhancements and operational improvements
Act as the SQL / Oracle Subject Matter Expert (SME)
Perform comprehensive legacy system analysis
Develop and maintain high-fidelity documentation of current-state data architectures
Create and validate conceptual, logical, and physical data models in alignment with 3NF and dimensional modeling standards
Author and analyze advanced ANSI SQL to support data profiling, validation, reconciliation, lineage assessment, and performance evaluation
Assess data quality, structural integrity, and performance characteristics of legacy databases
Partner with solution and enterprise architects to support future-state data architecture planning
Translate detailed legacy-state findings into actionable inputs for architectural decision records (ADRs)
Communicate complex technical findings clearly and concisely to cross-functional stakeholders
Operate in a documentation-first, analysis-driven role with minimal to no hands-on application development
Preferred
Experience supporting large-scale government or regulated enterprise systems
Familiarity with data governance, metadata management, and compliance frameworks
Strong documentation skills with the ability to translate complex technical concepts into clear, consumable artifacts for technical and business stakeholders
Company
SAVVY Technology Solutions LLC
SAVVY Technology Solutions is an IT service provider and reseller serving Public Sector and Commercial clients.
Founded in 2008
11-50 employees
H1B Sponsorship
SAVVY Technology Solutions LLC has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (2)
2022 (2)
2021 (2)
Funding
Current Stage
Early StageCompany data provided by crunchbase