Job Level: W2T Consultant
Job Location: Hybrid/Travel (Non-Local Candidate)
Travel Expectations: 25%, Must be willing to travel to Columbus when required for meetings
Job Classification: Temporary (W2T)
Join Centric Consulting – A Culture You’ll Love
At Centric Consulting, we've cultivated a unique approach to business. Our business is built on three fundamental principles: Enjoy the people you work with, have fun, and do great work. These principles define our consulting model and have crafted one of the most vibrant cultures in the consulting industry – celebrating individuals, collaboration, and lifelong friendships.
In this role, you will:
- Design, develop, and implement ETL processes using SQL Server Integration Services (SSIS) to extract, transform, and load data from various sources into our data warehouse.
- Develop and maintain stored procedures, views, and functions in SQL Server to support data integration and reporting needs.
- Create and maintain data warehouse documentation, including data flow diagrams, data dictionaries, and ETL specifications.
- Troubleshoot and resolve data quality issues and performance bottlenecks in ETL processes.
- Collaborate with business analysts and data analysts to understand data requirements and ensure data accuracy and integrity.
- Work with version control systems like Git to manage code and collaborate effectively with the team.
- Contribute to the ongoing improvement of our data warehouse architecture and ETL processes.
Who You Are:
- Proven experience as an ETL/Data Warehouse Developer with a strong understanding of data warehousing concepts and best practices.
- Extensive experience with Microsoft SQL Server, including SSIS, T-SQL, and database design.
- Proficiency in dimensional modeling and star schema design.
- Experience with version control systems, such as Git.
- Strong analytical and problem-solving skills.
- Excellent communication and collaboration skills.
Preferred Qualifications:
- Knowledge of the insurance industry, particularly financial insurance, is highly desirable.
- Experience with data visualization tools (e.g., Power BI, Tableau) is a plus.
Total Rewards: We proudly offer competitive compensation, a comprehensive and well-rounded benefits package for full-time employees that have been designed to nourish your well-being, such as health coverage, wellness programs, 401K company match, self-managed PTO, and other unique incentives that celebrate your accomplishments.
- Remote and Hybrid Work
- Time Off When You Need It
- Benefits That Flex
- Professional Development
While benefits eligibility may vary for roles that are not full-time, we provide unique opportunities for growth, skill development, and more. Regardless of your role, you’ll be part of a collaborative environment where every team member contributes to our shared success.
Discover more about our benefits by exploring additional details here benefits .
Who We Are:
Founded in 1999 with a remote workforce, we combine the benefits of experience, flexibility, and cost efficiency to create tailored solutions centered on what’s best for businesses. Now numbering more than 1,400 employees in the U.S. and India, we’re committed to solving clients’ toughest problems and delivering on our mission of providing unmatched experiences.
Our purpose at Centric Consulting is to bring unmatched experiences to clients and employees. These aren't just words we use — it's how we became a company and who we are today. Providing an unmatched experience means we approach each other as human beings and lead with empathy and humility. It means we work diligently to ensure we are a place where everyone can create a sense of belonging and feel respected for who they are.
What Makes Centric a Great Place to Work?
We know that creating and sustaining an authentically welcoming culture requires that we all play a part in promoting diversity, equity, and inclusion , from our business practice to how we show up for employees and communities. This is how we bring our mission and core values to life, working together to provide the highest quality services to our clients while allowing our employees to reach their full potential. We are proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veterans’ status, or any other characteristic protected by federal, state, or local laws.
Reasonable accommodations are available for candidates during all aspects of the selection process. Please advise the talent acquisition team if you require accommodations during the application or interview process.
