Data Architect

3 weeks ago


Forest Lake, Minnesota, United States Ampact Full time
About the Role

Ampact is seeking a highly skilled Data Engineer to own its data and architecture. This individual will play a pivotal role in designing, implementing, and maintaining robust data management processes and procedures. Leveraging expertise in data architecture, integration, and governance, the successful candidate will collaborate cross-functionally to ensure the quality, integrity, accessibility, efficiency, and security of our organization's data assets.

Key Responsibilities
  • Implement and execute performance tuning strategies to optimize system efficiency, including analyzing bottlenecks, fine-tuning configurations, and optimizing queries for improved response times and resource utilization.
  • Develop and implement robust data models to support business requirements using relational and dimensional modeling techniques, data normalization, and schema design to ensure scalability, performance, and data integrity within the organization's databases and systems.
  • Develop comprehensive data roadmaps outlining the strategic direction for data management, integration, and utilization, including identifying key milestones, technologies, and processes to ensure alignment with organizational goals and objectives.
  • Reverse engineer data systems and vendor applications to understand data structures, relationships, and integration points, enabling effective data extraction, transformation, and loading (ETL) processes for data migration, integration, and analysis purposes.
  • Investigate data sources, understand data repositories, and create documentation for future optimization.
  • Provide actionable recommendations to key stakeholders and business teams for improving data quality, reliability, and efficiency based on the analysis of integrity issues and process inefficiencies.
  • Collaborate in the development of data roadmaps outlining strategic initiatives to address identified gaps and drive continuous improvement.
  • Establish and maintain data lineage documentation, mapping the flow of data from its origin through various transformations and systems, ensuring transparency and traceability for compliance, auditing, and troubleshooting purposes.
  • Provide thought leadership to develop new or improved processes, methodologies, systems, tools, and/or services to enhance operating environment based on practical experience, optimal outcomes, and best practices.
Requirements

The ideal candidate will have a Bachelor's degree in Computer Science, Information Technology, or a related field, with a minimum of 5 years' experience in data modeling, database design, and data architecture roles. Strong understanding of data management concepts, including data modeling, data quality, metadata management, and data security, is essential. Experience with data management tools and platforms, such as data cataloging tools, metadata management tools, and data governance frameworks, is also required. Proficiency in data modeling tools such as ERwin, ER/Studio, PowerDesigner, or similar is necessary. Strong understanding of relational database concepts and SQL, with experience in designing and optimizing database schemas, indexes, and queries, is also required. Familiarity with dimensional modeling techniques and data warehousing concepts is desirable. Experience with NoSQL databases such as MongoDB, Cassandra, or Elasticsearch is a plus. Familiarity with database management systems (e.g., SQL Server, Oracle, MySQL) and data integration technologies (e.g., ETL, ELT) is also desirable. Excellent analytical and problem-solving skills with a keen attention to detail are essential. Effective communication and interpersonal skills with the ability to collaborate with stakeholders at all levels of the organization are also required. Ability to work independently and manage multiple priorities in a fast-paced environment is necessary. Certification in data management or related areas (e.g., CDMP, DAMA) is a plus. Knowledge of regulatory compliance requirements, such as GDPR, HIPAA, SOX, etc., is desirable.

About Ampact

