"Alerted.org

Novi, MI, USA | Salary | Full Time

Our Purpose

At Vibe, we are driven by our mission to elevate community and create opportunity. We believe in fostering an environment of inclusivity where every team member has the chance to grow professionally. Guided by our core values – be inclusive, educate, embrace change, and seek opportunities - we are dedicated to making a positive impact in the lives of our members and communities. As we continue to grow and expand our team, we are seeking passionate individuals who share our vision and are eager to join us in our journey. If you are someone who is passionate about making a difference and is committed to creating a brighter future for our communities, we invite you to explore this exciting opportunity at Vibe!

Position Purpose

The Data Engineer will be responsible for designing, developing, and managing data pipelines, ensuring data quality, and optimizing performance on the Snowflake, Power BI and SQL platforms. This role will work closely with the Business Intelligence team, data analysts and our IT departments to enable our data sources to be accessible and actionable.

Essential Duties

Design & Development:

+ Develop and maintain robust, scalable data pipelines for extracting, transforming, and loading (ETL) data into Snowflake from various sources (e.g., databases, APIs, third-party systems).

+ Implement and optimize Snowflake schemas (e.g., star and snowflake schemas) and data models for analytics and reporting.

+ Write complex SQL queries to help enable business analysts in partner departments for data extraction and transformation.

+ Develop complex Data Models within Power BI and produce self service data visualization dashboards.

Data Integration:

+ Collaborate with cross-functional teams to gather data requirements and design integrations between Snowflake and other data sources (e.g., on-premise databases, cloud platforms, data lakes).

+ Work with our vendors to develop efficient ways to exchange data.

+ Implement data ingestion frameworks using tools like Snowpipe for real-time or batch processing.

Optimization & Performance:

+ Optimize Snowflake queries, databases, and storage to improve performance and reduce costs (e.g., clustering, pruning, and partitioning).

+ Monitor and troubleshoot data pipelines and optimize processes for reliability, efficiency, and scalability.

+ Develop and execute a cost-conscious data lake ingestion strategy by evaluating, prioritizing, and onboarding high-value data sources to ensure scalable, efficient, and business-aligned data architecture.

Data Governance & Quality:

+ Implement and maintain data quality checks and validation mechanisms.

+ Ensure compliance with data privacy and security standards, especially when working with sensitive or regulated data.

+ Maintain documentation on data processes, pipelines, and data models for internal use.

Collaboration:

+ Work with data analysts, IT development teams and partner departments to ensure that data solutions align with business requirements.

+ Assist in providing access to data and creating views in Snowflake for reporting and analytics purposes.

Education/Experience

+ Strong experience in data engineering or related roles with a focus on Snowflake.

+ Hands-on experience with Snowflake's architecture, performance tuning, and advanced features (e.g., Snowflake Streams, Tasks, Snowpipe).

+ Strong partnership and collaboration experience to develop solutions for several internal departments and external vendors.

+ Proficiency in SQL, Snowflake SQL, DB2 and Python.

+ Experience with ETL/ELT tools such as Talend, Apache NiFi, or custom solutions.

+ Experience with cloud platforms (AWS, Azure, or Google Cloud) and data integration services.

Skills/Abilities

+ Expertise in Snowflake data warehousing concepts such as data loading, performance tuning, partitioning, and storage optimization.

+ Proficient in programming languages like DB2, SnowSQL, SQL Server, Python or Java for data pipeline development.

+ Knowledge of data visualization and reporting tools (e.g., Power BI) is a plus.

+ Strong problem-solving and troubleshooting skills.

+ Excellent communication skills for collaborating with stakeholders and team members.

+ Ability to manage multiple projects and meet deadlines in a fast-paced environment.

Physical Requirements

These physical demands are representative of the physical requirements necessary for an employee to successfully perform the essential functions of the position. Reasonable accommodations can be made to enable people with disabilities to perform the described essential functions of the position. While performing the responsibilities of the job, the employee is required to hear, see, talk, stand, walk, stoop, kneel, lift, push, pull, and grasp.

I have received a copy of this job description: _______________________________

Employee's Name (please print)

________________________________________ ______________________________________________

Manager's Signature