DescriptionSGS&CO needs an awesome BI Data Engineer!

　　As one of our BI Data Engineers you will use the latest technologies to deliver solutions for our internal clients that address their business needs and challenges. You will engage in a range of analytical projects, from complex data modelling to designing Data Engineering solutions that include error handling, data synchronization and auditing.

　　At SGS&Co, we share a commitment to excellence and a desire to work in a comfortable, friendly environment.

　　Essential Responsibilities and Accountabilities

　　Preferred OLAP Data Modeling experience & solution designProficiency in cloud data integration (ETL/ELT), data mining, partner with source system technical owners to create data extraction methodologiesFamiliarity with Data Lake platform components, data structures, and overall integrationStrong understanding on the principles and implementation of Enterprise Data Management i.e., Master Data & Data QualityPlan, design, document, develop, test, troubleshoot and manage Data Warehouse & Data Lake solutionsFamiliar with source control technologies and incident workflow platforms, i.e., Github, Service Now, Azure DevOpsConduct gap, risk, and impact analysis across our data & BI solutionsAdhere to development standards, test plans, update release documentation Partner with infrastructure resources during the configuration, deployment, and maintenance of database platforms and code changesWork closely with business partners to deliver effective global Data BI in a timely mannerTrain and advise our customers on the proper usage and application of SGS's master, transactional and meta dataFamiliar with Datawarehouse & Data Lake data security models, i.e., object, row, column levels, etc.Demonstrate ability to be collaborative and work in team environmentDo not fear to clearly communicating ideas, risks, and general status updates across projectsPreference to having some experience in Agile & Scrum methodologiesCompetency Requirements

　　Strong preference on understanding Modern Data Architecture and respective platforms Synapse Analytics and SnowflakeFamiliar with Azure, ADF/Snowflake Pipelines,Familiar with API integration, different data structures and formats (JSON, Parquet, XML, etc.)Expertise in Microsoft SQL Server (current and older versions)Expertise with MSFT SQL Server components, i.e., Integration, Analysis ServicesExperience with Power BI or equivalent visualization technologyExperience with DAX / OLAP is a plusDemonstrated SQL skills with extensive experience in developing stored procedures, views, functions, triggers, and advanced logical methods.Familiarity with data warehousing methodologies and techniques.Robust ETL/ELT design expertise (error handling, data synchronization / auditing, etc.)Strong skills in Microsoft Excel and/or Excel Services, SharePoint.Experience with Web development tools and Web services a plus (ASP.NET, VB.NET, XML)Understanding of SDLC and production environmentsGood interpersonal, oral, and written communication skills, including the ability to communicate complex ideas in a simple way##LI-VU1

　　Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

　　The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)

　　Southern Graphic Systems, LLC ("Sgsco ") is an equal opportunity employer. Sgsco will not discriminate against any applicant for employment on the basis of r ace, creed, color, r eligion, s ex, age, national origin, disability, veteran status, s exual orientation, marital status, or any other characteristic protected by state or federal law. Use the links below to review statements of protection from discrimination under Federal law for applicants and employees