DataWarehouse Engineer at W2O Group

| Austin
Sorry, this job was removed at 12:59 p.m. (CST) on Monday, August 10, 2020
Find out who's hiring in Austin.
See all Data + Analytics jobs in Austin
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Datawarehouse Engineer

Recently named Best Place to Work by MM&M, The Holmes Report, PR News, PRWeek, and AdAge, W2O is an integrated marketing and communications firm powered by analytics and specializing in healthcare.  We are currently seeking a talented Datawarehouse Engineer to join our growing team of pharmaceutical advertising, technology and data professionals. This is a great opportunity to join a dynamic, fast-growing global agency. This role may be seated in the Austin, Florham Park, NJ or Chicago offices of W2O.


The Datawarehouse Engineer designs, implements and maintains data warehousing and data management solutions to support aggregation of heterogeneous data sets and execution of analytical requirements. This includes building source system data processes, verifying data accuracy, and designing complex interactions between data fields within the data management solution. The Datawarehouse Engineer develops data set processes for data modeling, mining, and production, and create custom software components and analytics applications. The Datawarehouse Engineer is expected to anticipate business needs by designing and building custom queries and front-end reports that provide actionable insight to end-users.


  • Designing, maintaining, and enhancing data warehousing systems
  • Designing, building and maintaining feeds for new and existing data sources
  • Ensuring ongoing accuracy of data feeds, monitoring for changes in the source systems which may alter inbound data
  • Experience in large scale data warehousing and data lake including analysis, design, architect and development of complex transformation and mappings & design using, data stage and data services
  • Deep knowledge leading large data warehouses implementations, working as data architect/modeler and a workstream leader
  • This role holds key the responsibility for the technical data integration and metadata management functions within a large-scale implementation project.
  • Experience in significant data integration architectures, design, DBA, and development hands-on experience within a data warehousing environment, and very strong working experience with both technical and business metadata and metadata catalogs.
  • Proficient in developing POCs to validate new architectures and solutions, evaluate new tools based on the company’s data.
  • Hands on experience in production support process, analyses issues and identify opportunities to improve the existing process and to resolve issues.
  • Experience with Disaster management and mitigation
  • Established, advocated, and enforced data management best practices, principles, and standards for performance, reliability, scalability, security, and reusability at an enterprise scale.
  • Knowledge in Data Warehousing techniques for Data Cleansing, Slowly Changing Dimension phenomenon (SCD), surrogate key
  • Deep understanding of Data Governance, Data Strategies, Data Analytics, Data Integration, Data Architecture, Data Manipulation, Data Analysis, Data Mappings, Data Profiling, Data Strategy, Data Mining and Data Quality Improvement.
  • Working experience in various reporting tools.
  • Building appropriate linkages and relationships between data fields within data warehouse
  • Creating and maintaining source-of-truth relationship tables for key fields to be referenced throughout a data warehouse.
  • Implementing a standard nomenclature for use within a data warehouse, in accordance with established Business Intelligence policies.
  • Documenting all metadata regarding data source, field type, definition, etc. for each field and table created.
  • Serving as a subject matter expert on data sources, structure, or definitions.
  • Working with knowledge management experts to optimize data and information usage.
  • Working with Information Systems teams to optimize the data warehouse through hardware or software upgrades or enhancements.
  • Structuring data in a way that is easy to understand, query, and display.
  • The ideal candidate will have strong analytical and programming proficiencies and proven expertise in high-dimensional data-analysis.
  • Collecting, organizing, analyzing, and disseminating significant amounts of information with attention to detail and accuracy
  • Developing, designing, and automating regular reports accurately and on a timely basis
  • Designing and building ad-hoc reports that provide actionable and meaningful information
  • Responding to analytics inquiries from various entities by identifying data that will provide appropriate and actionable answers.
  • Identifying, analyzing, and interpreting trends or patterns in complex data sets and connecting those trends to actionable insights and business needs.


  • Masters or Ph.D. in Computer Science, Biomedical Informatics, Mathematics or other relevant quantitative discipline.
  • 5+ years minimum Hands-on experience in a variety of data warehouse implementation and management technologies, techniques, and concepts
  • Familiarity with Azure, AWS, and NoSQL database systems, such as MongoDB and CouchDB
  • Proven ability to work with experts in natural language processing and knowledge management
  • Good organization and communication skills, with demonstrated ability to productively work as a member of a team. Strong verbal and written communication skills in English are required
  • Knowledge and experience with software engineering best practices such as: version control, code review, unit/regression testing, continuous development/continuous integration.

