FULL_TIME

FEED

OTHER

This role will serve as the technical leader of our enterprise BI architecture, driving continuous improvement, scalability, performance optimization, governance, and innovation. Our AWS data platform has been established, and the current focus is on increasing data ingestion from SAP (ECC and S/4) and other non-SAP systems for enterprise reporting.

Job Title: AWS BI Solution ArchitectLocation: Onsite - Neenah, WI (preferred) or Oconomowoc, WI Reports To: IT Senior Director - Data & AnalyticsPosition OverviewWe are seeking an experienced AWS BI Solution Architect with strong SAP expertise to lead and evolve our established AWS-based analytics platform. This role will serve as the technical leader of our enterprise BI architecture, driving continuous improvement, scalability, performance optimization, governance, and innovation.Our AWS data platform has been established, and the current focus is on increasing data ingestion from SAP (ECC and S/4) and other non-SAP systems for enterprise reporting. The next phase requires strong architectural leadership to enhance integration, improve data modeling standards, optimize cost and performance, and expand advanced analytics capabilities.This is a high-impact leadership role with visibility across the organization.Key Responsibilities 1. Player/Coach Technical Leadership <ul><li>Architect solutions while remaining hands-on in design reviews, SQL development, and pipeline troubleshooting.</li><li>Lead by example in writing performant queries and optimizing ETL jobs.</li><li>Mentor data engineers and BI developers through code reviews and architectural guidance.</li><li>Establish engineering standards and development best practices.</li><li>Coach team members on dimensional modeling and data structures.</li></ul>2. SAP & Enterprise Data Ingestion Ownership <ul><li>Lead ingestion for SAP data (ECC and S/4HANA).</li><li>Lead integration of additional enterprise systems and flat files into AWS.</li><li>Define full load vs. incremental load standards.</li><li>Establish monitoring and alerting for pipeline reliability.</li><li>Reduce ingestion latency where appropriate.</li></ul>3. AWS BI Platform Optimization <ul><li>Own and enhance AWS architecture leveraging appropriate AWS Services</li><li>Optimize Glue jobs and ETL frameworks.</li><li>Improve S3 lifecycle and storage tiering strategies.</li><li>Implement cost optimization strategies across compute and storage.</li><li>Drive performance benchmarking and continuous improvement.</li></ul>4. Data Modeling & Analytics Enablement <ul><li>Lead enterprise dimensional modeling standards.</li><li>Improve semantic layers and curated data marts.</li><li>Position platform for advanced analytics and AI/ML readiness.</li></ul>5. Governance, Security & Reliability <ul><li>Strengthen IAM, row-level security, and data access controls.</li><li>Implement data quality monitoring frameworks.</li><li>Document lineage and data definitions.</li><li>Define SLAs and reliability metrics.</li><li>Ensure compliance with enterprise security policies.</li></ul>Required Qualifications <ul><li>8+ years in data architecture, BI, or data engineering roles.</li><li>5+ years hands-on experience designing AWS data platforms.</li><li>SAP data expertise (ECC and/or S/4HANA).</li><li>Proven experience with SAP data ingestion into a cloud warehouse.</li><li>Strong experience with: <ul><li>AWS Glue ETL frameworks</li><li>S3 data lake architecture</li></ul></li></ul><ul><li>Advanced SQL and dimensional modeling expertise.</li><li>Experience leading technical teams while remaining hands-on.</li></ul>Preferred Qualifications <ul><li>AWS Solutions Architect Certification.</li><li>Experience with SAP SLT, ODP, CDS views, or SAP BW.</li><li>Experience with Infrastructure as Code (Terraform, CloudFormation).</li></ul>What Success Looks Like <ul><li>SAP and enterprise data ingestion pipelines run reliably with defined SLAs.</li><li>AWS BI platform performance and cost efficiency improve measurably.</li><li>Platform stability increases while technical debt decreases.</li><li>Engineering standards elevate team capability.</li><li>Business stakeholders trust and actively use analytics outputs.</li><li>The AWS BI platform is scalable and positioned for future innovation.</li></ul>Ideal Candidate Profile <ul><li>Architect mindset with engineer execution capability.</li><li>Comfortable rolling up sleeves to solve complex data problems.</li><li>Strong communicator who can translate business needs into technical solutions.</li><li>Naturally accountable and ownership-driven.</li><li>Passionate about building scalable, governed data ecosystems</li></ul><img alt=" " height="1" src="https://ars2.equest.com/?response_id=f17ac3be67b1de4e7cd522b47e0894be&view" width="1"/>

