PERFORMANCE OPTIMIZATION:

• Continuously optimize query performance, storage costs, and processing speeds across platforms.

Collaborate Across Teams:

• Work with data scientists, analysts, and business stakeholders to understand data needs and provide high-quality, efficient data solutions.

Mentor & Lead:

• Provide technical guidance and mentorship to junior data analysts, fostering their development and ensuring best practices are followed.

Ensure Data Integrity:

• Maintain high standards of data integrity by developing data quality checks, validation rules, and ensuring proper data governance practices are in place.

Problem Solving & Troubleshooting: Resolve complex data issues through detailed analysis, identifying root causes, and implementing long-term solutions to prevent recurrence.
Requirements:
-

Education: Bachelor’s degree in Computer Science, MIS, or a related field, or equivalent experience.

• Experience: 6+ years of experience in data engineering, including hands-on experience with Snowflake and MS SQL databases.
• Snowflake: Strong experience in designing data architectures, optimizing Snowflake warehouses, and leveraging its advanced features (e.g., time travel, zero-copy cloning).
• MS SQL Server: Extensive knowledge of database design, query optimization, normalization, and performance improvements.
• Data Pipeline Development: Proven experience in designing, implementing, and maintaining data pipelines using modern ETL/ELT tools and technologies in tools like Apache Airflow, Talend, DBT, Fivetran or custom Python/Scala pipelines.
• Data Warehousing: Expertise in data warehousing design and management, particularly with Snowflake.
• Programming & Scripting: Proficiency in programming languages such as Python, SQL, and experience working with data processing frameworks.
• Cloud Platforms: Experience with cloud technologies like AWS, Azure, or Google Cloud and their respective data services.
• Extensive experience in developing and delivering reporting and analytics solutions, with a proven track record of utilizing Power BI and other advanced reporting tools to drive data-driven insights.
• Data Quality: Strong experience in ensuring data integrity and quality through validation, testing, and transformation.
• Mentorship: Ability to mentor and provide guidance to junior team members, fostering a culture of learning and development.
• Performance Tuning: Expertise in query optimization, database tuning, and enhancing performance in large-scale data environments.
• Analytical & Problem-Solving Skills: Excellent analytical skills with a strong focus on troubleshooting and resolving data issues.
• Communication Skills: Strong verbal and written communication skills, with the ability to articulate technical concepts to both technical and non-technical stakeholders.

Physical Requirements: The physical demands described here are representative of those that are required by an employee to successfully perform the essential functions of this job. · While performing the duties of this job, the employee is regularly required to talk or hear. The employee is frequently required to sit; stand; walk; use hands to finger, handle or feel; as well as reach with hands and arms. · The employee must frequently lift and/or move up to 15 pounds and occasionally lift and/or move up to 35 pounds. Specific vision abilities required by this job include close vision, distance vision, depth perception and ability to adjust focus. · Ability to work in open environment with fluctuating temperatures and standard lighting.· Ability to work on computer and mobile phone for multiple hours; with frequent interruptions.· Required to use stairwells to attend meetings and engage with employees on multiple floors throughout building.
Other Considerations: Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice. Reasonable accommodations may be made to qualified individuals with disabilities to enable them to perform the essential functions of the role.
CompensationStarting annual salary: $120,000-$130,000. Exact compensation may vary based on skills, experience, and location

ABOUT THE ROLE:

We are seeking a Sr. Data Engineer with extensive experience in designing and implementing data architectures in Snowflake and MS SQL Server, as well as working with multiple database platforms for varied business use cases. This role focuses on building robust data pipelines, optimizing data structures, and ensuring high-performance data solutions that meet the needs of a data-driven organization. This individual embraces and supports our in-person/on-site work culture and embodies our company values of Ownership, Collaboration and Respect.