<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 skilled IT Systems Engineer to join our team on a contract basis in Detroit, Michigan. In this role, you will be responsible for maintaining and enhancing enterprise technology environments, ensuring their performance, security, and reliability. This position offers an exciting opportunity to work across systems administration, endpoint management, and technical support, collaborating with both internal teams and external vendors.<br><br>Responsibilities:<br>• Manage and monitor installed systems, servers, and storage to ensure optimal performance and reliability.<br>• Configure, test, and maintain operating systems, enterprise applications, and virtualization platforms.<br>• Develop and implement robust backup, disaster recovery, and redundancy strategies.<br>• Create automation scripts to streamline processes and improve operational efficiency.<br>• Administer Windows endpoints and mobile devices using Microsoft Intune, including compliance policies and application deployments.<br>• Provide advanced technical support to resolve escalated issues and document solutions for future reference.<br>• Collaborate with network engineers and other IT team members to address connectivity and system-related challenges.<br>• Participate in technology upgrades, migrations, and new system implementations to support organizational goals.<br>• Monitor system and application performance, identifying and addressing areas for improvement.<br>• Ensure secure and standardized configurations across all devices within the organization.
We are looking for a skilled Data Engineer to join our team in Ann Arbor, Michigan, and contribute to the development of a modern, scalable data platform. In this role, you will focus on building efficient data pipelines, ensuring data quality, and enabling seamless integration across systems to support business analytics and decision-making. This position offers an exciting opportunity to work with cutting-edge technologies and play a key role in the transformation of our data environment.<br><br>Responsibilities:<br>• Design and implement robust data pipelines on Azure using tools such as Databricks, Spark, Delta Lake, and Airflow.<br>• Develop workflows to ingest and integrate data from diverse sources into Azure Data Lake.<br>• Build and maintain data transformation layers following the medallion architecture principles.<br>• Apply data quality checks, validation processes, and deduplication techniques to ensure accuracy and reliability.<br>• Create reusable and parameterized notebooks to streamline batch and streaming data processes.<br>• Optimize merge and update logic in Delta Lake by leveraging efficient partitioning strategies.<br>• Collaborate with business and application teams to understand and fulfill data integration requirements.<br>• Enable downstream integrations with APIs, Power BI dashboards, and reporting systems.<br>• Establish monitoring, logging, and data lineage tracking using tools like Unity Catalog and Azure Monitor.<br>• Participate in code reviews, agile development practices, and team design discussions.
We are looking for a driven IT Coordinator to join our team in Southfield, Michigan. This long-term contract position involves assisting with help desk support and coordination of IT activities, particularly in customer-facing situations. The ideal candidate will have a proactive attitude and excellent communication skills, ensuring smooth operations and technical support.<br><br>Responsibilities:<br>• Provide initial troubleshooting support for IT-related issues, ensuring timely resolutions.<br>• Assist with conference room setup, including display and A/V equipment functionality.<br>• Monitor and complete daily checklists to maintain operational efficiency.<br>• Coordinate with the IT department to address and resolve service desk tickets.<br>• Support end users with basic queries related to Active Directory and Windows 10.<br>• Maintain accurate records of IT activities and issue resolutions.<br>• Ensure smooth operation of Microsoft Windows systems and provide basic troubleshooting.<br>• Deliver exceptional customer service by addressing technical concerns promptly.<br>• Collaborate with team members to improve IT support processes.
We are looking for a highly skilled Server Administrator to join our team in Dearborn, Michigan. This contract position offers an excellent opportunity to showcase your technical expertise in server management and optimization while working on-site. The initial contract lasts for six months, with the potential for extension or transition to a long-term role based on performance.<br><br>Responsibilities:<br>• Manage and optimize VMware virtualization environments to ensure seamless performance.<br>• Configure and administer web services, including Internet Information Services (IIS), to support business needs.<br>• Implement and maintain Microsoft Intune for efficient device management across the organization.<br>• Set up and troubleshoot network load balancing to enhance system reliability and scalability.<br>• Configure and manage firewalls to protect systems and data from unauthorized access.<br>• Monitor and maintain Active Directory to ensure secure and efficient user access.<br>• Oversee the administration of Microsoft Windows Server and Windows 10 systems.<br>• Collaborate on Citrix-related technologies to ensure optimal performance and user experience.<br>• Perform network troubleshooting to resolve connectivity issues and maintain uptime.<br>• Document configurations and processes to support ongoing system management.
