Data Management SQL Developer

PLS Financial Services - Oak Brook, IL

Full-time - Mid Level

Oak Brook, IL

101-250 employees

Credit Intermediation and Related Activities

About the position

The Data Management SQL Developer at PLS Financial Services, Inc. is responsible for designing, developing, and maintaining business intelligence solutions that support the company's objectives. This role focuses on enhancing business intelligence capabilities, developing reporting systems, and executing complex queries to provide accessible information for better decision-making across various functional teams.

Responsibilities

• Translate business needs to technical specifications
• Design, build and deploy BI solutions (e.g. reporting tools)
• Support data analytics platforms
• Collaborate with different teams to integrate systems
• Develop and execute database queries and conduct analyses
• Create visualizations and reports for requests from different functional teams
• Develop and update technical documentation and reporting requirements
• Other duties as assigned

Requirements

• 5+ years of experience as a SQL developer
• Proven experience in developing MS SQL and Azure preferred databases for both cloud-based and on-premises environments
• 3+ years of experience with SQL Databases in Azure environment, Azure Data Factory (ADF), and Azure Cosmos DB (or other NoSQL databases)
• 3+ years of experience working with complex SQL queries, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and PowerBI
• Skilled at optimizing large, complicated SQL statements
• Functional experience with Microsoft Excel
• Familiar with data governance and quality
• Capable of troubleshooting common query issues
• Familiar with tools that can aid with profiling server resource usage and optimizing it
• Proficient understanding of code versioning tools
• Proven abilities to take initiative and be innovative
• Strong problem-solving and analytical skills
• Strong attention to detail
• Ability to work in a team

Benefits

• Health insurance
• Dental insurance
• Vision insurance
• 401k
• Vacation
• Opportunities for advancement
• On-going training available