Data Consultant

Design, develop, and maintain scalable data pipelines and analytical solutions using SQL Server and Python, ensuring data quality, performance optimization, automation, and operational efficiency.

Integrate, extract, transform, and model data from diverse sources including SQL databases, SharePoint, APIs, ArcGIS, and Python-based data services to support enterprise ETL and analytics requirements.

Develop and deliver robust reporting and data solutions by collaborating with business stakeholders and technical teams, translating complex requirements into actionable insights and scalable data products.

Build and support automated data ingestion, transformation, and incremental loading processes, while monitoring and maintaining data pipelines to ensure reliability, accuracy, and availability of business-critical reporting.

Apply data governance and best practices, including data security, role-based access control, version control, deployment pipelines, and lifecycle management across analytical platforms.

Leverage Python and AI-powered capabilities to automate repetitive tasks, enhance data processing workflows, and support the development of foundational Generative AI and AI Agent solutions, including prompt-driven automation and intelligent data retrieval processes.

Create and maintain comprehensive technical documentation, including database schemas, ETL workflows, SQL procedures, Python scripts, API integrations, AI solution architectures, and operational runbooks to support governance, maintenance, and knowledge sharing.

• Collaborate with cross-functional teams to identify opportunities for process improvement through data engineering, automation, machine learning, and emerging AI technologies