Data Engineer ADF Snowflake OBP Integration HYBRID in Glendale Milwaukee WI 6 Months

Genius Business Solutions; Milwaukee (WI); Hybrid; USD 90,000 - 130,000; Full time

Job summary

GeniusBSI seeks a senior data engineer to craft end-to-end data pipelines using Azure Data Factory for OBP and to design scalable Snowflake data models across global operations.

You will optimize SQL, implement robust data integration workflows, and collaborate with analysts to translate requirements into technical designs within a hybrid work environment.

Qualifications

• 8+ years of experience using ADF for OBP in enterprise projects.
• Strong Snowflake expertise including schema design and data sharing.
• Deep experience with data warehousing and dimensional modeling.
• Proficient SQL optimization and heavy data transformation.
• Cloud-based data engineering practices, monitoring and cost management.
• Hybrid work experience and strong cross-team collaboration.

Responsibilities

• Design end-to-end data pipelines using Azure Data Factory for OBP.
• Develop Snowflake data models aligned with enterprise standards.
• Create robust data integration workflows with error handling, logging, and recoverability.
• Collaborate with analysts to translate requirements into technical designs for pipelines and models.
• Tune performance of ADF pipelines and Snowflake queries.
• Document configurations and data models; ensure security and compliance.

Skills

ADF for OBP

Snowflake

Data warehousing

SQL optimization

Cloud data engineering

Agile

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

This hybrid day shift role focuses on delivering robust data solutions using ADF for OBP and Snowflake within a large multinational environment. The role involves designing and optimizing data pipelines, collaborating with cross functional teams, and ensuring secure and reliable data flows that support strategic business analytics and decision making across global operations.

Key Responsibilities

• Design end-to-end data pipelines using Azure Data Factory (ADF) for OBP, enabling reliable movement and transformation of data between enterprise systems and analytical platforms.
• Develop scalable Snowflake data models aligned with enterprise standards to optimize query performance and maintain data integrity across subject areas.
• Implement robust data integration workflows orchestrating ADF activities and Snowflake operations, with strong focus on error handling, logging, and recoverability.
• Collaborate with business analysts and product owners to translate functional requirements into technical designs for ADF pipelines and Snowflake structures.
• Perform detailed performance tuning on ADF pipelines and Snowflake queries by analyzing execution patterns and resource usage.
• Establish and maintain data quality checks within ADF and Snowflake processes to detect anomalies and enforce validation rules.
• Create and maintain technical documentation for ADF configurations, OBP integrations, and Snowflake data models.
• Coordinate with infrastructure and security teams to align implementations with enterprise guidelines on access control, encryption, and compliance.
• Investigate and resolve incidents related to data loads, pipeline failures, and performance degradation in ADF and Snowflake environments.
• Support migration of existing data solutions into Snowflake and ADF, planning transition steps and executing cutover activities.
• Engage with testing teams to define and execute unit, integration, and regression tests for ADF pipelines and Snowflake objects.
• Contribute to continuous improvement by recommending enhancements to development standards, reusable components, and monitoring dashboards.
• Participate in agile ceremonies and cross-functional sessions, providing technical input, effort estimates, and aligning delivery plans with business priorities.

Qualifications

• Strong expertise in ADF for OBP, with at least 8 years of practical experience in enterprise projects.
• Advanced proficiency in Snowflake, including schema design, warehouse configuration, and secure data sharing models.
• Solid experience in data warehousing and dimensional modeling to structure Snowflake objects for reporting and analytics.
• Proven capability in SQL optimization and data transformation techniques for high-volume processing.
• Practical knowledge of cloud-based data engineering practices, including monitoring, cost management, and environment segregation.
• Strong communication and collaboration skills to work effectively in hybrid environments.
• Experience in structured delivery methodologies such as Agile or iterative approaches.

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.