Americo Financial Life and Annuity ยท 1 day ago
SQL Developer II
Kansas City, MO
Full-time
Onsite
Mid Level
3+ years expAmerico Financial Life and Annuity is seeking a SQL Developer II who will develop and optimize SQL-based solutions for accurate and secure access to enterprise data. The role involves designing and developing SQL solutions, optimizing queries, and collaborating on data integration processes to support high-quality applications and analytics.
BankingConsultingCrowdfundingFinancial ServicesInsuranceRetirement
Responsibilities
Design and Develop SQL Solutions - Create and maintain database objects (tables, views, stored procedures, functions) to support applications, reporting, and analytics. Ensure solutions follow best practices for performance, scalability, and maintainability
Optimize and Tune SQL Queries - Analyze and improve query performance through indexing strategies, execution plan reviews, and code optimization to ensure efficient data access
Collaborate on Data Integration Processes - Work with ETL teams (primarily Informatica, occasionally SSIS) to support data movement and transformation between systems, ensuring accuracy and consistency
Support Solution Design and Standards - Participate in design discussions, provide guidance on SQL Server capabilities, and ensure adherence to corporate standards and best practices in database development
Testing and Quality Assurance - Validate SQL code and database changes through unit testing and assist with integration testing to ensure reliability and compliance with requirements
Qualification
Required
3-5 years of hands-on experience with Microsoft SQL Server in a development role with strong T-SQL skills (queries, stored procedures, functions)
SQL Server Management Studio (SSMS)
Ability to analyze execution plans and apply indexing strategies
Work with ETL teams (primarily Informatica, occasionally SSIS) to support data movement and transformation between systems
Participate in design discussions, provide guidance on SQL Server capabilities, and ensure adherence to corporate standards and best practices in database development
Validate SQL code and database changes through unit testing and assist with integration testing to ensure reliability and compliance with requirements
Preferred
Oracle experience
Familiarity with source control tools (e.g., Azure DevOps, Git)
SSIS experience strongly preferred; Informatica familiarity helpful
Azure Database Administrator Associate or Data Engineer Associate (preferred, not required)
Company
Americo Financial Life and Annuity
Americo Financial Life and Annuity is a financial services company that offers life insurance services.
201-500 employees
H1B Sponsorship
Americo Financial Life and Annuity 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
2021 (1)
Funding
Current Stage
Growth StageLeadership Team
Mark Fallon
Senior Vice President and Chief Financial Officer
Renee Platz
Executive Assistant-CIO/Sr VP-Investments
Recent News
Company data provided by crunchbase