Data Warehouse Developer

TSheets is proudly owned by Intuit and powered by QuickBooks. Our team of 275 rock stars has joined forces with Intuit’s over 8,000 brilliant individuals who share our passion to innovate and deliver excellence. TSheets and Intuit share an obsessive customer-centric vision. As one company, we will provide a seamless experience and better tools to run your business.

TSheets set up shop in a little-known tech hub: Eagle, Idaho. We are surrounded by rolling foothills and mountain slopes with the 25-mile Boise River greenbelt running through our backyard. Idaho is a place for those who really know how to work hard and play harder.

Join us on our relentless mission to become the #1 employee-rated and requested time tracking and scheduling software solution on the planet!

Role Description:
Are you passionate about data? Do you enjoy architecting and building data models that help uncover insights? Does the thought of ETL, star schemas, and creating stable data structures put a smile on your face? Do you find yourself wishing you could work in a data-driven environment where your efforts will have an impact on the success of clients and coworkers?

In addition to data challenges, we are a tight-knit team that supports each other in every way we can. Joiningour team ( http://www.tsheets.com/about/our-team ) means making meaningful contributions and quickly seeing those contributions come to fruition.

Responsibilities:

• Work with stakeholders including the executive, product, data and design teams to understand business processes and support their data infrastructure needs.
• Provide functional and technical subject matter expertise in various data management, warehousing, business intelligence and big data solutions.
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS technologies.
• Standardize cross-departmental data definitions, KPIs, and calculations.
• Architect and implement intuitive Kimball-based star schema data models and marts.
• Maintain, troubleshoot, and debug all ETL / ELT processes including complex dependencies across data sources and models.
• Quality check, unit test, and document all new and existing processes.

Why join us?

TSheets set up shop in a little-known tech hub: Eagle, Idaho. We are surrounded by rolling foothills and mountain slopes with the 25-mile Boise River greenbelt running through our backyard. The TSheets team lives, eats and breathes our core values, one of which is: Work really hard; play really hard. We are a dynamic, close-knit team with strong convictions. We also offer an extensive benefits package for all full-time employees including company-paid health benefits. You will be joining a fun, creative, experienced, and bright team, who are passionate about what we create.

Join us on our relentless mission to become the #1 employee-rated and requested time tracking and scheduling software solution on the planet!

Qualifications:

• * Bachelor’s degree in Computer Science or other IT related field
• 5+ years of professional experience as a Data Engineer / Data Warehouse Developer
• Expertise in the following:
• Multiple flavors of SQL (TSQL,PostgreSQL, MySQL, etc)
• Data Sharding
• AWS / Redshift Data Warehouse
• Matillion ETL or other AWS compatible ETL / ELT tool
• Architecting and building Kimball dimensional models and star schemas
• BI tools such as Tableau, Periscope data, SSRS, etc.
• Solid understanding of the software development process, including requirement gathering, analysis/design, development tools/technologies, release/version control, contemporary testing methodologies.
• Strong analytical skills along with the ability to work independently
• Demonstrated understanding of data warehouse design patterns and trends such as dimensional modeling, logical data warehouse and cloud data warehouse.
• Knowledge and experience working with secured and sensitive data and systems such as PII, PCI, and GDRP.
• Excellent attention to detail
• Excellent verbal and written communication skills

Imagine a career where your creative inspiration can fuel BIG innovation. Year-over-year, Intuit has been recognized as a best employer and is consistently ranked on Fortune’s “100 Best Companies To Work For” and Fortune World’s “Most Admired Software Companies” lists. Immerse yourself in our award winning culture while creating breakthrough solutions that simplify the lives of consumers and small businesses and their customers worldwide.

Intuit is expanding its social, mobile, and global footprint with a full suite of products and services that are revolutionizing the industry. Utilizing design for delight and lean startup methodologies, our entrepreneurial employees have brought more than 250 innovations to market – from QuickBooks® and TurboTax®, to GoPayment, Mint.com, big data, cloud (SaaS, PaaS) and mobile apps. The breadth and depth of these customer-driven innovations mean limitless opportunities for you to turn your ingenious ideas into reality at Intuit.