Data Analytics Senior

Position: Senior Data Analyst / Data Engineer?????? Location: McLean, Virginia Duration: Contract Job ID: 176028 Job Overview: We are seeking a Senior Data Analytics Contractor to deliver end-to-end analytics solutions across modern data platforms. The ideal candidate 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. Additionally, the role involves leveraging Microsoft Copilot and other AI-assisted tools to accelerate analysis, development, documentation, and stakeholder support while applying strong validation, governance, and data quality practices. 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). • Leverage Microsoft Copilot and AI tools to accelerate SQL/DAX generation, dashboard prototyping, narrative insights, and documentation while ensuring correctness through testing and validation. • 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 handoff. Qualifications: • 7 - 10+ 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. About PTR Global: PTR Global is a leading provider of information technology and workforce solutions. PTR Global has become one of the largest providers in its industry, with over 5000 professionals providing services across the U.S. and Canada. For more information visit www.ptrglobal.com At PTR Global, we understand the importance of your privacy and security. We NEVER ASK job applicants to: • Pay any fee to be considered for, submitted to, or selected for any opportunity. • Purchase any product, service, or gift cards from us or for us as part of an application, interview, or selection process. • Provide sensitive financial information such as credit card numbers or banking information. Successfully placed or hired candidates would only be asked for banking details after accepting an offer from us during our official onboarding processes as part of payroll setup. Pay Range: $60- $65 The specific compensation for this position will be determined by several factors, including the scope, complexity, and location of the role, as well as the cost of labor in the market; the skills, education, training, credentials, and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits, including medical, dental, vision, and 401K contributions, as well as PTO, sick leave, and other benefits mandated by applicable state or localities where you reside or work. If you receive a suspicious message, email, or phone call claiming to be from PTR Global do not respond or click on any links. Instead, contact us directly at +1 214-740-2424. To report any concerns, please email us at legal@pinnacle1.com Add your LinkedIn Hashtag at end of the job description