Assistant Database Engineer - Innovation Centers

Turner Construction Company Minneapolis , MN 55415

Posted 6 months ago


Project Location(s):Minneapolis, MN 55401 USA

Minimum Years Experience:Travel Involved:None/Not SpecifiedJob Type:RegularJob Classification:EntryEducation:Bachelors DegreeJob Family:ConstructionCompensation:Salaried Non-Exempt

Title: Assistant Database Engineer

We are currently establishing a number of innovation centers around the globe for the research and development of critical technologies to address our broad range of operations and enable our digital transformation. We are leveraging advancements in AI, machine learning to enhance productivity, reduce risks, protect workers and develop future business opportunities.

Roles and Responsibilities:
As members of the data engineering team, our Assistant Database Engineers are responsible for assisting our data architect with our data warehouse environment, including both the load and transformation of data and storage in a fast-paced research and development environment.

Essential Duties and Responsibilities:

  • Assist in the intergradation of data from various sources into data warehouse environments

  • Assist in the development of a data dictionary crossing both old and new systems to translate terminology and naming convention differences between the systems

  • Communicates directly with technical resources from 3rd party vendors who are supplying data to establish requirements for the delivery of data and the understanding of the meaning and purpose of individual data elements

  • Assist in the development and building of a data model to house data from both old and new systems, under the supervision of the data architect

  • Assist in writing ETL packages necessary to transform and load data into the data warehouse

  • Assist in the designs and development of a method of blending data from old and new systems into a single structure so that the organization has a continuous record of data crossing both time frames

  • Assist in writing ETL packages necessary to publish harmonized data sets (representing data from the old and new systems blended) into other data marts and other databases that need to consume this data

  • Qualifications:

  • Bachelor of Science degree in Computer Science, or equivalent experience

  • 2 or more years of experience in database development including ETL work

  • Strong understanding of normalization and de-normalization of data

  • Able to quickly and independently discover and understand the meaning and purpose of data

  • Able to recognize similar data in multiple systems even If the terminology is different

  • Excellent communication skills in interacting with both 3rd party vendors and internal teams

  • Able to blend data from multiple sources into a single data source, preserving the integrity and traceability of data sources

  • Functional understanding of working within an Agile team, including working in sprints

  • A strong understanding with large and complex datasets with particular emphasis in the construction industry is highly desirable

  • The ability to innovate and think outside the box in an R&D environment with the ability to produce quick turnaround prototypes and the ability to scale as needed

  • A strong understanding of SQL required

  • A strong understanding of the common industry databases such as MySQL, PostgresSQL, Oracle, SQL Server, etc.

  • Experience with ETL tools required

  • Experience with data warehouse environments required

  • Proficiency in either TSQL or PLSQL a plus

Turner is an Equal Opportunity Employer minorities/females/veterans/individuals with disabilities/sexual orientation/gender identity.

VEVRAA Federal Contractor

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Database Automation Engineer

Wells Fargo

Posted 2 days ago

