• Data Engineer

    Job ID
    2019-3013
    Address
    7700 Windrose Ave.
    City
    Plano
    State
    TX
  • Overview and Responsibilities

     

    The Data Engineer will be a part of a new team dedicated to accelerating the transformation of Republic Finance credit policy development and execution capabilities. This role will be a part of a team responsible for designing of platforms, systems, and data warehouse solutions to ensure robust campaign management, decision execution, performance monitoring, and risk-related data management. This team member must be highly dynamic, strategic, bold, curious, and highly collaborative. The member must possess a broad and deep understanding of digital capabilities in the lending space, must have a strong grasp of consumer behavior and trends, and curiosity and desire to help with constructing the vision and roadmap to achieve a quantum leap in our analytic capabilities and digitization through the implementation of cutting-edge tools, technologies, enhanced data, and highly integrated systems and processes. This position reports directly to the head of risk infrastructure and will interface regularly with senior leaders from the across the organization. In addition, this individual will be a part of discussions and negotiations with external partners and cutting-edge vendors in the field of data management and analytics and machine learning. Key job responsibilities are as follows:

     

    • Define information/data flows, data delivery architecture and data tools necessary to support credit risk analytics as well as stakeholder reporting
    • Meet with business users to collect their reporting or dashboard requirements
    • Work with business and application architects to review business drivers and analyze requirements, translate user requirements into actionable implementation details
    • Design, build, and maintain an enterprise data warehouse by assisting in defining standards for naming, documenting, governing, managing, modeling, cleansing, enriching, transforming, moving, storing, searching, and delivering all data within the enterprise domain within defined timeline
    • Develop the different artifacts including technical design specs , source to target mapping, business use case scenario based testing and data quality to ensure successful data load process from several sources to an enterprise data warehouse
    • Responsible for designing, developing, testing, and troubleshooting SSIS packages that implement complex ETL processes
    • Leverage MS SQL Server experience and knowledge (2012 and later) to implement robust and maintainable solutions that meet business requirements
    • Collaborate with internal teams to understand, translate and capture the requirements for conceptual and logical data models, interface specifications to maximize the value and performance of the data assets
    • Establish source to target data mapping specs, data lineage, business data transformation across the lending operation and ensure that the data is captured, stored, accessed, and distributed accurately, consistently, and optimally
    • Help with establishing and sustaining optimal data governance framework as a key member of the governance committee
    • Create and maintain appropriate metadata for risk data architecture related artifacts including data lineage

    Qualifications

    • Strong overall experience using Microsoft BI stack (MS SQL server, SSIS,SSAS,SSRS, Power BI)
    • Expertise in business intelligence, data warehousing, data analytics and reporting with Microsoft SSRS Report Builder, Visual Studio data tool and Power BI.
    • Fundamental understanding of MS SQL Server development and administration
    • Highly proficient in T-SQL script development using stored procedures, views, user defined functions etc.
    • Strong ability to analyze data, identify data quality issues, troubleshooting report, dashboard data issue or performance issue.
    • Strong knowledge and experience in master and reference data management, data quality, and metadata management
    • Experience in creating and reviewing architecture and development materials, such as conceptual data models, logical data models and data flow diagram
    • Deep expertise in dimensional data modeling, relational DBMS data modeling
    • Expertise in relational DBMS data modeling
    • Experience with modeling tools like ERWIN, ER Studio, etc.
    • Demonstrate ability in managing simultaneous complex tasks from concept to successful completion
    • Strong communication, presentation and collaboration skills

    Preferred Skills

    • Experience in consumer lending industry with strong business understanding around loan origination, campaign management, and loss mitigation

    Benefits

    We offer a competitive compensation and benefits package including: 

    • Health/Dental/Vision
    • Paid Vacation
    • 401 (K) and employer match
    • Company provided Life Insurance & Long Term Disability

    Additional benefits with Republic include:

    • Regular drawings for sports tickets
    • Employee of the Month Program
    • Philanthropic support for charities such as Juvenile Diabetes Research Foundation and the American Cancer Society
    • Professional offices with a friendly team environment

     

    Republic Finance, LLC is an Equal Opportunity Employer and does not discriminate on the basis of race, sex, color, religion, national origin, age disability or veteran status in employment opportunities and benefits. Republic Finance, LLC maintains a Drug-Free Workplace.  

    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.