1 день назад
Database Analyst/SQL DBA (SQL Server)
Вакансия из Hirify Global, списка международных tech-компанийДля мэтча и отклика нужен Plus
Мэтч & Сопровод
Для мэтча с этой вакансией нужен Plus
Описание вакансии
Текст:
TL;DR
Database Analyst/SQL DBA (SQL Server): Supporting critical data loads, data quality initiatives, and regulatory reporting data marts for Credit Risk Management with an accent on SQL Server administration, ETL, data validation, and performance tuning. Focus on designing data quality tests, troubleshooting source-to-target issues, improving load processes, and implementing database security and indexing strategies.
Location: Des Moines, IA, United States
Company
is a US IT staffing company providing technical expertise and contingent workforce solutions to clients.
What you will do
- Support critical month-end data loads, data quality initiatives, and data marts used for Credit Risk Management and regulatory reporting.
- Define data quality rules, create test plans, execute assessments, and perform data cleansing activities.
- Review data accuracy, completeness, integrity, consistency, uniqueness, and timeliness across large datasets.
- Investigate, troubleshoot, document, and resolve source-to-target and other database quality issues.
- Design and implement improvements to data load processes, database performance, indexing, security controls, installations, upgrades, and migrations.
- Lead consultations with business and technology stakeholders while mentoring less experienced database analysts and supporting moderately complex projects.
Requirements
- 5+ years of database design and administration experience.
- 5+ years of experience with Microsoft SQL Server, including relational queries, stored procedures, query optimization, and performance tuning.
- 5+ years of ETL programming experience in a data warehouse environment.
- Experience with database testing, data modeling or mapping, SQL query creation, data analysis, and root-cause investigation.
- Ability to communicate complex data issues, prioritize work under pressure, and collaborate with business partners, technology teams, and stakeholders.
- Ability to provide leadership through coaching, training, mentoring, and cross-functional collaboration.
Nice to have
- 5+ years of experience with SQL Server Integration Services (SSIS).
- Experience with Ab Initio, SAS, SSRS, Visual Basic scripting, SSIS expressions, Excel, or other data quality and reporting tools.
- Financial services, credit risk management, Agile, database troubleshooting, and QA process improvement experience.
Culture & Benefits
- Contract engagement with an IT staffing company.
- Cross-functional work with business users, technology teams, internal stakeholders, and external customers.
- Opportunity to lead database quality initiatives and mentor less experienced analysts.
Будьте осторожны: если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого - это мошенники. Обязательно жмите "Пожаловаться" или пишите в поддержку. Подробнее в гайде →