• Data Quality Engineer

    Job Locations US-MD-Bethesda
    Job ID
    2018-1695
    # of Openings
    1
    Category
    Data Architecture
    Type
    Regular Full-Time
  • OVERVIEW

     

    CSS Logo_joint venture

     

     

     

    The Company

     

    Common Securitization Solutions (CSS) is seeking an experienced Data Quality Engineer to join our team of talented professionals in Bethesda, Maryland.

     

    How many times in your career do you get the opportunity to do something that’s never been done? To create something that will change an entire industry? CSS is building the Common Securitization Platform to issue and manage mortgage securities. We’re looking for people who can walk in two worlds – a start-up environment where development is collaborative and rapid; and a production environment where we run and monitor the performance of the platform. Longer-term, this platform could serve the entire US housing finance industry. Sound transformative? It is. Come join us and help create something remarkable.

    RESPONSIBILITIES

     

    Job Information

    As a Data Quality Engineer you are responsible for building/analyzing/maintaining automation frameworks for CSS Data projects, working closely with engineering and product teams for our production platform. You will use your engineering acumen and passion for quality to drive results for and with our teams bringing cutting-edge mortgage securities platform. This is not a typical GUI automation kind of role, you must have worked and built automation frameworks on Big data / high volume data pipelines

    / ETL projects.

     

    An ideal candidate will be someone with sound technical background in data domain – storage / QA processing / analytics, has solid business acumen and a strong automation / solution oriented thought process. Will be a self-starter who can work with the business process team and work backwards to conceive & devise the highest Quality Data solutions. Is a great communicator and at ease on partnering with business owners and other internal / external teams. Having strong skills in interpreting data and providing powerful, simple visualizations is important so our business leaders can make quick, but well-informed decisions. Can explore newer technology options, if need be, and has a high sense of ownership over every deliverable by the team. Is constantly obsessed with customer delight & business impact / end result and ‘gets it done’ in business time.

     


    Key Job Functions

     

    • Defining quality checks and evaluating SQL, stored procedures, process,  testing and developing automation for high volume data pipelines, ETL transformations, and other data integration workflows across multiple sources while applying best practices in data integrity, data quality, and distributed data processing.

    • Designing and developing testing infrastructure and executing automation scripts on a scheduled basis for production Data Platforms with understanding of Oracle and Big Data programming models.

    • Perform both manual testing, and implementing test automation frameworks (especially for data pipeline projects).

    • Research related products and make necessary software recommendations & implement innovative solutions

    • Perform load testing utilizing JMeter scripts.

    • Testing / automating REST API services.

    • Report and document QA activities and project status to Engineering and Product Management on a weekly basis.

    • Write test plans, test cases, status reports and summary reports.

    • Participate in daily scrum and bi-weekly sprint planning meetings.

    • Assisting QA functions for the engineering team, providing guidance, support, and direction for the growing QA team.

    • Automating IT Data QC tasks, Data validation batch job scheduling, and job orchestration.


    QUALIFICATIONS

     

    Education   

    • Bachelor's degree in Computer Science, Math or a related technical field.

     

    Minimum Experience  

     

    • Minimum of 5 years of developing end-to-end Business Intelligence solutions: data modeling, ETL and reporting.

    • Must have at least 5 years of programming and automation experience including REST API services. Developing automation tools and scripting languages such as Java, Javascript/NodeJS, Python, Perl, Ruby and Bash.

    • Applicants must be authorized to work in the US without requiring employer sponsorship currently or in the future. CSS does not offer H-1B sponsorship for this position.

     

    Specialized Knowledge & Skills     

      

    • Proven analytical and quantitative ability and a passion for enabling customers to use data and metrics to back up assumptions, develop business cases, and complete root cause analyses.

    • Capability to work in a rapidly changing business environment and to enable simplified user access to massive data by building scalable data solutions

    • Strong verbal and written communication skills, including an ability to effectively lead and influence interactions with both business and technical teams.

    • Advanced SQL writing and expertise in data warehousing (SQL, ETL, Data Modeling, etc.) and using databases such as Oracle, MYSQL, Postgres, Cassandra, MongoDB, Hive etc.. in a business environment with complex datasets.

    • Knowledge of Hadoop, Kafka, Spark and other big data.

    • Excellent analytical and problem solving skills

    • Experience in leading team of QA Engineers  in a data environment

    • Experience with continuous integration tools such as Jenkins, CircleCI etc.

    • Ability to work independently and a part of a team - Team attitude and ability to multi-task

    • Extensive experience in data validation and statistical data quality analysis and reporting.

    • Experience using data profiling / quality tools with the ability to access databases with SQL or other methods to assess the effectiveness of data quality controls and identify improvement opportunities.

    • Experience in the definition, monitoring, and maintenance of data quality and metadata processes, rules, thresholds, and standard metrics/quality-expectations for data elements that support critical business processes.

    • Understand conceptual data and business process modeling and data life cycle / state transition concepts.

    • Experience in validating ETL processes.

    • Experience developing and conducting training.

    • Utilize QA automation tools such as Selenium, SoapUI.

    • Knowledge of database tuning and what effects performance

    • AWS services experience and cloud based automated testing

    • Utilize hosted load testing services such as BlazeMeter and FloodIO to distributing the load geographically.

    • Experience with continuous integration tools such as Jenkins, CircleCI etc.

     

    Employment

    As a condition of employment with Common Securitization Solutions, any successful job applicant will be required to pass a pre-employment drug screen and to successfully complete a background investigation, which may also include a credit check for positions in some areas of our business.   

         

    Common Securitization Solutions is an Equal Opportunity Employer.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Need help finding the right job?

    We can recommend jobs specifically for you! Click here to get started.