Data Integration Engineer

TEKsystems
Madison, WI, United States
Full-time
We are sorry. The job offer you are looking for is no longer available.

We are hiring a Data Integration Developer to join our team on a hybrid basis.Position Description : This is a key role on our IT Data Team requiring a broad range of skills and the ability to step into different roles depending on the size and scope of the business need.

Data ArchitectureSpecialize in data modeling, both 3NF and dimensional, with experience in conceptual, logical, physical, and industry data modeling.

Strong knowledge and experience with data architecture methodologies.Apply the appropriate level of modeling theory, pattern recognition, and abstractions to architect and design a pragmatic solution that functionally meets the business and technical requirements.

Partner with internal business units to define information requirements and translate them into appropriate data solutions.

Collaborate with IT and business partners to lead data discovery, profiling, analysis, and quality assessments in order to obtain clear information requirements.

Develop and validate source to target mappings and transformation logic required to support business needs. Understand the importance of capturing data lineage.

Architect, implement and verify end-to-end data solutions.Develop test plans needed to ensure a quality deliverable. Participate in validation testing, coordinate user acceptance testing and training to ensure the final implementation enables the user to solve their business problem.

General Data ManagementPlay a critical role in architecting our data and analytics solution landscapeDemonstrate competence, experience, knowledge, understanding, and advocacy of data management concepts, data warehousing, BI, and analytics.

Demonstrate ability to perform appropriate level of strategic thinking by viewing initiatives both within the immediate project context as well as the overall architectural vision.

Participate and / or Lead in data architectural design and strategy discussions.Data DeliveryWork with the business users to conduct data discovery engagements and can quickly identify, and prototype, a solution that brings together multiple data sources into one coherent concept and understanding.

data blending)Leverage existing tools to create data visualizations and mentors the business to be self-sufficient.Collaborate build relationships!Identify and communicate project risks and impediments and proactively work with other members of the Analytics team to complete high-value deliverables as identified by business partners and team leadership.

Partner with Analytics team members to translate business and functional requirements into technical designsStrive to understand the data consumption needs of the business community, as well as the problems faced by business users involving the access and use of dataHelp Analytics teams develop solutions that enable businesses to capitalize on business insights and drive toward gaining a competitive advantageTechnical Profile : Minimum of 3-5 years of experience in Data Solution delivery in a complex environment working collaboratively in a team settingProficient in Data Solution tools and concepts such as : Business Intelligence tools : Microsoft tools (SQL Server Management Studio, SSRS, SSAS, Power Pivot, Power Query, PowerBI), AlteryxDatabase : SQL ServerData Query tools : SQL, T-SQLData Management and Quality : data mapping, data profiling, metadata repository, relational data modeling, master data managementData Modeling : ER / Studio Data Architect, 3NF and dimensional modelingData Warehousing concepts : Inmon, Kimball, Data LakeData Integration concepts and strategies : EII, ETL, EL-T and EAIAbout TEKsystems : We're partners in transformation.

We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia.

As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change.

That's the power of true partnership. TEKsystems is an Allegis Group company.The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

2 days ago
Related jobs
Promoted
Gainwell Technologies LLC
WI, US
Remote

Experienced Business Analyst - Estate Recovery. Consider the business implications of the application of technology to the current and future business environment. Business Analyst position with 3 or more years of Medicaid knowledge, someone who has worked for or with the state preferred. Join the g...

Promoted
Exact Sciences
Madison, Wisconsin

The Principal Systems Engineer provides technical leadership, direction, and expertise in the design and development of instruments, software, or automation used in clinical laboratories to perform diagnostic tests. The Principal Systems Engineer works with project leads and teams to ensure that use...

Promoted
Church Mutual Insurance Company, S.I.
Madison, Wisconsin

Senior Underwriting Data Analyst. Develop advanced data and reporting solutions utilizing intelligence applications to provide dashboards, data marts, query tools, and ad hoc reporting. Retrieve and manipulate data from multiple data sources using current tools and software, such as SAS EG, SAS VA, ...

Promoted
Fortune 500
Madison, Wisconsin

...

Promoted
Trachte LLC
Madison, Wisconsin

Plans, directs, and coordinates integration design activities of assigned projects to ensure that output goals and/or objectives are accomplished within prescribed time frames and funding parameters by performing the following duties. Manages the Integration design process to seek, receive, interpre...

Promoted
Noblesoft Solutions
Madison, Wisconsin

Ability to automate test scripts for a data management platform supporting ETL, MDM, data quality and business intelligence. Ability to perform functional and non-functional testing for platform supporting ETL, MDM, data quality and business intelligence – 1 year. Compile and analyze statistical dat...

Promoted
Uline
Sun Prairie, Wisconsin

JavaCorporate Headquarters12575 Uline Drive, Pleasant Prairie, WI 53158Are you ready to design, innovate and lead in a collaborative, cutting-edge tech environment? Uline is seeking a Senior Java Software Developer to spearhead the development, deployment and maintenance. ...

Promoted
TECHEAD
WI, United States

Create and optimize data models and architecture within Azure Data Lake, ensuring efficient data organization and storage for analytical purposes. Design, implement, and maintain efficient and scalable data pipelines and ETL processes using Azure Data Factory or similar tools for data ingestion, tra...

Promoted
DataAnnotation
Madison, Wisconsin

We are looking for proficient programmers to join our team to train our AI chatbots to code.You will work with the chatbots that we are building in order to measure their progress, as well as write and evaluate code.Qualifications, skills, and all relevant experience needed for this role can be foun...

Promoted
Beacon Hill
Madison, Wisconsin
Remote

Using ETL tools to design ETL jobs (ETL 6 years, MINIMUM 2 years of ETL with Alteryx). Candidates MUST have Alteryx experience related to ETL, not just Alteryx experience based in data prep. Gathering requirements and developing technical specifications for ETL - 6 years. Testing and debugging ETL -...