What are the responsibilities and job description for the Sr. Associate, SQL Developer position at KPMG?
Business Title: Sr. Associate, SQL Developer
Requisition Number: 101606 - 32
Function: Tax Services
Area of Interest:
State: IL
City: Chicago
Description:
Known for being a great place to work and build a career, KPMG provides audit, tax and advisory services for organizations in today's most important industries. Our growth is driven by delivering real results for our clients. It's also enabled by our culture, which encourages individual development, embraces an inclusive environment, rewards innovative excellence and supports our communities. With qualities like those, it's no wonder we're consistently ranked among the best companies to work for by Fortune Magazine, Consulting Magazine, Working Mother Magazine, Diversity Inc. and others. If you're as passionate about your future as we are, join our team.
KPMG is currently seeking a Senior Associate, Database Developer to join our Tax Technology organization.
Responsibilities:
-
Design logical database models and provide technical guidance during each phase of the development process
-
Provide performance tuning and optimization of existing SQL code
-
Deliver technical support for the database environment and database objects such as stored procedures, functions, triggers, tables, and views
-
Work with developers, business analysts, other team members and clients to review the business requirements and translate them into database objects
-
Create, maintain, and publish data models, data dictionaries and entity relationship diagrams using industry standard tools and technologies
-
Develop and practice standards for database architecture, administration, security, design, backup, recovery, development, and deployment for departmental use
Qualifications:
-
Minimum five years of recent experience in overall SQL Server performance tuning and optimization related field or equivalent industry experience; minimum five years of recent experience in logical and physical database modeling, as well as designing database schema, stored procedures, triggers, and other database related objects
-
Minimum five years of recent and progressive experience developing, unit testing and troubleshooting SQL Server in Azure Cloud and SQL Server 2014, 2016 and 2019 including SSRS, SSIS, and SSAS (desirable), as well as experience with Azure DevOps: advanced level of knowledge in using these technologies preferred
-
Bachelor's degree in Computer Science from an accredited college/university is preferred
-
Advanced knowledge of T-SQL/Stored Procedure/Function programming and design
-
Experience with PowerShell or other scripting languages
KPMG complies with all local/state regulations in regards to displaying salary ranges. If required, the salary range(s) are displayed below and are specifically for those potential hires who will perform work in or reside in the location(s) listed, if selected for the role. Any offered salary is determined based on internal equity, internal salary ranges, market data, ranges, applicant's skills and prior relevant experience, certain degrees and certifications (e.g. JD, technology), for example.
KPMG LLP (the U.S. member firm of KPMG International) offers a comprehensive compensation and benefits package. KPMG is an affirmative action-equal opportunity employer. KPMG complies with all applicable federal, state and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, citizenship status, disability, protected veteran status, or any other category protected by applicable federal, state or local laws. The attached link ( https://assets.kpmg.com/content/dam/kpmg/us/pdf/2018/09/eeo.pdf) contains further information regarding the firm's compliance with federal, state and local recruitment and hiring laws. No phone calls or agencies please.
KPMG does not currently require partners or employees to be fully vaccinated or test negative for COVID-19 in order to go to KPMG offices, client sites or KPMG events, except when mandated by federal, state or local law. In some circumstances, clients also may require proof of vaccination or testing (e.g., to go to the client site).
GL: 5
GF: 15305