Job Description
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