ETL Developer

Job Description

We are seeking business intelligence developer who can implement ETL solutions for clients in different industries dealing with various types of challenging data. Candidates must have an advanced knowledge of SQL Server, SSIS Catalog, SSIS, T-SQL, and some data modeling experience. Candidates must have strong communication skills that allow you to regularly deal with the business, as well as with specialists from related fields, including database developers, and software engineers. Candidates must have outstanding analytical and problem solving skills and a good grasp of the technical side of business intelligence and always keep up to date with the latest BI tools and technologies.

 Responsibilities:

  • Design, build and deploy effective SSIS packages
  • Implement stored procedures and effectively query a database
  • Translate requirements from the business and analyst into technical code
  • Identify and test for bugs and bottlenecks in the ETL solution
  • Ensure the best possible performance and quality in the packages
    Provide support and fix issues in the packages

Skill Requirements:

  • Writes advanced SQL including some query tuning
  • Experience in the identification of data quality
  • Some database design experience is helpful
  • Experience designing and building complete ETL/SSIS processes moving and transforming data for ODS, Staging, and Data Warehousing
  • Some Knowledge of C#/VB.NET a plus
  • Utilize ad-hoc techniques to perform on-the-fly analysis of data
  • Proficient in how to deploy to and debug a production SSIS environment

 

Application Developer (.NET Core MSFT) 

MUST HAVES

  • Minimum 5 years related experience
  • Has to have led\managed a team formally for at least a year
  • AWS and\or Azure experience - architecting solutions in Cloud Environments
  • Agile software development experience
  • English as first or very advanced English if not first

NICE TO HAVE

  •  Data background - either in Analytics, Warehousing, Data Integration\API Dev, Visualization, etc

Technical Background  

  • C#, .NET, .NET Core 2+, ASP.NET MVC, IIS 7.5+, LINQ and Entity Framework
  • AngularJS, VueJS or ReactJS front end experience
  • SQL Server 2012-2017
  • Primarily developing enterprise data management applications\web applications\APIs - RESTful API development - JSON
  • Experience with DevOps concepts such as code versioning, branching, shelving, merging, and publishing
  • MSFT Azure or AWS experience

 

Technical Lead

  • Minimum 5 years related experience
  • Has to have led\managed a team formally for at least a year
  • AWS and\or Azure experience - architecting solutions in Cloud Environments
  • Agile software development experience
  • English as first or very advanced English if not first
  • Data background - either in Analytics, Warehousing, Data
  • Integration\API Dev, Visualization, etc

    Technical Background

  • PHP - Laravel, etc
  • Other options
  • Data Engineer
  • Integration Engineer using SSIS, Talend, Pentaho
  • Data Warehousing
  • Data Modeling
  • Big Data technologies
  • Apache Hadoop, Spark, etc
  • SQL Server, MySQL, Aurora primary experience (Oracle, Postgres, MongoDB secondary experience)
  • .NET Application Developer
  • Primarily developing enterprise data management applications\web applications\APIs
  • MSFT Azure or AWS experience

 

Administrative Assistant

We are looking for a responsible Administrative Assistant to perform a variety of administrative and clerical tasks. Duties of the Administrative Assistant include providing support to our partners and employees, assisting in daily company needs, and managing our company’s general administrative activities.

Administrative Assistant responsibilities also include making travel and meeting arrangements, preparing reports and maintaining appropriate filing systems. The ideal candidate should have excellent oral and written communication skills and be able to organize their work using tools, like MS Excel and office equipment.  Ultimately, a successful Administrative Assistant should ensure the efficient and smooth running of our day-to-day operations.

Responsibilities

  • Answer and direct phone calls
  • Organize and schedule appointments
  • Plan meetings and take detailed minutes
  • Write and distribute email, correspondence memos, letters, faxes and forms
  • Assist in the preparation of regularly scheduled reports
  • Develop and maintain a filing system
  • Update and maintain office policies and procedures
  • Order office supplies and research new deals and suppliers
  • Maintain contact lists
  • Book travel arrangements
  • Submit and reconcile expense reports
  • Provide general support to visitors
  • Act as the point of contact for internal and external clients
  • Liaise with executive and senior administrative assistants to handle requests and queries from senior managers

Requirements

  • Proven experience as an administrative assistant, virtual assistant or office admin assistant
  • Knowledge of office management systems and procedures
  • Working knowledge of office equipment, like printers and fax machines
  • Proficiency in MS Office (MS Excel and MS PowerPoint, in particular)
  • Excellent time management skills and the ability to prioritize work
  • Attention to detail and problem solving skills
  • Excellent written and verbal communication skills
  • Strong organizational skills with the ability to multi-task
  • High School degree; additional qualification as an Administrative assistant or Secretary will be a plus

 

Technical Lead

