Talent.com
Database Analyst/SQL DBA
Database Analyst/SQL DBAArtech Information System LLC • Des Moines, IA, US
serp_jobs.error_messages.no_longer_accepting
Database Analyst / SQL DBA

Database Analyst / SQL DBA

Artech Information System LLC • Des Moines, IA, US
job_description.job_card.variable_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.job_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.

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.
  • 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.
  • 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.
  • J-18808-Ljbffr

    serp_jobs.job_alerts.create_a_job

    Dba • Des Moines, IA, US

    Job_description.internal_linking.related_jobs
    Oracle Database Administrator

    Oracle Database Administrator

    VirtualVocations • Des Moines, Iowa, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Oracle Database Administrator.Key Responsibilities Administer, monitor, and maintain Oracle databases (11g / 12c / 19c) Plan and execute end-to-end migration of Ora...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Oracle Certified Data Architect

    Oracle Certified Data Architect

    VirtualVocations • Des Moines, Iowa, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Architect to support a long-term government contract.Key Responsibilities Lead a team of data analysts and database administrators Design and construct database a...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_hours • serp_jobs.job_card.promoted • serp_jobs.job_card.new
    Database-as-a-Service Engineer

    Database-as-a-Service Engineer

    VirtualVocations • Des Moines, Iowa, United States
    serp_jobs.job_card.full_time
    A company is looking for a Database-as-a-Service (DBaaS) Engineer responsible for building and maintaining Microsoft SQL Server clusters and infrastructure. Key Responsibilities Design, build, and...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_hours • serp_jobs.job_card.promoted • serp_jobs.job_card.new
    Data Analyst III

    Data Analyst III

    VirtualVocations • Des Moines, Iowa, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Analyst III in Healthcare Analytics.Key Responsibilities Analyze and interpret data from various sources to assess business impacts and trends Develop and maintai...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Junior Database Administrator

    Junior Database Administrator

    VirtualVocations • Des Moines, Iowa, United States
    serp_jobs.job_card.full_time
    A company is looking for a Junior Database Administrator / Oracle-Azure.Key Responsibilities Provide basic escalation support for AmeriCorps applications utilizing Oracle databases Perform low to ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    CDP Database Analyst

    CDP Database Analyst

    Robert Half • Des Moines, IA, US
    serp_jobs.job_card.full_time
    Position : SENIOR CDP DATA ANALYST - Help Build a Smarter Connected Digital Experience.Salary : UP TO $140K + EXCEPTIONAL BENEFITS. For immediate and confidential consideration, please send a message ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_1_day • serp_jobs.job_card.promoted
    SQL Database Administrator

    SQL Database Administrator

    VirtualVocations • Des Moines, Iowa, United States
    serp_jobs.job_card.full_time
    A company is looking for a SQL Database Administrator to join their IT Infrastructure team.Key Responsibilities Support a large-scale SQL Server environment with over 1000 databases and 60 SQL Se...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Data Analyst / SQL Developer

    Data Analyst / SQL Developer

    VirtualVocations • Des Moines, Iowa, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Analyst / SQL Developer.Key Responsibilities Analyze and develop complex SQL for data warehouse reporting and analytics Document requirements for new business proce...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_hours • serp_jobs.job_card.promoted • serp_jobs.job_card.new
    Lead Database Administrator

    Lead Database Administrator

    defi AUTO LLC • Des Moines, IA, US
    serp_jobs.job_card.full_time
    It’s an exciting time to join defi!.SOLUTIONS is a pioneer in end-to-end, SaaS loan originations, servicing, and managed servicing solutions. Our customers include the highest-volume captive a...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Business Analyst - Data

    Business Analyst - Data

    VirtualVocations • Des Moines, Iowa, United States
    serp_jobs.job_card.full_time
    A company is looking for a Business Analyst - Data to join their team.Key Responsibilities Lead and deliver data initiatives that drive business value through effective project planning and manag...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Senior Database Administrator

    Senior Database Administrator

    VirtualVocations • Des Moines, Iowa, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Database Administrator (DBA) to lead the design, optimization, and sustainment of secure enterprise databases. Key Responsibilities Design, configure, and maintai...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Database Administrator for PostgreSQL

    Database Administrator for PostgreSQL

    VirtualVocations • Des Moines, Iowa, United States
    serp_jobs.job_card.full_time
    A company is looking for a Database Administrator for PostgreSQL.Key Responsibilities Administer, configure, and maintain PostgreSQL databases ensuring high availability and security Monitor and...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_hours • serp_jobs.job_card.promoted • serp_jobs.job_card.new
    California Licensed EPIC Analyst

    California Licensed EPIC Analyst

    VirtualVocations • Des Moines, Iowa, United States
    serp_jobs.job_card.full_time
    A company is looking for a California Licensed EPIC Reporting Analyst.Key Responsibilities Analyzes and provides guidance in support of hospital integration initiatives Develops and tests high-a...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_hours • serp_jobs.job_card.promoted • serp_jobs.job_card.new
    Application Data Analyst

    Application Data Analyst

    VirtualVocations • Des Moines, Iowa, United States
    serp_jobs.job_card.full_time
    A company is looking for an Application Data Analyst to join their Data Governance and Insights team.Key Responsibilities Collaborate with business data owners to implement data governance polici...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Clinical Informatics Analyst (BI Engineer / SQL Programming) - REMOTE

    Clinical Informatics Analyst (BI Engineer / SQL Programming) - REMOTE

    Molina Healthcare • Ankeny, Iowa, US
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time
    Read on to find out what you will need to succeed in this position, including skills, qualifications, and experience.Reporting to the Director of Clinical Informatics for Analytics & Interfaces...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Microsoft SQL Server Administrator

    Microsoft SQL Server Administrator

    VirtualVocations • Des Moines, Iowa, United States
    serp_jobs.job_card.full_time
    A company is looking for a Microsoft SQL Server Database Administrator.Key Responsibilities Implement and administer database and data warehouse architecture Analyze data architectures and backe...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_1_day • serp_jobs.job_card.promoted
    Business Data Analyst

    Business Data Analyst

    VirtualVocations • Des Moines, Iowa, United States
    serp_jobs.job_card.full_time
    A company is looking for a BI Reporting Analyst IV to conduct comprehensive business analysis and develop actionable insights. Key Responsibilities Perform business analysis using statistical meth...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Database Administrator

    Database Administrator

    Robert Half • Des Moines, IA, US
    serp_jobs.job_card.full_time
    Position : SENIOR DATABASE ADMINISTRATOR - Power the data behind a Mobile-First Transformation.Salary : UPTO $148K + EXCEPTIONAL BENEFITS. For immediate and confidential consideration, please send a m...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Oracle / SQL ETL Developer - Managed care

    Oracle / SQL ETL Developer - Managed care

    HSK Technologies Inc • Des Moines, IA, US
    serp_jobs.job_card.full_time
    Note : Only submit candidates with legitimate experience writing Stored Procedures, Views, and T-SQL within an Oracle platform. I understand that this one is a challenge.Oracle / SQL ETL Developer - Ma...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Senior Business Data Analyst

    Senior Business Data Analyst

    VirtualVocations • Des Moines, Iowa, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Business Data Analyst - Remote.Key Responsibilities Define, gather, and review data requirements for health insurer's databases Conduct data profiling and analy...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted