Data Analyst - Chicago, IL

AHU Technologies Inc

Data Analyst - Chicago, IL

Washington, DC
Part Time
Paid
  • Responsibilities

    Job Description:

    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.

    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

    This is a remote position.