Placement papers | Freshers Walkin | Jobs daily: SQL Data Warehouse/BI Developer at W.B. Mason Company, Inc. (Brockton, MA)


Search jobs and placement papers

SQL Data Warehouse/BI Developer at W.B. Mason Company, Inc. (Brockton, MA)

Over the last decade W.B. has built an in-house, on-shore software development team to support its unique role in the market.  W.B. Mason believes in tailoring our services to the needs of each customer.  Developing software to handle that kind of variety and complexity is a great challenge.  Managing the software for ourselves means we can focus on agility and continual delivery.  A role on our team will give you experience in a wide variety of technologies as well as an opportunity to learn about every part of our business.  From the web to the warehouse, our design & development teams have created the tools our company uses to compete with the largest distribution and ecommerce companies in the world. 






Responsibilities





Essential Duties and Responsibilities



  • ETL/SSIS Development

    • SQL 2012/2016 Data Warehouse and downstream data models

    • Third party/external data integration

    • Azure SQL Databases and Data Warehouse development and integration



  • Participate in design and development of data warehouse expansion including operational and warehouse management systems (WMS) data.

  • Participation in design and development of tabular data models to support primary lines of business and data analysts

  • Support and assist the BI developers with data provisioning and new tool discovery

  • Work with eCommerce, CRM, ERP and Mobile developers to determine data sourcing and integration needs and solution design including data flows in a hybrid on premise/cloud environment

  • All other duties as assigned


Knowledge, Skills and Abilities



  • Ability to understand business objectives and decision paths to produce required data models and analysis tools

  • Ability to conceptualize data interaction in complicated models and create appropriate measures

  • Must be able to communicate effectively in both technical and business settings.

  • Self-motivated, creative, passionate and able to acclimate into a fast-paced dynamic environment with shifting priorities

  • Attention to detail and sense of responsibility for data availability, security and quality

  • Motivated by learning new technologies and building better business solutions






Qualifications





Education and/or Experience



  •  BS/BA degree or equivalent

    • Bachelor’s Degree in Technology related discipline preferred



  • 3-6 years experience with MS SQL Server

    • Microsoft SQL Server (2012/2016)

    • SQL Server Reporting Services (SSRS)

    • SQL Server Analysis Services (SSAS)

    • SQL Server Integration Services (SSIS)



  • Strong Transact-SQL, Complex Stored Procedures, Performance Tuning

  • Experience with SSAS Tabular development and DAX

  • SSRS, PowerBI or similar reporting and visual analysis tool experience

  • Visual Studio, Powershell

  • Familiarity with VB.NET, C# and MS Dynamics AX a plus

  • Experience in hybrid on premise/cloud environment and data sync methodologies desired

  • Azure SQL Data Warehouse, Data Factory, Data Lake experience preferred


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


Complete job listing can be viewed here! Apply directly for immediate consideration.


by via developer jobs - Stack Overflow
 

No comments:

Post a Comment