Data Warehouse Engineer

Equifax Boise , ID 83701

Posted 2 months ago

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.

Qualifications:

  • 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?

  • Accountability

  • Bravery

  • Curiosity

  • Collaboration

  • Think and act differently

  • Trust

  • Ownership

  • Decide-Execute-Ship

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

Primary Location:

USA-ID-Boise

Function:

Function - Data and Analytics

Schedule:

Full time

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Technical Support Engineer Vmware Tanzu Data Services Opportunity For Working Remotely

Vmware, Inc.

Posted 2 weeks ago

VIEW JOBS 9/29/2021 12:00:00 AM 2021-12-28T00:00 * The Staff Technical Support Engineer is a key role in VMware's new exciting Modern Applications Business Unit (MAPBU) team comprised of products and services under the Tanzu portfolio (TeamTanzu) to help customers build, run and manage their most important applications. We build applications with velocity to run in a cloud-native environment, to run open-source Kubernetes with consistency and manage our customers' entire footprint with confidence to help them achieve their business outcomes. We are looking for engineers who want to make a lasting impact on our enterprise-grade database and analytics offerings, VMWare Tanzu Greenplum, VMware Tanzu SQL (MySQL & Postgres). * You You understand enterprise customers' expectations of the technical support experience and judge your success by the success of your team and the happiness of your customers. Maybe you're interested in working directly with enterprise clients to replicate, troubleshoot, and resolve their technical issues, or perhaps you enjoy working under pressure, helping people in high impact situations. Either way, you thoughtfully assist each customer by listening, connecting the dots, documenting the situation and solution, and escalating when appropriate. You bring analytical, troubleshooting, and problem-solving skills and you are interested in continuously improving yourself, our support systems and products by taking training, reporting defects, and collaborating with R&D and operations to triage customer issues. * Us In VMware Support, we are passionate about providing our software customers with the highest level of service. We work in small teams around the globe, supporting customers 24x7. We believe in doing the right thing and working at a sustainable pace; typically 8 hours each day with occasional weekend support rotations. We are passionate about our people, building on individual strengths, and encourage continuous learning and certifications. And, when you're off work, we want you to relax, recharge, and refocus. * Your Day. * Apply in-depth knowledge to troubleshoot complex technical issues around VMware Tanzu Data Services products * Plan, design, develop, and test software systems and applications for software enhancements and new products. * Contribute to the design of architecture, features and enhancements, * Work with Engineering teams to prioritize upcoming fixes and patches. * Responsible for Customer Escalation triage and facilitation, business review preparation, and Product Release Readiness programs. * Required Skills / Experiences * Ability to analyze, diagnose, replicate, troubleshoot, and resolve standard to highly complex technical issues * Familiarity with Networking in Linux environments * Troubleshooting skills in Linux environments (pstack, strace, gdb, etc.) * Familiarity with PostgreSQL or similar technologies (psql, patroni HA, etc.) * The ability to juggle conflicting priorities and demands, and deliver on time * Strong communication skills. * Highly developed interpersonal skills: team player attitude, self-motivation and proactive attitude * 5+ years of experience in a job or computer-related occupation. * Desirable Skills / Experiences * Production DBA experience including patching and upgrades is a plus * Work experience with distributed MPP systems (i.e. Greenplum, Netezza, Teradata) is a plus * Kubernetes and container technologies knowledge is a plus * Strong knowledge of data normalization and data relationships * Technical degree (Computer science, Telecommunications or similar), experience in a related role is a plus Category : Client Support Subcategory: Technical Support Experience: Manager and Professional Full Time/ Part Time: Full Time Posted Date: 2021-07-27 VMware Company Overview: At VMware, we believe that software has the power to unlock new opportunities for people and our planet. We look beyond the barriers of compromise to engineer new ways to make technologies work together seamlessly. Our cloud, mobility, and security software form a flexible, consistent digital foundation for securely delivering the apps, services and experiences that are transforming business innovation around the globe. At the core of what we do are our people who deeply value execution, passion, integrity, customers, and community. Shape what's possible today at http://careers.vmware.com. Equal Employment Opportunity Statement: VMware is an Equal Opportunity Employer and Prohibits Discrimination and Harassment of Any Kind: VMware is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment. All employment decisions at VMware are based on business needs, job requirements and individual qualifications, without regard to race, color, religion or belief, national, social or ethnic origin, sex (including pregnancy), age, physical, mental or sensory disability, HIV Status, sexual orientation, gender identity and/or expression, marital, civil union or domestic partnership status, past or present military service, family medical history or genetic information, family or parental status, or any other status protected by the laws or regulations in the locations where we operate. VMware will not tolerate discrimination or harassment based on any of these characteristics. VMware encourages applicants of all ages. Vmware will provide reasonable accommodation to employees who have protected disabilities consistent with local law. Vmware, Inc. Boise ID

Data Warehouse Engineer

Equifax