Data Architect

1 week ago

West Chester, Pennsylvania, United States Aegion Full time

About Aegion Corporation

Aegion Corporation and its family of companies shield and protect the world's infrastructure from degradation and corrosion with a variety of technologies and services. With operations in multiple countries across the world, a career at Aegion will provide challenging and innovative opportunities with a company that is a technology leader in their industry.

About the IT Organization

Aegion's IT organization includes a team of exceptionally talented individuals responsible for supporting Aegion's growing global businesses. The IT organization is team-oriented and forward thinking with multiple opportunities to develop an array of new business capabilities and technological skills.

About the BI Team

Aegion's BI Team is looking for experienced BI professionals with the ability to develop our Enterprise Data Warehouse and Analytics environment. Our BI Team supports the global functions of our business across all divisions of the enterprise. Primary focus of this role is on Data Warehouse development, but as a member of the BI team, members will have the opportunity to perform end-to-end development to include requirements gathering and analysis, data modeling, ETL development, design and tuning, semantic layer design, report, and dashboard creation as well as migration and administration activities.

Responsibilities

  • Design, develop and support ETL mappings.
  • Create ETL, Semantic Layer and Data Warehouse modeling standards.
  • Develop semantic layer and metadata repositories.
  • Develop ETL and promote that content as needed.
  • Monitor data warehouse performance.
  • Use your creativity and experience to model and build an Enterprise Data Warehouse.
  • Create, enhance, and tune stored procedures.
  • Ability to lead and execute throughout all phases of an analytics implementation.
  • Ability to communicate with business leaders at all levels of the organization and to translate business requirements into successful ETL and data warehouse solutions.
  • Demonstrate a visionary mindset when designing and implementing analytics projects to ensure a scalable, efficient, and accurate BI solution.

Qualifications

  • Must have a minimum five to seven years of experience in a business analytics position within an IT department.
  • Must have a minimum three to five years developing data warehouse solutions to include DDL creation, source to target mapping, hands on ETL experience, and working knowledge of type 2 dimensions and incremental data loads.
  • Must have a minimum three to five years of experience working with stored procedures.
  • Must possess a strong understanding of relational data warehouse modeling to include star and snowflake schemas.

Other Options

  • Four-year college degree, specialized training, or equivalent work experience.
  • Strong analytical, critical thinking and problem-solving capabilities.
  • Solid understanding of Agile Scrum project management methodologies.
  • Knowledge of database performance factors, monitoring tools and tuning procedures.

What We Offer

We offer a Competitive Salary with Career Growth Opportunities and a Full Benefits Package including Medical, Dental and Vision Insurance, Matching 401k, Tuition Assistance, Paid Time Off, and much more.

Aegion's Commitment to Diversity and Inclusion

Aegion is an Equal Opportunity Employer. Equal opportunity is a sound and just concept to which Aegion is firmly bound. Aegion will not engage in discrimination against, or harassment of, any person employed or seeking employment with Aegion on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, non-disqualifying disability, status as a protected veteran or other characteristics protected by law.

VEVRAA Compliant

