Lead Business Intel Data Warehouse Engineer

  • DexYP,
  • Dfw Airport/grapevine, TX
  • 3 hours ago
company banner
Business Intelligence, Data Warehouse, Engineer, IT, System, Software, Engineers, Informatica, Business Objects, SQL, UNIX, Oracle, Microstrategy
Full Time
Work from home not available Travel not required

Job Description


The Lead - Business Intelligence / Data Warehouse Engineer will consolidate and modernize existing legacy data warehouses to meet current and future growth needs. Working with business partners, infrastructure, data scientists as well as BI developers to solve large scale integration and analytics problems.

As a key technical leader, advocate for empowering and enlightening business leaders and technical peers with the power of data and a well-architected warehouse in a dynamic environment.


You will be responsible as the data warehouse architect for the design, configure, operation and maintenance for a unified enterprise data warehouse with Kimball best practices on an appliance DW environment.

You will evaluate existing environment including hardware, software, tools, web portals, internet and intranet connections, firewalls, servers, size and data needs, user experience, security and budget to determine best approach for the consolidated data warehouse.

You will also be responsible for designing and implementing short and long-term strategic goals for managing and maintaining data warehouses and associated software and tools. In addition, all planned and in-place system architectures are aligned with the specific Thryv's business goals for data and reporting.

Design and support the implementation of big data ingestion into the EDW and Hadoop clusters.

Provide expertise and architectural assistance to other IT personnel including software teams, Data Scientists, System Analysts and Software Engineers. Conduct research on new Business Intelligence and Data Warehouse technologies and create and develop plans for investing in such systems that will increase cost effectiveness and flexibility.

Leads key development efforts, overseeing others as well as contributing hands-on development for Informatica, Hadoop, Vertica and reporting tools such as Business Objects, MicroStrategy or Power BI.

Actively works with infrastructure to ensure needed cross-system integrations properly engineered, capacity planning and other data base administration tasks.

Ensure system's integrity for each source and target through various checks and balances. Focus design and development to maximize system's performance and reliability.

Works with Product Owners and Data Scientists to anticipate and support research and data needs with a focus on empowered self-service to these key constituents:

• Evangelist for BI - Protect, support, exposes and share with others to get more usage and value of the data and help others turn it into knowledge and insight.

• Supports leadership with due diligence/acquisition support from data integration aspects.

• Demonstrated ability and strength to plan a next-gen solution architecture within an existing data warehouse environment.

• Demonstrates ability to plan and model data integration processes

• Create and present to senior leaders relevant BI topics/issues. Represent Thryv with presentations as needed to industry/peer groups on BI/DW topics/expertise.


• Master's degree or equivalent experience.

• 10+ years of enterprise data warehouse implementation and development with focus on systems integration. Demonstrate proficiency in multiple terabyte environments (15TB+). Extensive SQL language expertise.

• This position is 70% Hands-on:

o 5+ years of Informatica or other relevant ETL tools

o 5+ years UNIX shell and scripting experience

o 5+ years of multi-terabyte (15TB +) warehouse development/support with data warehouse appliance applications i.e. Vertica or Netezza.

o 5+ years of Oracle database experience

o 3+ years of data modeling experience on Kimball/dimensional modeling

o 2+ years of Salesforce (SFDC) experience

o 2+ years of Hadoop/MapReduce 40% hands on experience

o 1+ years Cloud technology involving AWS Data architecture and Data Lake projects

o 1+ year of development experience with Microstrategy, Microsoft SSRS/SSAS, or other BI tools

• Strong verbal and written skill with proven experience in persuasion and consensus building

• Familiarity with industry best practices in software and solutions development

• Outgoing and comfortable with strong opinion leaders and teammate's

• Proven passion and experience as an advocate of BI solutions to empower higher-order business insights and actions

• Conduct reviews with department heads and end-users to ensure optimal operation and further infrastructure development if required.

Thryv is an equal opportunity employer.

Company Information

At DexYP, we champion and empower our clients to thrive in today's competitive environment and we feel good about that. We specialize in providing them the tools they need to compete against the big guys, the national chains that are dominating the marketplace. These tools will save them time, money and keep them connected with their customers, wherever they may be. They also allow them the ability to control their operations at anytime, anywhere, from the palm of their hand. Why choose DexYP? Our team members are our most valued asset. We give them the chance to grow their skill set and take their career as far as possible. You'll work hard, make great money and have fun doing it. You'll be a part of a strong and stable company that’s current client base exceeds 700,000. With our flagship customer relationship management software "Thryv", we continue to grow and evolve to stay on the cutting edge of technology and meet the ever-changing needs of local business. You'll feel good about what you do and that you’re making a difference by supporting local business across the country to help ensure they continue to succeed.
Dice Id : 10237745
Position Id : 19-0098
Originally Posted : 2 months ago