AHU Technologies Recruitment · 1 month ago
Data Analyst - Chicago, IL
AHU Technologies Recruitment is seeking a Data Analyst to support Grant Thornton, a major Audit, Tax, and Advisory Services company. The role involves developing data models, analyzing complex data sources, and ensuring data quality for global needs while collaborating with various teams.
AppsConsultingEnterprise Resource Planning (ERP)OutsourcingStaffing AgencyWeb Development
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
Qualification
Required
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
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
Preferred
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)
Company
AHU Technologies Recruitment
At AHU Technology, we specialize in IT consulting and permanent staffing, serving the dynamic IT needs of top United States corporations.
H1B Sponsorship
AHU Technologies Recruitment has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (4)
2024 (4)
2022 (8)
2021 (5)
2020 (5)
Funding
Current Stage
Growth StageCompany data provided by crunchbase