VEVRAA compliant – priority referral Protected Veterans request.

  • Data Architect

    2 days ago

    West Chester, Pennsylvania, United States Aegion Full time

    About Aegion CorporationAegion Corporation is a leading provider of innovative technologies and services that shield and protect the world's infrastructure from degradation and corrosion. With a global presence and a team of talented individuals, Aegion offers challenging and innovative opportunities for career growth and development.About the IT...

  • Co-op Student

    1 month ago

    West Chester, Pennsylvania, United States Resolution Life Full time

    As part of the application process, a candidate account is required to log in and view application(s). Please be sure to check email regularly for information regarding our employment process.Co-op with Resolution Life USPosition Summary:Resolution Life is looking to expand our team of experts that work together to convert vast amounts of business and...

  • Data Architect

    1 week ago

    West Windsor, United States Quantum Integrators Full time

    Role: Data Architect - OnsiteLocation: West Windsor, NJJob type: Full time jobJob Description:We are seeking a highly experienced and certified Senior Data Architect with extensive knowledge of Google Cloud Platform (GCP) to join our dynamic team. As a Senior Data Architect, you will play a pivotal role in shaping our data architecture, ensuring its...

  • Data Architect

    1 week ago

    West Windsor Township, United States Quantum Integrators Full time

    Role: Data Architect - OnsiteLocation: West Windsor, NJJob type: Full time jobJob Description:We are seeking a highly experienced and certified Senior Data Architect with extensive knowledge of Google Cloud Platform (GCP) to join our dynamic team. As a Senior Data Architect, you will play a pivotal role in shaping our data architecture, ensuring its...

  • Principal Solutions Architect

    1 week ago

    Chester, Virginia, United States EVERSANA Full time

    Job OverviewCompany Overview:At EVERSANA, we take pride in being recognized as a Great Place to Work globally. Our mission is to foster a healthier world through innovative solutions. Our dedicated team of over 7,000 professionals is committed to delivering next-generation commercialization services to the life sciences sector. We support more than 650...

  • Generative AI Solutions Architect

    1 month ago

    Chester, Virginia, United States Intervision Systems Technologies Inc Full time

    Are you looking for a challenging role as a Generative AI Solutions Architect?As a leading managed service provider (MSP), InterVision assists IT leaders in solving the most crucial challenges they face by solving for the right technology, deployed on the right premises, and managed through the right model to fit their unique demands and meet their long-term...

  • Network Architect

    2 days ago

    Chester, New York, United States Pierce Technology Corp Full time

    Job DescriptionPierce Technology Corp is seeking a highly skilled Network Architect to join our team. As a key member of our network infrastructure team, you will be responsible for designing, implementing, and maintaining our Ethernet and IP networks.Key Responsibilities:Network Design and Implementation: Design and implement Ethernet and IP networks,...

  • Lead Solutions Architect

    2 weeks ago

    Port Chester, New York, United States Endeavor Full time

    The OpportunityWe are seeking a Lead Solutions Architect who will report directly to the Solutions Engineering Manager. In this position, you will play a pivotal role in driving business development and enhancing sales performance by offering technical insights, competitive analysis, and product assessment support to potential clients for the OneTrust Data...

  • Database Architect

    2 months ago

    West Des Moines, United States Telligen Full time

    As a Database Architect, you will be responsible for the analysis, design, development, and implementation of the data architecture in support of product(s) roadmap. You will architect the analytical data systems including data warehouse(s), data lake(s), and data mart(s) as best meet the product(s) requirements. You will be familiar with a variety of...

  • IT Architect UAM

    3 days ago

    West Bradenton, Florida, United States Apex Ventures Full time

    About Apex VenturesWe are a leading state-owned IT company, shaping the path of public administration and society into the digital future. Our mission has never been more important than it is today, as we protect the data of the state, businesses, and citizens, building trust and ensuring the digital sovereignty of the state.Our TeamWe are a team of around...

  • Lead Business Intelligence Architect

    1 week ago

    West Lafayette, Indiana, United States Purdue University Full time

    Position Overview The Lead Business Intelligence (BI) Architect is responsible for delivering technical knowledge and development assistance for enterprise-level programs and applications, engaging with stakeholders to gather requirements. This role encompasses all stages of the BI development lifecycle and, as a project leader, oversees the comprehensive...

  • Salesforce Solutions Architect

    2 weeks ago

    West Des Moines, Iowa, United States Homesteaders Life Company Corp Full time

    Job OverviewAs a Salesforce Solutions Architect, you will take charge of the technical design, development, and deployment of Salesforce solutions. Your role will involve Apex development, configuration, and applying best-practice architectural methodologies to facilitate both the creation of new products and the enhancement of existing Salesforce...

  • Enterprise Architect 2-Enterprise Mobility and End User Services Architect

    1 week ago

    West Burke, United States CPS Energy Full time

    We are engineers, high line workers, power plant managers, accountants, electricians, project coordinators, risk analysts, customer service operators, community representatives, safety and security specialists, communicators, human resources partners, information technology technicians and much, much more. We are 3,300 people committed to enhancing the lives...

  • Solutions Architect

    4 weeks ago

    West Palm Beach, United States Granite Telecommunications Full time

    General Summary of Position:The Solution Architect’s role is one to utilize their technology background to lead the consultative discovery of the client/prospect’s business goals, objectives, and challenges and to translate them into effective technology and services solutions. The SA plays a leadership role, by analyzing business requirements,...

  • Solutions Architect

    4 weeks ago

    West Palm Beach, United States Granite Telecommunications Full time

    General Summary of Position:The Solution Architect’s role is one to utilize their technology background to lead the consultative discovery of the client/prospect’s business goals, objectives, and challenges and to translate them into effective technology and services solutions. The SA plays a leadership role, by analyzing business requirements,...

  • Solutions Architect

    2 weeks ago

    West Palm Beach, United States Granite Telecommunications Full time

    General Summary of Position: The Solution Architects role is one to utilize their technology background to lead the consultative discovery of the client/prospects business goals, objectives, and challenges and to translate them into effective technology and services solutions. The SA plays a leadership role, by analyzing business requirements, presenting...

  • Lead Systems Architect

    2 weeks ago

    West Columbia, South Carolina, United States Searchability Full time

    Position: Lead Systems ArchitectType: ContractEngagement: Outside IR35Location: HybridClearance Level: BPSS / SCCompensation: Competitive daily rateKey Responsibilities:Collaborate with senior stakeholders to ascertain necessary technical capabilities and timelines across extensive Information Systems delivery initiatives.Assume a leadership role within the...

  • Sr Amazon Connect Cloud Engineer

    2 months ago

    Chester, Virginia, United States Intervision Systems Technologies Inc Full time

    Are you looking for a challenging role as a Sr. Amazon Connect Cloud Engineer?As a leading strategic service provider (SSP), InterVision assists IT leaders & C-Suite executives in solving the most crucial business challenges they face by solving for the right technology, deployed on the right premises, and managed through the right model to fit their unique...

  • Co-op Student

    1 month ago

    West Chester, United States Resolution Life Full time

    As part of the application process, a candidate account is required to log in and view application(s). Please be sure to check email regularly for information regarding our employment process.Co-op with Resolution Life USPosition Summary:Resolution Life is looking to expand our team of experts that work together to convert vast amounts of business and...

  • Solutions Architect- Enterprise Applications

    2 months ago

    West Bend, United States West Bend Insurance Company Full time

    Company Overview Voted Journal Sentinels Top Workplaces to work for 3 consecutive years! Join us at West Bend, where we have been voted top workplaces to work three consecutive years. At West Bend, we believe that our employees are our greatest asset. We hire talented individuals who are conscientious, dedicated, customer focused, and able to build lasting...

  • Cloud Solutions Architect for Federal Financial Services

    2 weeks ago

    West Mclean, VA, United States Amazon Web Services, Inc. Full time

    Are you passionate about guiding clients in the adoption of cutting-edge cloud technologies and resolving complex technical challenges? Do you possess the expertise to assist teams in comprehending application architectures and migration strategies, along with the capability to steer projects towards successful outcomes?As a Cloud Solutions Architect at...

  • Software Architect

    2 weeks ago

    West Columbia, United States Rose International Full time

    •**Only qualified Software Architect candidates located near the Columbia, SC area to be considered due to the position requiring an onsite presence*** As a Salesforce Administrator at the Department of Admin, you will play a pivotal role in the daily maintenance, enhancement, and integration of our Salesforce instance. You will be...