SQL Developer

SQL Developer PositionATI is Hiring. We are looking for a SQL Developer for our Kansas City, MO client.
The SQL Developer is responsible for designing, developing, maintaining, and optimizing databases and reporting solutions that support financial and accounting operations. This role partners closely with Finance, Accounting, Admin, and IT teams to develop reliable data integrations, financial reporting, reconciliations, and data quality initiatives that ensure the accuracy, integrity, and availability of critical business data.
The ideal candidate combines strong technical expertise with a solid understanding of financial systems, data governance, and software development best practices. This position plays a key role in supporting business decision-making through scalable, auditable, and high-performance data solutions.
Expectations:Analyze, define, and document system requirements for data, workflow, logical processes, interfaces with other systems, auditing, reporting requirements, and production configurationDesign, develop, test, implement, and maintain database and reporting solutions that support financial and operational objectivesDevelop and support data integration processes between internal and external systems, ensuring data accuracy, consistency, and completenessAdhere to established coding standards and procedures, including participation in the peer review processEnsure that each data flow has robust audit, data validation, error handling, monitoring, and reporting steps to always ensure accuracy and completeness of loaded dataProvide accurate effort estimates to the Team Lead and/or Project Manager and project teams as appropriateDeliver testing support including the design and execution and documentation of test scriptsStrong analytical and problem-solving skillsStrong communication, presentation, and relationship management skillsExperience working in a team-oriented, collaborative environmentAbility to work with diverse teamsAbility to maintain confidentialityPerforms other related duties as assigned and requiredCompetencies:Strong understanding of accounting and financial data, concepts, and principlesAdvanced analytical, troubleshooting, and problem-solving skillsExcellent verbal and written communication skills with the ability to communicate technical concepts to both technical and non-technical audiencesStrong organizational and time-management skills with the ability to manage multiple priorities and deadlinesAbility to build effective working relationships across business and technical teamsDemonstrated commitment to quality, accuracy, and continuous improvementAbility to work independently while contributing effectively within a collaborative team environmentTechnical

Qualifications:
Advanced proficiency in Microsoft SQL Server development and database designExperience developing complex T-SQL queries, stored procedures, views, functions, and performance optimization techniquesHands-on experience with SQL Server Integration Services (SSIS)SQL Server Reporting Services (SSRS)Data warehouse and ETL development conceptsDatabase performance tuning and troubleshootingSource control and change management processesThe ability to work accurately and diligently under pressure, on multiple projects within your project timeframesExperience with CTE's and temporal tables is a plusExperience with Power BI is a plusExperience documenting and following specifications with complex business logicExperience with ADF is a plusRequisites:Bachelor's Degree in Computer Science, similar degree, or equivalent work experienceFinancial and accounting reporting and data – 3 to 5 yearsSQL development in SQL Server 2014 and above – 3 to 5 yearsSSRS reports in SQL Server 2014 and above – 2 to 3 yearsSSIS development in SQL Server 2014 and above – 2 to 3 yearsSolid understanding of databases and data processing