Data Warehouse Engineer
Credito Real USA Finance LLC
San Jose, San Jose, CR
hace 6 días

POSITION SUMMARY

We are one of the nation’s top automobile loan providers and we are searching for a Microsoft Database Engineer in Costa Rica.

This individual will be responsible with designing, building and maintaining our data warehouse. You will help to analyze our current capabilities while designing the next generation solution that will be core to the data architecture of our future growth.

As an experienced data warehouse engineer, you will also be responsible for working with developers and BI staff to ensure that they know how best to work with the warehouse to optimize our output.

A successful candidate will work closely with the with various team members to understand the solutions needed to enable all technology and to create a more efficient environment.

They will be very strong in Microsoft SSAS and / or Snowflake and able to help determine which solution(s) are best. They must be able to handle a fast-paced environment that is very growth oriented.

We offer competitive pay, a talented team and have plenty of fun while we work. We also love the fact that we are helping people every day build better credit and better lives! Ready to join us?

WHAT YOU’LL BE DOING

  • Provide technical leadership for strategy, architecture, design, development, testing, production launch, and ongoing support of our data warehouse.
  • Provide architectural leadership for technology solutions, data architectures, data warehouse, cloud, and infrastructure initiatives
  • Design and develop high volume data ingestion components and ETL solutions to collect data from various internal and external sources
  • Recommend data governance processes, security standards, and models that will provide architectural guidelines to support the development initiatives
  • Participate in strategic and tactical planning and design sessions and conduct whiteboard sessions with product management, BI, data engineering, architects, operations, and development team
  • Ensures data quality and controls are in place to support of various data ingestion inflows and outflows processes
  • Manage and use tools in data warehouse development and deployment such as ETL tools, data quality and cleansing tools, query / reporting tools, OLAP, data mining, etc.
  • Administer the overall data warehouse strategy, architectures and security, definition of data models, all data marts, evaluation of infrastructure components, software, performance, and data applications design
  • Drive decision-making processes to align with business priorities and objectives related to key architecture solutions
  • Responsible for developing / implementing cloud infrastructure to support current and future business needs
  • Develops the strategy and approve the systems architecture for Database and application Servers, daily Database backup & recovery, and Disaster Recovery plans.
  • Extract, Transform and Load (ETL) functions from a variety of operational systems
  • Developing and maintenance of Multi-Dimensional Data Cubes loaded from the Data Warehouse
  • Assessing the performance and capacity requirements of the data warehouse
  • Assessing and ensuring all operational aspects of the data warehouse, including availability, data integrity, data feeds, etc.
  • Provide Technical Leadership for strategy, architecture, design, development, testing, production launch, and ongoing support of HR, Finance, and Operations Global Percepta Business applications.
  • Design, develop, manage, and maintain application development standards that meet or exceed industry standards and / or client identified application development requirements.
  • Institute and manage an effective application development Systems Lifecycle methodology.

  • Make key technology decisions related to Global DWH and Enterprise Systems applications.
  • Verifying that the architecture and implementation meets all user requirements.
  • Provide 24x7 support for critical production systems.
  • Performs other related duties as assigned.
  • ESSENTIALS THAT WILL MAKE YOU SUCCESSFUL

  • Strong command of SSAS and / or Snowflake
  • Understanding of relational, star and snowflake data modeling
  • PowerShell and Unix shell scripting skills
  • Familiarity with SSAS, SSIS, SSRS
  • Strong mathematical and statistical knowledge
  • Excellent written and verbal communication skills
  • Impeccable attention to detail
  • Experience with backups, restores and recovery models.
  • Excellent written and verbal communication.
  • Flexible, team player, get-it-done personality.
  • Ability to organize and plan work independently.
  • Ability to multi-task and context-switch effectively between different activities and teams.
  • EDUCATION AND WORK EXPERIENCE REQUIREMENTS

  • Bachelor’s Degree preferred.
  • 5+ years MS SQL data warehouse engineering or similar, preferably in the auto-finance industry.
  • Pay : $42,000 - $48,000 annually.

    Location : Costa Rica / Remote / Preferable close to San Jose.

    Reportar esta oferta
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Inscribirse
    Mi Correo Electrónico
    Al hacer clic en la opción "Continuar", doy mi consentimiento para que neuvoo procese mis datos de conformidad con lo establecido en su Política de privacidad . Puedo darme de baja o retirar mi autorización en cualquier momento.
    Continuar
    Formulario de postulación