Data Engineer

Job Title: Data Engineer (Contract) - Job#5885 Location: Chicago, IL (Hybrid) Overview This is a hybrid Data Engineer + Data Analyst role that blends data pipeline development, data analytics, business insights, and dashboard/reporting capabilities. The Data Engineer will design and build scalable data pipelines, develop dashboards, analyze complex data sets for insights, and communicate findings to customers and leadership. The role supports IT and Information Security compliance initiatives and enables self-service reporting across Cloud environments. You will work on a small, collaborative team with the opportunity to add significant value, influence processes, and shape data strategy. Key Responsibilities Data Engineering & Architecture • Design, build, and maintain scalable, repeatable, secure data pipelines (ETL/ELT) and data ingestion processes. • Develop and optimize data sets, operational data stores, and data marts. • Create real-time and batch ETL processes aligned with business needs. • Perform logical data modeling and implement physical data structures. • Conduct design reviews related to code, tables, and database architecture for data warehouse environments. Analytics, Insights & Storytelling • Analyze data sets to identify trends, patterns, and insights that drive improved Cloud IT and IS compliance. • Translate complex analysis into business-readable insights and actionable recommendations. • Communicate findings to customers and summarize key messages for leadership using strong business storytelling skills. • Serve as a trusted advisor to data consumers, helping identify data problems and guide issue resolution. Dashboarding & Reporting • Build and maintain dashboards using PowerBI and Tableau to enable customer self-service compliance insights. • Lead the development and refinement of reports, KPIs, and analytics visualizations. • Assist less experienced staff (as needed) in data visualization best practices. Workflow Automation & Business Processes • Build workflow automations using Microsoft Power Automate. • Support development of new processes, standards, and operational plans for the team. Documentation & Governance • Document data flows, data models, data quality standards, pipeline processes, and security/access requirements. • Maintain a query library for recurring data requests. • Ensure data security, quality, and reliability standards are followed across systems. Day-to-Day Expectations • Participate in Agile ceremonies and provide status updates. • Create and work Agile stories aligned with product features; escalate issues appropriately. • Support business-as-usual rotation tasks (customer notifications, report development, peer reviews). • Share knowledge proactively and contribute to a collaborative, professional team culture. Top Required Hard Skills Data Analytics (PowerBI, Tableau, Excel; ability to analyze data sets for business insights) • Data Engineering (pipeline development, ETL/ELT, data modeling, data set management) Dashboard Development (PowerBI, Tableau) • Workflow Automation (Microsoft Power Automate) • Business Analysis (requirements gathering, translating business needs into specifications) • Preferred: • IT background with understanding of AWS/Azure Cloud, vulnerability management, and IT/IS compliance. Top Required Soft Skills • Customer communication (written and verbal) • Business storytelling and presentation delivery • Business requirements gathering • Critical thinking and decision-making • Ability to collaborate in a small, high-impact team Education & Experience • Bachelor’s degree or equivalent experience. • 1+ years of relevant work experience required. • Experience in analytics, data engineering, or similar hybrid roles strongly preferred. • Related certifications or participation in industry organizations preferred. Technical Knowledge & Tools • ETL/ELT processes and data warehouse architectures • Data modeling, data processing pipelines • PowerBI, Tableau, SQL, Excel • Scripting languages • Cloud data platforms (AWS, Azure) – preferred • CI/CD familiarity • Understanding of data security and privacy regulations • Agile methodologies and SDLC About Delphi-US Delphi-US is a national recruiting firm based in Newport, Rhode Island. We specialize in IT, Engineering and Professional Staffing services for organizations across the United States of America.? Our mission is simple: We are Peacemakers in the Talent War. Delphi attracts our nation’s best and brightest Technical & Professional Talent and position our nation’s finest employers to further their competitive advantages.? We accomplish this with a proprietary skill-based and cultural matching process that results in higher qualified submissions, hiring with purpose, and employer/employee mutual success. You’ll find our team is supremely experienced, friendly, professional and ready to advocate on your behalf.? Armed with best in class talent, Delphi has an indelible understanding of employer expectations and we deliver lasting results.