Maagsoft Inc.
Role: Data Engineer
Location: Iowa (Remote)
Experience: 11 Years (Passport Copy Mandatory)
Base Pay Range $50.00/yr - $60.00/yr
Responsibilities
Work with a highly dynamic team focused on Digital Transformation.
Understand the domain and business processes to implement successful data pipelines.
Provide work status and coordinate with Data Engineers.
Manage customer deliverables and regularly report the status via Weekly/Monthly reviews.
Design, develop and maintain ETL processes, stored procedures, functions, and views.
Program in T‑SQL with relational databases including supported versions of Microsoft SQL Server.
Write high‑performance SQL queries using joins, cross apply, aggregate queries, merge, pivot.
Design normalized database tables with proper indexing and constraints.
Perform SQL query tuning and performance optimization on complex and inefficient queries.
Provide guidance on the use of table variables, temporary tables, and CTEs to handle large datasets.
Collaborate with DBA on database design and performance enhancements.
Lead all phases of the software development life cycle in a team environment.
Debug existing code and troubleshoot issues.
Design and provide a framework for maintaining the existing data warehouse for reporting and data analytics.
Follow best practices, design, develop, test and document ETL processes.
Qualifications
Strong experience with EDW, Data Lake, AI/ML and Omni‑Channel.
Strong proficiency in Databricks and Azure Data Factory.
Experience in Data Development functions: design of new or enhancement of existing enterprise database systems; maintenance and/or development of critical data processes; unit and system testing; support and help desk tasks.
Experience architecting ETL functions between relational databases and external data files.
Strong programming ability; must be a strong programmer.
Familiarity with data visualization and ETL processes.
Additional Information
Seniority level: Mid‑Senior level
Employment type: Contract
Job function: Information Technology
Industries: Staffing and Recruiting
Contact Pavan Lead Technical Recruiter
Email: Pavan@maagsoft.com Cell: (518)631-2888
#J-18808-Ljbffr
Experience: 11 Years (Passport Copy Mandatory)
Base Pay Range $50.00/yr - $60.00/yr
Responsibilities
Work with a highly dynamic team focused on Digital Transformation.
Understand the domain and business processes to implement successful data pipelines.
Provide work status and coordinate with Data Engineers.
Manage customer deliverables and regularly report the status via Weekly/Monthly reviews.
Design, develop and maintain ETL processes, stored procedures, functions, and views.
Program in T‑SQL with relational databases including supported versions of Microsoft SQL Server.
Write high‑performance SQL queries using joins, cross apply, aggregate queries, merge, pivot.
Design normalized database tables with proper indexing and constraints.
Perform SQL query tuning and performance optimization on complex and inefficient queries.
Provide guidance on the use of table variables, temporary tables, and CTEs to handle large datasets.
Collaborate with DBA on database design and performance enhancements.
Lead all phases of the software development life cycle in a team environment.
Debug existing code and troubleshoot issues.
Design and provide a framework for maintaining the existing data warehouse for reporting and data analytics.
Follow best practices, design, develop, test and document ETL processes.
Qualifications
Strong experience with EDW, Data Lake, AI/ML and Omni‑Channel.
Strong proficiency in Databricks and Azure Data Factory.
Experience in Data Development functions: design of new or enhancement of existing enterprise database systems; maintenance and/or development of critical data processes; unit and system testing; support and help desk tasks.
Experience architecting ETL functions between relational databases and external data files.
Strong programming ability; must be a strong programmer.
Familiarity with data visualization and ETL processes.
Additional Information
Seniority level: Mid‑Senior level
Employment type: Contract
Job function: Information Technology
Industries: Staffing and Recruiting
Contact Pavan Lead Technical Recruiter
Email: Pavan@maagsoft.com Cell: (518)631-2888
#J-18808-Ljbffr