Full-time
Huntsville, AL
Job description
Position Overview
Position works, with limited supervision, within TAC’s Data & Reporting team to support TAC’s business intelligence (BI) efforts of converting data to information and ultimately knowledge for internal and external stakeholders. Responsible for developing solutions to respond to reporting requirements including modeling of target data structures, extraction, transformation and loading of data, creating business metadata, and presentation of data to develop static and interactive reporting, dashboards, pixel-perfect and subscription-based reports as needed. Serves to establish and support a central repository in reporting and data administration within TAC.
Essential Job Functions
Design data infrastructure to extract and organize data for authorized individuals to access. Identify TAC’s internal and external data sources, collaborating with department SMEs to determine their data storage and organizational needs and using the information to create and maintain data infrastructure for internal users.
SQL Server Database Administrator which involves database maintenance, tuning, upgrades and problem solving.
Contribute to the creation, maintenance and expansion of the conceptual and logical enterprise data models using modern techniques and methods for data warehousing data mart OLAP systems. Integrating new data source as required by business needs.
Develop database solutions to store and retrieve TAC’s data. Support the whole data pipeline creation and successful executions: starting from row data, through structuring data and pushing it to Data Warehouse, Operational Data Store (ODS) and Dashboards. Migrate data from legacy systems to new solutions. Responsible for the entire lifecycle of extract, transform and load (ETL) pipelines creation and maintenance from the concept to PROD release including data analysis and requirement elicitation, implementing data pipelines, testing, gathering and migrating code.
Convert business needs into data and system requirements, align business processes with IT systems and manage the flow of data and information within TAC. Understand the logic behind the queries, with relation to the business cases. Working with key stakeholders to understand what data element is valuable for business to represented on the dashboard. Develop presentation layer objects that present data in a manner that is easily understandable to business users for report creation, with the intention of BI self-service within the current analytics package or via a connector.
Maintains TAC databases, through administration and support including, but not limited to, upgrades, patching, etc.
Analyzes business needs and develops requirements (alone or in collaboration with a Business Systems/Intelligence Analyst) and prepares technical specifications based on those gathered requirements. As a partner and subject matter expert to the business, establish a mindset that data functions are an integral part of existing business processes, process modifications or process implementations.
Perform additional job duties as assigned.
Experience / Education Requirements
Other Skills & Abilities
Physical Requirements
NOTE: Nothing in this job description restricts management’s right to assign or reassign duties and responsibilities to this job at any time. This description reflects management’s assignment of essential functions. It does not prescribe or restrict the tasks that may be assigned. This job description is subject to change at any time.
Job Type: Full-time
Pay: $90,000.00 - $100,000.00 per year
Work Location: In person
