Highlights
Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients world-wide.
Numbers & Facts
| Location | Hudson, MA (Remote) |
| Industry | Computer/IT Services |
| Salary | $39.28–$46.42 |
| Company Size | 100 to 499 employees |
| Year Founded | 2009 |
| Website | http://www.tekwissen.com/ |
Description
Overview:
TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients world-wide. Our client is a global professional services firm specializing in digital transformation, business process management (BPM), analytics, and AI-driven solutions. The company partners with organizations to improve efficiency, transform operations, and drive business outcomes through a combination of process expertise, technology, and data insight.
TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients world-wide. Our client is a global professional services firm specializing in digital transformation, business process management (BPM), analytics, and AI-driven solutions. The company partners with organizations to improve efficiency, transform operations, and drive business outcomes through a combination of process expertise, technology, and data insight.
Job Title: ETL Developer/Data Engineer
Location: Hudson, MA
Duration: 6 Months
Job Type: Temporary Assignment
Work Type: Remote
Job Description:
- We are looking for a savvy ETL Developer/ Data Engineer to join our team. The hire will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection.
- The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing existing data systems and building them from the ground up.
Primary Duties/Responsibilities:
- Maintain and provide enhancements to data architecture within new/existing systems including Data Warehouse.
- Recommend and implement processes to improve data quality, data reliability, and database performance.
- Employ variety of ETL and integration tools for system and data integrations.
- Architect solutions that support data scientist and business stakeholders.
- Conduct ETL testing and data transformation testing.
- Develop data models for data science team that can be utilized for data mining.
- Maintain source to target documentation and process flow documentation.
- Take on DBMS responsibilities and wear multiple hats such as: ETL's, serve as SQL Server DBA Processes/Job/Error Handling/Troubleshooting/Scheduling, etc.
- Proactively monitor ETL Processes / Jobs.
Experience:
- Relevant hands-on work experience in a Datawarehouse testing role.
- ETL (Extract Transform Load)/ODS (Operational Data Store) experience.
- MS SQL Server
- Commercial Real Estate experience preferred.
Education:
- Bachelor's degree in computer science or information technology from an accredited institution
Skills:
- ETL Tools: Azure Data Factory (ADF) 3+ year including API source exposure.
- Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. (4+ years of SQL) and working knowledge of Azure.
- Proficient in Azure Managed MS SQL Server database including setting indexes, database security, and backups.
- Data Testing: 3+ years
- Fundamental knowledge of data warehouse concepts
- Data Warehouse testing: 2+ year
- Must have Python skills Data frame, NumPy, Panda libraries
- C# 2+ Years
- Microsoft Fabric 1 Years
- Should be able to Develop Azure Logic App, Azure Function in C#.
- Experience in data duality, source systems analysis, and business rules validation.
- Ability to write and understand Source to Target documentation.
- Detail oriented and meticulous approach to duties.
- Keep our data separated and secure.
- Good analytical skills.
- A knack for independent and group work.
- Capacity to successfully manage a pipeline of duties with minimal supervision.
Good To Have:
- Familiarity with data and cybersecurity.
TekWissen Group is an equal opportunity employer supporting workforce diversity.
About Company
WE THE TEKWISSEN PEOPLE
TekWissen offers you a broader portfolio of services, industry-leading solutions, and the meaningful innovations that give you greater flexibility and speed to respond to market dynamics, reduced costs and risk to improve enterprise performance, and increased productivity to enable growth.
To keep pace with global market demands, TekWissen keeps its finger on the pulse of change. Our organized approach to guiding a project from its inception to closure. Managing projects is becoming more and more important as we enter the digital era. To cope with the pace that this transition demands, a method is required to manage projects so they can yield quality work, while incorporating efficient use of time and resources.
Project involves identifying which quality standards are relevant to the project and determining how to satisfy them.
It is important to perform quality planning during the Planning Process and should be done alongside the other project planning processes because changes in the quality will likely require changes in the other planning processes, or the desired product quality may require a detailed risk analysis of an identified problem. It is important to remember that quality should be planned, designed, then built in, not added on after the fact.
Capabilities and accomplishments in one TekWissen business enhance the opportunity for success in the others. Put simply, TekWissen's unique combination of attributes promotes success.