Solutions Architect - Data Warehouse (Design Group)

Division Information Design Group is a leading Engineering, Systems Integration, and IT consulting firm, capable of providing complete operating solutions for consumer products, life sciences, and other industrial sectors.  Design Group provides engineering, project management, regulatory compliance, and other technology services to the world's leading companies.  Our organization is staffed by over 1,400 engineering and technical specialists, operating from over 40 global offices in the US and India. Design Group provides professional engineering, architectural and construction management services through our wholly owned and professionally licensed subsidiary, Design Group Facility Solutions, Inc. We are focused on providing our professionals with opportunities for leadership and career advancement with a thriving work environment and a unique people centric culture. We offer a robust, centralized learning and development program to improve the career experience for every professional. Barry-Wehmiller is a diversified global supplier of engineering consulting and manufacturing technology for the packaging, corrugating, sheeting and paper-converting industries. By blending people-centric leadership with disciplined operational strategies and purpose-driven growth, Barry-Wehmiller has become a $2.5 billion organization with more than 11,000 team members united by a common belief: to use the power of business to build a better world. Job Summary We are seeking an innovative databasedeveloper with superior SQL Server skills to provide development expertise to our business intelligence (BI) team. The databasedeveloper will be responsible for the analysis, design, documentation, development, testing, tuning, and support of analytics database development for the BI team; and provide support and guidance to the BI team and BI customers regarding analytics database development best practices and development standards. Responsibilities Responsible for designing, coding, and implementing reporting/analytics database solutions using modern techniques and programming language Providing high-level database development assistance in creating specific reporting for various  business units Providing general support on information technology to design, develop, execute, and maintain the database application systems Design and development of the organization's business intelligence data warehouse for the identification, collection, and analysis of manufacturing and sales data Research, collect, validate, and collate data and information to design, direct, and support the development of accurate and meaningful business intelligence reports. Ensures research and innovation at all levels of the analytics development process Will participate in multiple projects simultaneously Works harmoniously in a cross-functional team comprising managers, supervisors, business analysts, systems personnel, network staff, and other developers in ensuring the delivery of BI solutions as planned, within set budget, and timely Functions as technical architect and Subject Matter Expert (SME) on enterprise related BI systems Performs the role of the principal designer responsible for complex systems and their subsystems employing deep knowledge of current technology and tools, as well as relevant systems that are already existing Provides excellent customer service by responding to and assisting with help desk calls to resolving issues, including system outages Perform gap analysis between business requirements and available data elements provided by client and vendor integration teams Work closely with Database Administrators and Data Integration (ETL) developers resulting in effective data driven solutions. Requirements  BA or BS degree with 3+ years of directly related experiencepreferred Microsoft SQL Server development (T-SQL) including extensive use of stored procedures, database optimization, and database design SSIS (SQL Server Integration Services) development SSRS (SQL Server Reporting Services) development Basic SQL server administration experience. (users, permission, backups, recovery, monitoring, etc). Master Data Management experience Development of tabular and multi-dimensional data sources Preferred experience with Oracle, MySQL, and DB2 Strong SQL expertise. You can write a query to do almost anything. ETL experience is a must Experience with database tuning experience by running diagnostics, performing query optimization, and other performance tuning. Experience troubleshooting potential issues and experience with best practices around database operations. Strong analytical skills and attention to detail Works well in a team environment Barry-Wehmiller is an equal opportunity employer. M/F/D/V This organization uses E-Verify. Applicants may be subject to pre-employment screening which may include drug screening, reference checks, employment verifications, background screening and/or skills assessments. R002646
Salary Range: NA
Minimum Qualification
Not Specified years

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.