Data Warehouse & BI Engineer

CTG's long-standing Fortune 500 client of over 15 years has a W2 contract assignment for a Data Warehouse & BI Engineer.

Type: Contract

Job Title: Data Warehouse & BI Engineer

Location: Charlotte, NC preferred; Corning, NY also preferred. Remote candidates will be considered.

Pay Rate: $58.62/hr.-$78.83/hr

Work Hours: M-F 8am-5pm

Education: Bachelor's degree in Information Technology, Computer Science, Engineering, or a related technical field.

Description

The Data Warehouse & BI Engineer will design, develop, and support data warehouse, business intelligence, reporting, and analytics solutions that enable operational visibility and data-driven decision-making. This hands-on role will work across business and technology teams throughout the full solution lifecycle, including requirements gathering, architecture, development, testing, deployment, and ongoing support.

The ideal candidate has strong experience with Microsoft BI technologies, SQL Server, T-SQL, ETL, data warehousing, SSRS, SSIS, SSAS, and Power BI. Experience supporting manufacturing systems and operational analytics is highly preferred.

Requirements:

• Design, develop, and maintain scalable data warehouse and business intelligence solutions.
• Gather requirements and translate business needs into effective technical solutions.
• Develop T-SQL stored procedures, functions, queries, and scripts.
• Design, build, and support ETL processes for data integration and transformation.
• Develop and support Power BI, SSRS, and other reporting and analytics solutions.
• Troubleshoot data issues, stored procedures, reports, and integration processes.
• Collaborate with DBA teams on database performance, query optimization, indexing, and tuning.
• Develop data migration procedures and scripts as needed.
• Contribute to data warehouse architecture and technical standards.
• Maintain code in source control and follow SDLC standards.
• Support operationally critical initiatives and global project timelines as needed.

Qualifications

• 5+ years of experience designing, developing, and supporting Data Warehouse and Business Intelligence solutions.
• 5+ years of experience with Microsoft BI technologies, including SQL Server, SSRS, SSIS, and SSAS.
• Strong T-SQL development experience, including stored procedures, functions, query optimization, and performance tuning.
• Experience developing data warehouse, ETL, reporting, and analytics solutions.
• Experience with Power BI or similar BI/dashboarding platforms.
• Experience working within an SDLC environment.
• Strong analytical, troubleshooting, and problem-solving skills.
• Ability to collaborate effectively with technical and non-technical stakeholders and manage multiple priorities.

Preferred Qualifications

• Experience with Agile methodologies.
• Experience supporting manufacturing or factory-floor systems and processes.
• Familiarity with Camstar or other Manufacturing Execution Systems (MES).
• Experience with MES, CMMS, SPC, OSI PI, or similar manufacturing systems and data models.
• Experience with Microsoft SQL Server and Oracle databases.
• Experience with TFS, GitLab, Git, or similar source control platforms.
• Understanding of OLTP and OLAP systems, cubes, and complex reporting/information models.
• Knowledge of data warehousing and BI architecture best practices.
• Experience supporting analytics in regulated or operationally sensitive environments.
• Ability to travel 0–25% domestically and internationally, as required.

Additional Information

• No third party resumes will be accepted

• Drug testing and/or other employment-related inquiries may be conducted

• CTG will consider for employment-qualified applicants with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.

• All interested individuals MUST be able to work on a W2 Tax basis (no C2C or third party vendors)

• CTG is an Equal Employment Opportunity employer

• CTG is an E-Verify Company

• This position does not support immigration sponsorship.

To be considered for this opportunity, please apply directly through our website by clicking the link below.

About CTG

CTG, a Cegeka company, delivers IT and business solutions that enhance clients’ digital agility, empowering them to seize new opportunities and overcome any challenge. Backed by more than 60 years’ experience and a commitment to being a reliable, results-driven partner, we work shoulder to shoulder with clients to shape digital together. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. With more than 9,000 team members in over 15 countries, we combine global expertise with local insight to deliver innovative solutions. We operate across the Americas, Europe, and India, working with over 3,000 clients in many of today's highest-growth industries.

Together, we shape what’s next—working shoulder to shoulder to deliver impactful solutions for our clients and society. Our culture is built by the people who work at CTG, the values we hold, and the actions we take. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. At CTG, you’ll find a workplace where you are encouraged to grow, supported in your ambitions, and empowered to shape your own career journey. For more information, visit www.ctg.com.

CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.

CTG is an Equal Opportunity Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law. CTG is fully committed to promoting employment opportunities for members of protected classes.