The Technical Lead is a combination of a business and technical customer facing role that will be accountable from a technical perspective for the end-to-end customer data technical architecture, development, deployment and support. As a Technical Lead, you will work with stakeholders and manage the internal development team to guide technical development. The Technical Lead will lead the development team to setup, configure and deploy the systems. Some of these information systems may include CRM, Accounting, Finance, Operations (line of business), Reporting, Website, Inventory Systems, Order Management.

This role has a particular emphasis on managing the development process, managing a functional development team, and advising on best practices.

The ideal candidate will have experience in customer facing and development management roles and have led successful technical and economic value discussions with senior customer executives, driving decisions and implementation.

 

Blockchain Developer

We are looking for an experienced and motivated Blockchain Developer who is highly collaborative, works well with product owners, and is committed to creating solutions to meet end-user and business needs. The ideal candidate will have a thorough understanding of cryptography, cryptocurrency, Blockchain, smart contracts and the related application development. Critical thinking, business acumen, and communication are heavily valued and deeply encouraged. If you are interested in learning, growing professionally and working with a great team, this position is for you.

Responsibilities

  • Be an integral member of the team that builds site features, functionality, apps, and tools on tight deadlines
  • Research, strategize and educate on methodology and best practices for blockchain design, implementation, and deployment
  • Design and implement blockchain supporting tools and utilities
  • Create, audit, and review Solidity smart contracts
  • Successfully implement the use of blockchain per clients’ needs
  • Work closely with architecture and, design and backend teams to ensure the technical feasibility of functionality and design.
  • Maintain company-defined and industry standards and best practices
  • Work collaboratively with the development team and stakeholders to ensure the overall platform implementation is technically cohesive
  • Propose solutions to iterate, launch, test, assess, and repeat in order to refine the user experience and enhance business results
  • Advise organization on technology best suited to meet Company’s objectives and requirements
  • Must be able to gather requirements, design, code, and test independently as well as work within a team structure
  • Develop technical documentation as needed

Minimum Qualitifications

  • 2-5 years of related experience
  • Cryptography, Security, Bitcoin, Ethereum, Solidity, Smart Contracts
  • Node.js, web3.js, Javascript
  • C#, ASP.NET, SQL Server
  • Azure, AWS
  • Distributed Systems, Microservices Architecture
  • Experience with Git or other version control system
  • BS degree in Computer Science or related field

 

Solutions Architect

The Solutions Architect (SA) is a combination of a business and technical customer facing role that will be accountable from an architecture perspective for the end-to-end customer data platform design, architecture, and deployment. As a Solutions Architect, you will work with stakeholders to specify, design, and select information systems that deliver great value to the client’s organization. In addition, you will work with the development team to setup, configure and deploy the systems with ultimate ownership responsibility for the end product. Some of these information systems may include CRM, Accounting, Finance, Operations (line of business), Reporting, Website, Inventory Systems, Order Management, etc.

This role has a particular emphasis on identifying a customer need and finding a system that will solve their problem. The SA should understand data structures and information architecture at a high-level. They will work with the client to understand their business, operational workflows and processes then collaborate with the delivery team for execution. Additionally, the SA will continually show value to the client via systems implementation, improved process workflow and reduced operation cost.

The ideal candidate will have experience in customer facing roles and have led successful technical and economic value discussions with senior customer executives, driving decisions and implementation.

 

Entry-level Database Engineer

​
Description:

Treehouse Technology Group (TTG) is looking for a self-motivated database engineer to work on unique, custom data warehousing and data integration projects. This position will be building data models for business intelligence, analytics, and dash-boarding projects across a variety of industries. We love all-things-data here at TTG and we are looking for other ambitious, driven individuals who want to work with us and learn quickly. Critical thinking, business acumen, and communication are heavily valued and deeply encouraged. If you are interested in learning, growing professionally and working with a great team, this position is for you. Send me a message or send an email and cover letter to [email protected]

Responsibilities:

  • Design and implement custom data warehouse (OLAP) and ETL solutions
  • Design and implement custom data integration solutions
  • Ensure best practices for data integrity, quality, access and security
  • Design logical data models and physical database designs optimized for performance, availability and reliability.
  • Build cool things that will scale

Secondary Job Responsibilities:

  • Design and implement dashboards and reports
  • Design and implement tools to automate database operations and monitoring
  • Tuning and optimization of backend and frontend data operations.
  • Scripting and automation to support development, QA and production database environments and deployments

Minimum Qualifications:

  • Passion for data technology
  • B.S. degree in Computer Science or related discipline, with strong academic record
  • 1- 3 years experience in a Database Management role (e.g., DBA, ETL, Data Analyst), and/or working with relational databases, preferably MySQL and Microsoft SQL Server
  • Strong work ethic, sense of ownership and initiative
  • Strong background in Agile software development
  • Strong analytical, programming and problem solving skills
  • Self-motivated, organized, ability to handle multiple projects

Preferred Qualifications:

  • Experience with AWS
  • Experience with SSIS, Talend Open Studio
  • Experience in database tuning, performance optimization, replication
  • Experience with at least one scripting language
  • Knowledge of financial services industry (alt. health care, logistics, cpg, web analytics, marketing)