Home > Indianapolis jobs > Indianapolis computer/technical

Posted: Saturday, September 30, 2017 9:41 AM

The Application Database Administrator (DBA) is responsible for the overall Systems Development Life Cycle and maintenance of the GoodwillA?s data environment including relational databases, data warehousing technologies, ETL technology and supporting our Business Intelligence data feeds. They deliver solutions that ensure compatibility and integration with company strategies and business plans. They establish standards and guidelines regarding data access and data management for improving technology development and support processes. The DBA will design and build relational databases and data stores for data storage, processing, reporting, backup and recovery. Develops and implements strategies for a data warehouse, data marts, data acquisition, and archive recovery. Cleans and maintains the database by removing and deleting old data. May evaluate new data sources for adherence to the organizations quality standards and ease of integration. Familiar with a variety of the fields concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of tasks. A wide degree of creativity and latitude is expected. This role demonstrates behaviors consistent with our Mission, Vision and Values, on behalf of Goodwill of Central and Southern Indiana. ResponsibilitiesInterview end:users and stakeholders for analytic needs/requests.Maintain and grow a robust Microsoft SQL data warehousing environment with data sourced from a variety of operational systems including packaged, custom and external cloud:based applications.Identify business drivers, pain points and opportunities; generate solution options to address the same.Work with our PMO and Development Manager to scope and prioritize projects and manage deliverables with business partners.Document system requirements.Create and maintain high level data diagrams of the current and future state architectures with a roadmap connecting the migration path.Create and maintain documents that define source data ownership that can be used as the foundation for data governanceProvide user support for enhancements, bug fixes, and questions.Transform business requirements into data models, data flows and front:end applications (reports, dashboards, etc.)Build data models (logical and physical).Build data integration and transformation layer.Transform data into information by delivering reports, dashboards, analytic cubes, etc. to business leadersUnit test all components in the solution stack (database, staging layer, front:end).Perform end:to:end integration testing of BI solutions.Direct the troubleshooting and resolution of Tier 3 technology problems and assume the role of problem manager as required.Provide level 2 and 3 support for databases, tools, reporting environments and BI solution.Coordinate with other operational resources (e.g. database, network, servers) to ensure uptime for the data warehouse and reporting environments including BI.Work with developers to provide data services to existing and new applications (e.g., logical and physical database design, creating and optimizing stored procedures, functions, views, etc.)Maintain ETL interfaces with existing 3rd party applications and in:house developed solutions.Maintain existing Microsoft replication.Maintain DOMO data feeds.Responsible for the upgrades and ongoing maintenance of databases, tools and BI software.Deliver quality business systems and enhancements on:time and on:budget.Plan, design, develop, implement and maintain data management and software engineering processes, methods and tools.Share suggestions for improving overall best practices, security and technical operations. Initiate forums to share standards and educational information.Provide senior technical leadership to the organization by being conversant with and cognizant of the future direction of information technology and systems, how that direction will impact the company, and how future and current sy


• Location: Indianapolis

• Post ID: 30593557 indianapolis is an interactive computer service that enables access by multiple users and should not be treated as the publisher or speaker of any information provided by another information content provider. © 2017