Data Engineer

Brooksource is seeking a Senior Data Engineer for a 6-month contract-to-hire position, mainly remote with a preference for candidates local to Metro Detroit. The role involves building and maintaining secure, scalable ETL/ELT pipelines, optimizing data models and workflows, and collaborating with various teams to translate business needs into technical solutions.

Responsibilities:

• Build and maintain secure, scalable ETL/ELT pipelines
• Develop and optimize data models and workflows for analytics and reporting
• Create monitoring and alerting to ensure data quality and pipeline reliability
• Collaborate with engineering, architecture, product, analytics, and IT teams
• Translate business needs into technical solutions
• Conduct code reviews and mentor junior engineers
• Improve processes through automation, tooling, and best practices
• Own critical data flows and reporting systems
• Build dashboards and datasets in Domo
• Participate in Agile ceremonies and surface blockers early

Requirements:

• Strong SQL skills and data modeling expertise
• Experience with Snowflake or similar cloud data platforms
• Hands-on Python experience (or Java/Scala)
• Experience integrating with APIs and third-party data sources
• Familiarity with AWS cloud-native services and infrastructure-as-code
• Strong analytical, debugging, and problem-solving skills
• Experience in Agile environments and influencing without authority
• Strong organizational and time-management skills
• Bachelor's degree in Computer Science or related field
• 5+ years developing and maintaining ELT systems
• Experience with Snowflake/BigQuery, SQL, and pipeline development required
• Experience with Domo datasets, dataflows, and dashboards
• Experience building integrations with SaaS APIs like Salesforce
• DBT or automated testing experience
• Extra consideration for AWS or Snowflake certifications