Menasha Global, LLC

Business Intelligence Architect (AWS)

equestftpin

UNKNOWN

ADAPTED_NOW

The ideal candidate will have a proven track record designing and implementing successful data and Artificial Intelligence/Machine Learning (AI/ML) solutions, is a strategic thinker with a strong technical background, has exceptional communication, problem-solving skills, with a mindset of continuous learning and curiosity leading to tangible results. This individual will be part of the Data Technology group within the Digital Engineering Solutions team, helping to drive strategic Architecture, Engineering and Construction (AEC) initiatives using cutting-edge data technologies and analytics to deliver actionable business insights and robust solutions for AEC professionals and client outcomes.

42372BR Requisition ID: 42372BR Business Unit: COR Job Description: CDM Smith is seeking a Lead Data and AI Architect to join our Digital Engineering Solutions team. This individual will be part of the Data Technology group within the Digital Engineering Solutions team, helping to drive strategic Architecture, Engineering and Construction (AEC) initiatives using cutting-edge data technologies and analytics to deliver actionable business insights and robust solutions for AEC professionals and client outcomes. The Data Technology group will lead the firm in AEC-focused Business Intelligence and data services by providing architectural guidance, technological vision, and solution development. The Data Technology group will specifically utilize advanced analytics, data science, and AI/ML to give our business and our products a competitive advantage. It includes understanding and managing the data, how it interconnects, and architecting & engineering data for self-serve BI and BA opportunities. This position is for a person who has demonstrated excellence in data architecture capabilities, experienced with data technology and processes, and enjoys framing a problem, shaping and creating solutions, and helping to lead and champion implementation. As a member of the Digital Engineering Solutions team, the Data Technology group will also engage in research and development and provide guidance and oversight to the AEC practices at CDM Smith, engaging in new product research, testing, and the incubation of data technology-related ideas that arise from around the company. The ideal candidate will have a proven track record designing and implementing successful data and Artificial Intelligence/Machine Learning (AI/ML) solutions, is a strategic thinker with a strong technical background, has exceptional communication, problem-solving skills, with a mindset of continuous learning and curiosity leading to tangible results. Under the direction of the Data Technology Leader, the duties and responsibilities for this position include: • Develop and design the architecture for various data and AI solutions, ensuring each solution is scalable, secure, and reliable. • Engage with our business units to understand their requirements and translate them into technical requirements and designs. • Create data and AI architectural solutions to complex architecture, engineering, and environmental science problems. • Design and implement strategies to scale data and AI solutions across different business units. • Create detailed architecture and technical design docs for our data and AI solutions. • Assist with initiatives and efforts, as part of a collaborative team, with your data scientists, data engineers, data analysts, and stakeholders. • Eagerness to learn and work as part of a multidisciplinary team across a global practice. • Stay abreast of the latest developments and advancements, including new and emerging technologies & best practices and new tools & software applications and how they could impact CDM Smith. • Assist with the development of documentation, standards, best practices, and workflows for data technology hardware/software in use across the business. • Present to external audiences as needed. • Assist with marketing, communications, and business development descriptions and activities as needed. • Assist with internal and external website descriptions as needed. • Perform other duties as required. #LI-LP1 #LI-REMOTE Job Title: Lead Data & AI Architect Group: COR Employment Type: Regular Minimum Qualifications: • Bachelor’s degree. • 8 years of related experience. • Equivalent additional directly related experience will be considered in lieu of a degree. Domestic and/or international travel may be required. The frequency of travel is contingent on specific duties, responsibilities, and the essential functions of the position, which may vary depending on workload and project demands. EEO Statement: We attract the best people in the industry, supporting their efforts to learn and grow. We strive to create a challenging and progressive work environment. We provide career opportunities that span a variety of disciplines and geographic locations, with projects that our employees plan, design, build and operate as diverse as the needs of our clients. CDM Smith is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, pregnancy related conditions, childbirth and related medical conditions, sexual orientation, gender identity or gender expression), national origin, age, marital status, disability, veteran status, citizenship status, genetic information or any other characteristic protected by applicable law. Why CDM Smith?: Check out this video and find out why our team loves to work here! (https://www.cdmsmith.com/en/Video/Meet-CDM-Smith) Join Us! CDM Smith – where amazing career journeys unfold. Imagine a place committed to offering an unmatched employee experience. Where you work on projects that are meaningful to you. Where you play an active part in shaping your career journey. Where your co-workers are invested in you and your success. Where you are encouraged and supported to do your very best and given the tools and resources to do so. Where it’s a priority that the company takes good care of you and your family. Our employees are the heart of our company. As an employer of choice, our goal is to provide a challenging, progressive and inclusive work environment which fosters personal leadership, career growth and development for every employee. We value passionate individuals who challenge the norm, deliver world-class solutions and bring diverse perspectives. Join our team, and together we will make a difference and change the world. Job Site Location: United States - Nationwide Agency Disclaimer: All vendors must have a signed CDM Smith Placement Agreement from the CDM Smith Recruitment Center Manager to receive payment for your placement. Verbal or written commitments from any other member of the CDM Smith staff will not be considered binding terms. All unsolicited resumes sent to CDM Smith and any resume submitted to any employee outside of CDM Smith Recruiting Center Team (RCT) will be considered property of CDM Smith. CDM Smith will not be held liable to pay a placement fee. Amount of Travel Required: 0% Assignment Category: Fulltime-Regular Visa Sponsorship Available: No - We will not support sponsorship, i.e. H-1B or TN Visas for this position Skills and Abilities: • Advanced understanding and experience with all functions of the data management lifecycle including data governance, data architecture, data integration, metadata management, data development, data quality management, data administration, security & operations, data stewardship and master data management. • Strong knowledge and experience with Microsoft Azure cloud services and Databricks. • Understands the principles of the Azure well-architected framework and can apply those principles to our Data and AI solution. • Expert knowledge and proven ability to develop highly complex data and AI architectures. Inquisitive, with a desire to ask questions and get a deeper understanding of business and data challenges. • Excellent written and oral communication skills with the ability to communicate well with people from both technical and non-technical backgrounds. Ability to listen, build rapport, and credibility as a strategic and diplomatic partner with our business units. • Innovative and able to apply critical thinking skills to generate new solutions/ideas that create value and improve processes. • Detail oriented with the ability to assist with executing highly complex or specialized projects. Background Check and Drug Testing Information: CDM Smith Inc. and its divisions and subsidiaries (hereafter collectively referred to as “CDM Smith”) reserves the right to require background checks including criminal, employment, education, licensure, etc. as well as credit and motor vehicle when applicable for certain positions. In addition, CDM Smith may conduct drug testing for designated positions. Background checks are conducted after an offer of employment has been made in the United States. The timing of when background checks will be conducted on candidates for positions outside the United States will vary based on country statutory law but in no case, will the background check precede an interview. CDM Smith will conduct interviews of qualified individuals prior to requesting a criminal background check, and no job application submitted prior to such interview shall inquire into an applicant's criminal history. If this position is subject to a background check for any convictions related to its responsibilities and requirements, employment will be contingent upon successful completion of a background investigation including criminal history. Criminal history will not automatically disqualify a candidate. In addition, during employment individuals may be required by CDM Smith or a CDM Smith client to successfully complete additional background checks, including motor vehicle record as well as drug testing. Pay Range Minimum: $121,368 Pay Range Maximum: $212,368 Additional Compensation: All bonuses at CDM Smith are discretionary and may or may not apply to this position. Work Location Options: Fully Remote or Hybrid Work Options may be considered for successful candidate. Additional Pay Range Information: The pay range for this position is listed above. This pay range is a good faith estimate representative of all experience levels for this position based on the geographic location assigned to the position. Please note that pay ranges vary based on geographic location. In addition to geographic location, the company considers several other factors when extending an offer including but not limited to the role, function and associated responsibilities, the candidate’s work experience, education/training and key skills. Massachusetts Applicants: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

CDM Smith

Lead Data & AI Architect

IT Architect jobs in Appleton, WI - find them here! Apply today to the top opportunities near you.

IT Architect Jobs in Appleton, WI

Resume Resources

Get noticed by top employers!

IT Architect Jobs in Appleton, WI

Business Intelligence Architect (AWS) Menasha Global, LLC

Lead Data & AI Architect CDM Smith

Resume Resources