Affirma, five years in a row ranked "Best Companies to Work for" and "Fastest Growing Companies" in Washington is seeking a Data Engineer to join our growing Data & Analytics team. This individual will support Affirma’s mission to provide exception value to our clients by planning, executing, and deploying data management solutions.

This role requires candidates to reside in Washington State*

Qualifications

• 2-4 years experience in dimensional data modeling, ETL development, and data warehousing in a professional capacity
• Hands-on experience with a variety of leading ETL, database, or data warehousing technologies like Azure, SQL Server, Databricks, SSIS, Data Factory, etc.
• Strong knowledge of relational databases including retrieving, manipulating, creating, updating, and deleting data and database objects
• Experience bringing together data from many disparate data sources to a unified source of truth
• Hands-on experience implementing data warehouses of any scale and understanding of data warehousing best practices
• Advanced knowledge of T-SQL and Python in developing complex queries, stored procedures, functions, and database administration operations, and query optimization and tuning
• Ability to work in a dynamic environment with some level of ambiguity to implement customer and project requirements with minimal supervision
• Excellent written and verbal communication with stakeholders, team members, and in documentation
• Bachelor’s degree or equivalent education and/or experience

Responsibilities

• Design, propose, and develop database and data warehousing solutions
• Collaborate with team members to refine and debug scripts and reports
• Write and maintain documentation to describe database development, logic, scripting, testing, changes, and corrections
• Support the release of solutions into production environments
• Balance shifting priorities, demands, and timelines while effectively communicating expectations to team members and stakeholders in a clear and timely fashion
• Provide technical to assistance to data consumers regarding errors, problems, or questions with databases and reports
• Provide thought leadership, best practices, and standards required to deliver effective, lasting, and easy-to-maintain solutions to clients
• Continuously grow depth and breadth of knowledge of leading data and analytics tools and principles

Preferred experience includes:

• Background in computer science or related technical field
• Experience working with Big Data tools like Hadoop

Accountabilities and Measures

• Keeping our clients happy
• Working and collaborating well with internal and external team members
• Adhering to billable and un-billable policies

Compensation & Benefits:
$120,000-$145,000 Dependent on Experience

Benefits

• Paid Time Off (PTO)
• Paid Holidays
• 401(k) Retirement Plan
• Health, Dental, Vision, Life, as well as, Short-Term and Long-Term Disability insurance
• Monetary assistance with training and certifications
• Referral Bonus

Affirma is an Equal Opportunity Employer and does not make employment decisions or otherwise discriminates based on race, creed, color, national origin, sex, military status, sexual orientation, or the presence of any sensory, mental, or physical disability, genetic information, or any other category protected by law.