Data Analyst II

Dexian • Full-time • Charlotte, NC, US • $50 - $52 / hour • 22h ago

PROJECT DESCRIPTION/JOB SUMMARY

Key Responsibilities
* Supports database and data migration projects across SQL, Oracle, and ESRI environments.
* Data architecture work through diagramming, process mapping, and schema development.
* Supports data and database quality control through querying, reporting, and manual intervention.
* Assists with development of front end and analytical tools, using systems like ESRI ArcGIS Enterprise, PowerBI, and PowerApps.
* Implements relational database best practices, indexing and normalizing data, and joining multiple tables to provide business insights and visualization.
* Interfaces with internal customers to gather feedback, present development work, and improve processes.

Required Qualifications
* Bachelors Degree in addition to 3-5 years of experience
* Masters Degree in addition to 1-2 years of experience
* 5+ years of experience in data analysis, database design/architecture, or related field
* Experience developing PowerBI and other business reporting tools to enhance data visualization and reporting capabilities.
* Database design and development experience
* SQL query writing and troubleshooting
* Python proficiency, including writing ETLs and/or leveraging spatial packages
* ESRI ArcGIS, including experience with ArcGIS Online and/or Enterprise deployments

Preferred Qualifications
* GISP or DBA certifications
* Familiarity with Real Estate, right-of-way, and/or utilities
* Database migration experience
* Experience supporting ESRI applications and spatial data
* Experience administering and monitoring database activity for performance and reliability

Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide. As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants. Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.

Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit https://dexian.com/ to learn more.

Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.

Apply