Krasan Consulting Services
Senior Platform Developer - ETL (Springfield)
Krasan Consulting Services, Springfield, Illinois, us, 62777
Hiring for: Senior Platform Developer (Data Modeling & Database Architecture)
Primary Responsibilities: Data Modeling & Architecture Design and develop conceptual, logical, and physical data models for greenfield initiatives and legacy modernization efforts. Create and maintain Entity-Relationship Diagrams (ERDs) using tools such as Erwin and PowerDesigner. Perform 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. Relational & Dimensional Database Design Architect robust relational database schemas for enterprise platforms including Microsoft SQL Server, Oracle, and MySQL. Design dimensional data models (star and snowflake schemas) to support analytics, reporting, and BI solutions. Partner with reporting and analytics teams to ensure performance, usability, and extensibility of data models. Data Profiling, Quality & Lineage Analysis Conduct data profiling and data quality assessments using complex ANSI SQL queries. Analyze data distributions, identify anomalies, validate business rules, and detect data integrity issues. Establish authoritative sources of truth across multiple systems. Document data lineage, metadata, and source-to-target mappings to support governance, auditability, and integrations. Database Performance & Optimization Optimize database performance through indexing strategies, query tuning, and schema optimization. Analyze execution plans, storage strategies, and metadata to diagnose and resolve performance issues. Recommend and implement architectural enhancements to ensure scalability, reliability, and long-term maintainability.
Key Deliverables: Data Modeling Artifacts Conceptual, logical, and physical data models with fully defined ERDs. Reverse-engineered models of legacy systems with detailed documentation. Database Implementation Assets DDL scripts for schema and table creation. Stored procedures, views, functions, and triggers. Comprehensive indexing strategies aligned with workload patterns. Data Quality & Governance Documentation Data quality assessment reports with profiling results and remediation recommendations. Data lineage diagrams, metadata repositories, and source-to-target mappings. Performance & Capacity Optimization Performance tuning reports including index recommendations and query optimization. Capacity planning and scalability analysis for future growth. Required Skills & Expertise Strong expertise in data modeling methodologies (Conceptual, Logical, Physical, 3NF, Dimensional). Advanced proficiency in ANSI SQL. Hands-on experience with SQL Server, Oracle, and MySQL. Extensive experience using Erwin, PowerDesigner, or equivalent tools. Proven ability to analyze and optimize complex database environments.
Preferred Qualifications: Experience working with large-scale government or regulated enterprise systems. Knowledge of data governance, metadata management, and compliance frameworks. Excellent documentation skills with the ability to communicate complex technical concepts to both technical and business stakeholders.
Primary Responsibilities: Data Modeling & Architecture Design and develop conceptual, logical, and physical data models for greenfield initiatives and legacy modernization efforts. Create and maintain Entity-Relationship Diagrams (ERDs) using tools such as Erwin and PowerDesigner. Perform 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. Relational & Dimensional Database Design Architect robust relational database schemas for enterprise platforms including Microsoft SQL Server, Oracle, and MySQL. Design dimensional data models (star and snowflake schemas) to support analytics, reporting, and BI solutions. Partner with reporting and analytics teams to ensure performance, usability, and extensibility of data models. Data Profiling, Quality & Lineage Analysis Conduct data profiling and data quality assessments using complex ANSI SQL queries. Analyze data distributions, identify anomalies, validate business rules, and detect data integrity issues. Establish authoritative sources of truth across multiple systems. Document data lineage, metadata, and source-to-target mappings to support governance, auditability, and integrations. Database Performance & Optimization Optimize database performance through indexing strategies, query tuning, and schema optimization. Analyze execution plans, storage strategies, and metadata to diagnose and resolve performance issues. Recommend and implement architectural enhancements to ensure scalability, reliability, and long-term maintainability.
Key Deliverables: Data Modeling Artifacts Conceptual, logical, and physical data models with fully defined ERDs. Reverse-engineered models of legacy systems with detailed documentation. Database Implementation Assets DDL scripts for schema and table creation. Stored procedures, views, functions, and triggers. Comprehensive indexing strategies aligned with workload patterns. Data Quality & Governance Documentation Data quality assessment reports with profiling results and remediation recommendations. Data lineage diagrams, metadata repositories, and source-to-target mappings. Performance & Capacity Optimization Performance tuning reports including index recommendations and query optimization. Capacity planning and scalability analysis for future growth. Required Skills & Expertise Strong expertise in data modeling methodologies (Conceptual, Logical, Physical, 3NF, Dimensional). Advanced proficiency in ANSI SQL. Hands-on experience with SQL Server, Oracle, and MySQL. Extensive experience using Erwin, PowerDesigner, or equivalent tools. Proven ability to analyze and optimize complex database environments.
Preferred Qualifications: Experience working with large-scale government or regulated enterprise systems. Knowledge of data governance, metadata management, and compliance frameworks. Excellent documentation skills with the ability to communicate complex technical concepts to both technical and business stakeholders.