Business Intelligence Data Engineer

We are seeking a highly skilled Data Engineer to join our Business Intelligence (BI) team in India. This role is foundational to our data strategy and serves as a dedicated resource for our Finance and cross-functional teams. You will be responsible for designing, building, and optimizing a high-velocity AWS data ecosystem that bridges the gap between raw business data and actionable intelligence.

The ideal candidate is a technical expert in data movement and modeling, passionate about building robust, scalable infrastructure that transforms raw financial data into reliable, AI-ready assets. This role is designed to provide the business with the agility it needs to move fast while maintaining high standards for data integrity, security, and enterprise alignment.

Job Responsibilities:
• Architect and Build Pipelines: Design, develop, and maintain automated ETL/ELT pipelines to ingest data from diverse sources (ERP, CRM, Billing systems).

• Data Modeling: Design and implement scalable data models (Star Schema, Data Vault, or OBT) that support complex financial reporting, ensuring high performance and data integrity.

• Workflow Orchestration: Lead the transition from legacy manual processes to robust, automated pipelines. Use Python and AWS native orchestration to engineer scalable infrastructure that powers high-availability data products.

• Optimization & Scaling: Continuously improve data ingestion throughput query performance to handle increasing volumes of Financial, Sales, and Marketing data.

• Data Governance & Quality: Implement custom Python-based validation frameworks and CloudWatch monitoring to ensure gold-standard accuracy for financial metrics like ARR, NRR, and Churn.

• Cross-Functional Collaboration: Partner with BI Analysts and functional teams to translate business requirements into technical data specifications and architectural designs.

• DevOps Integration: Maintain and promote code quality through version control (Git), CI/CD pipelines, and rigorous documentation of the data lineage.

• Semantic Layer: Institutionalize KPI definitions and metric governance by building a unified semantic layer; ensure data consistency across Finance and GTM systems to eliminate reporting silos and maintain a single source of truth.

• Security & Compliance: Ensure all financial data pipelines adhere to strict security standards, encryption, and access control policies.

Job Qualification:
• 4+ years of experience in data engineering, backend development, or data architecture.

• Proven track record of building and scaling production-grade data pipelines.

• Experience working cross-functionally to support strategic initiatives.

• Bachelor’s degree in computer science, software engineering, or a related technical field. Master’s degree in a technical discipline preferred.

Technical Skills

• Advanced SQL: Expert-level ability to write complex, performant queries and stored procedures.

• Programming: Strong proficiency in Python for data engineering and API integrations.

• AWS Mastery: Strong hands-on experience building and scaling production-grade pipelines using the AWS stack (S3, Glue, Redshift, Lambda, or Athena).

• Data Architecture: Mastery of data warehousing concepts, dimensional modeling, and Lakehouse architecture.

• Data Pipeline Automation: Proven experience designing and managing complex task dependencies and distributed workflows. Proficiency in using industry-standard orchestration engines to ensure resilient, scalable, and observable data movement.

• BI Support: Expertise in developing robust backend data models to support enterprise reporting. Proficiency in optimizing analytical query performance, managing tabular schemas, and establishing unified metric definitions to ensure data consistency across visualization tools.

• DevOps: Solid experience with Git and an understanding of CI/CD practices for data deployments

About Model N
Model N is the leader in revenue optimization and compliance for pharmaceutical, medtech and high-tech innovators. For more than 25 years, we have helped customers maximize revenue, streamline operations, and maintain compliance through cloud-based software, value-add services, and data-driven insights. With a focus on innovation and customer success, Model N empowers life sciences and high-tech manufacturers to bring life-changing products to the world more efficiently and profitably. Model N is trusted by over 150 of the world’s leading companies across more than 120 countries. For more information, visit www.modeln.com.