Mid-Level Data Analyst

Expert Technology Services

Tempe, AZ

Apply

JOB DETAILS

SKILLS

Architectural Design, Best Practices, Business Analysis, Cataloguing, Continuous Improvement, Data Analysis, Data Lake, Data Management, Data Mapping, Data Migration, Data Modeling, Data Profiling, Data Quality, Data Science, Data Storage, Data Warehousing, Database Design, Database Programming Languages, Identify Issues, Machine Learning, Machine Tool, Metadata, Microsoft Product Family, Microsoft SQL Server, Microsoft Windows Azure, Migration Strategy, NoSQL, Reconciliation, SQL (Structured Query Language), SQL Databases, Traceability, Usability Engineering

LOCATION

Tempe, AZ

POSTED

4 days ago

Job Summary Mid-Level Data Analyst (Tempe, AZ)

- Perform detailed data analysis to identify anomalies, inconsistencies, and data quality issues in source systems.
- Support data profiling, analysis, and transformation activities across legacy and target systems, including handling data in relational, NoSQL, and object storage environments.
- Develop and maintain two-way data mappings (source-to-target and target-to-source) to ensure data completeness, traceability, and alignment with business requirements.
- Maintain a strong understanding of target data models, database structures, and data usage patterns to support accurate data transformation and validation.
- Contribute to the design, architecture, and management of data lake and data warehouse solutions for structured, performant, and accessible data.
- Collaborate with Business Analysts, Technical Architects, and development teams to translate business rules into data mappings and transformation logic.
- Identify data quality issues and gaps, support data cleansing decisions, and ensure alignment with approved data mapping and transformation guidelines.
- Perform and support data validation and reconciliation activities to confirm data accuracy, completeness, and usability throughout data pipelines and migration processes.
- Document data flows, schemas, mappings, and transformation logic to ensure traceability, auditability, and governance compliance.
- Participate in the continuous improvement of data platform architecture, tooling, and data migration strategies in accordance with organizational standards and best practices.

Required Skills:
- 3+ years of experience in data analysis, development, or related roles involving data integration or migration.
- Experience with data mapping, transformation, and validation in migration/integration contexts.
- Solid understanding of database design principles: relational modeling, normalization, and denormalization.
- Proficiency in SQL, especially with Azure SQL Database, Azure SQL Managed Instance, or similar platforms.
- Ability to move and transform data across structured, semi-structured, and unstructured formats.

Nice to Have:
- Experience with MS SQL Server, Azure Cosmos DB, or other NoSQL databases.
- Knowledge of Kusto Query Language (KQL), Azure Monitor, and/or Azure Data Explorer.
- Experience with object storage patterns, such as blob or file-based architectures.
- Familiarity with data lakes and warehouses (e.g., Azure Data Lake Storage, Microsoft Fabric).
- Exposure to data science or advanced analytics platforms (Azure Machine Learning, Databricks, etc.).
- Understanding of data governance, lineage, cataloging, and metadata management.

About the Company

Expert Technology Services

Resume Resources

Free Resume Templates Free Resume Builder