Lead SQL & BI Developer

Job Title Lead SQL & BI Developer

Job Location South San Francisco CA 3 Days Onsite

Job Duration: Long Term

Role Overview:

We are seeking an Onshore Lead Data Developer and BI Expert (12 14 years of experience) 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 Responsibilities

Client Advisory & Delivery Leadership

• Stakeholder 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 customers 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 & Engineering

• Database 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)

Technical Expertise

• 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 & Leadership

• Executive 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 & Certifications

• Highly Preferred: Microsoft Certified: Data Analyst Associate (PL-300) or Azure Data Engineer Associate (DP-203).

Education

• Bachelors or Masters in Information Technology Computer Science or relevant field.