• webs.jpg
    • websponsors5.jpg
    • websponsors2.jpg
    • websponsors6.jpg
    • websponsors.jpg
    • websponsors3.jpg
    • websponsors4.jpg
  • !! If you are a member and want to add your jobclick here to log in!

     

     

  • SQL BI Developer

    1A Auto, Inc.
    Job Description
    Location: Westford, MA
    Department: IT
     
    SQL BI Developer
     
    About 1A Auto 1A Auto is a high growth e-commerce company and we pride ourselves on employing the best talent. Each team member brings a unique skill set to the table and collectively have a track record of accomplishing the most challenging of goals.  We are an online aftermarket auto parts retailer headquartered northwest of Boston. We are a leader in our market and are positioned for further growth. We offer a great “can-do” culture, a casual work environment, and the opportunity to apply your skills in a rewarding situation. Overview This role will be joining the SQL Server DBA team and will be joining in the effort to develop and modernize the Enterprise Business Intelligence platform. This position requires that the candidate understands, uses and applies technical standards, principles, theories, concepts and techniques and provides solutions to a variety of technical problems of moderate to high scope and complexity. The candidate will also regularly interact with the users ranging from the end user to directors to understand, document and communicate their needs, perform requirements analysis, develop and deliver data warehousing solutions as per the requirements and contribute to the development and delivery of documentation.  This position requires a wide range of technical development, design, and multitasking skills. General Responsibilities
    • Working with stakeholders to understand reporting needs
    • Identifying and querying data sources to get the required data
    • Cleansing and massaging data into the shape required,
    • Creating and deploying Power Bl datasets, reports, and dashboards
    • Presenting and gathering feedback on the finished product
    • Conduct technical training
    • Improve performance and extend functionality
    • Maintain and document operational environment.
    • Development of SSIS packages for ETL
    • Development of SSAS cubes and data marts
    • T-SQL Development
    • Create QA standard and process for Business Intelligence
    • Developing Business Intelligence reports, and dashboards
    • Identify correct reporting medium for needs of business (SSRS/Power BI)
    • Take part in an on call rotation
    EDUCATION/QUALIFICATIONS                                                                                                                                                                                                                                                                                                                                                                                                                                                        Description of education and specialized skills Technical Skills:
    • Strong ability in data modeling
    • Ability to develop an ETL process which can support multiple business needs and processes
    • Experience with developing an Enterprise Data Warehouse environment from the scratch
    • Experience creating process and procedure around data cleansing and data normalization
    Technology Experience:
    • SSIS 3+ years
    • SSAS 4+ years
    • SSRS 2+ years
    • Power BI 1+ year
    • T-SQL 4+ years
    • Github
    • SQL Server 2012
    • SQL Server 2016
    Soft Skills:
    • Solid experience and ability to document and explain data modeling to technical and non technical resources
    • Superior organizational skills, with a
    • disciplined approach to implementation, support and documentation
    • Strong analytical skills
    • Strong desire build collaboration between business units and teams
    • Creating data flow charts and data dependency lists
    Please note: This job description is not all inclusive, but rather is intended to capture the majority of the job functions.
  • New Members