• Detroit, MI
    8 days ago

    Job Description

    We are unable to sponsor or take over sponsorship of an employment visa at this time.

    Job Title: Senior Data Engineer

    Role Summary

    We are looking for a Senior Data Engineer to design, build, and optimize scalable data pipelines and data platforms supporting analytics, reporting, and AI/ML use cases. The ideal candidate has strong hands-on experience with Snowflake on AWS, Python-based ETL/ELT development, and enterprise scheduling/orchestration tools like Control-M, along with legacy/enterprise ETL experience in IBM DataStage. You will collaborate across engineering, analytics, and business teams in an Agile delivery model.

    Key Responsibilities

    • Design, develop, and maintain end-to-end data pipelines (batch and near real-time) using Snowflake, AWS services, and Python.
    • Build and optimize data models in Snowflake (e.g., dimensional modeling, data vault, or curated data marts) for analytics and downstream consumption.
    • Develop and maintain ETL/ELT workflows using Python and IBM DataStage; migrate/modernize workloads where applicable.
    • Implement job scheduling, monitoring, and operational support using Control-M (alerting, retries, SLAs, and dependency management).
    • Ensure data quality, governance, lineage, and documentation standards are met across pipelines.
    • Perform performance tuning and cost optimization across Snowflake and AWS (query optimization, clustering, warehouse sizing, storage management).
    • Partner with stakeholders (Data Science/AI, BI, Product, and Platform teams) to enable data products and AI-ready datasets.
    • Participate in Agile ceremonies, contribute to estimation, planning, and sprint execution; follow SDLC and change management processes.
    • Troubleshoot production issues, perform root-cause analysis, and drive preventative improvements.

    Required Technical Skills

    • Snowflake: Strong expertise in Snowflake architecture, SQL development, performance tuning, security/roles, data loading/unloading, and best practices.
    • AWS: Hands-on experience with AWS data ecosystem (commonly S3, IAM, CloudWatch; plus services such as Glue, Lambda, EC2, Step Functions, EMR, or Kinesis as applicable).
    • Python: Strong Python programming for data engineering (ETL/ELT frameworks, API ingestion, automation, unit testing, logging).
    • Control-M: Experience designing and managing enterprise job scheduling, dependencies, calendars, SLAs, monitoring, and incident handling.
    • IBM DataStage: Solid experience building and maintaining DataStage jobs, handling complex transformations, and supporting production workloads.
    • SQL: Advanced SQL skills for transformations, optimization, and data validation across large datasets.
    • CI/CD & Version Control: Experience with Git and CI/CD practices for data pipelines (tools may vary).
    • Operational Excellence: Monitoring, alerting, and production support experience in a 24x7 or business-critical environment.

    Good to Have

    • AI/ML exposure: Experience enabling AI/ML pipelines or feature datasets; familiarity with ML lifecycle concepts, feature engineering, or MLOps tools/processes.
    • Experience with data governance/metadata tools and practices (catalog, lineage, data quality frameworks).
    • Exposure to streaming or event-driven architectures.

    Required Soft Skills

    • Strong experience working in Agile/Scrum teams and delivering within structured SDLC processes.
    • Excellent communication skills (technical and non-technical) with the ability to explain complex data concepts clearly.
    • Proven ability to coordinate across multiple teams (Data Engineering, Data Science, DevOps, Security, BI, and business stakeholders).
    • Strong ownership mindset, problem-solving ability, and attention to detail.

    Qualifications (Typical)

    • Bachelor's degree in Computer Science, Engineering, or related field (or equivalent practical experience).
    • 9+ years of data engineering experience, including enterprise-grade data platform delivery and production support.

    Kaleidoscope, an Infosys Company, is an equal opportunity employer, and all qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, spouse of protected veteran, or disability.

    Numbers & Facts

    LocationDetroit, MI

    Skills

    • AWS Lambdaunmatched
    • Agile Modelingunmatched
    • Agile Programming Methodologiesunmatched
    • Amazon Elastic Compute Cloud (EC2)unmatched
    • Amazon Simple Storage Service (S3)unmatched
    • Amazon Web Services (AWS)unmatched
    • Application Programming Interface (API)unmatched
    • Artificial Intelligence (AI)unmatched
    • Best Practicesunmatched
    • Business Intelligenceunmatched
    • Change Managementunmatched
    • Communication Skillsunmatched
    • Computer Scienceunmatched
    • Continuous Deployment/Deliveryunmatched
    • Continuous Integrationunmatched
    • Cost Controlunmatched
    • Data Analysisunmatched
    • Data Managementunmatched
    • Data Martunmatched
    • Data Modelingunmatched
    • Data Qualityunmatched
    • Data Scienceunmatched
    • Data Setsunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Detail Orientedunmatched
    • DevOpsunmatched
    • Dimensional Modelingunmatched
    • Documentation Standardsunmatched
    • Ecosystemsunmatched
    • Electronic Medical Recordsunmatched
    • Gitunmatched
    • IBM WebSphere DataStageunmatched
    • Identify Issuesunmatched
    • Incident Responseunmatched
    • Loading/Unloadingunmatched
    • Metadataunmatched
    • Operational Controlunmatched
    • Operational Supportunmatched
    • Organizational Skillsunmatched
    • Performance Tuning/Optimizationunmatched
    • Problem Solving Skillsunmatched
    • Process Improvementunmatched
    • Production Supportunmatched
    • Python Programming/Scripting Languageunmatched
    • Query Optimizationunmatched
    • Root Cause Analysisunmatched
    • SQL (Structured Query Language)unmatched
    • Scalable System Developmentunmatched
    • Schedule Developmentunmatched
    • Scrum Project Management and Software Developmentunmatched
    • Service Level Agreement (SLA)unmatched
    • Snowflake Schemaunmatched
    • Software Development Lifecycle (SDLC)unmatched
    • Software Engineeringunmatched
    • Source Code/Configuration Management (SCM)unmatched
    • Sprint Planningunmatched
    • Test Automationunmatched
    • Training Data Setsunmatched
    • Unit Testunmatched
    • Use Casesunmatched
    • Warehousingunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder