Data & Analytics Engineer
New
Based in the United States, working remotely within the Eastern Time Zone, Eastern Time ZoneFull-TimeMiddle
SalaryCompetitive annual salary. Quarterly bonus opportunities.
Apply NowOpens the employer's application page
Job Details
- Experience
- At least 3 years of experience in data engineering, analytics engineering, or a closely related technical role.
- Required Skills
- PythonSQLMicrosoft AzurePandasSparkRESTful APIs
Requirements
- At least 3 years of experience in data engineering, analytics engineering, or a closely related technical role.
- Strong SQL skills, including T-SQL and troubleshooting, refactoring, and optimizing stored procedures, database views, and SQL Server Agent jobs.
- Strong Python skills for data processing, transformation, and analytics; experience with DuckDB, Spark, pandas, or comparable technologies.
- Hands-on experience with cloud-based data platforms, ideally Microsoft Azure, and familiarity with Delta Lake or similar formats.
- Knowledge of dimensional modeling, medallion architecture, slowly changing dimensions, and reusable business metrics.
- Experience building and maintaining ELT pipelines integrating REST APIs, SaaS applications, and multiple business data sources.
- Experience migrating reports, databases, or data workloads between platforms, including reconciliation, validation, stakeholder communication, and sign-off.
- Experience developing business dashboards and reports and translating business questions into precise metrics.
- Familiarity with Git-based workflows, pull requests, code reviews, and collaborative software development.
- Strong problem-solving skills and a disciplined approach to validating data and investigating discrepancies.
- Preferred: experience in an MSP or IT services environment, or familiarity with ConnectWise, Sage Intacct, or HiBob data.
- Preferred: experience with Salesforce, Gong, Cognism, or HubSpot; Power BI, DAX, and semantic models; or legacy system decommissioning.
- Preferred: familiarity with Microsoft Fabric, Azure Container Apps, Docker, Azure Static Web Apps, or Azure App Service.
- Preferred: JavaScript, HTML, and CSS; data quality tools such as dbt tests or Great Expectations; LLM APIs, RAG, or semantic layers; or CI/CD workflows with GitHub Actions or similar.
- Willingness to use AI-assisted development tools regularly and critically evaluate their outputs.
Responsibilities
- Develop and operate a Microsoft Azure cloud data platform integrating business applications and SaaS systems into a centralized lakehouse.
- Build and maintain ELT pipelines using SQL, Python, REST APIs, and data processing technologies.
- Migrate active reports from legacy SQL Server and Power BI environments to a centralized lakehouse and data portal.
- Identify legacy system dependencies, coordinate transitions, validate replacements, and manage decommissioning and archival.
- Design dimensional models, medallion architectures, slowly changing dimensions, and standardized business metrics.
- Monitor pipeline health, investigate discrepancies, reconcile metrics, and implement data validation and observability practices.
- Develop dashboards and reporting solutions for service delivery, profitability, customer retention, sales opportunities, and operational performance.
- Work with business stakeholders to clarify reporting needs and define measurable metrics.
- Contribute to internal tools and web applications, and help build AI-powered analytics using large language models, semantic layers, and retrieval-based approaches.
- Use Git workflows, code reviews, automated deployment practices, and AI coding assistants while validating the quality of delivered work.
View Full Description & ApplyYou'll be redirected to the employer's site
