<p>Our client is undergoing a major digital transformation, shifting toward a cloud-native, API-driven infrastructure. They’re looking for a Data Engineer to help build a modern, scalable data platform that supports this evolution. This role will focus on creating secure, efficient data pipelines, preparing data for analytics, and enabling real-time data sharing across systems.</p><p>As the organization transitions from older, legacy systems to more dynamic, event-based and API-integrated models, the Data Engineer will be instrumental in modernizing the data environment—particularly across the bronze, silver, and gold layers of their medallion architecture.</p><p><strong>Key Responsibilities:</strong></p><ul><li>Design and deploy scalable data pipelines in Azure using tools like Databricks, Spark, Delta Lake, DBT, Dagster, Airflow, and Parquet.</li><li>Build workflows to ingest data from various sources (e.g., SFTP, vendor APIs) into Azure Data Lake.</li><li>Develop and maintain data transformation layers (Bronze/Silver/Gold) within a medallion architecture.</li><li>Apply data quality checks, deduplication, and validation logic throughout the ingestion process.</li><li>Create reusable and parameterized notebooks for both batch and streaming data jobs.</li><li>Implement efficient merge/update logic in Delta Lake using partitioning strategies.</li><li>Work closely with business and application teams to gather and deliver data integration needs.</li><li>Support downstream integrations with APIs, Power BI dashboards, and SQL-based reports.</li><li>Set up monitoring, logging, and data lineage tracking using tools like Unity Catalog and Azure Monitor.</li><li>Participate in code reviews, design sessions, and agile backlog grooming.</li></ul><p><strong>Additional Technical Duties:</strong></p><ul><li><strong>SQL Server Development:</strong> Write and optimize stored procedures, functions, views, and indexing strategies for high-performance data processing.</li><li><strong>ETL/ELT Processes:</strong> Manage data extraction, transformation, and loading using SSIS and SQL batch jobs.</li></ul><p><strong>Tech Stack:</strong></p><ul><li><strong>Languages & Frameworks:</strong> Python, C#, .NET Core, SQL, T-SQL</li><li><strong>Databases & ETL Tools:</strong> SQL Server, SSIS, SSRS, Power BI</li><li><strong>API Development:</strong> ASP.NET Core Web API, RESTful APIs</li><li><strong>Cloud & Data Services (Roadmap):</strong> Azure Data Factory, Azure Functions, Azure Databricks, Azure SQL Database, Azure Data Lake, Azure Storage</li><li><strong>Streaming & Big Data (Roadmap):</strong> Delta Lake, Databricks, Kafka (preferred but not required)</li><li><strong>Governance & Security:</strong> Data integrity, performance tuning, access control, compliance</li><li><strong>Collaboration Tools:</strong> Jira, Confluence, Visio, Smartsheet</li></ul>
We are looking for a detail-oriented Bookkeeper/Accountant to join our team in Toledo, Ohio. This role is ideal for someone with experience in union payroll and billing processes, as well as proficiency in accounting systems tailored for construction and union-focused operations. The position offers excellent benefits including full insurance coverage, profit sharing bonuses, and an employer-funded retirement plan.<br><br>Responsibilities:<br>• Handle billing processes for multiple divisions, including structural contracts, rebar contracts, and time-and-material billings.<br>• Prepare invoices using various formats and online portals such as Textura, GCPay, and ProCore.<br>• Manage payroll tasks including processing direct deposits, checks, and handling garnishments.<br>• Compile and submit monthly union reports for operating engineers and ironworker unions.<br>• Update union master data within the Foundation Accounting system.<br>• Assist with audits and ensure compliance with union reporting standards.<br>• Process sworn statements and waivers related to billing and payroll activities.<br>• Utilize software tools like Foundation Accounting, Excel, and Word to complete bookkeeping tasks.<br>• Maintain organized and accurate records for all financial transactions.<br>• Collaborate with team members to restructure processes based on departmental strengths.
We are looking for a knowledgeable Purchase & Sales Specialist to join our team in Plymouth, Michigan. This Contract-to-Permanent position is ideal for someone with a strong background in procurement, particularly in the construction and materials industry. The role involves managing purchasing activities, vendor relationships, and inventory coordination while ensuring cost efficiency and compliance.<br><br>Responsibilities:<br>• Coordinate the procurement of construction materials, including pipes, valves, and fittings, to align with project specifications and timelines.<br>• Build and maintain strong relationships with vendors, evaluating their reliability, pricing, and quality.<br>• Collaborate with internal teams such as project managers and engineers to address procurement needs and delivery requirements.<br>• Create and manage purchase orders while ensuring compliance with company standards and regulations.<br>• Negotiate vendor contracts to achieve cost savings and maintain budgetary control.<br>• Monitor inventory levels and synchronize deliveries with project schedules to prevent delays.<br>• Resolve issues related to late deliveries, defective materials, or discrepancies in inventory.<br>• Research and onboard new suppliers to diversify and strengthen the supply chain.<br>• Analyze procurement data to identify cost-saving opportunities and improve efficiency.
