Sql jobs in United States

• Job category: Not Evaluated (Job Family)

PPI (an independent subsidiary of iA Financial) is an Insurance Marketing Organization that sits between independent advisors and insurance companies. From coast-to-coast, we provide value-added services and support such as digital tools, education, marketing, and processing, to help Advisors elevate and grow their business with a socially responsible mindset.

At PPI, each day you have the opportunity to make a meaningful difference when you support our independent insurance advisors in providing financial security and peace of mind to their clients: Canadian families and businesses.

When you join PPI you will be part of a diverse, inclusive and equitable place to work that values different perspectives. You will benefit from a culture that is people-focused, inclusive and collaborative with opportunities to learn and develop your skills, develop your career and make a meaningful impact.

PPI is pleased to provide employees with the flexibility of a hybrid work environment. This role is eligible for working from home up to 3 days per week.

We are seeking a skilled Infrastructure/Backend Developer to join our team as a developer of in-house systems and platforms, including PPI’s commission system.

The successful candidate will have a proficient understanding of cloud architecture, infrastructure-as-code, software development, GitOps, CI/CD, IaC, IAM, security principles, automated testing and observability tools and methodologies. They will work closely with PPI’s Infrastructure, Security, IT Operations, and Development teams to implement and maintain continuous integration (CI) and continuous deployment (CD) environments to securely deploy in-house developed applications onto appropriately provisioned Cloud Infrastructure.

Key Responsibilities:

1. Maintain and enhance PPI’s commission system in accordance with cybersecurity policies and DevSecOps methodology.
2. Manage data feeds, maintain back-office databases, provide reporting and Macro/Power queries, maintain converter and decryption tools for carrier feeds, and enhance the platform for additional functionality.
3. Provide similar support for other systems and tools as identified by other departments, e.g. planned future phases of PPI’s secure Advisor Portal.
4. Investigate, identify, and implement AI, Robotics, and Machine Learning use cases to enhance the administration of new and existing insurance business.
5. Collaborate with various departments to identify opportunities for AI-driven improvements and implement solutions that drive efficiency and innovation.
6. Automate business and IT tasks, such as:
1. User creation and deletion
2. Reports (Power BI, Power Query, and DAX)
3. Document indexing
4. Software installation scripts
5. Azure service deployment
6. Build and maintain Sql Server Integration Scripts (SSIS)
7. Build and maintain web APIs
7. Document the processes and best practices needed to design and deploy secure cloud infrastructure and applications at PPI.
8. Assist with deploying code to production environment via infrastructure-as-code following change management processes and approvals.
9. Work with the security, infrastructure, IT operations, and development teams to ensure the right security, infrastructure, and deployment processes and controls are implemented for projects.
10. Support the build and implementation of continuous integration (CI) and continuous deployment (CD) environments and ensure proper security controls and procedures are embedded in development pipeline, such as automated code assessments.
11. Support and collaborate with the development and IT ops teams in the operationalization of project (e.g. Advisor Portal) DevSecOps.
12. Liaise with 3rd party consultants (e.g. Accounting System) as required on the development, testing and deployment of upgrades.
13. Engage in actions that encourage, reflect and align with PPI’s ESG (Environmental, Social and Governance) commitments to our Advisors, their clients and our employees.

Education, Experience and Skills:

1. Degree in computer science or related discipline.
2. 7 or more years of solid cloud development and architecture experience.
3. Experience with Microsoft Azure, PowerBI, SQL.
4. Proficiency in C# (C++ preferable).
5. Proficiency with T-SQL including Stored Procedures.
6. Demonstrated proficiency in DevSecOps methodologies, technologies, and implementation.
7. Proficiency with testing and scanning tools (ex. SonarQube, Snyk, BlackDuck, etc.).
8. Hands on experience working with monitoring/observability tools and with GitOps.
9. Strong understanding of DevSecOps process and governance.
10. Exemplary interpersonal skills with a demonstrated ability to develop and maintain relationships and work harmoniously with multiple teams.
11. Excellent written and verbal communication skills with proficiency in documentation.
12. Experience in a financial services or insurance environment will be an advantage.

The expected salary range for this position starts at $120,000 and will be commensurate with the candidate’s experience and skill set.

We thank all applicants for applying, however, only those selected for an interview will be contacted. Your resume may be used for other vacancies.

See why so many people choose iA!

iA Financial Group is the strength of a company with a human side, with its over 10,000 employees. Together, we have earned the trust of our more than five million clients and 50,000 advisors who have chosen us for their insurance, savings, and wealth management.

With over $235 billion in assets, we’re a key player in the financial services industry in Canada and the United States. The secret to our success? Investing in you, one person at a time. Because, for over 130 years, we have believed that it’s by supporting our employees and surrounding ourselves with the most reputable leaders in the industry, we will continue to innovate.

At iA, we’re invested in you.

At iA Financial Group, we support and celebrate diversity. We strive to provide a workplace that is recognized as inclusive for all, regardless of ethnic origin, nationality, language, religious beliefs, gender, sexual orientation, age, marital status, family situation, or physical or mental disability.

Please note that if you need help or assistance to make the recruitment process more accessible for you, write to us. Someone from our team will be happy to assist you.