W2O Group offers a comprehensive benefit program and perks, including unlimited and flexible PTO, expanded paid leave for new parents including a 4th Trimester program that helps new parents transition back to work, and a five-week sabbatical program.  Other perks include Income Protection, Retirement plans/401(k) match, and cell phone savings plans.  Learn more about our great benefits and perks at:

W2O Group is an Equal Opportunity Employer. We foster an environment that embraces diversity. We are stronger with a wider range of opinions, strengths, and backgrounds to achieve our goals.

Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
    • C#Languages
    • JavaLanguages
    • PHPLanguages
    • PythonLanguages
    • RLanguages
    • jQueryLibraries
    • jQuery UILibraries
    • ReactLibraries
    • HadoopFrameworks
    • LaravelFrameworks
    • Node.jsFrameworks
    • CassandraDatabases
    • HiveDatabases
    • PostgreSQLDatabases


We're located in East Austin, an area flourishing with new, unique businesses. We're neighbors with dozens of restaurants, food trucks and bars.

An Insider's view of W2O Group

What’s the vibe like in the office?

With Covid 19, W2O has fully embraced the work from home culture. We connect with each other daily, but most importantly we are treated as professionals, and we are all given the freedom to do our best work. If anything, this drives all of us. Empowered is not just a buzz word here at W2O, it's how we are all treated and it's who we are!



How does the company support your career growth?

One of our core values at W2O is "Make it Happen." This has been true to our culture since Day 1. W2O has a wonderfully entrepreneurial spirit - especially in Austin. As employees, we are always encouraged to chart our own path to better the business and ourselves. There's no template for career growth here. Just passion, grit and a good attitude!


Senior Account Director

How do your team's ideas influence the company's direction?

The technology team at W2O drives digital transformation for our customers, as our business evolves from a traditional professional services firm into a technology provider. This puts the team in the enviable position of being able to strongly guide the direction of the organization toward a new frontier in our industry.


Chief Technology Officer

What are W2O Group Perks + Benefits

W2O Group Benefits Overview

W2O has some of the best benefits in the industry - comprehensive and complete!

Volunteer in local community
W2O encourages giving back and supports employees in all our offices.
Friends outside of work
Eat lunch together
Intracompany committees
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Dedicated Diversity/Inclusion Staff
Diversity manifesto
Someone's primary function is managing the company’s diversity and inclusion initiatives
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Retirement & Stock Options Benefits
401(K) Matching
W2O provides employees with a 401(k) matching plan managed by [provider]. We match 50% of contributions up to 6% of an employee's annual gross pay.
Performance Bonus
There is an Annual Performance Bonus, paid out in March
Child Care & Parental Leave Benefits
Generous Parental Leave
We provide up to 5 weeks of parental leave for the primary caretaker. Acme Co. also provides 5 weeks of leave for the secondary caretaker.
Flexible Work Schedule
W2O provides employees with a flexible work schedule that includes the ability to work from Home when needed.
Return-to-work program post parental leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Eligible employees get 30 days of paid sabbatical after their first 5 years of working at the company.
Paid Holidays
Paid Sick Days
Employees receive 10 hours per year of paid sick leave.
Perks & Discounts
Casual Dress
Commuter Benefits
Free Daily Meals
Stocked Kitchen
Happy Hours
Pet Friendly
Acme Co.'s pet policy is dog friendly daily.
Fitness Subsidies
$200 per year provided for Staff Employees to spend on a Healthy product or activity.
Professional Development Benefits
Job Training & Conferences
W2O offers employees professional development opportunities like Onsite training courses and the ability to attend job related conferences and seminars.
Diversity Program
Lunch and learns
W2O hosts lunch and learn meetings.
Cross functional training encouraged
Promote from within
Mentorship program
Our mentorship program includes 1-to-1 program, Cross-department program, Career mentoring, Leadership mentoring.
More Jobs at W2O Group17 open jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView W2O Group's full profileSee more W2O Group jobs