ETL Developer

Please find the Job Position Details; Position: ETL DataStage Developer Location: Mclean, VA (Onsite) Duration: 6+ Months (with possible extension) Pay Rate: $60-$70/hr. on W2 (Depending upon the experience) 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. Job Description: 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.