Data Engineer

About the role

We are seeking a skilled Data Engineer to join our dynamic team at Clayco. As a Data Engineer, you will play a crucial role in building and operating a Snowflake data lakehouse that supports reporting, advanced analytics, and AI initiatives.

Responsibilities

• Design, build, and maintain data pipelines from various source systems into a Snowflake data lakehouse.
• Analyze data elements, data flow, dependencies, and relationships from different systems and assist in designing conceptual, physical, and logical data models.
• Develop complex data sets to fulfill diverse business needs in reporting, advanced analytics, and ad-hoc analysis.
• Cook up and execute data migrations across systems, such as SQL Server to Snowflake or other cloud data platforms.
• Develop and implement scripts for data lakehouse maintenance, monitoring, and performance tuning.
• Implement data quality checks, anomaly detection, and SLAs.
• Maintain metadata and documentation.
• Assist various business and technical stakeholders with data-related technical needs and issues.
• Collaborate closely with cross-functional teams to understand and transform business requirements into scalable and manageable data solutions.
• Present solutions and options to leadership, project teams, and stakeholders, adapting the communication style to both technical and non-technical audiences.
• Ensure adherence to documented design and development patterns and standards within the team.
• Proactively monitor and resolve ongoing production issues.
• Promote the approach of self-service data solutions and enable other teams with analytics solutions delivery through a 'Data as a Service' model.
• Make data AI-ready by translating business knowledge into a semantic layer.

Requirements

• Hands-on experience in designing, developing, and implementing data solutions.
• Advanced SQL knowledge with strong query writing and stored procedures skills.
• Strong experience with relational databases such as Snowflake, SQL Server, or Oracle.
• Proficiency in object-oriented/object function scripting languages such as Python, Java, Scala, etc.
• Basic knowledge and understanding of Azure cloud services.
• Basic knowledge and understanding of stream-processing systems.
• Experience with data analysis, ETL, and workflow automation.
• Experience with AI systems both for personal productivity as well as business enablement.

Qualifications

No other builder can offer the collaborative design-build approach that Clayco does. We work on creative, complex, award-winning, high-profile jobs. The pace is fast!

Benefits

• Discretionary Annual Bonus: Subject to company and individual performance.
• Comprehensive Benefits Package Including: Medical, dental and vision plans, 401k, generous PTO and paid company holidays, employee assistance program, flexible spending accounts, life insurance, disability coverage, learning & development programs and more!

Pay

The salary range for this position considers a wide range of factors in making compensation decisions including but not limited to: Education, qualifications, skills, training, experience, certifications, internal equity, and location. Compensation decisions are dependent on the facts and circumstances of each case.

Schedule

Flexible schedule to accommodate the fast-paced nature of the role.