Microsoft ETL Developer

Company: W.B. Mason Company, Inc.
Location: Brockton
Posted on: January 17, 2022

Job Description:

Company IntroductionW.B. Mason has been providing goods and services to American businesses for over 130 years. We pride ourselves on our long history of partnering with our customers and vendors to offer innovative, cost effective and customized solutions to an ever-evolving set of business requirements. Over the last decade we have been investing in technology and building a talented, dedicated in-house development team to ensure we can focus on agility and continual delivery of solutions. In the past year the Covid-19 Pandemic has disrupted the way our company and hundreds of thousands of our customers across the US - need to work. And once again WB Mason has been able to adapt and meet the moment in many ways because of our commitment to a strong technology foundation and the capabilities of our amazing people.W.B. Mason recently embarked on an ambitious, multi-year digital transformation journey designed to help the Company take advantage of cloud-based technologies across the business. Were partnering with Microsoft to transform our ERP + CRM capabilities with Dynamics 365 / Power Platform and our data + reporting capabilities with Azure / Power BI. Joining the technology team at W.B. Mason will provide you with a tremendous opportunity to use the latest solutions to help our stakeholders increase their efficiency through process automation and increase their business insight through comprehensive, real-time data analytics. Weve made a lot of great progress since we started our journey, but a lot of work remains to be done and we need to grow our team of passionate, hard-working professionals to help us achieve our bold objectives in the coming years. If this sounds like an exciting mission to you, we look forward to speaking with you soon. Summary W.B. Mason is looking to add an ETL Developer to support the Companys on-going data management efforts and migration to the Microsoft D365 and Azure platforms.Our Data Team is based in Brockton, MA; however, this position would be fully remote for the foreseeable future, until such time as it is safe to return to the office. That said, candidates interested in working fully remote will also be considered (with the acknowledgement that, in the future, there may be the potential need to travel to Massachusetts for occasional in-person meetings).While W.B. Mason is working hard to migrate its core data to Azure, the Company still has a significant on-premises SQL landscape that needs to be maintained and enhanced. Given those parallel demands, W.B. Mason is looking for experienced data professionals to enhance our capabilities and capacity to tackle these exciting projects. The ideal candidate for this ETL Developer role will be well-versed in on-premises SQL / SSIS solutions, with some experience with Azure data platforms being a plus.The candidate must be detail-oriented and have the ability to manage / prioritize multiple projects while also supporting any issues that might arise with Production workloads.This is an excellent opportunity for data professionals who are looking to build upon their current knowledge and expertise in Microsoft SQL Server ETL practices while gaining exposure to and experience in Azure Data Services.Essential Duties and Responsibilities

• Candidate must have minimum of 3-5 years of experience in ETL development.
  • Minimum of 3 years hands-on experience using ETL tools (SSIS / Azure Data Factory) is a must.
    • Ability to design, develop, implement and support ETL processes from embedded sources to SQL data warehouse.
      • Ability to design, develop and maintain SQL objects such as tables, stored procedures, functions and schemas.
        • Extensive programming experience in PL/SQL and database skills.
          • Demonstrated knowledge of database structures and data architecture.
            • Hands-on experience with Big Data technologies such as Python, Node.js, Scala, etc. is a plus.
              • Familiarity with fundamentals of SDLC and experience working with developer tools such as TFS, Azure DevOps and GitLabs.
                • Independently motivated to learn, collaborate and work with the Data Engineering Team in their upcoming efforts to migrate on-premises data to Azure.
                  • Demonstrated ability to deliver projects on time.Education and/or Experience
                    BS/BA degree or equivalent

                    Bachelors Degree in Technology related discipline preferredMinimum QualificationsTo perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed above are representative of the knowledge, skill and/or ability required.Physical DemandsThe physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is required to stand, walk, speak and hear. The employee is frequently required to sit. The employee is frequently required to use hands/fingers for data entry and filing. The employee must be able to lift up to 20 pounds.Equal Opportunity EmployerW.B. Mason Company, Inc. is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status.

Keywords: W.B. Mason Company, Inc., Brockton , Microsoft ETL Developer, IT / Software / Systems , Brockton, Massachusetts