ZT Group Intl, Inc. dba ZT Systems
Senior ETL Developer - Azure Data Tools
ZT Group Intl, Inc. dba ZT Systems, Secaucus, New Jersey, us, 07094
Senior ETL Developer - Azure Data Tools page is loaded
Senior ETL Developer - Azure Data Tools
Apply locations Secaucus, NJ time type Full time posted on Posted 30+ Days Ago job requisition id R-103749
About the Role We are looking for a passionate Senior
ETL
Developer
SSIS
/Azure Data tools. The
ETL
Developer will be involved in developing solutions for enterprise data warehousing (EDW), reporting and business intelligence (
SSIS
/
SSRS
) initiatives. Work with business usersand functional and development teams to collect, analyze, and document requirements. The role is responsible for designing, coding, testing, and scheduling
ETL
programs to support the enterprise and reporting data warehouse. Our ideal candidates are familiar with various data collectionand visualization products and solutions and have hands-on experience with end-to-end development.
Azure Data Factory, Azure SQL Database Services, Data Lake and MS SQL. What You Will Do Understand technical requirements and develop
data models
usable by users and efficient for ETLs.
Organize, design, develop
ETL
workflows from heterogeneous data sources and dashboards for scalable, refreshable analysis and reporting
Assist with impact analysis of changing upstream processes to Data Warehouse and Reporting systems.
Supporting analysts with data queries and dashboard creation used for business decision making and performance monitoring.
Writes technical documentation (design specifications, data model diagrams, data flow diagrams, Configuration Management, Production Support documents etc.,).
Adhere to development standards, time tracking, policies and change management process
Monitors developed
ETL
processes in production, and trouble-shoots production problems when they occur.
What You Will Need A minimum 5
years experience with Azure Data Factory is highly preferred.
2+ years of relevant experience in software application development, information technology or a related field
Bachelor's degree in related field required, or advanced degree with equivalent work experience
Understanding of database management systems, online analytical processing (OLAP) and
ETL
(Extract, transform, load) framework.
Strong experience with
MS SQL
queries.
Working knowledge of Microsoft Power BI, Tableau.
Knowledge of at least one ERP system/functions such as SAP, Syspro, Oracle etc., is a plus but not required.
Must have ability to translate requirements to technical implementation
Strong verbal communication skills and team collaboration consensus required
Analytical mind with a problem-solving aptitude
Ability to work independently and with a team on simultaneous tasks in a fast-paced environment with emphasis on accuracy and timeliness
Please apply only if can work as a ZT employee in our Secaucus, NJ headquarters. ZT Systems assesses market data to ensure a competitive compensation package is created for all our employees. The typical base salary for this position is expected to be between $82,500 and $121,000 per year.If hired, the final base salary will be determined on an individual basis taking into consideration experience, skills, knowledge, education and/or certifications. Base salary is just one component of ZT Systems total rewards philosophy. We take pride in offering a wide range of benefits and perks that appeal to the variety of needs across our diverse employee base. Other rewards may include bonus, paid time off, generous 401k match, tuition reimbursement, wellbeing resources, and more. We are dedicated to building a diverse, inclusive, and authentic workplace, so if youre excited about this opportunity but your experience doesnt align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for this or other roles. About ZT Systems
At ZT Systems, youll get to do work you are proud of alongside smart, passionate people. Every day, there are opportunities to collaborate with the best in the industry to design, build, and deliver impactful solutions to world-class customers. Along the way, you will gain hands-on experience in a face-paced environment thats challenging, rewarding, and career-defining. A culture built around our values we work hard and think fast. We view challenges as opportunitiesto do better, push harder, and be faster than we were the day before. When we fail, we learn from it and move on together. And when we succeed, we use the momentum to go even further. We create value with everything we do, building the foundation of todayand transforming the future of tomorrow.
Join ZT Systems and help us build technology infrastructure that connects the world. What We Offer
When you join ZT, youll enjoy a range of world-class, inclusive employee benefits designed to grow with you and our company. From competitive compensation to 401K matching to comprehensive health & wellness programs and tuition reimbursement, ZT Systems offers industry leading benefits packages for eligible employees designed to help you get the most out of life. ZT Group Intl. is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. ZT Systems provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. About US
If you are a current
ZT Systems employee
interested in applying for an internal job, please use this link below: #J-18808-Ljbffr
Apply locations Secaucus, NJ time type Full time posted on Posted 30+ Days Ago job requisition id R-103749
About the Role We are looking for a passionate Senior
ETL
Developer
SSIS
/Azure Data tools. The
ETL
Developer will be involved in developing solutions for enterprise data warehousing (EDW), reporting and business intelligence (
SSIS
/
SSRS
) initiatives. Work with business usersand functional and development teams to collect, analyze, and document requirements. The role is responsible for designing, coding, testing, and scheduling
ETL
programs to support the enterprise and reporting data warehouse. Our ideal candidates are familiar with various data collectionand visualization products and solutions and have hands-on experience with end-to-end development.
Azure Data Factory, Azure SQL Database Services, Data Lake and MS SQL. What You Will Do Understand technical requirements and develop
data models
usable by users and efficient for ETLs.
Organize, design, develop
ETL
workflows from heterogeneous data sources and dashboards for scalable, refreshable analysis and reporting
Assist with impact analysis of changing upstream processes to Data Warehouse and Reporting systems.
Supporting analysts with data queries and dashboard creation used for business decision making and performance monitoring.
Writes technical documentation (design specifications, data model diagrams, data flow diagrams, Configuration Management, Production Support documents etc.,).
Adhere to development standards, time tracking, policies and change management process
Monitors developed
ETL
processes in production, and trouble-shoots production problems when they occur.
What You Will Need A minimum 5
years experience with Azure Data Factory is highly preferred.
2+ years of relevant experience in software application development, information technology or a related field
Bachelor's degree in related field required, or advanced degree with equivalent work experience
Understanding of database management systems, online analytical processing (OLAP) and
ETL
(Extract, transform, load) framework.
Strong experience with
MS SQL
queries.
Working knowledge of Microsoft Power BI, Tableau.
Knowledge of at least one ERP system/functions such as SAP, Syspro, Oracle etc., is a plus but not required.
Must have ability to translate requirements to technical implementation
Strong verbal communication skills and team collaboration consensus required
Analytical mind with a problem-solving aptitude
Ability to work independently and with a team on simultaneous tasks in a fast-paced environment with emphasis on accuracy and timeliness
Please apply only if can work as a ZT employee in our Secaucus, NJ headquarters. ZT Systems assesses market data to ensure a competitive compensation package is created for all our employees. The typical base salary for this position is expected to be between $82,500 and $121,000 per year.If hired, the final base salary will be determined on an individual basis taking into consideration experience, skills, knowledge, education and/or certifications. Base salary is just one component of ZT Systems total rewards philosophy. We take pride in offering a wide range of benefits and perks that appeal to the variety of needs across our diverse employee base. Other rewards may include bonus, paid time off, generous 401k match, tuition reimbursement, wellbeing resources, and more. We are dedicated to building a diverse, inclusive, and authentic workplace, so if youre excited about this opportunity but your experience doesnt align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for this or other roles. About ZT Systems
At ZT Systems, youll get to do work you are proud of alongside smart, passionate people. Every day, there are opportunities to collaborate with the best in the industry to design, build, and deliver impactful solutions to world-class customers. Along the way, you will gain hands-on experience in a face-paced environment thats challenging, rewarding, and career-defining. A culture built around our values we work hard and think fast. We view challenges as opportunitiesto do better, push harder, and be faster than we were the day before. When we fail, we learn from it and move on together. And when we succeed, we use the momentum to go even further. We create value with everything we do, building the foundation of todayand transforming the future of tomorrow.
Join ZT Systems and help us build technology infrastructure that connects the world. What We Offer
When you join ZT, youll enjoy a range of world-class, inclusive employee benefits designed to grow with you and our company. From competitive compensation to 401K matching to comprehensive health & wellness programs and tuition reimbursement, ZT Systems offers industry leading benefits packages for eligible employees designed to help you get the most out of life. ZT Group Intl. is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. ZT Systems provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. About US
If you are a current
ZT Systems employee
interested in applying for an internal job, please use this link below: #J-18808-Ljbffr