Senior BI Developer

Role Overview

• The Sr BI Developer is responsible for designing, developing, and delivering scalable business intelligence and analytics solutions that support data-driven decision-making across services and operational domains.
• Engage with business stakeholders to elicit, analyze, and document detailed business and reporting requirements.
• Facilitate workshops to define KPIs, standardized metric logic, and data definitions.
• Develop functional specifications, source-to-target mappings, and technical design documentation.
• Ensure traceability from requirements through development, testing, and deployment.
• Design and develop enterprise dashboards and reports using Power BI (PBI) including advanced DAX, optimized data models, and performance tuning.
• Build and maintain SSAS tabular models and semantic layers to support enterprise analytics.
• Develop and optimize complex SQL queries within Amazon Redshift environments.
• Perform dashboard performance optimization, query tuning, and model refinement.
• Support UAT, deployment, and post-production stabilization activities.
• Design and develop scalable data transformation workflows using the Databricks Lakehouse platform (Spark, PySpark, SQL, Delta Lake).
• Build and maintain ETL/ELT pipelines within Databricks to support BI and advanced analytics workloads.
• Implement and manage Delta Lake architecture, including partitioning strategies, performance optimization, and data version control.
• Integrate Databricks pipelines with Amazon Redshift and AWS services (S3, Glue, IAM, Lambda).
• Support ingestion of structured and semi-structured data from ERP, CRM, and service systems into curated analytical layers.
• Perform pipeline monitoring, troubleshooting, and optimization to ensure reliability and scalability.
• Contribute to advanced analytics initiatives including predictive metrics, anomaly detection, and automation use cases.
• Support integration of AI/ML models and Generative AI (GenAI)-enabled reporting capabilities into BI solutions.
• Explore opportunities for AI-assisted insights, natural language querying, and intelligent automation within dashboards.
• Work closely with BI Leads, product owners, and data engineers to deliver prioritized solutions.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, Business Analytics, or related field required.
• 8+ years of experience combining Business Analysis, BI development, and data engineering.
• Experience supporting service operations or commercial analytics domains preferred.
• Strong requirement elicitation, documentation, and stakeholder engagement skills.
• Experience preparing functional and technical design artifacts.
• Exposure to ERP (SAP), CRM (SFDC), or service management systems.
• Experience in service domain analytics.
• Advanced expertise in Power BI (DAX, Power Query, enterprise modeling, performance optimization).
• Strong hands-on experience with SSAS tabular modeling and cube development.
• Proficiency in SQL with demonstrated experience in Amazon Redshift.
• Strong hands-on experience with Databricks (Spark, PySpark, Delta Lake, Workflows).
• Experience designing ETL/ELT pipelines within a Lakehouse architecture.
• Working knowledge of the AWS ecosystem (S3, Redshift, Glue, IAM).
• Strong understanding of data warehousing concepts, dimensional modeling, and pipeline optimization.
• Exposure to AI/ML fundamentals and predictive analytics concepts.
• Familiarity with Generative AI (GenAI), LLM-based analytics use cases, or AI-assisted reporting frameworks.
• Experience working in Agile/Scrum delivery environments.
• AWS, Databricks, Power BI, or AI/ML-related certifications.

Tech Stack

• Amazon Redshift
• AWS
• ERP
• ETL
• PySpark
• SFDC
• Spark
• SQL

Benefits

• Health insurance
• 401(k) matching
• Flexible work hours
• Paid time off
• Remote work options