*Role : SQL Business Intelligence / EDW Developer*
*Location : Atlanta, GA* *Interview : Phone and f2f* *Duration : 6+months* Position Summary: The Software Engineer, Business Intelligence / EDW Developer implements the best practices in support of Business Intelligence practice. This role will develop code for extracting data from source systems and loading to the Enterprise Operation Data Store (ODS). This role will also create (Extract/Transform/Load) ETL for the purpose of loading to the Enterprise Data Warehouse. This role is expected to develop and support data visualizations and reports that have been developed using Power BI. The work will require understanding of Microsoft SQL Server based data warehousing. To be successful in this role: · You demonstrate the ability to recognize and respond to customer needs and you demonstrate commitment to customer service. · You own the problems and requests assigned to you and resolve issues to the customer’s satisfaction. · You are a clear communicator and have the ability to communicate appropriately to different audiences and organizational levels. · You can examine situations, analyze possible causes and recommend actions. · You have the ability to prioritize your daily tasks and the flexibility to monitor/adjust, as necessary. · You enjoy collaborating with others and working as part of team towards common visions and goals. Responsibilities: · Implement, support and maintain data process models, including sourcing, loading, transformation and extraction. · Implement business rules via stored procedures, middleware or other technologies. · Perform system analysis, data analysis or programming, using a variety of computer languages and procedures. · Create SSIS Packages and SQL for transforming and loading data from source systems to the ODS and then to the EDW. · Support and maintain ETL processes to accommodate changes in source systems and new business user requirements. · Create Dashboards and Reports based on a set of User requirements, while adhering to Company and Industry standards. · Define and capture metadata and rules associated with ETL processes. Skills: · Strong customer service skills, including the ability to communicate (both verbal and written) in a positive manner. · Excellent telephone manner. · Proven strong analytical ability as well as troubleshooting and reasoning skills. · Strong documentation skills. · The ability to research, document and implement a solution. · The ability to work collaboratively. Qualifications: · 5+ years using T-SQL or comparable SQL dialect such as PLSQL. · 5+ years using SQL Server Integration Services for ETL / data movement / integration · 2+ years using SQL Server Reporting Services · Experience using SQL Server Management Studio and Visual Studio Data Tools · Experience troubleshooting and monitoring SQL Agent job schedules. · Experience working with Relational Data Warehouses where star-schema / Kimball design practices have been adopted. · Experience in Power BI development (on premise or cloud) · Experience working in a Hybrid Cloud – On Premise landscape *Regards , * *Akshita | ** KPG99,INC <http://www.kpg99.com/>* *3240 E State, St Ext | Hamilton, NJ 08619 609-681-2602 || aksh...@kpgtech.com <aksh...@kpgtech.com> * -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
