Sr. Data Engineer

Kunai is a fast-growing digital consultancy focused on banking, payments, and fintech powered by a global network that attracts the best and brightest people from all backgrounds and cultures, driven by innovation and experimentation, spread across almost every single continent. Over the past decade, we've shipped over 150 products for clients that include Visa, American Express, Capital One, WEX, Wells Fargo, Ernst & Young, and TOMS Shoes. Our founders built a previous agency (Monsoon) that was acquired by Capital One in 2015.

As a Sr. Data Engineer, you will plan data integration processes by developing common definitions of sourced data. This will include:

• Designing common keys in physical data structure
• Establishing data integration specifications
• Examining data applications, data models and data warehouse schema
• Determining best-fit data interchange methods
• Assessing middleware tools for data integration, transformation, and routing
• Developing project scope and specifications and identifying factors that negatively impact integration
• Forecasting resource requirements and establishing delivery timetables
• Analyzing various data stores and database tables to establish knowledge of data for accurate retrieval and use. This will include the implementation of stored procedures and effectively querying data sources. 

Additional responsibilities will include:

• Validating data integration by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware.
• Utilizing available tools such as SQL, Power BI, Cognos, and Excel to provide technical reports for various requestors.
• Presenting data in a way that is most meaningful and readily accessible to the requestor using a combination of application solutions and system reports.
• Demonstrating outstanding communication skills to translate reporting requests in order to accurately meet the actual information and deadline needs of users.
• Educating requestors on appropriate and desirable parameters to ensure they get the information they need.
• Collaborating with end users to gather requirements and ensuring proper testing and validation.
• Providing support to end users on standardized and ad hoc reports.
• Working closely with IT to ensure security enforcement when deploying reports.
• Programming custom solution tools as needed in an object oriented language of choice, along with documentation and training for those who will support the tools.

 

Required skills include:        

• Bachelor’s degree with 7-10 years of relevant working experience in the data engineering space.
• Training and direct experience in data engineering using tools such as Azure Data Factory, MS SQL, Azure Synapse, SSIS, SSRS, SQL Query Analyzer, Power BI, Cognos, and Excel.   
• Experience designing and building complete ETL processes moving and transforming data for operational use.
• Extensive working experience with MS SQL database and writing SQL and T-SQL queries and stored procedures 
• Experience with noSQL databases like Cosmo and MongoDB a plus.
• Working experience with Azure environment a must, experience with other Azure tools like Logic Apps, Functions Apps, Power Automate/Apps, Azure Storage, App Services, a big plus
• Working knowledge of database architecture and design, data warehouse, data extraction, data modeling, and analysis.
• Communicate effectively verbally and in writing to technical and non-technical users.   
• Able to handle detail-oriented work while meeting schedules and deadlines. 
• Ad-hoc reporting, Requirements analysis, Database management, Business Intelligence Tools, data modeling. 

 

At Kunai, we have built deep relationships with our clients. Our bar is high, and our mission is to always exceed our client’s expectations. If you are fanatical about customer success and driven to work on and solve tough technical challenges, we would love to chat with you!