Data Analyst

Join to apply for the Data Analyst role at Apex Systems
.

Get AI-powered advice on this job and more exclusive features.

This range is provided by Apex Systems. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

$65.00/hr - $85.00/hr

• Serve as a technical resource for strategic oversight, planning, and development of data models and database structures to support global needs.
• Translate logical designs into physical databases and define data flows through successive stages.
• Plan, design, and document logical and physical enterprise relational data models.
• Facilitate and participate in design meetings and review sessions with development, architecture, data integration, BI teams, and power users.
• Implement physical data models on platforms such as Snowflake.
• Gather data requirements by working with end users.
• Analyze complex data sources and develop source-to-target mapping documents, including business transformation rules.
• Perform data quality analysis and profiling to ensure integrity and accuracy.
• Support QA and end users during testing phases, including QA and User Acceptance Testing.
• Provide daily production support and ongoing maintenance for the enterprise data warehouse.
• Identify problematic data areas, research root causes, and determine corrective actions.
• Support data governance by developing processes and queries to monitor and ensure data quality.
• Gather, clean, and preprocess data from various sources, ensuring integrity and quality.
• Identify KPIs and develop metrics to track and measure business performance.
• Monitor data quality, identify issues, and propose cleansing or enhancement solutions.
• Stay updated with industry trends and best practices in data analysis, modeling, and reporting.

• Demonstrate strong individual contribution and teamwork, with excellent communication skills.
• Adapt quickly to change with a flexible, cooperative work style and ability to reprioritize as needed.
• Bachelor of Science (BS) in computer science or information systems (or equivalent work experience).
• 7–10+ years of overall IT experience in software development or data-related roles, with evidence of increasing responsibility.
• 5–7 years of significant data analysis experience, including 2–4 years building complex data models.
• 2+ years of data profiling experience.
• 3–5 years of strong Snowflake experience; ability to construct complex SQL queries.
• Proven experience with programming languages such as SQL and Python for data manipulation and analysis.
• Experience with data analysis and visualization tools such as SAP BO, Power BI and Excel.
• Extensive knowledge of advanced concepts, practices, and procedures in analytic database environments.
• Proficiency with best practices in data modelling, data analysis, and data warehousing concepts.
• Ability to understand requirements and create complex relational data models.
• Ability to create data flow and process flow diagrams.
• Knowledge of BI methodologies, Data Marts, Data Warehousing, OLAP tools and techniques (a plus).
• Experience in professional services, accounting industry, or client service/consultative technology roles (a plus).
• Strong analytical and problem-solving skills to interpret complex data sources and generate meaningful insights.
• Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure.
• Good business knowledge and confident decision-making skills.
• Excellent written and oral communication skills, including business writing.
• Ability to communicate strategies around data modelling and architecture to cross-functional teams and business executives.
• Attention to detail and ability to maintain data accuracy and integrity.
• Ability to work with large datasets through data cleaning, preprocessing, and transformation techniques.
• Team oriented, flexible, and able to work in an ambiguous and/or changing work environment.

Seniority level: Mid-Senior level

Employment type: Full-time

Job function: Information Technology
Industries: IT Services and IT Consulting

Location: Chicago, IL

Apex Systems is an equal opportunity employer. We do not discriminate or allow…