Data Analytics Manager

The Heritage Group Indianapolis , IN 46218

Posted 2 weeks ago

Job Summary

The BI CoE Manager will be a key player in helping The Heritage Group in designing, guiding, managing, and determining how enterprise data will be stored and utilized. This role will be responsible for identifying strategic data requirements of the enterprise and design models to make sure such data requirements align with the architecture of the enterprise. This is to be accomplished through collaboration with the business unit stakeholders as well as members of the ITSS Data Services Team. This role must keep up with the demands of a growing organization and work effectively in a team environment, but also with self-direction.

Essential Job Functions:

  • Identify strategic data requirements of the enterprise.

  • Determine how enterprise data will be stored and utilized, seeking consolidation where possible.

  • Collaborate with Database Administrator(s) to design and develop complex database management systems and separate public data from private data.

  • Collaborate with business unit stakeholders (e.g. application owners, business analysts, data architects either employees or third parties hired by BU's) to provide data governance, oversight/security, knowledge sharing, shared license management and general consultative advice (e.g. assistance reviewing contracts with third party BI resources).

  • Assist when possible to collate new data, provide guidance and support for new reports / dashboards.

  • Identify opportunities to meld existing data architecture with new ones as technology emerges and is adopted at the company.

  • Learn new techniques for data modeling and management and empower end users with appropriate knowledge.

  • Ensure the protection of data from unauthorized persons

Relevant Skills:

  • Very high level of self-awareness and desire to develop leadership capabilities.

  • Experience identifying and resolving issues independently. Demonstrates a solid sense of accountability and sound personal judgement.

  • Courage to take initiative in unfamiliar or ambiguous circumstances, including this newly developed role and desire from BU's to advance BI priorities.

  • Ability to gain alignment with different clients and represent a common point of view across multiple stakeholders.

  • Excellent verbal and written communication.

  • Demonstrated creative thinking and problem solving.

  • Ability to manage projects and process improvement initiatives in partnership with ITSS Project Management resources.

  • Maintains a high level of confidentiality.

Requirements:

  • Has 5+ years of experience in data analysis and/or data architecture: requirements gathering and data design and architecture.

  • Has 2+ years of experience in data strategy, oversight, CoE-type role.

  • Has 5+ years in BI vendor engagement and management.

  • Strong background in system development and data management.

  • Strong understanding of software project management approaches and requirements, system development lifecycle, and design and test techniques to perform duties effectively.

  • Proven knowledge of database design and modeling

  • Experience utilizing different data modeling techniques, and database design and management.

  • Working knowledge of Power BI, SSIS, SSAS, SSRS, Azure and related technologies in the MS BI development stack.

The Heritage Group is an Equal Opportunity Employer


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Team Manager

The Heritage Group

Posted 2 weeks ago

VIEW JOBS 9/6/2019 12:00:00 AM 2019-12-05T00:00 Position: Data Team Manager Job Summary: The Data Team Manager will be a key player in helping The Heritage Group improve business performance in technology capabilities. Reporting to the Director of Strategic Technology the role will be responsible for daily management, performance tuning, backup and recovery, disaster recovery, database security, capacity assessment, and database architecture. The role must keep up with the demands of a growing organization and work effectively in a team environment, but also with self-direction. The ideal candidate will be an experienced SQL DBA that also wants to lead a team of DBA's and THG's data strategy. Essential Job Functions: * Responsible for SQL Database development and support. * Leader of the THG Data Team that includes SQL (1) and Oracle (1) DBA's, Viewpoint Administrator, Great Plains Administrator and Business Intelligence (BI) Center of Excellence Manager. * Responsible for overall THG data strategy. * Provide input into overall development/implementation plan and document database builds and changes, perform SQL designs, table designs, and stored procedures work. * Ability to architect, design and configure large, complex databases with replication and high-availability on the most current MSSQL versions. * Translate logical to physical design, develops comprehensive DB architecture, implementation and upgrade plans and assists in definition of database standards, policies, and procedures. * Lead data requirements, architecture review, and modeling sessions. * Primary contact for projects within the team, interfacing with project managers, application development staff and management. * Project based infrastructure and Execute database software installation (SQL Server 2008R2, 2012, 2014, 2016 and 2017 clusters), database creations/configurations and loads. * Maintenance and support of SQL server Mirroring, Log shipping, Clustering, and other methods of disaster recovery. * Responsible for data loading, security, capacity planning and backup and recovery. * SQL Server Reporting Services report development, maintenance and administration. * Database performance fine tuning and optimizing poorly performing queries, stored procedures, etc. * Day-to-day 24x7 production operations support (incident break/fix, change, service requests, and vulnerability management). * Production patch/upgrade management. * Application support and troubleshooting (applications that rely upon SQL database only; examples include TimeClockPlus, Great Plains, ViewPoint) * Customer support & communications. Relevant Skills * Willingness to learn or knowledge of Oracle and Informix database administration. This role will serve as backups to other DBA teammates that are the SME's (subject matter experts) of these technologies. This role is the primary SQL database SME with 2 DBA teammates to serve as backup. * Very high-level of self-awareness and desire to develop leadership capabilities. * Ability to hold themselves and others accountable to high standards * Experience identifying and resolving issues independently. Demonstrates a solid sense of accountability and sound personal judgement. * Courage to take initiative in unfamiliar or ambiguous circumstances. * Ability to gain alignment with different clients and represent a common point of view across multiple stakeholders. * Excellent verbal and written communication * Demonstrated creative thinking and problem solving * Ability to manage projects and process improvement initiatives. * Maintains a high level of confidentiality Requirements: * Has 5+ years of experience in database development and support in MS SQL Server environments. * Has 3+ years of experience in team management, ideally a team of DBA's or similar. * Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc. * Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools. * Ability to detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention. * Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication. THG leverages Rubrik and Zerto for backup and DR solutions. * Expert experience in implementing operational automation. * Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively. * Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, SSRS, Idera, DMVs, system sprocs) * SQL Development ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints ) * Solid acquaintance with windows server, security delegation, SPNs, storage components. * Documentation skills for processes and procedures (creating KBs, runbooks, topology, etc.) * SQL Database Operational support to tech users * Knowledge of Great Plans and SQL interaction and functionality. The Company: For over 80 years, The Heritage Group (THG) has managed a diverse set of prominent companies involved in the highway construction, environmental services, oil refining & specialty chemicals industries and fuel distribution industry. This vast experience combined with a team management style, allows for the diversity of a large conglomerate and the personal service of a smaller, customer-focused organization. THG is a growth-oriented company with operations in North America, Europe and Asia and a customer network that spans the globe. As a family-owned business, a long-term financial approach and conservative investment philosophy has placed THG on a solid foundation to pursue growth opportunities as they appear. The organization has a creative culture, always searching for opportunities and researching industry-changing solutions. The company has grown impressively over the past 30 years both organically and by acquisition, often turning around distressed businesses. THG's growth has been enabled by a positive culture comprised of the following characteristics: entrepreneurial and decentralized, lean and nimble, informal and non-hierarchical, loyal and supportive. THG is a builder of businesses and is well positioned financially to continue to grow effectively. As a company, we look for individuals that demonstrate strength in Intuition and Analysis, Making an Impact and Working with Others The Heritage Group Indianapolis IN

Data Analytics Manager

The Heritage Group