Data Analyst Job at Expert Technology Services in Chicago

Company: Grant Thornton is a major Audit Tax and Advisory Services company offering a broad range of services in strategy and consulting operations technology and more across various industries.

Location: 100% Remote - collaborating with teams based in both the United States and Ireland. Due to the Ireland component schedule flexibility is essential to accommodate cross-time zone coordination.

This position may be offered to a candidate authorized to work in the US for his/her/their stated employer without any restrictions that would prevent the candidate from working on the proposed assignment for the duration of the assignment period.

No OT: Only seeking candidates on a straight hourly rate; no overtime rates will be approved.

Duration: Contract 12 months

Background Check: No
Drug Screen: No

Responsibilities:

• 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.

Qualifications:

• 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.
• Stay updated with industry trends and best practices in data analysis, modeling, and reporting.

Interview Process:

• 30‑minute technical interview with Manager.
• 30‑minute behavioral interview with Director.

Key Skills:

• Data Analytics
• Microsoft Access
• SQL
• Power BI
• R
• Data Visualization
• Tableau
• Data Management
• Data Mining
• SAS
• Data Analysis Skills
• Analytics