ETL Developer/Data Engineer

• 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., * 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.

• 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 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.