Ethos Group offers employees an opportunity to work in an innovative and challenging environment where new ideas are encouraged and individual contributions are recognized. Through respect, ambition and teamwork, we enrich and strengthen our energetic culture and drive success for all.
Our company has humble beginnings – with a core group of people whose dedication and resilience still serves as an inspiration for our team today. These individuals remain a vital and active part of our company and eagerly share their passion with the next generation of leaders. Our team members are motivated to help the company grow, and willingly share their excitement and expertise, inspiring others to reach their full potential.
The strong relationships that our company has established with our clients are reinforced by the commitment we have to one another within the company. Our culture is founded on honor, integrity and initiative. Our corporate character is what motivates us to be the best in the world at what we do.
Explore our opportunities to see if you have what it takes to become part of the Ethos Group team.
Company Information Ethos Group is a leader in the automotive industry with an ambitious vision for our future growth. We provide technologically advanced solutions which assist our clients in meeting the changing demands of the marketplace as well as developing strong foundations for success. We are also undergoing a large technology initiative which means we need driven people in order to meet goals. This position involves developing web-based systems that are used by both our customers and staff.
Dynamic Work Environment We are dedicated to providing a world class facility for all of our employees. We have invested in a brand new 100,000 square foot corporate office in Irving, Texas which is surrounded by numerous restaurants, entertainment, and a live music venue. It has state of the art technology throughout the space, dedicated meeting and huddle rooms to encourage collaboration, sit to stand work stations, and a huge working café. All of this is housed in a light filled space with wrap around windows on every floor. Twenty five thousand square feet is dedicated to our IT department as it is rapidly growing and will continue to do so in the future.
About our Team The IT team consists of members who work cooperatively in a professional environment that encourages initiative, positive attitudes, and collaboration. We provide mentoring to support professional development along with an opportunity to work independently as well as contribute new ideas. Our team actively uses the Scrum/Agile work philosophy creating an environment where you are valued, inspired to be the best, and empowered to make it happen.
Having a great company culture is one of our top priorities. We are involved in many extracurricular activities such as quarterly department events, sports, gaming nights, and camping. Working at Ethos Group is like working with a family. We bond like friends and help each other achieve goals. It truly is a one of a kind environment.
Design, create, and load data into a Microsoft Azure SQL Data Warehouse environment.
Develop, and execute ETL packages to move data using stored procedures, functions, and SQL scripts in a Microsoft SQL Server environment.
Design star and snowflake schemas to support analytical needs
Perform data analysis to identify data patterns and anomalies.
Perform basic troubleshooting of T-SQL and SSIS processes.
Develop and modify stored procedures and T-SQL scripts in response to validation exceptions.
Design, implement, and maintain new and existing database objects including tables, indexes, constraints, stored procedures, and user-defined functions in support of data conversion projects.
Stay current with Microsoft SQL Server technologies and current database concepts
Perform other job-related duties and responsibilities that may be assigned from time to time.
Bachelor's Degree in Computer Science, Management Information Systems (MIS), or related field or relevant work experience
Ability to work well within deadline-oriented development structure.
Ability to work well both independently and collaboratively within a team environment.
Strong technical abilities and desire to learn new things.
Excellent interpersonal skills including verbal and written communication skill, teamwork and customer service skills.
Technical knowledge requirements
Proficiently use Microsoft SQL Server Management Studio
Proficiently use Microsoft Visual Studio
Write and maintain stored procedures and functions using T-SQL and SSMS
Use aggregate functions in Microsoft SQL Server
Create and maintain complex queries in Microsoft SQL Server using T-SQL
Understand and use database schemas, tables, relationships, and constraints
Develop, maintain, and troubleshoot Microsoft SQL Server Integration Services (SSIS) packages using SQL Server Business Intelligence Design Studio
Understanding of the Kimball methodology
Nice to haves
Experience with the Microsoft Parallel Data Warehouse or Azure SQL Data Warehouse
Exposure to an Agile development environment
Scripting experience with Python or C# is a plus
Application development experience is a plus
Ability to write reports using Microsoft SQL Server Reporting Services (SSRS) is a plus
*Must be U.S. Citizen or Permanent Resident. *Principals only. Recruiters, please do not contact this job poster.