Job Title: IAM Data Analyst
Remote
C2H role
Day-to-Day Responsibilities:
The IAM Analyst will engage in the following activities:
- Data Normalization: Scrubbing and normalizing data for consistency and accuracy.
- Data Structure Identification: Analyzing data structures to identify best practices for management and organization.
- SQL Proficiency: Independently writing SQL queries and performing data extracts.
- Excel & Power Query: Transforming raw data into meaningful visualizations using Excel and Power Query.
- MS Power Automate: Creating automated processes and forms to collect and merge data with SQL or Excel.
- Data Mapping Documentation: Writing comprehensive data mapping documents in Excel.
- Visio: Developing and modifying data flow diagrams as needed.
- Effective Questioning: Asking pertinent questions to gather critical project details.
- Proactive Problem Solving: Taking initiative with limited information to obtain a complete understanding of project requirements.
- Self-Starter: Working independently with minimal direction.
Performance Expectations/Metrics:
- Serve as the project data owner.
- Scrub and normalize data efficiently.
- Create visualized KPI tools to track performance.
- Collaborate with various internal teams to collect necessary data and document data mapping specifications.
Previous Job Titles/Background:
Ideal candidates may have held positions such as:
- Data Analyst
- Database Architect Candidates should possess extensive experience in architecting database structures and utilizing staging methods for data cleansing and normalization. This role is suited for someone passionate about owning data from start to finish.
Internal/External Interactions:
The IAM Analyst will interface with business users and technical teams.
Required Skills/Experience:
- SQL, Excel, Visio, Power Automate, Power Query
- Data mapping
- Visio process flows
Preferred Skills/Experience:
- IAM knowledge
- Cybersecurity knowledge
- SOX experience
Education Requirement:
- Bachelor’s degree in a quantitative or business-related field.
Education Preferred:
- Related advanced degrees may be beneficial.
Software Skills Required:
- SQL, Excel, Visio, Power Automate
Dexian, LLC 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. 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/