BI Manager and Solution Architect
Tenneco Automotive Operating Company Inc. is seeking a full-time BI Manager and Solution Architect at our offices in Southfield, MI. This position is responsible for Architecture design, building and supporting Business Intelligence and Analytics services/applications, executing a business intelligence and analytics vision and roadmap to support critical decision making at Tenneco considering IT trends and customer needs. This position requires a Bachelor’s degree or equivalent in Computer Information Systems, Computer Technology, or a related field and 5 years related (progressive, post-baccalaureate) experience. Must also have 24 months of demonstrated ability (which may have been gained concurrently) with each of the following: (1) creating, setting up, and maintaining the Microsoft Azure Cloud solutions; (2) design and build enterprise reporting solutions and Enable self-service reporting using Microsoft Power BI; (3) developing Business Intelligence solutions, ETL and reporting infrastructure including developing solutions for data collection, management, and usage using Microsoft Business Intelligence platform – SSAS, SSIS and SSRS; (4) developing relational database-based data storage solutions using technologies including Microsoft SQL Server; (5) Agile software development using the scrum methodology; (6) developing data pipeline using Cloud ETL tools (Azure Data Factory, Azure Data Lake Storage and Databricks) and reporting infrastructure including developing solutions for data collection, management, and usage; and (7) utilizing the following tools and technologies: Microsoft Power BI Desktop, Power BI Premium Service, Power BI Administration, Power BI REST APIs, PowerShell, Power Query, Azure SQL Database, Azure Synapse Analytics (former Azure Data warehouse) SAP HANA, SQL Server and T-SQL, SSIS, Azure Data Factory, SSAS Multi-dimensional and Tabular, MDX/DAX, Databricks, Python , Git and Azure DevOps. This position also requires the following Microsoft Certifications: Developing Microsoft Azure Solutions, SQL Server, Microsoft Certified Professional, SQL Server 2008 Database Development, and SQL Server 2008 Business Intelligence Development and Maintenance.