Are you looking for a New Job or Looking for better opportunities?
We got a New Job Opening for
Full Details :
Company Name : Computer Enterprises, Inc. (CEI)
Location : Hampton, VA
Position : BI Developer
Job Description : Job Summary: A successful candidate will have a wide range of data and business intelligence skills to develop and maintain Agency Reports Library and Enterprise Data Warehouse. They will be able to execute the full Business Intelligence Development lifecycle and will work closely with the Director of Enterprise Technology Solutions to create an Enterprise Business Intelligence Data Warehouse.You will work and collaborate with business stakeholders, business leaders, and subject matter experts, to understand and document the current business processes and key Agency metrics. You will also work with IT staff to acquire the data, create the necessary SQL Server database structures, develop the ETL packages, dimensionally model the data, and build the necessary reports and dashboards for Enterprise Agency consumption via canned reports and self-service business intelligence.You will be part of an agile software development team and will be responsible for taking deliverables through all phases of the Software Development Life Cycle and change management process. This position also manages the BI and Data Warehouse report data repositories, software, and servers, and supports deployment to cloud-based and enterprise environments.Tools currently used: SSIS (including custom C# script tasks)SQL Server Management StudioTableau Online, and Tableau PublicSSRSExcelWeb APIsAccess DatabasesPower BIEssential Job Functions: Strong database understanding and data programming skills.Excellent TSQL database coding skills to include stored procedures, functions, tables, views, triggers, and synonym creation.Executes full business intelligence life cycle including requirements gathering, documentation, analysis, design, ETL development, dimensional modeling, report, and dashboard creation.Design and develop new reports and reporting solutions from requirements and from an understanding of organizational business needs in Tableau Desktop, and SSRS.Use SQL Server SSIS and SQL Management Studio to extract data from source, transform data as necessary, and create all database objects needed to store the data.Strong SSIS skills to include understanding of control flow and data flow tasks, with package auditing of data as it moves through the data pipeline. Ability to program some custom C# scripting tasks for complex assignments.Strong knowledge of all SQL Server database tasks including jobs, data backups and redundancy, database maintenance (indexing and statistics), to serve as the SQL Server backup DBA as necessary.Work closely with the SQL Server DBA on data warehouse object creation, query performance tuning, and reporting in Tableau and SSRS environments.Work closely with business owners to develop and present reports and dashboard data in a manner and stylistic flare that matches the intended audience.Manage Tableau users, permissions and groups, folders and reporting library using the Tableau Online management interface, and Tableau bridge client.Work with the DBA to configure SSRS and Tableau configuration management tools.Manage SSRS report manager including report deployment, folders, and permissions.Work closely with the Web Development team to import data from custom web applications forms into the BI environment for agency report creation.Deploy reports, dashboards and stories using Tableau Online, Tableau Public, and SSRS.Assist in development of project definitions, including proposals, estimates, planning, schedules and documentation.Provide support to the development of training materials and training activities related to the BI tools and applicationsRequirements: SQL Server, SSIS, SSRS, ETLCreating ETL packages using C# integration process (helpful in data warehousing)SQL Query StoreSQL Server Data Tools (SSDT) for Visual Studio 2017Experience writing complex queriesKnowledge of Active Directory and file share systemsGood understanding and/or experience with Python, Tableau and PowerBI preferredJob Type: Full-timePay: From $77,000.00 per yearSchedule:8 hour shiftDay shiftMonday to FridayEducation:Bachelor’s (Preferred)Experience:Tableau: 3 years (Preferred)Database development: 8 years (Preferred)Microsoft Office: 1 year (Preferred)Microsoft SQL Server: 1 year (Preferred)Power BI: 2 years (Preferred)License/Certification:Driver’s License (Preferred)Work Location: One location
This post is listed Under Virginia jobs
Disclaimer : Localpublic.in works to publish latest job info only and is no where responsible for any errors. Users must Research on their own before joining any company