Data Engineer
We are not a bank, and we do not give loans. We do more important things, such as helping B9 members to have steady and predictable cash-flow so they can keep realizing their dreams, develop socially and thrive. As we support our customers, B9’s culture is built on supporting each team member’s efforts and recognizing their contributions. We create a workplace where people can find opportunities to thrive.
Our customers come from various backgrounds, many of them are young workers, part-time students, gig workers, and New-To-America. Same way as we at B9 we strive for diversity of thought, communication, background, experience and more.
Our product lowers barriers to access to finance for millions of hardworking Americans and newcomers each year. As we build products, we approach our engineering and design with inclusion in mind.
- Strong knowledge of SQL (T-SQL is preferable).
- Experience with Azure (Azure Service Bus, ADF, Azure Function, SQL Managed Instance).
- Good knowledge of python.
- Good knowledge of any modern RDBMS (what are indexes, views, functions, triggers, etc)
- Proficient in exploring databases and identify data elements with minimal documentation.
- Experience with ETL tool (SSIS, ADF).
- Proficient in data modelling of DWH.
- Experience and understanding of testing, coding, design, documentation and change management procedures.
- Strong work ethic with a highly positive, hands-on, can-do attitude and flexible team player.
- Ability to manage tasks independently, take ownership of responsibilities and work with minimal supervision.
- High level of integrity, takes accountability of work and good attitude over teamwork; and Takes initiative to improve the current state of things and adaptable to embrace new changes.
- Proficient in foundational data visualization concepts, ability to identify appropriate visual tools (charts) for dashboard development.
- Experience with Power BI or SQL Analysis Service (Tabular).
- Knowledge of DAX.
- Building the DWH for which all data is collected, organized, and analyzed
- Ingesting all data into this DWH
- Cleanse data ingested into DWH
- Prep data for analysis based on guidance from data modelers and data analysts/scientists
- Maintain and support these environments to ensure reliability and performance
- Perform ongoing monitoring of data pipelines and work with stakeholders to troubleshoot and performance tune.
- Create and maintain accurate and complete documentation of the DWH platform and the pipelines developed to ensure its currency.
- Maintain awareness of industry trends on regulatory compliance, emerging threats and appropriate steps to mitigate the risks; and
- Highlight any potential concerns/risks and proactively shares best risk management practices.
- Any other ad-hoc duties as assigned.
- Full-time, relocation to Mexico-City;
- Latest tech stack, high load distributed application development challenges;
- International team of experienced and talented professionals;
- Ability to become a Technical/Team leader in a fast growing team.
