AHU Technologies Inc
AHU Technologies Inc is hiring: Data Analyst Chicago IL in Washington DC
AHU Technologies Inc, Washington DC, Washington DC, US
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.
- 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.
- 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.
- 30 minute technical interview with Manager
- 30 minute behavioral interview with Director