SQL DBA/BI Developer

<strong>Grow Your Career at Connection&nbsp;</strong><br /><br /><strong>Join a team where you make the difference. Enjoy a culture grounded by working together. Join a team whose future is bright. Your career opportunities are limitless.</strong>

Newport News, VA

Connection

<strong>Founded in 1982, Connection delivers valuable IT services and advanced technology solutions to business, government, education, and healthcare markets. Today, we serve our customers through our staff of highly trained Account Managers, our team of on-staff experts, and our efficient procurement websites. We are also proud to offer custom-configured computer systems from a ISO 9001:2015 certified technical configuration lab at our distribution center in Wilmington, OH.</strong><br /><br /><strong>Our company has over&nbsp;<a href="https://www.connection.com/content/about/certifications-and-authorizations?cm_sp=content-_-about-us-_-certifications-and-authorizations">2,500 technical certifications</a>&nbsp;that ensure our experts can solve any customer need, no matter how complex. Additionally, our GlobalServe offering delivers global procurement solutions through our network of 500 suppliers in 174 countries.</strong> https://www.connection.com/

keywords: position summary,benefits,database,teamwork,performance,production,training,analysis,experience,knowledge,technical,skills,degree,professional

Full-Time

Overview: <p>Connection Services has a fantastic opportunity for a DBA / BI Developer in the Newport News, VA area. This is a full-time direct hire opportunity with excellent benefits.</p> <p>BI Developer/Database Administrator&nbsp;to function as the resident database and reporting services Subject Matter Expert. This role will also interact with internal stakeholders to understand data reporting/analytics needs, collect requirements, data transformation, and build business intelligence and reporting solutions. This role will be located in Newport News, Virginia, and reports to the Chief Information Officer (CIO).</p> <div id="gtx-trans" style="position: absolute; left: -79px; top: 26.7639px;">&nbsp;</div>
Responsibilities: <ul> <li>Analysis, relational database design, data integration, and reports/dashboards development and management using reporting and analytics tools including, but not limited to, SQL Server, TSQL, SSIS, SSRS, Power Query and Power BI</li> <li>Perform DBA duties including support of schema design, ETL, monitoring and administration of batch jobs, and monitoring database usage.</li> <li>Makes recommendations for standardized processes, methodologies, and applications to collect, store, process, and analyze data and meta-data</li> <li>Design and development of standard and complex reports focusing on the delivery of operational and insights-based reports.</li> <li>Develops scripts for database maintenance jobs to write the extraction, transformation, and load (ETL) or data transformation services (DTS) tasks required for ETL development primarily in a SQL environment.</li> <li>Configures and maintains databases and their servers both in development and production including capacity planning, updating, troubleshooting, access management, performance management, and disaster recovery</li> <li>Develops technical specifications and business requirements documents pertaining to BI and data analytics needs.</li> <li>Manages interface with database vendors for technical support and works with vendors on consultative design projects</li> <li>Provides training and support to users related to databases, user interfaces, reporting and analytics tools (Practice Engine, Power BI, and SQL)</li> <li>Designs, develops and supports new and existing data warehouses</li> <li>Support any future firm projects as it relates to database and reporting solutions</li> <li>Collaborate with Information security and advise/maintain data classification standards and data management guidelines/procedures.</li> <li>Collaborates and communicates regularly and effectively with team members</li> </ul> <div id="gtx-trans" style="position: absolute; left: -48px; top: 26.7639px;">&nbsp;</div>
Requirements: <ul> <li>At least 4 years working with SQL Server managing databases, developing complex queries/reports, and 2 years of ETL experience.</li> <li>Experience and working knowledge of TSQL, SSIS, SSRS, SQL</li> <li>Strong knowledge of design, development, and implementation of APIs for system and data integration.</li> <li>At least 3 years' experience in database performance tuning and query optimization</li> <li>experience with advanced and complex data reporting tools including Power Query, Power BI and similar data analytics tools</li> <li>Bachelor's Degree in Computer Science, Information Science, or related field or an acceptable combination of education, training, and experience</li> <li>A minimum of 5 years' worth of relevant experience</li> <li>Solid understanding of APIs</li> <li>Strong knowledge of business process knowledge</li> <li>Reliable, accessible and able to work under pressure</li> <li>Ability to work on multiple projects with multiple deadlines</li> <li>Ability to adapt to change and learn new skills quickly</li> <li>Ability to work independently and with minimum supervision under a system of discipline and accountability</li> <li>Expert analytical and problem-solving skills</li> <li>Exceptional customer service orientation</li> <li>Able to work with people of varied technical\non-technical backgrounds and management levels</li> <li>Technical writing and documentation experience</li> </ul> <div id="gtx-trans" style="position: absolute; left: -34px; top: 26.7639px;">&nbsp;</div>