Data Warehouse Analyst - Office of Data Strategy job in Atlanta

Georgia Institute of Technology
Atlanta, GA, United States
1 day ago
Apply on jobs.diversity.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Working hours
Regular working hours

Tech stack

Microsoft Windows Data Analysis Software Applications Information Systems Data Validation Data Governance Data Integration Data Integrity Extract Transform Load (ETL) Data Retrieval Data Warehousing Database Design
+10 more
Microsoft Office Operational Data Store Power BI Standard Sql SQL Databases Data Strategy People Soft Banner Advertisement Data Analytics Workday

Job description

Supports data-driven decision-making by gathering and analyzing business and data requirements. Assists in developing Operational Data Warehouse data models, translating business needs into technical solutions, and maintaining ETL processes to ensure accurate and reliable data integration., 1. Assists in documenting business and functional requirements, process workflows, data definitions, and interface specifications to support data warehouse development and reporting initiatives.

  1. Supports the design, development, and maintenance of logical and physical data models used for operational reporting, analytics, and institutional decision-making.
  2. Collaborates with IT teams, business analysts, data analysts, and functional stakeholders to gather requirements, troubleshoot issues, and support the successful delivery of data integration and reporting projects.
  3. Assists in the development, testing, implementation, and maintenance of ETL (Extract, Transform, Load) processes and reporting solutions that support university-wide operational and strategic reporting needs.
  4. Monitors and validates daily data warehouse jobs, data loads, and system processes to ensure data accuracy, completeness, and availability investigates and escalates issues as appropriate.
  5. Performs data validation and quality assurance activities to identify discrepancies, reconcile data issues, and ensure compliance with established data governance standards.
  6. Assists in troubleshooting data integration, transformation, and reporting issues by analyzing source data, ETL processes, and system outputs.
  7. Develops and maintains technical documentation for data models, ETL workflows, reporting processes, and data warehouse procedures.
  8. Supports the creation and maintenance of operational reports, dashboards, and ad hoc data requests to meet institutional and departmental needs.
  9. Participates in testing and implementation activities for new data sources, system enhancements, and reporting solutions to ensure data integrity and system performance., This position does not have any financial responsibilities. This position will not be required to drive. This role is considered a position of trust. This position does not require a purchasing card (P-Card). This position may travel 1%-24% of the time.

Background Check

  • Standard Enhanced

Requirements

Educational Requirements Bachelor’s degree from an accredited institution of higher education in a related field

Required Experience Three (3) years of experience in data integration, SQL programming, database management, querying and analyzing data using SQL, and/or data modeling.

Preferred Qualifications

Preferred Educational Qualifications An advanced degree from an accredited institution of higher education in a related field

Preferred Experience Coursework or experience in data analytics, database design, or information systems Experience with ERP systems for reporting purposes, such as Banner/Ellucian, PeopleSoft, or Workday

Knowledge, Skills, & Abilities

ABILITIES Commitment to service and operational excellence Able to handle multiple tasks or projects at one time, meeting assigned deadlines

KNOWLEDGE Knowledge of data sources, database design, and data warehouse concepts Familiarity with data modeling Working knowledge of SQL for data retrieval and manipulation Knowledge of Microsoft 365, including Power BI for reporting Proficient with computer applications and programs associated with the position (i.e., Microsoft Office suite), Excellent interpersonal, initiative, teamwork, problem-solving, independent judgment, organization, communication (verbal and written), time management, project management, and presentation skills Strong attention to detail and follow-up skills Strong customer service skills and phone and e-mail etiquette

About the company

Are you ready to transform lives through academic excellence, innovative research, strong community partnerships and economic opportunity? Kennesaw State University is one of the 50 largest public institutions in the country. With growing enrollment and global reach, we continue to expand our institutional influence and prominence beyond the state of Georgia. We offer more than 190 undergraduate, graduate, and doctoral degrees to empower over 50,000 students to become thought leaders, lifelong learners, and informed global citizens. Our entrepreneurial spirit, high-impact research, and Division I athletics draw students from throughout the region and from more than 100 countries across the globe. Our university’s vibrant culture, career opportunities, rich benefits, and values of respect, integrity, collaboration, inclusivity, and accountability make us an employer of choice. We are part of the University System of Georgia . We are searching for talented people to join Kennesaw State University in our vision . Come Take Flight at KSU!, The University System of Georgia is comprised of our 25 institutions of higher education and learning as well as the System Office. Our USG Statement of Core Values are Integrity, Excellence, Accountability, and Respect. These values serve as the foundation for all that we do as an organization, and each USG community member is responsible for demonstrating and upholding these standards. More details on the USG Statement of Core Values and Code of Conduct are available in USG Board Policy 8.2.18.1.2 and can be found on-line at https://www.usg.edu/policymanual/section8/C224/#p8.2.18_personnel_conduct .

Additionally, USG supports Freedom of Expression as stated in Board Policy 6.5 Freedom of Expression and Academic Freedom found on-line at https://www.usg.edu/policymanual/section6/C2653 .

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on jobs.diversity.com
Prepare application

Good distractions

Loading talks and stories from around this role…