Ampact is a national nonprofit that specializes in implementing and scaling evidence-based AmeriCorps programs across three focus areas: education, environment, and healthy futures. Most of the programming at Ampact is focused on education - specifically through the Reading Corps, Math Corps, and Early Learning Corps programs. These programs have a 20-year track record in providing high-dosage tutoring to over 50,000 students annually and have been tested rigorously through independent evaluations. Ampact has experienced significant growth in recent years and has ambition for continued growth. Ampact has 325+ employees and 3,500+ AmeriCorps members across 10 states. Its annual operating budget is $115 million. Ampact is headquartered in Minneapolis, Minnesota, with employees located in 10 states. Candidates must have legal authorization to work in the US without the need for employer sponsorship, both now and in the future. Ampact is unable to sponsor visas or work permits.
  • Data Engineer

    3 weeks ago


    Forest Lake, Minnesota, United States Omni Inclusive Full time

    Job SummaryAs a Senior Data Engineer at Omni Inclusive, you will be responsible for designing and developing data pipelines and data storage using cloud technologies. You will work with AWS GovCloud and develop data pipelines using AWS technologies such as Aurora, DynamoDB, RedShift, S3, Glue, and Lambda. You will also troubleshoot data-related issues and...


  • Forest Lake, Minnesota, United States C4 Technical Services Full time

    Job Title: Cloud Security and Infrastructure ManagerAbout the Role:As a Cloud Security and Infrastructure Manager at C4 Technical Services, you will be responsible for designing, testing, and building Azure and on-prem solutions for 300+ users in 4+ sites. This hands-on role requires expertise in deploying and optimizing systems in Azure IaaS and PaaS,...

  • Data Architect

    2 months ago


    Lake Forest, United States CitiusTech Full time

    Sr Solutions Architect - Databricks & AWSWho we are: -At CitiusTech, we constantly strive to solve the industry's greatest challenges with technology, creativity, and agility. With over 8,500 healthcare technology professionals worldwide, CitiusTech powers healthcare digital innovation, business transformation, and industry-wide convergence for over 140...


  • Lake City, United States ClinDCast LLC Full time

    Job Title: Salesforce Data Cloud Architect Work Mode: On-site Location: Atlanta, GA Job Description: We are looking for an experienced Salesforce Data Cloud Architect with a strong background in Salesforce technical architecture, data cloud design, and hands-on development. This role is ideal for someone with extensive expertise in Salesforce Data Cloud and...

  • Senior Data Architect

    4 weeks ago


    Lake Oswego, United States Insight Global Full time

    Job Title: Senior Data ArchitectWe are seeking a highly skilled Senior Data Architect to join our team at Insight Global. As a key member of our data engineering team, you will be responsible for designing and implementing scalable data architectures to support our business growth.Key Responsibilities:Design and implement data pipelines using Azure Data...


  • Lake Forest, California, United States Tential Full time

    Job Title: Cloud ArchitectAt Tential, we're seeking a skilled Cloud Architect to join our Enterprise Business Systems team. As a Cloud Architect, you'll play a critical role in developing and executing digital product innovation across various domains, including infrastructure, software development, security, and scalability.Key Responsibilities:Lead...


  • Lake Forest, California, United States Tential Full time

    Job SummaryTential is seeking a highly skilled Cloud Solutions Architect to join our Enterprise Business Systems team. As a Cloud Solutions Architect, you will play a critical role in understanding day-to-day challenges of our digital product development teams and offering your experience to assist in the development and execution of digital product...

  • SAP OTC Architect

    1 month ago


    Lake Forest, United States TEKsystems co Allegis Group Full time

    Location: Chicago, IL (5 days per week onsite)Duration: 6 months contract to hirePrimary Job FunctionThe OTC Architect will work with stakeholders to build a holistic view of the organization's SAP strategy processes to identify the required capabilities and define the short-term and long-term strategy and implementation plans necessary to achieve the...


  • Lake Forest, United States York Solutions, LLC Full time

    Title: SAP OTC Solutions ArchitectContract to HireThis role is open to anyone willing to relocate to Illinois or anyone willing to travel onsite weekly!Rate Range: $70-95/hrYork is hiring! We are currently seeking an SAP OTC Solutions Architect that meets the below requirements for a contract opportunity with a client in the pharmaceutical industry. Our Lake...


  • Lake Forest, California, United States Tential Full time

    Job DescriptionAs a Cloud Solutions Architect at Tential, you will play a critical role in developing and executing digital product innovation across various domains. You will work closely with diverse teams of engineers and technology experts to assess, recommend, and prioritize activities and investments to deliver scalable and secure digital platforms.Key...


  • Lake Oswego, Oregon, United States NAVEX Global Full time

    Transforming Business with Data ArchitectureAt NAVEX Global, we're committed to harnessing the power of data to drive business growth and innovation. As a Principal Enterprise Architect, Data, you'll play a critical role in shaping our data strategy and architecture.Key Responsibilities:• Design and document enterprise-wide architectures, roadmaps, and...


  • Salt Lake, Utah, United States Enbridge Full time

    Job DescriptionWe are seeking a highly skilled Data Architect Specialist I to provide technical leadership in modern data architecture for our analytics services, solutions, and supporting technologies. The successful candidate will have a strong background in data architecture, with experience in designing and deploying large data architecture...


  • Salt Lake, Utah, United States Xerox Full time

    About XeroxXerox is a leading provider of document management and print solutions, with a rich history of innovation and customer satisfaction.As a Data Center Solution Architect, you will play a key role in designing and implementing cutting-edge data center solutions for our clients.ResponsibilitiesTranslate business needs into successful data center...

  • Big Data Developer

    2 weeks ago


    Lake Forest, United States Motion Recruitment Full time

    Our client is looking for a Data Lake Architect to join their team in Mettawa, IL/.This is a 6 month contract that can pay up to $70/hourQualifications• Bachelors degree in relevant field and at least 4 years relevant experience OR Masters degree in relevant field and at least 2 years’ experience.• Hands-on experience with big data tools: Hadoop,...


  • Lake Forest, California, United States Health Fitness Full time

    Job SummaryWe are seeking a highly skilled Cloud Infrastructure Solutions Architect to lead the design and implementation of complex infrastructure service solutions. The ideal candidate will have a strong background in cloud and on-premises infrastructure, with expertise in virtualization, storage, and networking.Key ResponsibilitiesCollaborate with...


  • Lake Forest, California, United States Omni Inclusive Full time

    Job Description:The selected candidate will be part of the R&D DevOps team at Omni Inclusive, focusing on Power BI services management and development. They should have excellent communication skills to collaborate effectively with stakeholders and internal customers. The ideal candidate should be capable of collecting, understanding, and translating...

  • SAP OTC Architect

    1 month ago


    Lake Forest, United States Mindgadget Inc. Full time

    Hello Applicant, Please review the below role and let me know if interested. Roles: SAP OTC ArchitectLocation: Lake Forest, ILProject Landscape: One current project is a Gross margin improvement project around freight matrix and routing matrix for Rapid Diagnostics. Current model has the 3PL doing all of the analysis and set the cost, but moving forward...

  • SAP Domain Architect

    1 month ago


    Lake Forest, United States Kloudhunt LLC Full time

    Primary Job FunctionThe Domain Architect will work with stakeholders to build a holistic view of the organization's SAP strategy processes to identify the required capabilities and define the short-term and long-term strategy and implementation plans necessary to achieve the long-term strategic objectives.The Domain Architect will develop and own Abbott's...

  • Software Architect

    1 week ago


    West Lake Hills, United States Dell Full time

    Software Architect - Embedded Engineering, Applied Data Science In the rapidly moving Artificial Intelligence era, few spaces are moving faster than the AI-enabled PC. As a leading provider of world-class technology, this means bringing more intelligence into the PC ecosystem, enabling superior performance, enhanced productivity, and delightful experiences...


  • Forest Park, Georgia, United States Eateam Full time

    Job Title: Cloud ArchitectJoin Eateam as a Cloud Architect and be part of a dynamic team that delivers innovative cloud solutions to our customers.About the Role:We are seeking an experienced Cloud Architect to join our team. As a Cloud Architect, you will be responsible for designing and implementing cloud-based solutions for our customers. You will work...


  • Lake Forest, Illinois, United States Pactiv Evergreen Full time

    About the Role:The Director of Security Architecture will be responsible for overseeing the design and implementation of security architecture solutions for Pactiv Evergreen. This role requires a deep understanding of security best practices, emerging threats, and the ability to collaborate with cross-functional teams to design and implement security...

  • System Architect

    4 weeks ago


    Black Forest, Colorado, United States The Judge Group Full time

    Job SummaryThe Judge Group is seeking a highly skilled System Architect to support the Missile Defense National Team for C2BMC Architecture and System Engineering IPT.The ideal candidate will have experience with DoD test methodologies and terminologies, Missile Defense Agency elements or components, and associated test tools.Key ResponsibilitiesSupport test...