Back to jobs

Database Analyst/SQL DBA

Pay
Pay not listedSimilar roles state $90K–$150K
Work setting
On-site — work setting source
Work setup in the employer’s posting: On-site
From the employer’s posting
Employment
Contract — employment source
Employment type in the employer’s posting: Contract
From the employer’s posting

What you’ll bring

All qualifications

Core experience

  • Data modeling and/or mapping, mapping analysis.
  • Ability and knowledge for effectively interacting with data users, managers and other stakeholders
  • 5+ years database design and administration experience
  • 5+ years of working with SQL Server Integration Services (SSIS) experience
  • Experience with Visual Basic script, SSIS expressions.
  • Ability to identify and describe the complex data issues between technology and business partners
Qualification wording
Data modeling and/or mapping, mapping analysis.
Ability and knowledge for effectively interacting with data users, managers and other stakeholders
5+ years database design and administration experience
5+ years of working with SQL Server Integration Services (SSIS) experience
Experience with Visual Basic script, SSIS expressions.
Ability to identify and describe the complex data issues between technology and business partners

Posting record

Report an error

Actively hiringFirst seen by us today, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 19, 2026today
Recorded sightings
1
Employer says posted
Jun 22, 2017

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$89.8K–$150K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 22,960 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 0

Early. Similar jobs usually come down between day 9 and day 59.

From 40,482 similar postings that came down. Coming down is not always a hire.

Artech Information System is hiring

55 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SAS
  • SQL
  • Ab Initio
  • Excel
  • SQL Server
  • SSIS
  • SSRS
Where the posting names them
- Knowledge of QA practices, Data Quality process improvements - Knowledge of research methods, data analysis using SAS or other data quality tools - Knowledge and understanding of Agile
- Experience with Visual Basic script, SSIS expressions. - Strong working knowledge and ability to use SAS, Excel, Microsoft office products and other tools to support report generation and on-going maintenance. Additional Information
- Conceptual, logical, and/or physical database design - Perform and create SQL queries to identify data issues. - Data modeling and/or mapping, mapping analysis.
- Data modeling and/or mapping, mapping analysis. - Moderate to complex programming and coding to automate and/or support the database environment, SQL query creation and testing. - Analyze, query and manipulate data according to defined business rules and procedures
- Ensure adherence to data quality standards, Identify areas of improvement - Planning, testing, configuration and execution of installations, upgrades and migrations, SQL queries associated with key data issues found by customers. - Implementing security controls
- 5+ years database design and administration experience - 5+ years of experience writing Microsoft SQL Server relational database queries, stored procedures ,query optimization and performance tuning - 5+ years MS SQL server experience
- 5+ years of experience writing Microsoft SQL Server relational database queries, stored procedures ,query optimization and performance tuning - 5+ years MS SQL server experience - 5+ years of ETL (Extract, Transform, Load) Programming experience RQO0005045
Desired Qualification: - 5+ years of working with SQL Server Integration Services (SSIS) experience - 5+ years of Knowledge of Ab Initio experience ETL and Data Quality tool
- Knowledge and understanding of database troubleshooting - Knowledge and understanding of SQL Server Reporting Services (SSRS) - Knowledge and understanding of credit risk management
- 5+ years of working with SQL Server Integration Services (SSIS) experience - 5+ years of Knowledge of Ab Initio experience ETL and Data Quality tool - 3+ years of financial services industry experience
Additional Desired - Experience with Visual Basic script, SSIS expressions. - Strong working knowledge and ability to use SAS, Excel, Microsoft office products and other tools to support report generation and on-going maintenance.

Your next step

Complete your application on jobs.smartrecruiters.com. The employer’s form will show what is required.

Applying through SmartRecruiters

  • Uploading your resume fills in the application form for you, so check what it filled before you send.

Already applied? Track this application

Job description

View original posting ↗

Job Description

Description:

  • This position is within our Enterprise Data & Analytics/Credit Risk Management Production Support Data Quality and Metrics team and provides support of critical month-end data loads data quality initiatives that support to the data mart, which is used by the Credit Risk Management business unit for CAR, CCAR (Comprehensive Capital Analysis Review) and BASEL regulatory reporting, as well as other business critical reporting needs.
  • This position will play a senior lead role ensuring proper implementation of data quality during the creation and modification of data, according to data quality standards, guidelines, metrics and quality-expectations.
  • Defines rules to evaluate data quality and creates effective test plans.
  • Ensures accuracy, completeness, integrity, consistency, uniqueness and timeliness of data.
  • Executes Data Quality and Metrics team tests/assessments and data cleansing activities.
  • Serves as a liaison between the business and internal clients in managing the data loads for one or many portfolios, including execution of data load steps and active troubleshooting as needed to keep data loads on-schedule.
  • Leads proposal, design and implementation of data load process improvements to reduce speed to market and improve data quality for our customers.

