Data Warehousing Jobs

Summary About Northwood Advisors Northwood Advisors is a consulting firm that helps organizations unlock growth through data-driven insights, business analytics, and modern technology solutions. We specialize in business intelligence, data warehousing, and cloud platforms like Microsoft Azure and Power BI, delivering tailored strategies that drive measurable results. About the Role We’re looking for a seasoned Business Development Representative/Manager (BDR/BDM) with a technical background and a consultative, relationship-first approach. Hours: ~10 hrs./week | 30-60 days initially, ideally extend to long term What You’ll Do • Identify and engage prospects, understand their needs, and schedule qualified meetings • Build authentic relationships — no pressure t...

I’m standing up a brand-new business-intelligence stack in Snowflake and need a reusable migration framework built with dbt and solid SQL. The framework has to pull from two kinds of sources—existing relational databases and the steady stream of CSV/Excel flat files our teams export—then land, cleanse, validate, and automate each load all the way into analytics-ready tables. Here’s what I’m after: • A dbt project structured for easy extension, complete with models, seeds, macros, and tests that enforce data-quality rules at every stage. • Parameterised SQL and Snowflake tasks/procedures that orchestrate fully automated loads, from raw landing zones through staging to final marts. • Built-in monitoring and reporting—leveraging dbt tes...

I have an SSIS package that pulls data from an Oracle database through an connection and loads it downstream for ETL processing. The transfer works, but network-level performance is far below what I need. Here is what I’m looking for: • Diagnose the current ADO.NET-to-Oracle connection, identify any network, buffer, or packet-size bottlenecks, and benchmark the baseline throughput. • Tune the SSIS data flow (buffers, rows per batch, commit size, async settings, etc.) and, if necessary, adjust the Oracle driver or provider configuration. • Provide an updated package or detailed change list so I can reproduce the performance gains in other environments. • Produce a concise report summarizing findings, before-and-after metrics, and next-step recommendations....

Job Description We are looking for an experienced Azure Data Engineer / Data Integration Specialist to design and implement a robust, scalable data pipeline that pulls data from the Blackbaud API and loads it into an Azure SQL Database using Azure Data Factory (ADF). The goal is to have a fully automated, secure, and monitored ETL pipeline that runs on a scheduled basis and supports future scaling. Project Scope 1. Data Ingestion Connect to Blackbaud REST APIs (OAuth authentication) Handle pagination, rate limits, and API throttling Extract multiple endpoints (e.g., constituents, gifts, transactions, etc.) 2. Data Transformation Clean, normalize, and structure raw API JSON Handle nulls, schema drift, and data type conversions Add audit fields (load date, source system, batch id) 3. Data Lo...

Background & Goal We're a medium size ecommerce retailer running on Netsuite for our ERP and Big Commerce for our front end website. We're looking for a data engineer to help build a data warehouse for Netsuite, Big Commerce, and potentially some other data platforms to help us analyse our data faster and more accurately. We wish to engage a third party data Engineer to build a central Data Warehouse in Google BigQuery (or other similar service). We want to analyse data in a data visualisation tool such as Power BI. We are also interested in other capability that we will be able to use the data warehousing for in the future (better exception reporting, better customer analytics, new sales & marketing opportunities, etc) We have a capable internal IT/Analytics team, howe...

With an advanced background in data integration and management, I now need to master how these disciplines translate inside a modern data clean room. I’m interested in the end-to-end picture: architecting secure landing zones, orchestrating ingestion pipelines, enforcing governance policies, and operationalising joins and privacy-preserving transformations so that multiple parties can collaborate on sensitive datasets without risk. What I expect from you is a focused, hands-on transfer of know-how rather than a generic primer. Walk me through real-world patterns, preferred storage layers, and the way you wire up connectors and workflow engines. If you have battle-tested approaches using platforms such as Apache NiFi, Talend, Informatica—or any equivalent stack—please wea...

I need an experienced Oracle-centric developer who is equally comfortable in Databricks SQL, MySQL, PostgreSQL, T-SQL and PL/SQL to move several production-grade data sets off Oracle 19c and make them run just as fast—if not faster—on each target platform. Here is what the engagement looks like in practical terms: • Data migration: extract with native Oracle utilities (Data Pump or equivalent), load into MySQL, PostgreSQL and Databricks SQL, and validate row-level parity. • Query optimization: review my current PL/SQL queries, reproduce them on each destination, then tune them until execution times meet or exceed the Oracle baseline. Please capture execution plans and explain any indexing or partitioning decisions. • Stored procedure development: rewrite ex...