Data Engineer

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. 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. 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. The successful candidate will demonstrate a passion for delivering data analytics to all levels of an organization, flexibility, team-player attitude, excellent communication skills, and will be driven by curiosity without the fear of failure. The IT organization offers a challenging environment focused on teamwork and delivering value added solutions for the organization. We consistently strive to attract and retain intelligent, creative, energetic, and fun employees with a focus on building exceptional teams. Responsibilities: Experience building business intelligence solutions with the ability to: 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 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 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 – priority referral Protected Veterans request. Aegion's mission is to keep infrastructure working better, safer and longer for customers throughout the world. Aegion is a multinational company providing pipeline services including the protection, rehabilitation, engineering and design of infrastructure projects for a wide range of industries. We are industry pioneers and continue to develop transformational solutions to rehabilitate, maintain and strengthen aging infrastructure, especially pipelines in the wastewater, water, energy, mining and refining industries. Above all else, Aegion strives to protect our communities through Stronger. Safer. Infrastructure.®