Qualifications

Responsibilities include but are not limited to the following tasks:

  • Reviews data loaded into the data mart for accuracy
  • Recommends maintenance enhancements and data quality metric requirements for data processes to improve the accuracy of the data mart data
  • Reviews referential integrity and historical integrity of data mart data
  • Assist in determining root cause of data quality issues and recommending short term and long term solutions
  • Perform in depth testing and validation of key data quality issues identified by business partners and other users of the data mart
  • Investigate, troubleshoot and document source-to-target and other data issues from internal and external customers
  • Resolves data quality problems
  • Leads planning, analysis, design, implementation, and maintenance of process to support and improve the CLRTY database platform.
  • Leads consultation with and provides guidance to database users and client groups, often recommending tactical and strategic solutions.
  • Actively communicate data quality issues with multiple internal and external customers
  • Performs complex server-class database testing activities across various platforms and environments including one or more of the following:
  • Business requirement identification and analysis.
  • Conceptual, logical, and/or physical database design
  • Perform and create SQL queries to identify data issues.
  • Data modeling and/or mapping, mapping analysis.
  • Moderate to complex programming and coding to automate and/or support the database environment, SQL query creation and testing.
  • Analyze, query and manipulate data according to defined business rules and procedures
  • Performance monitoring and tuning.
  • Evaluate large datasets for quality and accuracy
  • Work with programmers to correct data quality errors
  • Determine root cause for data quality errors and make recommendations for long-term solutions
  • Research and determine scope and complexity of issue so as to identify steps to fix issue
  • Analyzing database data quality metrics and assisting with capacity planning data quality dashboard output and review.
  • Ensure adherence to data quality standards, Identify areas of improvement
  • Planning, testing, configuration and execution of installations, upgrades and migrations, SQL queries associated with key data issues found by customers.
  • Implementing security controls
  • Implementing an indexing strategy to support both effective data loads, and well as user extraction of data.
  • Leads mentors and/or provides guidance to less experienced database analysts, including guidance for troubleshooting escalated issues.
  • Participate in the development of data/database architectures and management policies, procedures and standards.
  • May lead moderately complex projects.

The selected candidate should demonstrate the following competencies:

  • Ability and knowledge for effectively interacting with data users, managers and other stakeholders
  • Ability to identify and describe the complex data issues between technology and business partners
  • Ability to prioritize work, meet deadlines, achieve goals, and work under pressure in a dynamic and complex environment
  • Ability to provide leadership by coaching, training, and mentoring
  • Ability to identify business needs and deliver solutions in close partnership with line of business and technology
  • Ability to influence across all organizational levels, particularly senior management
  • Ability to actively lead oneself and implement ideas in a cross-functional team environment.

Required Qualification:

  • 5+ years database design and administration experience
  • 5+ years of experience writing Microsoft SQL Server relational database queries, stored procedures ,query optimization and performance tuning
  • 5+ years MS SQL server experience
  • 5+ years of ETL (Extract, Transform, Load) Programming experience RQO0005045
  • 5+ years of working with and/or writing ETL (Extract, Transform,Load) in a data warehouse environment

Desired Qualification:

  • 5+ years of working with SQL Server Integration Services (SSIS) experience
  • 5+ years of Knowledge of Ab Initio experience ETL and Data Quality tool
  • 3+ years of financial services industry experience
  • Knowledge of QA practices, Data Quality process improvements
  • Knowledge of research methods, data analysis using SAS or other data quality tools
  • Knowledge and understanding of Agile
  • Knowledge and understanding of database troubleshooting
  • Knowledge and understanding of SQL Server Reporting Services (SSRS)
  • Knowledge and understanding of credit risk management
  • Strong analytical skills with high attention to detail and accuracy
  • Excellent verbal, written, and interpersonal skills

Additional Desired

  • Experience with Visual Basic script, SSIS expressions.
  • Strong working knowledge and ability to use SAS, Excel, Microsoft office products and other tools to support report generation and on-going maintenance.

Additional Information

For more information, please contact

Meher Prerana
973.507.7510

Company Description

Artech is the 10th Largest IT Staffing Company in the US, according to Staffing Industry Analysts' 2012 annual report. Artech provides technical expertise to fill gaps in clients' immediate skill-sets availability, deliver emerging technology skill-sets, refresh existing skill base, allow for flexibility in project planning and execution phases, and provide budgeting/financial flexibility by offering contingent labor as a variable cost.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Des Moines, IA, United States

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.