DataWarehouse Engineer at Real Chemistry

| 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.

Role: 

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.

Responsibilities

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

Experience

  • 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: http://www.w2ogroup.com/

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

Location

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 Real Chemistry

What’s the vibe like in the office?

With Covid 19, Real Chemistry 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. Empowered is not just a buzz word here at Real Chemistry, it's how we are all treated and it's who we are!

John

Director

How does the company support your career growth?

One of our core values at Real Chemistry is "Make it Happen." This has been true to our culture since Day 1. Real Chemistry has a wonderfully entrepreneurial spirit . 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

Alexandra

Senior Account Director

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

The technology team at Real Chemistry 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.

Manoj

Chief Technology Officer

What are Real Chemistry Perks + Benefits

Real Chemistry Benefits Overview

Real Chemistry offers a comprehensive benefit program and perks, including flexible PTO, expanded paid leave for new parents including Your 4th Trimester ® , a 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: http://www.realchemistry.com/

Culture
Volunteer in local community
Real Chemistry 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
Diversity
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)
Real Chemistry offers pre-tax flexible spending accounts to help offset eligible Healthcare (including Limited Purpose) expenses.
Disability Insurance
Real Chemistry offers Short Term and Long Term Disability.
Dental Benefits
Base & Buy Up options available.
Vision Benefits
Base & Buy Up options available.
Health Insurance Benefits
Real Chemistry offers 2 High Deductible plans (HDHP), 1 PPO plan and a CA specific HMO plan for employees and their dependents (legal spouse, domestic partner (regardless of gender) and/or children).
Life Insurance
Real Chemistry offers Basic & Voluntary Life and AD&D.
Pet Insurance
Real Chemistry offers pet insurance through Nationwide to cover out- of-pocket expenses associated with veterinary costs. Rates may vary by state and plan.
Wellness Programs
$500 annual benefit to use for wellness related expenses such as gym memberships, health wearables, diet programs, fitness classes, etc.
Mental Health Benefits
Real Chemistry offers a confidential EAP, tele-counseling services, weekly mindful and guided meditation, and a partnership with a wellness app.
Retirement & Stock Options Benefits
401(K) Matching
Real Chemistry employees may enroll into a pre-tax or Roth 401(k). Company match is $.50 on the dollar of the first 6% salary contribution with a 3-year vesting schedule.
Performance Bonus
There is an Annual Performance Bonus, paid out in March.
Child Care & Parental Leave Benefits
Generous Parental Leave
Real Chemistry offers a 4th Trimester program facilitated by a professional coach that curates a personalized experience for new parents preparing for leave through returning to work post leave.
Family Medical Leave
Return-to-work program post parental leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Sabbatical
Eligible employees get 30 days of paid sabbatical after their first 5 years of working at the company.
Paid Holidays
Perks & Discounts
Casual Dress
Commuter Benefits
Free Daily Meals
Stocked Kitchen
Happy Hours
Pet Friendly
Fitness Subsidies
$500 per year provided for Staff Employees to spend on a Healthy product or activity.
Home Office Stipend for Remote Employees
Professional Development Benefits
Job Training & Conferences
Real Chemistry offers employees professional development opportunities like Onsite training courses and the ability to attend job related conferences and seminars.
Diversity Program
Lunch and learns
Real Chemistry hosts lunch and learn meetings.
Cross functional training encouraged
Promote from within
Mentorship program
More Jobs at Real Chemistry58 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Content
Data + Analytics
new
Remote
Data + Analytics
new
Remote
Operations
new
Remote
Finance
new
Remote
Sales
new
Remote
Marketing
new
Austin
Data + Analytics
new
Remote
Operations
new
Remote
Marketing
new
Remote
Data + Analytics
new
Remote
Marketing
new
Remote
Marketing
new
Remote
Operations
new
Remote
Developer
new
Remote
Design + UX
new
Remote
Finance
new
Remote
Developer
new
Remote
Data + Analytics
new
Remote
Marketing
new
Remote
Data + Analytics
new
Remote
Marketing
new
Remote
Operations
new
Remote
Product
new
Austin
Marketing
new
Remote
Data + Analytics
new
Remote
Sales
new
Remote
Marketing
new
Remote
Data + Analytics
new
Remote
Marketing
new
Remote
Marketing
new
Remote
Finance
new
Remote
Marketing
new
Remote
Content
new
Austin
Data + Analytics
new
Austin
Data + Analytics
new
Remote
Content
new
Remote
Developer
new
Austin
Marketing
new
Remote
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Real Chemistry's full profileSee more Real Chemistry jobs