Senior Data Engineer

Overview Corporate Tools is hiring a Senior Data Engineer for up to $150,000/year. You will be a traditional company employee. This is a remote position, but if you're near one of our local offices, you're welcome to come hangout with us in-office as well. Our main offices are in Post Falls, ID, and Spokane, WA; we also have satellite offices in Austin, TX, and Salt Lake City, UT. You'll be working 40 hours a week and, of course, enjoy great company benefits. As a Senior Data Engineer at Corporate Tools, you will work closely with our Software and Analyst teams to manage everything that has to do with data. This role will help get large datasets into the hands of people that need it while also making sure it doesn't adversely impact other things we have going on in our software ecosystem. There will be a heavy focus on infrastructure, data pipelines and scalable database design - we want someone who can help us improve our current databases and infrastructure and maintain it in a cost-effective manner. This is more than just building and maintaining ETL pipelines. We need innovation, creativity, and solutions that will have a significant impact on how our data is handled and created. Wage Up to $150,000 / year Benefits 100% employer-paid medical, dental & vision Full coverage for employees - nothing comes out of your paycheck. Plus an annual review with a raise option. Time off that grows with you 22 days PTO + 4 holidays to start. After 3 years it bumps to 29 days, and after 5 years you move to flexible time off - not accrued, not capped. Take time off when you want. Parental leave & 401(k) match Paid parental leave, plus up to 6% company 401(k) matching with no vesting period - it's yours from day one. Quarterly allowance Spend it on whatever makes work better: a comfier remote setup, continuing-education classes, a plant for your desk, coffee for a coworker, a massage for yourself... really, whatever. No dumb perks (and a trail mix bar) No weekend dog-walking gimmicks that look cool but cost nothing because nobody uses them. We spend on benefits you'll actually use - an open-concept office, friendly coworkers, a creative environment, and yeah... a trail mix bar. Responsibilities Focus on data infrastructure. Lead and build out data services/platforms from scratch (using OpenSource tech). Creating and maintaining transparent, bulletproof ETL (extract, transform, and load) pipelines that cleans, transforms, and aggregates unorganized and messy data into databases or data sources. Consume data from roughly 40 different sources Collaborate closely with our Data Analysts to get them the data they need. Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc. Improve existing data models while implementing new business capabilities and integration points. Creating proactive monitoring so we learn about data breakages or inconsistencies right away. Maintaining internal documentation of how the data is housed and transformed. Improve existing data models, and design new ones to meet the needs of data consumers across Corporate Tools. Stay current with latest cloud technologies, patterns, and methodologies; share knowledge by clearly articulating results and ideas to fellow engineers, data analysts, and stakeholders. Requirements Bachelor's (BA or BS) in computer science, or related field. 2+ years in a full stack development role 4+ years of experience working in a data engineer role, or related position. 2+ years of experience standing up and maintaining a Redshift warehouse 4+ years of experience with Postgres, specifically with RDS. 4+ years of AWS experience, specifically S3, Glue, IAM, EC2, DDB, and other related data solutions. Experience working with Redshift, DBT, Snowflake, Apache Airflow, Azure Data Warehouse, or other industry standard big data or ETL related technologies. Experience working with both analytical and transactional databases. Advanced working SQL (Preferably PostgreSQL) knowledge and experience working with relational databases. Experience with Grafana or other monitoring/charting systems. Proven knowledge of data platforms and tangible examples of designing and developing complex data pipelines to support better decision making in the business. Experience hosting and operating data platforms in cost efficient manner. Ability to translate business requirements into non-technical, lay terms. Proven expertise with data architecture design and deployment, data modeling, and database development. Corporate Tools