Lead SQL & BI Developer

Lead SQL & BI DeveloperWe are seeking an Onshore Lead Data Developer and BI Expert to serve as the critical bridge between our enterprise customers and our offshore technical development teams. While this role requires deep technical expertise in backend SQL engineering and sophisticated Power BI architecture, it is fundamentally a client-facing position. You will act as a strategic advisor, responsible for leading discovery workshops, driving business requirements, managing executive stakeholder expectations, and translating complex business needs into high-performance, actionable BI solutions.Key ResponsibilitiesStakeholder Management & Advisory: Act as the primary technical liaison for C-suite and executive stakeholders. Lead discovery workshops to capture business requirements and align technical solutions with the customer's long-term business goals and ROI.Expectation Management: Translate high-level business needs into scalable technical roadmaps. Proactively manage client expectations regarding feasibility, scope, and project timelines.Global Delivery & Bridge Leadership: Bridge the communication gap between onshore business leaders and offshore technical units. Ensure seamless 24/7 development cycles, optimize resource utilization, and foster a culture of transparency and high-quality delivery.Technical Architecture & EngineeringDatabase Engineering: Design and manage scalable relational databases within the Azure ecosystem (e.g., Azure Synapse), ensuring high availability and data integrity for enterprise reporting layers.Power BI Architecture: Develop and maintain complex enterprise-level Power BI datasets, utilizing Composite Models, Aggregations, and Incremental Refresh.Performance Optimization: Tune complex SQL queries and DAX expressions to guarantee sub-second response times across both the database and Power BI environments.Data Governance & Quality: Manage Power BI workspaces (including Row-Level Security and gateway configurations) and lead rigorous code reviews to ensure the offshore team adheres to best practices in data modeling and governance.Required Skills & Qualifications (Must Have)Experience: 12–14 years of professional experience focusing on Power BI Development, PL/SQL Development, and enterprise Data Visualization.SQL Mastery: Expert-level T-SQL (Stored Procedures, CTEs, Window Functions) with a deep understanding of indexing and execution plans.Power BI Expertise: Advanced proficiency in Power BI Desktop and Service, including expert-level DAX (Data Analysis Expressions) and Power Query (M).Data Modeling: Mastery of Star Schema and Snowflake Schema design principles for advanced analytical reporting.Microsoft Stack: Strong, hands-on experience with the Azure data ecosystem (Azure SQL Database, Synapse Analytics) and Power BI Premium features.Soft Skills & LeadershipExecutive Communication: Exceptional ability to translate complex data into clear, compelling narratives that guide strategic decision-making for non-technical business leaders.Strategic Global Delivery: Proven track record of managing end-to-end delivery in a hybrid onshore-offshore model, navigating different time zones and cultural nuances effectively.Client Relationship Engineering: Demonstrated ability to build trust with onsite clients, acting not just as an order-taker, but as a strategic technical advisor.Negotiation & Scope Management: High emotional intelligence and the ability to gracefully navigate changing business requirements while keeping development teams shielded from scope creep.Education & CertificationsHighly Preferred: Microsoft Certified: Data Analyst Associate (PL-300) or Azure Data Engineer Associate (DP-203).EducationBachelors or Masters in Information Technology, Computer Science or relevant field.Work EnvironmentThis job operates in a professional office environment. This role routinely uses standard office equipment, including but not limited to, computers, phones, and photocopiers. Physical Demands This position requires the frequent and repetitive use of a computer, keyboard, and mouse. Hand and finger dexterity is required.Other DutiesPlease note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice. EEO Saama provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.