Data Warehouse Analyst - Office of Data Strategy job in Atlanta
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+10 more
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.
- Supports the design, development, and maintenance of logical and physical data models used for operational reporting, analytics, and institutional decision-making.
- 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.
- 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.
- 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.
- Performs data validation and quality assurance activities to identify discrepancies, reconcile data issues, and ensure compliance with established data governance standards.
- Assists in troubleshooting data integration, transformation, and reporting issues by analyzing source data, ETL processes, and system outputs.
- Develops and maintains technical documentation for data models, ETL workflows, reporting processes, and data warehouse procedures.
- Supports the creation and maintenance of operational reports, dashboards, and ad hoc data requests to meet institutional and departmental needs.
- 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.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