Data & BI Architect

Data & BI ArchitectDepartment: HireMilitary JobsEmployment Type: PermanentLocation: IL - Chicago Metro Area / HybridCompensation: $170,000 - $180,000 / yearDescriptionWe are recruiting a Data & BI Architect on behalf of one of the largest metals distributors in the US in Lisle, ILThe Data & BI Architect will have primary focus on cloud data structures in environments such as SAP HANA, Azure, AWS and Informatica. These data environments will support our client''s fast-growing digital transformation and expansion into modern tools for modeling, visualization, AI/ML and custom applications that drive analytics, reporting and business process re-engineering for the company. Our client is a leader in the global metals supply chain for nearly 200 years and is at the center of it all, helping close the gap between metal producers'' supply and end-users demand.ResponsibilitiesDesign the cloud data and analytics environment for our client to ensure architecture meets current business needs while anticipating likely future growth requirements with easily extensible structures.Fulfil an important leadership role in the design of data, information and analytic governance in concert with IT Infrastructure and Cyber Security teams.Ability to support the data requirements of both traditional and leading-edge applications and uses ranging from basic SQL / SQL Server to Python, big data tools, NoSQL and similar.Optimize data centric collaboration across repositories spanning on premise and cloud assets using advanced tools such as Data Factory, Snowflake, etc. for creating, securing and managing data pipelines and connections.Assist with the quantification and tracking of business value derived from creation of data and analytic resources or monetization of data assets.Improve overall Enterprise Information Management including master data management, meta data management, data dictionary, catalog, glossary and lineage documentation.Collaborate with leaders from both IT and business disciplines (Supply Chain, Sales, Operations, Logistics) at various business levels (local, regional, corporate) in support of a business user focused ''Cloud Data Marketplace''. Coordinate seamlessly with outside firms and fortable working in a fast paced, results driven environment, simultaneously supporting multiple projects of various sizes in a hybrid W-Agile project management style.Experience in industrial distribution, manufacturing, logistics or similar business background is preferred.Occasional travel required.QualificationsMasters or Bachelor''s degree in Computer Science, Computer Engineering, Information Technology / Systems, Business Analytics or similar major.10 years minimum experience in Information Technology / Systems with at least 4 years of that in a lead role of a similar data and analytics modernization lifecycle in a complex environment.5-7 years of hands-on experience in data warehouse, data engineering, data modeling, MDM, ETL and related tactical roles building and implementing data and information infrastructure.Knowledge of SQL, Python, DAX, and other commonly used analytics languages.A deep understanding of Azure data stack (SPARK, Hadoop, Synapse, Kubernetes), and AWS services.Working knowledge of data visualization tools such as Power BI.Ability to conceptualize highly complex technical design issues, select the appropriate technologies and implementation approaches and clearly communicate required resources to executives.Occasional travel required.Experience and proven track record in a lead role throughout a data architecture modernization initiative focused on meeting the data requirements of the leading analytic tools and use cases including visualization, prediction, simulation, optimization and AI/ML.Superb quantitative and logical thinking skills combined with the ability to think creatively, envision relationships between data and create designs that ensure seamless and intuitive joins on them.Proven technical capabilities for designing, developing, implementing and tuning cloud data structures used within modern BI systems and platforms.Demonstrated ability to quickly learn and understand new software products and concepts, including ability to self-instruct using available texts and other resources.Leadership level organizational skills with emphasis on ability to organize and prioritize work to establish and meet deadlines, manage multiple projects, create and maintain documentation, and provide guidance and direction to others.Excellent communication and interpersonal skills; ability to interact across multiple departments and levels within a medium to large size enterprise.Ability to work independently or with minimal instruction or oversight.BenefitsA career with purpose and impact!Three weeks of vacation paid sick days, and holiday pay401(k) with employer matchComprehensive medical, dental, and vision insurance is available on Day 1 of your start datePaid Maternity and Parental leaveHealth and wellness programsOn-the-job training and mentoring from leadership and teammatesTuition ReimbursementOur client gives to our local communitiesDiversity and Inclusion initiativesGrowth potential in leadership and/or technical roles and more!

Created: 2025-11-15