website-hero-image2

2278 Senior Database Engineer (SQL)

Location: Portland, OR

Description:
Our Partner/Client is a leading provider of cutting-edge prepaid products, services, and transaction technologies to retailers, brands, and consumers. They support nearly 500,000 points of distribution and help retailers build prepaid card destinations, connect brands with new markets, and give consumers a simple, secure shopping experience. They are redefining the connection between merchants and their customers through stored value and mobile gifting solutions. A pioneer of digital gift card delivery, their platform supports gift cards sales through e-commerce, social media, promotional, and B2B toolsets. If you'd like to be a part of this please send your resume to careers@itmotives.com. We value diversity in the workplace and encourage women, minorities, and veterans to apply. Thank you!

Job Type: FTE

Additional Information:
Benefits of joining their team:
- Opportunity to solve interesting and challenging problems within a growing industry
- Collaborative and supportive Agile environment
- Continuous delivery culture and weekly production releases
- Community of strong software professionals
- Opportunities for career growth
- Downtown high-rise location with lots of windows and good views
- Healthy work environment, including in-suite bike storage, showers, and standing desks
- Company provided snacks and catered lunch and breakfast once a week
- Easy access to public transportation and company provided transit pass

Responsibilities
- Designing and developing enterprise data warehouse, reporting, and business intelligence solutions using Microsoft technologies
- Working with our product organization and business stakeholders to understand business requirements and objectives
- Collaborating with product development teams on integrating transactional systems with enterprise reporting solutions
- Contributing to overall enterprise reporting architecture strategy and design
- Supporting and enhancing existing reporting solutions
- Leading by example and setting a high standard for quality
- Performing code and design reviews
- Participating in an agile team and fostering collaboration and innovation across our development organization

Qualifications
Required:
- Excellent relational database design and development skills
- Experience with Microsoft SQL Server, SSIS, SSRS, and SSAS
- Strong query performance tuning and optimization skills
- Experience creating and modifying SQL stored procedures, functions, and views
- Experience with data warehouse modeling methodologies (e.g. Kimball, Inmon, or Data Vault)
- Experience designing and building ETL and/or ELT pipelines
- Experience designing and developing multi-dimensional schemas
- Experience developing self-service reporting solutions
- Experience integrating, configuring, and managing BI toolsets
- Willingness to dive into any challenge with a positive attitude
- Solid coaching and communication skills
- Excellent troubleshooting skills
- Works well in both team and individual development environments
- Experience with agile development practices

Preferred:
- BS or MS in Computer Science or related field
- Excellent working knowledge of data analysis concepts and processes
- Strong knowledge of data structures and algorithms
- Experience with data visualization toolsets like Power BI or Tableau
- Experience with Git or other DVCS
C# and the .NET Framework (v4.5)
- Knowledge of data access technologies like ADO.NET or an ORM such as EF or Dapper
- Experience working in continuous integration and continuous delivery environments
- Experience working in a microservices architecture
- Familiarity with design patterns and principles
- Experience with unit testing and Test-Driven Development
- Experience working with HIPAA and/or PCI data