VIEW JOBS 10/20/2019 12:00:00 AM 2020-01-18T00:00 Job Description At Wells Fargo, we want to satisfy our customers' financial needs and help them succeed financially. We're looking for talented people who will put our customers at the center of everything we do. Join our diverse and inclusive team where you'll feel valued and inspired to contribute your unique skills and experience. Help us build a better Wells Fargo. It all begins with outstanding talent. It all begins with you. Wells Fargo Technology sets IT strategy; enhances the design, development, and operations of our systems; optimizes the Wells Fargo infrastructure footprint; provides information security; and enables continuous banking access through in-store, online, ATM, and other channels to Wells Fargo's more than 70 million global customers. Enterprise Database Management is the Center of Excellence for database management within Wells Fargo. This position provides senior level capabilities relative to database engineering for the company. EDM Engineering sets database strategy by engineering the design, development, and operations of our database software/systems. The Enterprise Database Management Engineering (EDME) SQL Server Team is seeking a senior database analyst with focus on automation. This position will play a senior level role in streamlining, planning, designing, implementing and managing the EDM SQL Server database platform via scripting and automation. The ideal candidate will possess cross-functional skills and thrive in an Agile environment. This position will provide complex automation solutions using existing technology and tools. This position will interface with service delivery teams, application teams, and other DBA teams within EDM to support and deliver automation services. The successful candidate must be comfortable working on multiple dynamic projects simultaneously in an Agile environment, collaborating with database engineers, database architects, project managers, application teams, information security teams, and leadership at all levels of the organization. The person filling this position must be able to: * Provide technical consultation and support in the development of automation solutions * Translate requirements into code for new or existing solutions and projects * Work closely with existing database development staff to complete tasks * Work closely with other teams to understand and document requirements * Ability to troubleshoot and validate data query results * Ability to work with a team as well as be a self-starter * Developing original, intricate solutions and simplifying when feasible to improve maintainability * Participate in system and user acceptance testing tasks as assigned * Assure quality, security, and compliance requirements are met * Participate in an on call rotation if needed Required Qualifications * 10+ years of database design and administration experience * 5+ years of MS SQL server experience Desired Qualifications * Excellent verbal, written, and interpersonal communication skills * Web Services experience * 2+ years of SQL Server Integration Services (SSIS) experience * SQL Server Reporting Services (SSRS) experience Other Desired Qualifications * 7+ years of application development and implementation experience * 3+ years of experience designing and implementing process solutions for automation * 2+ years of PowerShell scripting experience * Knowledge and understanding of relational database concepts, querying, requirements gathering, and/or decision support tools * The capability to write and interpret advanced SQL Queries * Excellent verbal, written, and interpersonal communication skills * Passion for developing automated management of a large database environment * Knowledge and understanding of automation and engineering release development * Experience using JIRA or TFS with Agile methodologies * Experience developing in a fast paced environment using Agile methodologies, combined with a solid understanding of automation * Strong understanding of data loading and data cleansing principles * 2+years of working with any type of automation framework (System Center Orchestrator, Ansible, HP Operations Orchestrator / HP Server Automation, VMware, vRealize) * Experience with Agile Scrum (Daily Standup, Sprint Planning, and Sprint Retrospective meetings) and Kanban * Experience with WSDL, SOAP, API, REST * Knowledge and understanding of test driven solutions development * Technical working knowledge of layered products, networking concepts and storage system architectures * Experience with System Center Operations Manager (SCOM) monitoring in a SQL Server environment. Salary Information The salary range displayed below is based on a Full-time 40 hour a week schedule. MN-Minneapolis: Min: $105,000 Mid: $150,000 AZ-Chandler: Min: $105,000 Mid: $150,000 IA-West Des Moines: Min: $105,000 Mid: $150,000 MO-Saint Louis: Min: $105,000 Mid: $150,000 NC-Charlotte: Min: $105,000 Mid: $150,000 NC-Charlotte: Min: $105,000 Mid: $150,000 Street Address MN-Minneapolis: 255 2nd Ave S - Minneapolis, MN AZ-Chandler: 2600 S Price Rd - Chandler, AZ IA-West Des Moines: 7001 Westown Pkwy - West Des Moines, IA MO-Saint Louis: 1 N Jefferson Ave - Saint Louis, MO NC-Charlotte: 401 S Tryon St - Charlotte, NC NC-Charlotte: 1525 W Wt Harris Blvd - Charlotte, NC Disclaimer All offers for employment with Wells Fargo are contingent upon the candidate having successfully completed a criminal background check. Wells Fargo will consider qualified candidates with criminal histories in a manner consistent with the requirements of applicable local, state and Federal law, including Section 19 of the Federal Deposit Insurance Act. Relevant military experience is considered for veterans and transitioning service men and women. Wells Fargo is an Affirmative Action and Equal Opportunity Employer, Minority/Female/Disabled/Veteran/Gender Identity/Sexual Orientation. Wells Fargo Minneapolis MN

Assistant Database Engineer - Innovation Centers

Turner Construction Company