BI Data Engineer

Summary/Objective

Interview Process:

1st Round: 30 minute video panel interview

2nd Round: 1.5 hour onsite interview

This is an existing vacancy.

Essential Functions/ Responsibilities

As a BI Data Engineer, you will play a pivotal role in empowering cross-functional teams to make informed, data-driven decisions. Collaborating closely with Finance, Account Management, and Sales, you'll enable these teams to access high-quality insights and generate accurate reports. Your responsibilities will include:

• Driving Impact
  : Using your strong communication skills to convey analytical results in a way that inspires action and drives meaningful business change.
• Championing Data Excellence
  : Advocating for data as a first-class citizen by ensuring data quality, reliability, and usability across the organization.
• Collaboration and Peer Review
  : Providing constructive peer reviews and fostering a culture of continuous improvement in data deliverables.
• Educating Stakeholders
  : Helping teams understand and leverage data effectively through hands-on training sessions and creating thorough, user-friendly documentation.
• Proactive Problem-Solving
  : Independently identifying and proposing impactful data projects instead of solely responding to stakeholder requests.
• Staying Ahead of the Curve
  : Keeping abreast of advancements in the data and analytics community, evaluating new tools and methodologies, and integrating them into your workflow when appropriate.

Education and Experience

• BS/MS in Computer Science, or equivalent.
• Experience with cloud-based data warehousing, transformation, and ETL tools, such as Snowflake and DBT:
• Snowflake
  :
• Develop, manage, and optimize Snowflake data pipelines to ensure reliable data ingestion and transformation processes.
• Design and maintain Snowflake schemas, tables, and views with a focus on performance optimization and storage efficiency.
• Implement Snowflake features such as data sharing, secure views, and time travel to support business requirements.

• Monitor and troubleshoot performance issues within Snowflake, leveraging techniques like clustering, query tuning, and workload management.

• DBT
  :

• Build and maintain modular, well-structured dbt models that align with industry best practices and internal standards.
• Develop robust testing frameworks using dbt to ensure the accuracy and reliability of data transformations.
• Create reusable macros and custom packages to improve efficiency and standardization across dbt projects.
• Maintain version control for dbt projects, managing changes systematically with tools like Git.
• Understanding of time series and relational databases (Oracle, Snowflake, InfluxDB).
• Oracle, MongoDB (or noSQL generally)
  : Be able to read and understand Oracle PL/SQL procedures and functions. Analyze unstructured and semi-structured data from NoSQL databases.
• Tableau Dashboards
  : Design and deliver user-friendly dashboards and visualizations in Tableau, ensuring they align with stakeholder needs and provide actionable insights.
• Data Governance
  : Implement and uphold best practices in data quality, security, and governance across all platforms.

EEO Statement

Paymentus is an equal opportunity employer. We enthusiastically accept our responsibility to make employment decisions without regard to race, religious creed, color, age, sex, sexual orientation, national origin, ancestry, citizenship status, religion, marital status, disability, military service or veteran status, genetic information, medical condition including medical characteristics, or any other classification protected by applicable federal, state, and local laws and ordinances. Our management is dedicated to ensuring the fulfillment of this policy with respect to hiring, placement, promotion, transfer, demotion, layoff, termination, recruitment advertising, pay, and other forms of compensation, training, and general treatment during employment.

Reasonable Accommodation

Paymentus recognizes and supports its obligation to endeavor to accommodate job applicants and employees with known physical or mental disabilities who are able to perform the essential functions of the position, with or without reasonable accommodation. Paymentus will endeavor to provide reasonable accommodations to otherwise qualified job applicants and employees with known physical or mental disabilities, unless doing so would impose an undue hardship on the Company or pose a direct threat of substantial harm to the employee or others. An applicant or employee who believes he or she needs a reasonable accommodation of a disability should discuss the need for possible accommodation with the Human Resources Department, or his or her direct supervisor.