Why This Role Stands Out
This hybrid Data Warehouse & BI Engineer role offers a fantastic opportunity to advance your skills within a CMMI ML3-certified firm known for its commitment to talent solutions. You'll thrive here if you are a mid-senior level professional seeking impactful work in data and business intelligence, with the flexibility to balance your professional and personal life. Apply today to join a forward-thinking organization!
Quick Overview
Job Description
DivIHN (pronounced “divine”) is a CMMI ML3-certified Technology and Talent solutions firm. Driven by a unique Purpose, Culture, and Value Delivery Model, we enable meaningful connections between talented professionals and forward-thinking organizations. Since our formation in 2002, organizations across commercial and public sectors have been trusting us to help build their teams with exceptional temporary and permanent talent.
Visit us at to learn more and view our open positions.
Location: Corning, NY or Charlotte, NC
Duration: 5 Months
- The Data Warehouse & BI Engineer supports client’s manufacturing environment by leading the design, development, and delivery of data warehouse, reporting, and analytics solutions that drive operational visibility and business decision-making. This role is responsible for the full solution lifecycle, including requirements gathering, architecture and design, development, testing, deployment, and ongoing support.
- This is a hands-on role for a technically strong professional who can work across business and technology teams to translate complex requirements into scalable, reliable, and high-value solutions. The ideal candidate brings strong expertise in data warehousing, SQL development, ETL, and reporting, along with a passion for building data solutions that support manufacturing operations, improve performance, and enable informed decisions.
- Lead the end-to-end delivery of data warehouse, reporting, and analytics solutions, including requirements gathering, solution design, development, testing, implementation, and support.
- Design, develop, and maintain high-quality data warehouse and business intelligence solutions that support manufacturing and enterprise priorities.
- Partner with business stakeholders and technology teams to understand requirements, define solution approaches, and deliver impactful data and reporting capabilities.
- Develop and maintain T-SQL procedures, functions, queries, and scripts to support data integration, reporting, and analytics needs.
- Design, build, and support ETL processes for the intake and transformation of data from manufacturing and other enterprise systems.
- Research, analyze, and troubleshoot data issues, stored procedures, and associated SSRS or Power BI reports.
- Collaborate with the DBA team to assess server health, database performance, and query optimization opportunities; recommend and implement improvements such as indexing and query tuning.
- Develop and support data migration procedures and scripts as needed for project and operational initiatives.
- Contribute to the development and ongoing evolution of data warehouse architecture, ensuring solutions are scalable, maintainable, and aligned with best practices.
- Ensure data warehouse and analytics code is maintained in version control and developed in accordance with SDLC standards.
- Support operationally critical work and project timelines, including flexibility to work hours needed for global support when required.
- Bachelor’s degree in Information Technology, Computer Science, Engineering, or a related technical field.
- 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 experience with T-SQL development, including stored procedures, functions, performance tuning, and query optimization.
- Experience developing data warehouse, ETL, and end-user reporting solutions, including Power BI or similar dashboard/reporting tools.
- Experience working within a Software Development Lifecycle (SDLC) process.
- Strong analytical, problem-solving, and troubleshooting skills.
- Ability to work effectively with both technical and non-technical stakeholders and manage multiple priorities in a fast-paced environment.
- Experience using Agile project methodologies.
- Experience supporting manufacturing or factory floor systems and processes.
- Familiarity with Camstar or other Manufacturing Execution Systems (MES).
- Experience with manufacturing-related systems such as MES, CMMS, SPC, and OSI PI, including knowledge of their underlying data models.
- Knowledge of industry best practices in data warehousing, business intelligence architecture, and analytics delivery.
- Experience working with relational databases in Microsoft SQL Server and Oracle.
- Experience using TFS, GitLab, or similar source control platforms.
- Understanding of cubes and complex reporting or information models.
- Clear understanding of OLTP and OLAP systems.
- Experience supporting analytics or reporting solutions in a regulated or operationally sensitive environment.
DivIHN is an equal opportunity employer. DivIHN does not and shall not discriminate against any employee or qualified applicant on the basis of race, color, religion (creed), gender, gender expression, age, national origin (ancestry), disability, marital status, sexual orientation, or military status.
Similar jobs
- GE
Business Analyst - Enterprise Data Management - Hybrid
Genesis10
New York, NY🇺🇸$500 - $600/moHybrid1 week agoSQLSnowflakeAgile+4Technology - JM
Lead Software Engineer - Java/AWS
NewJ.P. Morgan
Jersey City, New Jersey🇺🇸On-site32 minutes agoOracleSpringAWS+10Technology - JM
Software Engineer III - AI Research
NewJ.P. Morgan
Jersey City, New Jersey🇺🇸On-site32 minutes agoMachine LearningAgileGenerative AI+3Technology - JM
Infrastructure Engineer III - Site Reliability
NewJ.P. Morgan
Plano, Texas🇺🇸On-site32 minutes agoGCPAWSSplunk+6Technology - JM
Lead Software Engineer - Databricks/Spark/AWS
NewJ.P. Morgan
Columbus, Ohio🇺🇸On-site32 minutes agoDynamoDBSQLAWS+15Technology - OR
Lead Principal Security Engineer
NewOracle
United States🇺🇸$130k - $306.4k/yrHybrid32 minutes agoOracleRubyRust+4Technology