Database Business Analyst

Company: JDM Systems Consultants Inc
Location: Austin
Posted on: January 17, 2020

Job Description:

Job Description: Support the delivery of curated, high quality refined data with the level of polish needed for external consumption. Major Job Duties and Responsibilities: --- Gather and translate business requirements into articulable data needs--- Track down and document sourcing of data needs for use by IT and business partners--- Transform business and technical metadata into external data product documents--- Research and communicate data related inquires to non-technical business partners and skilled IT resources as a Data SME.--- Profile and investigate structured and semi-structured datasets, reverse engineering based on business requests--- Review and sign off on development unit testing and QA test results--- Create and update internal project documents, including in-depth business metadata, UAT test plans and data integration--- Perform UAT analysis and drive standardization of UAT testing with the lens of an external consumer--- Create data quality metrics based off of UAT analysis and profiling and ensure implementation into final product.--- Determine downstream and upstream impact analysis on new changes and updates--- Ensure that data anomalies are detected and contained within thresholds--- Perform root cause analysis of data discrepancies based on data quality metrics--- Anticipate new issues and functionalities based on data quality trending.Top Skills:--- Ability to query big data and work with metadata--- 3+ Years' Experience with Json, Python, Spark, and SQL queries in Hadoop Required Skills/Experience:--- 8 years of work experience in database operations, direct marketing operations or related fields--- Advanced SQL proficiency--- Strong problem solving and analytical ability--- Strong written and verbal communication skills--- Ability to work under pressure--- Ability to work on multiple projects in various stages of development, concurrently--- High degree of personal accountability Required Education/Training:--- BA/BS in business, advertising, communications, computer science, or related quantitative or technical fieldWhat makes this position stand out? --- Very new data team and market for GM--- External data licensing--- Opportunity to create new data products and provide value to GM Interview Details:--- Phone Interview followed by video/in person meeting - provided by Dice

Keywords: JDM Systems Consultants Inc, Austin , Database Business Analyst, IT / Software / Systems , Austin, Texas