What are the responsibilities and job description for the Senior Data Engineer position at Crosscheck Staffing?
We are seeking a skilled Data Engineer to design, develop, and optimize our data pipelines and infrastructure. The ideal candidate will have experience working with Snowflake, Matillion, DBT, and Power BI to support data transformation, analytics, and reporting needs. You will collaborate with data analysts, business intelligence teams, and stakeholders to ensure seamless data integration and availability for decision-making.
Key Responsibilities:
- Design, develop, and maintain ETL/ELT pipelines using Matillion to integrate data from various sources into Snowflake.
- Develop and optimize data models using DBT (Data Build Tool) to enable efficient data transformations and analytics.
- Ensure data quality, consistency, and reliability through rigorous validation and monitoring techniques.
- Collaborate with business intelligence teams to build and maintain Power BI dashboards and reports.
- Optimize Snowflake performance, including query tuning, warehouse optimization, and cost management.
- Implement data governance, security best practices, and compliance standards.
- Work closely with cross-functional teams to understand business requirements and provide data-driven solutions.
- Monitor and troubleshoot data pipeline failures, ensuring system reliability and efficiency.
- Document technical processes, data flows, and best practices.
Qualifications:
- 3 years of experience in data engineering, ETL development, or cloud data warehousing.
- Strong expertise in Snowflake, including schema design, performance tuning, and security best practices.
- Hands-on experience with Matillion for building ETL/ELT pipelines.
- Proficiency in DBT for data transformations and model development.
- Experience with Power BI for reporting, dashboard creation, and data visualization.
- Strong proficiency in SQL, including query optimization and data manipulation.
- Familiarity with Python or other scripting languages for data processing is a plus.
- Experience working with cloud platforms such as AWS, Azure, or GCP is desirable.
Salary : $120,000 - $170,000
