Snowflake Data Engineer

Position Title: Data Engineer (Snowflake) Status: 6 month contract (with strong possibility of converting permanent) Pay: Up to $55.00 per hour ($110,000 - $130,000 annually should they be converted after 6 months) Location: Remote (must be willing to work 7:45am – 430pm Mountain Time) - two other Data Engineers on the team live in Denver and would be ideal to have the 3rd there as they meet up sometimes for lunch – not required though. • Strong Communication skills • Must be a US Citizen with strong communication skills • 2 years of experience working within Snowflake or an equivalent combination of education and experience sufficient to perform the essential functions of the job. • 5 years of related experience as a Data Engineer or similar role • Technical expertise with data pipelines, API management, data models, and data warehouses • Working knowledge of programming languages (e.g. Java and Python) • Hands-on experience with SQL database design JOB DESCRIPTION: Our client is seeking a Data Engineer for contract opportunity (with possibility of going permanent). The Data Engineer builds and optimizes the association’s data and data pipeline architecture. This includes data flow and collection, ensuring consistent architecture throughout. The incumbent’s work is varied, supporting multiple teams, systems, and projects. Staying up-to-date with data engineering tools and technologies, including cloud-based data services, is essential for this position. DUTIES: Data Storage • Designs, optimizes, and maintains databases for efficient data storage and retrieval. • Manages data warehouses or data lakes to ensure accessibility and reliability of data. • Develops and maintains data models and schemas that support analytics and reporting. • Manages our Snowflake instance to provide business and regulatory report on our portfolio and ancillary services from initial contact to post loan closure. Data Architecture • Builds and maintains data pipelines to move, transform, and load data from various sources to a centralized repository. • Optimizes data infrastructure and pipelines for speed, scalability, and cost-effectiveness. • Designs, publishes, documents, monitors, secures, and analyzes Application Programming Interfaces (APIs). • Creates ETL (Extract, Transform, Load) processes to clean, transform, and prepare data for analysis. Data Quality • Ensures data completeness, integrity, and security through validation, monitoring, and governance practices. • Normalization of data to eliminate duplications and ensure single source of truth. Data Collaboration • Works closely with stakeholders to understand data needs and provide access to relevant data. • Creates documentation and provides support to help others understand and use the data infrastructure effectively. Data Security and Confidentiality • Appropriately protects the confidentiality, security, and integrity of the Association, employees, borrowers, and other stakeholders REQUIRMENTS: • Bachelor’s degree in computer science, IT, or related field • 5 years of related experience as a Data Engineer or similar role • 2 years of experience working within Snowflake or an equivalent combination of education and experience sufficient to perform the essential functions of the job. • Technical expertise with data pipelines, API management, data models, and data warehouses • Working knowledge of programming languages (e.g. Java and Python) • Hands-on experience with SQL database design • Demonstrated analytical skills • Demonstrated skill in interacting and collaborating with others • Skill in oral and written communication, sufficient to discuss a variety of job-related topics, and to effectively communicate complex topics to a variety of audiences • Skill in utilizing a systematic approach to problem solving • Skill in researching information to gain knowledge to apply to business challenges • Skill in advising and guiding individuals to achieve results