Data Analyst

Position Type: Contract

Location: Chicago, IL (Onsite)

· 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 which 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

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