Role: Business Intelligence Engineer
Location: Bangalore
Shift timings: 3pm to 12am (2 days WFO/3 days WFH)
About the Company:
G2 Risk Solutions (G2RS) is the leader in risk and compliance business intelligence for financial institutions
and online platforms. We help our clients grow with confidence by staying ahead of complex and ever
changing regulatory requirements and risks.
We combine innovative technology data analytics and risk expertise to deliver a comprehensive suite of
solutions covering merchant risk digital commerce risk bankruptcy risk data management and regulatory
solutions. Our large valued and diverse client base spans the globe.
Merchant risk solution for payment providers to detect and monitor noncompliant merchants
before and after onboarding.
Digital commerce risk solution for platforms and marketplaces to monitor violations of policies on
content and/or advertising.
Bankruptcy risk solution for lenders and creditors identify monitor and manage bankrupt
accounts.
Data and regulatory solutions for financial institutions to aggregate and curate data manage credit
risk and make regulatory submissions.
We have a welcoming and energetic environment that encourages excellence collaboration and
innovation. This environment gives our people the opportunity to hone current skills and build new
capabilities while discovering their genius.
Job Description
The Business Intelligence Engineer role is essential for helping organizations harness the power of data to
make informed decisions optimize processes and achieve business objectives. Successful candidates will
have a strong technical skill set a deep understanding of data and the ability to collaborate effectively
across different teams.
In this role you will be responsible for designing developing and maintaining data pipelines data models
and visualizations to provide valuable insights to various business units. This position requires experience
in Python SQL Apache Airflow dbt (Data Build Tool) and Data Visualization.
Key Responsibilities
Data Pipeline Development:
Design implement and maintain data pipelines using Apache Airflow ensuring the extraction
transformation and loading (ETL) of data from various sources.
Collaborate with engineers and analysts to ensure efficient and reliable data pipelines.
Monitor and optimize data pipelines for performance and reliability.
Data Extraction and Transformation:
Utilize SQL and Python to extract data from various sources including databases APIs and
data warehouses.
Utilize dbt to transform raw data into structured clean and welldocumented datasets.
Maintain and evolve dbt models to support evolving business requirements.
Data Analysis and Modeling:
Conduct data analysis to identify trends patterns and insights that can drive business
decisions.
Develop and maintain data models that support business intelligence and reporting needs.
Report and Data Visualization:
Create interactive reports and dashboards using business intelligence tools like QuickSight
Tableau Power BI or custom Python solutions.
Ensure that stakeholders have access to actionable insights through userfriendly dashboards.
Collaboration:
Collaborate with crossfunctional teams including engineers data scientists and business
stakeholders to understand and address their data needs and priorities.
Communicate insights effectively and present datadriven recommendations to make data
driven decisions.
Data Quality Assurance and Documentation:
Implement data quality checks and validations to ensure data accuracy and consistency.
Maintain comprehensive documentation of data pipelines data models and reporting solutions.
Share knowledge and best practices with colleagues to promote a datadriven culture.
Automation and Scalability:
Identify opportunities to optimize query performance and data processing efficiency.
Ensure data solutions are scalable to accommodate growing data volumes and evolving business
needs.
Qualifications
Bachelors degree in a relevant field (e.g. Mathematics Economics Operations Finance Statis
tics Business Administration or Engineering).
5 years of Business Intelligence and/or Analytics roles.
Strong SQL skills with experience in database design data modeling and ETL processes.
Experience using PowerBI Looker QuickSight Tableau similar data visualization tools.
Scripting for automation especially Python or R.
Worked with crossfunctional teams to gather analytics requirements and translate those re
quirements into technical designs.
Knowledge of database systems data warehousing and data integration concepts.
Nice to have
Masters degree in a relevant field (e.g. Mathematics Economics Operations Finance Statis
tics Business Administration or Engineering).
Knowledge of dbt (Data Build Tool) for transforming and modeling data in a versioncontrolled
environment.
Advanced experience working with relational databases (e.g. design structure and database
management functions).
engineering,quicksight,data warehousing,data analysis,scalability,etl processes,mathematics,automation,apache airflow,business administration,data modeling,data quality assurance,business intelligence,economics,finance,operations,sql,tableau,statistics,data visualization,power bi,database design,python,data integration,dbt