Sr. BI Consultant with Python :: McLean, VA

[Mohd Mightywarner]

Sr. BI Consultant with Python

McLean, VA

Only USC and EAD

 

Role Summary:

• Client is seeking a Developer to deliver end-to-end analytics solutions across modern data platforms.
• Candidates will build and optimize datasets in SQL Server, Snowflake, and Microsoft Fabric, develop analytics in Python, and deliver executive-ready insights through Tableau and Power BI.
• Candidates will also leverage Microsoft Copilot and other AI-assisted tools to accelerate analysis, development, documentation, and stakeholder support—while applying strong validation, governance, and data quality practices.

Key Responsibilities:

• Gather requirements, define KPIs, and translate business needs into scalable analytics deliverables (datasets, semantic models, dashboards, and insights).
• Write and optimize advanced SQL across SQL Server, Snowflake, and Microsoft Fabric (Warehouse/Lakehouse).
• Design and maintain analytics-ready data models (dimensional/star schemas, curated layers, reusable views/tables).
• Build, enhance, and performance-tune dashboards and reporting in Power BI (DAX, Power Query, semantic models) and Tableau.
• Use Python (e.g., pandas, NumPy; optional scikit-learn/statsmodels) for data wrangling, statistical analysis, forecasting, experimentation support, and automation.
• Implement data validation and quality controls (reconciliation, anomaly checks, refresh monitoring, metric certification).
• Develop within Microsoft Fabric using relevant components (e.g., notebooks, Dataflows Gen2, pipelines, Lakehouse/Warehouse, semantic models) as applicable.
• Communicate findings clearly, create concise executive narratives, and recommend actions backed by data.
• Maintain documentation for metric definitions, logic, lineage, and operational runbooks to support hand-off.

Leverage Microsoft Copilot and AI tools (e.g., Copilot for Power BI/Fabric/M365 and other approved assistants) to:

• Accelerate SQL/DAX generation and refactoring.
• Speed up dashboard prototyping and narrative insights.
• Draft documentation and data dictionaries.
• Support stakeholder Q&A and self-service enablement, while ensuring correctness through testing and peer/stakeholder validation.

Required Skills and Experience:

• 7 to 10 plus years in data analytics/BI/consulting (or equivalent senior-level experience).
• Advanced SQL expertise (CTEs, window functions, complex joins, query tuning).
• Strong experience with SQL Server (T-SQL) and performance optimization.
• Experience with Snowflake (warehouse concepts, optimization/cost awareness, security basics).
• Hands-on experience with Microsoft Fabric (Lakehouse/Warehouse concepts; pipelines/dataflows/notebooks; semantic modeling).
• Strong dashboard development skills in Power BI (DAX, modeling, performance) and Tableau.
• Proficiency in Python for analytics and automation.
• Demonstrated ability to use AI-assisted tools productively with appropriate guardrails (validation, privacy, reproducibility).
• Excellent stakeholder management, communication, and independent delivery skills.

Deliverables / Success Measures:

• Reliable, documented KPI definitions and curated datasets used consistently across teams.
• High-performing, user-friendly dashboards in Power BI/Tableau with measurable adoption.
• Reduced manual reporting through automation and reusable analytics assets.
• Clear documentation and hand-off materials enabling maintainability after contract completion.

Must Have Qualifications:

• The ideal candidate must have working knowledge of Python, SQL, Power BI, and Snowflake, develop Power BI dashboards, and write SQL queries.
• Must have familiarity in AI and Copilot.

[alfaz.te...@gmail.com]

Cloud Data Engineer :: 16 Years

 

AWS / Azure / Snowflake / Big Data / ETL / Data Warehouse / Talend / Snowflake / BI Developer (SSIS / SSRS / Tableau)

Name:                              Vasanthakumar Ramaiyan
Date of Birth:                FEB/1983
Current Location:      Lowell, Massachusetts

Relocation :                  Open
Face to face:                Yes
Visa:                                  H-1B
Entry to US:                   Sep 2023 on H-1B

Passport Number :   WILL BE PROVIDED
LinkedIn ID:                  WILL BE PROVIDED
SSN - Last 4 digits:   WILL BE PROVIDED

Education and Year of passing B.E. Electronics & Communication Engineering – 2008

 

 

 

Thanks & Regards

 

Alfaz Karaami

TEK TREE LLC

Email:      al...@tektreeinc.com

Phone:     302-248-8015

LinkedIn : https://www.linkedin.com/in/alfazkaraami/

Website:  www.tektreeinc.com

Address:  1106 Drummond Plaza

                Newark, DE 19711