<p>Job Responsibilities</p> <p>Welcome to South Carolina. The new headquarters of American innovation.</p> <p>The South Carolina Department of Commerce (S.C. Commerce) is committed to maintaining the state's long-term competitiveness while building a modern economy - one that is diverse, supporting businesses at every phase of their lifecycle, while allowing people to live and work where they love.</p> <p>As one of 22 cabinet agencies, S.C. Commerce is the state's lead economic development agency. Its mission is to create economic opportunities to increase choices for all South Carolinians, which it does by supporting new and existing businesses and partnerships that fuel emerging industries such as life sciences, headquarters, and advanced energy. To drive the state's advanced energy potential and global impact, S.C. Commerce helped organize the SC Nexus for Advanced Resilient Energy (SC NEXUS), designated as one of 31 federal Technology and Innovation Hubs in 2023. A national leader in foreign direct investment, South Carolina extends its international reach with representation in Europe and Asia, ensuring the state remains a top, global business destination from launch to legacy.</p> <p>Job Purpose:</p> <p>The South Carolina Department of Commerce is seeking a Data Architecture Intern to join our multidisciplinary Research Team, which includes experts in economics, business analytics, finance, and GIS/visualization. This internship is ideal for students interested in building technical data infrastructure to support community and economic development research. The role offers a unique opportunity to contribute to high-impact projects that shape economic development decisions statewide. Under the guidance of our data architect, the intern will support the development of our enterprise data warehouse and assist with core economic research tasks to inform decision-making across the agency.</p> <p>Job Responsibilities:</p> <ul> <li>Assist with data engineering tasks, including designing and optimizing database schemas for a centralized data warehouse. </li><li>Help maintain and develop a custom-built Python data library (including GitHub issue resolution and basic unit testing). </li><li>Create and enhance Power BI semantic models and dashboards, including implementing API-based data sources and optimizing report performance. </li><li>Support the economic research team with streamlined tasks such as data gathering, basic analysis, one-page summaries, and visualization for internal and external stakeholders as needed. </li><li>Conduct literature reviews to inform project design, and help synthesize findings into clear, actionable insights. </li><li>Collaborate with a multidisciplinary team of economists, analysts, and visualization specialists on cross-functional projects. </li><li>Develop deliverables which communicate results in an easy-to-understand manner via research briefings, reports, presentations, fact sheets, visual, interactive, or other dynamic methods. </li></ul> <p>Minimum and Additional Requirements</p> <p>A high school diploma and relevant program experience. A bachelor's degree may be substituted for the required program experience.</p> <p>Preferred Qualifications</p> <ul> <li>Have or are pursuing an undergraduate or advanced degree in a technical or quantitative field (such as Computer Science, Data Science, Information Systems, Computer Engineering, or another closely related program) with demonstrated experience in data architecture, engineering, or analytics. </li><li>Intellectual curiosity and enthusiasm for using data and technology to understand economic trends, business dynamics, or community outcomes. </li><li>Experience designing relational database schemas and understanding of data warehousing concepts. </li><li>Strong analytical skills and passion for identifying trends and unique solutions through data analysis. </li><li>Python skills (especially with pandas); ability to read and apply documentation. </li><li>Familiarity with API integration and data transformation workflows. </li><li>Exposure to or use of U.S. Census datasets (ACS, CBP, LEHD, etc.). </li><li>Experience with or willingness to learn DAX, Power Query M, SQL, or PySpark. </li><li>Demonstrated analytical thinking, curiosity, and a commitment to continuous learning. </li><li>Strong interpersonal and communication skills and ability to work effectively with a wide range of constituencies to convey knowledge and concepts. </li></ul> <p>Additional Comments</p> <p>Expected 20 hours per week.</p>