The Snowflake Developer role with us isn't just a job - it's an awesome job. This role does not exist today, so you will have a real chance to make the job your own.

We are hiring builders at OBE. And we want to lean into your expertise to help us get better. We will give you what you need to do your job, and you will get to contribute every single day. This role can be based anywhere in the United States.

The role is perfect for an individual who professionally approaches their work and is passionate about making an impact in their workplace. If that sounds like you, come join this industry leader!

The Snowflake Business Intelligence Developer is a key, hands-on role that will develop and deliver solutions that enable the collection, transformation, and management of information from one or more sources. This role will be integrating data from source into Snowflake.

The ideal Developer for this role should be able to handle end-to-end Data Warehouse and Data Integration by taking into consideration the business cases, objectives, and requirements. The technical domain of the position includes Snowflake cloud data warehouse and the Data Integration, App & API Integration, Data Replication, and Mass Ingestions services of Informatic Intelligent Cloud Services. In addition, the responsibilities will include data integration, data architecture, information delivery, infrastructure, testing, and performance tuning for all components of the project.

Here's What You'll Get to Do:

• Architecting, designing and operationalization of large-scale data and analytics solutions on Snowflake Cloud Data Warehouse.
• Developing ETL pipelines in and out of data warehouse using combination of Python and Snowflakes SnowSQL Writing SQL queries against Snowflake.
• Serve as SME for Snowflake Internals and integration of Snowflake with other data processing and reporting technologies.
• Analyzes the impact of changes on existing ETL/ELT processes and systems.
• Assesses the compatibility with goals in all areas.
• Analyzes cost-effectiveness and feasibility
• Debug and tune data integration processes analyze data warehouse architecture, normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, dimensional surrogate key handling, exception data processing, troubleshoot and recommend improvements and alternate methodologies
• Design, develop and maintain Snowflake database objects (tables, views, stored procedures, etc.) and SQL scripts.
• Develop a new complex data warehouse, using strong Snowflake experience in SQL Development and Data Analysis.
• Administer and monitor the Snowflake computing platformPlan, design, develop and maintain the data architecture, data models and standards for various Data Integration & Data Warehouse projects in Snowflake
• Provide advice, guidance, and best practices around SnowflakeProvide guidance on moving data across different environments in Snowflake

Related Competencies:

• Can-do attitude, with the ability to drive to success in both independent and group projects
• Demonstrated experience with data integration architectures, data analysis and implementation
• Demonstrated experience with ETL tools, including Informatica Cloud IICSDemonstrated experience with Enterprise level Data Warehousing
• Demonstrated experience with Snowflake and SQLExperience in Snowflake advanced concepts such as resource monitors, virtual warehouse sizing, query performance tuning, zero-copy clone, time travel and understand how to use these features of experience in data Integration, ETL/ETL development, and database design or Datawarehouse design
• Experience with writing complex SQL queries, especially dynamic SQLExperience in Snowflake advanced concepts such as resource monitors, virtual warehouse sizing, query performance tuning, zero-copy clone, time travel, and understand how to use these features
• Expertise in Snowflake data modeling, ELT using Snowflake SQL , Snowflake Task Orchestration implementing complex stored Procedures and standard DWH and ETL concepts
• Experience with performance tuning and optimization of SQL queriesExperience with data security and role-based access controls
• Experience of working with Microsoft SQL Server and extensive knowledge about writing Stored procedures
• Able to be agile in thinking and approach to solve the problem at hand.
• Full Life Cycle Development
• Demonstrated experience and ability to deliver results quickly in a fast-paced environment on multiple projects
• Ability to work with other IT groups and business users
• Experience with Manufacturing Industry BI projects a strong plus

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)