Published date Posted on Indeed on Jul 01, 2022 (42 d ago)

ADTRAV Travel Management, founded in 1977, has over four decades of experience in managing corporate, government, vacation, group, meetings, and incentive travel programs across the United States. We have experienced steady growth throughout our history and are currently ranked as one of the top business travel management companies in the country.


ADTRAV is seeking a highly motivated Data Architect that is excited about creating robust data solutions and enjoys leading software teams to success. The right person will be confident in their contributions and have a demonstrated history of leadership on data oriented initiative resulting in positive business outcomes.

ESSENTIAL DUTIES & RESPONSIBILITIES:

  • Work with business to understand objectives of data warehouse

  • Understand source system data, process and flow

  • Data modeling for new data marts including data definitions, data flow diagrams, and process definitions

  • Develop and enhance ETL processes

  • Automate data quality checks

  • Design and develop database objects, tables, stored procedures, views and SSIS packages

  • Performance tuning of the stored procedures and T-SQL

  • Independently analyze, solve, and correct issues in real time

  • Document and test work products

  • Research Interpret business needs of stakeholders and develop analytical solutions

QUALIFICATIONS:

  • Bachelor's Degree and/or 8+ years of experience in data oriented roles

  • Minimum 2 years in leadership role (project lead, team lead, tech lead, architect, …)

  • Demonstrated ability to provide oversight to multiple projects with highly variable scopes

  • Proven track record of leadership resulting in positive business outcomes

  • “Can do” problem solving mentality, while still respecting standards, quality, and security

REQUIRED SKILLS:

  • Experience developing with an ETL tool

  • Experience developing SSIS packages

  • Strong Experience in relational and dimensional data modeling

  • Strong Experience with T-SQL programming, writing advanced queries

  • Experience in tuning queries using Data Base Tuning Advisor, Query Statistics and Execution plans

  • Exceptional organizational skills and ability to handle large projects while meeting deadlines and immediate business needs

  • Ability to work in a team environment

  • Good written and oral communication

  • Adhere to standards and best practices

  • Detail-oriented with strong organizational, analytical and communication skills

  • Places emphasis on client satisfaction and customer experience

  • Enthusiastic about learning large and complex systems, and new tools

ADDITIONAL PREFERRED SKILLS:

  • Experience with Qlik, or other BI tools

  • Python

  • Certifications

  • Experience with Data Marts

ADTRAV Corporation an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.


Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Piper Companies Piper Companies |
|
Yesterday

Piper Companies is looking for an IT Manager, Data for a leading pharmaceutical organization based in the Philadelphia, PA area.THIS IS A REMOTE OPPORTUNITYResponsibilities for the IT Manager, Data:You will lead developers, data engineers, DevOps, BA’s,.

Get To Know Us!GuideWell and its family of forward-thinking companies are focused on helping people and communities achieve better health and are at the forefront in the transformation of health care. We offer competitive salaries and benefits, work-life.

NeoGenomics Laboratories NeoGenomics Laboratories |
|
Yesterday

Are you motivated to participate in a dynamic, multi-tasking environment? Do you want to join a company that invests in its employees? Are you seeking a position where you can use your skills while continuing to be challenged and learn? Then we encourage.

Origami Risk Origami Risk |
|
Yesterday

Overview:The Software Implementation Specialist/Client Executive is part of the Professional Service team at Origami Risk. You will be a hands-on generalist focused on leading both technical and functional aspects of the full software implementation.

Tista Science and Technology Corporation Tista Science and Technology... |
|
3 d ago

Overview:The Senior Database Architect must have experience creating work breakdown structures and development of program schedules and assigning software development team personnel to tasks. Must have experience in the tracking resources and expenditures.

We are Locana!Locana is a global leader in technology consulting and geospatial systems development. We leverage location data, business intelligence, and integrated systems to drive enterprise collaboration and business performance for our public and.

Why CORMAC?At CORMAC, we leverage the power of data management and analytics to enable our customers to achieve their strategic goals. With over 20 years of experience in health information technology (HIT), human-centered design principles and Agile.

Maharishi Foundation International Maharishi Foundation International... |
Yesterday

About UsMaharishi Foundation International (MFI) is a US-registered non-profit that supports the development of new technologies and outreach opportunities for the worldwide Transcendental Meditation® (TM®) organisations. Over the past 60 years, more.

Merit America Merit America |
Yesterday

The Organization: Merit AmericaMerit America is a non-profit that has been named by the New York Times as “a glimpse of the hybrid future of training programs for the disadvantaged.” Our fast and flexible programs are designed to work for underemployed.

Quadrant Resource Quadrant Resource |
Yesterday

Job Description: Knowledge of architecture, client/server and distributed computing concepts*Strong or Windows Operating & Administration skillsGood understanding of networking protocols: DNS, HTTP, SSL, SMTP, TCPExcellent oral and written communication.

More jobs by this company

ADTRAV Travel Management ADTRAV Travel Management |
10 d ago

ADTRAV Travel Management, founded in 1977, has over four decades of experience in managing corporate, government, vacation, group, meetings, and incentive travel programs across the United States. We have experienced steady growth throughout our history.

ADTRAV Travel Management, founded in 1977, has over four decades of experience in managing corporate, government, vacation, group, meetings, and incentive travel programs across the United States. We have experienced steady growth throughout our history.