G2 Risk Solutions- Business Intelligence Engineer

ConsultBae

  • Bangalore, Karnataka
  • Permanent
  • Full-time
  • 1 month ago
Company DescriptionG2 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 non-compliant 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.Website: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 theability 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.This position requires work on the second shift (3pm-12am IST).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 well-documented 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 Apache Superset, Amazon QuickSight, Tableau, Power BI, or custom Python solutions.
  • Ensure that stakeholders have access to actionable insights through user-friendly dashboards.
Collaboration:
  • Collaborate with cross-functional teams, including engineers, data scientists, and business stakeholders, to understand and address their data needs and priorities.
  • Communicate insights effectively and present data-driven 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 data-driven 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.
Required Qualifications:
  • Strong proficiency in SQL for data extraction, transformation, and analysis.
  • Proficiency in Python for data processing, scripting, and automation.
  • Experience with Apache Airflow for building and managing ETL workflows.
  • Knowledge of dbt (Data Build Tool) for transforming and modeling data in a version- controlled environment.
  • Familiarity with Amazon QuickSight or similar data visualization tools.
  • Strong problem-solving and critical-thinking skills.
  • Excellent communication and collaboration skills.
  • Attention to detail and a strong commitment to data quality.
  • Knowledge of database systems, data warehousing, and data integration concepts.
Preferred Qualifications:
  • Bachelor's degree in a relevant field (e.g., Computer Science, Data Science, Business, or Engineering).
  • Relevant certifications in data engineering, business intelligence, or related fields.
  • Experience with cloud platforms (e.g., AWS, Azure, GCP).
  • Knowledge of advanced

ConsultBae