Sr Data Engineer HYBRID in Detroit MI 6 Months

Genius Business Solutions; Detroit (MI); On-site; USD 110,000 - 170,000; Full time

Job summary

Genius Business Solutions seeks a Senior Data Engineer to design, build, and optimize data pipelines and platforms supporting analytics, reporting, and AIML use cases. The role emphasizes Snowflake on AWS, Python ETL/ELT development, and enterprise scheduling with Control-M.

You will collaborate with Data Science, BI, and Platform teams in an Agile delivery model to enable data products and governed datasets across the enterprise.

Qualifications

• Extensive experience designing and maintaining scalable data pipelines.
• Strong Snowflake SQL development, data modeling, and performance tuning.
• Hands-on experience with AWS services (S3, Glue, Lambda, IAM) and Python ETL/ELT development.
• Familiarity with IBM DataStage and enterprise scheduling tooling.

Responsibilities

• Design, develop, and maintain batch and near real-time data pipelines using Snowflake and Python.
• Build and optimize Snowflake data models (dimensional, data vault, curated marts).
• Develop and maintain ETL/ELT workflows with Python and DataStage; migrate workloads.
• Implement job scheduling, monitoring, and operational support with Control-M.
• Ensure data quality, governance, lineage, and documentation across pipelines.
• Collaborate with Data Science, AI, BI, Product, and Platform teams in Agile ceremonies.

Skills

Snowflake

SQL

AWS

Python

DBT

DataStage

Tools

Control-M

Airflow

Qlik

AWS Glue

Job description

About Genius Business Solutions Inc. (GBSI)

Featured in CNBC, Digital Journal, Fox News, and CIO Review, GBSI is a globally recognized IT services leader with 20+ years serving Fortune 500 organizations. Our teams deliver solutions across automotive, manufacturing, retail, and pharmaceutical industries. Headquartered in Moline, IL, GBSI supports clients and consultants throughout the US, Canada, Europe, and India.

Join our innovative team to lead enterprise-grade SAP solutions and drive digital transformation initiatives across global enterprises.

Job Summary

We are looking for a Senior Data Engineer to design, build, and optimize scalable data pipelines and data platforms supporting analytics, reporting, and AIML use cases. The ideal candidate has strong hand son experience with Snowflake on AWS, Python based ETLELT 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.

Responsibilities

• Design, develop, and maintain batch and near real-time data pipelines using Snowflake, AWS, and Python.
• Build and optimize Snowflake data models (dimensional, data vault, curated marts).
• Develop and maintain ETL/ELT workflows using Python and IBM DataStage; migrate and modernize workloads.
• Implement job scheduling, monitoring, and operational support with Control-M (alerting, retries, SLAs, dependencies).
• Ensure data quality, governance, lineage, and documentation standards across pipelines.
• Perform performance tuning and cost optimization in Snowflake and AWS (query optimization, clustering, warehouse sizing).
• Collaborate with Data Science, AI, BI, Product, and Platform teams to enable data products and curated datasets.
• Participate in Agile ceremonies, contribute to estimation, sprint planning, and execution.
• Troubleshoot production issues, perform root cause analysis, and drive preventative improvements.

Required Technical Skills

• Snowflake: Strong expertise in architecture, SQL development, performance tuning, security roles, and data loading/unloading.
• AWS: Hands-on experience with S3, IAM, CloudWatch, Glue, Lambda, EC2, Step Functions, EMR, or Kinesis.
• Python: Strong programming for ETL/ELT frameworks, API ingestion, automation, unit testing, and logging.
• Control-M: Enterprise job scheduling, dependencies, calendars, SLAs, monitoring, and incident handling.
• IBM DataStage: Building and maintaining jobs, complex transformations, and production support.
• SQL: Advanced skills for transformations, optimization, and validation across large datasets.
• CI/CD & Git: Experience with version control and pipeline automation.
• Operational Excellence: Monitoring, alerting, and production support in business-critical environments.

Good to Have

• Exposure to AI/ML pipelines or feature datasets.
• Familiarity with data governance tools (catalogue, lineage, data quality frameworks).
• Experience with streaming/event-driven architectures.

Primary Skills

Snowflake, SQL, AWS, Python, DBT & DataStage

Secondary Skills

AWS Glue, Qlik, Control-M & Airflow.

Equal Employment Opportunity

GeniusBSI is an Equal Opportunity Employer. We believe that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion, or sexual orientation.

All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status, or any other basis as protected by federal, state, or local law.