Type: Full-time, Salary
Tilson is a high growth team of driven professionals with a national practice. We are on a mission to build America’s information infrastructure. We accomplish this with a team of experts working collaboratively on meaningful, impactful projects for great 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 has been recognized on the Inc. 5000 list of fastest growing private companies in the U.S. for seven years in a row.
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, conditioning or translating it to a format that is compatible with the new system’s data structures and initial loading processes, then loading the data in accordance with our stringent process and controls. Each project is a custom process for each client.
Participate in proposing, designing, and implementing solutions following the Tilson ETL architecture, standards, methodology and tools used.
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
Possess strong general computer and server skills and strong understanding of database concepts.
Advanced knowledge of SQL Server, SQL scripting abilities including T-SQL, PL/SQL and some data modeling experience.
Writes advanced SQL, including some query tuning
Experience pulling (extracting) data from a variety of data source types utilizing ODBC and/or Linked Servers
Ability to follow a scope document and create the scripts and process to perform the scope.
Design and develop SQL Server stored procedures, functions and views to be used during the ETL process.
Understanding of database triggers and constraints.
Experience in the identification of data quality.
Experience designing and building complete ETL processes moving and transforming data
Utilize ad-hoc techniques to perform on-the-fly analysis of data
Experience with Construction Industry ERP/Accounting systems
CMiC or Viewpoint ERP knowledge preferred
Motivated, a self-starter, responsible, honest with the ability to work unsupervised most of the time.
Outstanding analytical and problem-solving skills
Methodical and structured approach to design and development.
Delivery focused with the ability to prioritize activities.
Operates with a sense of urgency.
Innovative and resourceful.
Ability to work flexibly in a rapidly changing, ambiguous and often pressure-filled environment.
Successful candidates will be required to submit to criminal background check.
Tilson offers a competitive benefits package, including:
Paid time off
Healthcare, disability, dental and life insurance benefits
401(k) retirement savings plan with automatic company contribution
Entrepreneurial, highly technical and customer-focused work environment
Our mission is to serve our customers by building, integrating, and maintaining the information technology and communications infrastructure that enables great organizations to innovate and deliver.
Tilson is a world leader in executing information and communications technology projects to build a more connected world. We accomplish this with a team of experts working collaboratively on meaningful, impactful projects for great 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.
We will run our business sustainably, for its financial health, its people and the public good. We believe in:
Safety- above bottom line. Cutting corners is never an option.
Integrity- we do what is right, even if doing so puts us at a temporary disadvantage.
Accountability- everyone at Tilson is accountable for the work we do as a whole.
Professionalism- be trusted by our clients to be their ‘get it done’ team.
Respect- for our employees, clients, and partners.
Composure- we are comfortable in chaos and trust that we will always find a way through any challenge.
Tilson is an Equal Opportunity Employer/Affirmative Action employer
Tilson provides equal opportunity to all employees on the basis of individual qualification without regard to race, sex, religion, color, age, national origin, physical and mental disability, genetic information and history, sexual orientation, or other category protected by state or federal law. Tilson does not discriminate in the recruitment, hiring, compensation, promotion, transfer, benefits, or any other condition of employment.
Principals only. Recruiters should not contact Tilson.
No phone calls please.