Tilson is on a mission to build America's information infrastructure and we are seeking individuals from across the country to join us. Recognized on the Inc. 5000 list of fastest-growing private companies in the U.S. for 13 years in a row, Tilson is a high growth team of driven professionals with a national practice. We build high-performing teams who take on the largest and most impactful projects for our clients.

Position Details

Tilson is looking for an ETL Consultant to assist our Construction Industry clients in moving from one ERP software system to another. This role will be responsible for extracting data from a variety of legacy systems, conditioned or translated to a format that is compatible with the new system’s data structures and initial loading processes, then loaded in accordance with our stringent process and controls.

Responsibilities:

• Will participate in proposing, designing, and implementing solutions following the Tilson ETL architecture, standards, methodology and tools used.
• Conduct various client facing sessions such as Discovery, Scope, Planning, Status Reporting, etc.
• Translate requirements from the business into technical code.
• Implement stored procedures and effectively query a database.
• Performs source data mapping to map the data from source systems to the target data model.
• Identify and test for bugs and bottlenecks in the ETL solution.
• Ensure the best possible performance and quality in the packages.
• Ability to report your progress within a team structure.
• Follows Tilson’s best practices on data conversion.
• Provide excellent customer service, empathy, and build relationships with the Client.
• Bring your knowledge, experience professionalism to every situation.
• Volunteer and Express your thoughts and ideas around solutions or processes.

Qualifications:

• Strong and effective inter-personal and communication skills and the ability to interface professionally with a diverse group of Clients, including management and senior level executives.
• Strong attention to detail, excellent organization skills, and ability to manage multiple projects under tight deadlines.
• Analytical mind with a problem-solving aptitude.
• Entrepreneurial spirit and self-motivated.
• Exceptional team (and self-testing) quality assurance, processes, and execution.
• High Level of experience with MSSQL and/or Oracle.
• Advanced knowledge of T-SQL and/or PL/SQL
• Ability to create views, functions, stored procedures, etc.
• Understanding of MSSQL Linked Servers.
• Knowledge of cloud based ETL processes and/or API usage beneficial.
• Experience with CMiC, Vista by Viewpoint, or other Construction ERP systems strongly preferred.
• Minimum of 5 years’ experience in related field, and a strong understanding of construction ERP systems.

We accomplish our mission with a team of experts working collaboratively on meaningful, impactful projects for our clients. Our team environment fosters intellectual curiosity, motivates employees, and cultivates talented people who work with purpose, mastery and autonomy. We strive to listen to our clients, partner with them as a team, and accept their goals as our own.

Tilson believes in Safety, Integrity, Accountability, Professionalism, Respect, and Composure. To learn more about Tilson, the benefits we offer and our values , we invite you visit our website or visit our LinkedIn , Glassdoor, or Facebook pages for an inside glimpse at our culture.

Successful candidates will be required to submit to criminal background check and may be subject to a drug screen.

Tilson is an Equal Opportunity Employer/Affirmative Action employer.