Data Warehouse Engineer : The Data Warehouse Engineer implements dimensional models, from building the logical model to implementing the physical model and loading the data with ETL. The engineer makes big data easy through intuitive query writing, performance, and integrating BI tools. They run the full DW stack from design through implementation.
Who is Kount?
Kount, an Equifax Company, delivers digital fraud prevention and account protection for more than 9,000 leading brands and payment providers. Linked by Kount's award-winning AI, the Identity Trust Global Network analyzes signals from 32 billion annual interactions to personalize experiences across the spectrum of trust - from ensuring frictionless experiences to blocking fraud. Quick and accurate identity trust decisions deliver safe payment, account creation, and login events while reducing digital fraud, chargebacks, false positives, and manual reviews.
At Equifax, we believe knowledge drives progress. As a global data, analytics and technology company, we play an essential role in the global economy by helping employers, employees, financial institutions and government agencies make critical decisions with greater confidence.
We work to help create seamless and positive experiences during life's pivotal moments: applying for jobs or a mortgage, financing an education or buying a car. Our impact is real and to accomplish our goals we focus on nurturing our people for career advancement and their learning and development, supporting our next generation of leaders, maintaining an inclusive and diverse work environment, and regularly engaging and recognizing our employees. Regardless of location or role, the individual and collective work of our employees makes a difference and we are looking for talented team players to join us as we help people live their financial best.
The perks of being an Equifax employee?
We offer excellent compensation packages with market competitive pay, comprehensive healthcare packages, 401k matching, schedule flexibility, work from home opportunities, paid time off, and organizational growth potential.
Grow at your own pace through online courses at Learning @ Equifax.
What you'll do:
Extract use cases and requirements from data warehouse users.
Work with users to mock up dashboards and proof of concept data models.
Design dimensional data models that satisfy data requirements and address ease of use and performance.
Instantiate the dimensional data models on the Snowflake cloud platform.
Design and build out monitoring and support elements to ensure data quality and timeliness.
Bachelor's degree in Computer Science, Information Systems.
5+ years of experience with Data Warehousing: proven relational database design & build.
Minimum of three years of experience implementing dimensional data models (star schemas).
5+ years of strong SQL , MPP data warehouse platforms (Redshift, Netezza, Teradata or similar), Python, Big Data
Experience with building data warehouses on cloud infrastructure is preferred.
Extra points for any of the following:
Experience with performance tuning data warehouse queries. That involves SQL tuning and an understanding of how MPP architectures work.
Strong analytical skills with high attention to detail and accuracy
Experience designing and implementing on the Snowflake platform
Outstanding problem solving skills
Strong organizational, multi-tasking, and prioritizing skills
Success attributes of an Equifax employee; does this describe you?
Think and act differently
We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.
If this sounds like somewhere you want to work, don't delay, apply today - we're looking for you
Function - Data and Analytics