Email Attachment to Azure Data Warehouse Integration (P&L Automation)
Hourly: $85.00 - $85.00
We’re looking for a skilled developer to build an automated data pipeline that pulls weekly Profit & Loss (P&L) statement attachments from a designated email inbox and processes them into our Azure data environment. Key Responsibilities: • Monitor a specific email inbox and extract attached P&L files (Excel or CSV format) • Land the files in Azure Blob Storage or directly into a staging database • Normalize and transform the data into a clean, consistent structure (e.g., pivot/unpivot rows, align columns) • Ensure the dataset is report-ready for downstream consumption • Load transformed data into our Azure SQL Data Warehouse • Push the cleaned data into an existing Azure Analysis Services tabular model for use in Power BI Requirements: • Strong experience with Azure tools (Blob Storage, Data Factory, Logic Apps, or Functions) • Data wrangling and transformation expertise (Python, T-SQL, or ADF mapping data flows) • Familiarity with data modeling and tabular model structures • Ability to build fully automated and repeatable workflows The solution should run on a weekly schedule and require zero manual intervention once deployed.
Keyword: Data Cleaning
Price: $85.0
SQL Microsoft SQL Server Microsoft SQL Server Programming Python
Financial Analyst, Seniors Housing and Care
Who We Are A leading M&A advisory firm in the senior housing and care space is seeking a financial analyst to support our investment sales team. We’ve built a strong reputation on transparency, attention to detail, and relentless follow-through—and we need someone w...
View JobGA4 & Google Tag Manager Help
We're an electronic components manufacturer looking for some assistance with our GA4 and Google Tag Manager set-up! We solicited the help of an agency to help us migrate over to GA4 a couple years ago, but they left us with a bit of a mess to clean up and we are looking...
View JobAI/ML Engineer – Document Parsing with LLMs
Job Summary: We’re building a lightweight MVP for an AI-powered tool that helps industrial companies make sense of complex regulatory documents. Your job: build the backend engine that ingests long, messy documents and produces clean, structured summaries with LLM assis...
View Job