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.