Senior Consultant

As a Data Analyst, your main role is understanding business requirements and providing data mapping and analysis that forms the blueprint of data flow from raw source systems to a customized data mart, dashboards, or any other API required for data consumption. You will play a crucial role in the data management process, ensuring that data is collected, transformed, and made accessible for analytical purposes. Your expertise in data technologies will enable the organization to make informed decisions and derive valuable insights from large datasets.

Responsibilities:

• Understand the project requirements by conducting Business Discovery Sessions.
• Work with internal teams such as system support, DBA, and MIS to translate existing requirements into desired mart and reports.
• Prepare data mapping documents for various layers of the data platform (raw-bronze, EDM-silver, project specific-gold).
• Support different phases of projects as needed by data engineers, data modelers, QA testers, and Power BI developers.
• Collaborate with other developers, data analysts, and stakeholders to ensure that the software meets the needs of the business or organization.

Technical Skills

• Strong data querying and processing skills using SQL, SAS, Oracle, Apache Spark or similar languages.
• Experience with data visualization tools - Power BI, Business Objects, Crystal or similar tools.
• Knowledge of data warehousing and ETL concepts.

Competencies

• Expert-level proficiency in SQL and Python with additional experience in SAS/R/Spark.
• Deep understanding of distributed data processing frameworks, particularly Apache Spark.
• Experience with cloud platforms (Azure, AWS) - including object storage, compute, networking, and data integration services.
• Familiarity with data modeling techniques, including schema design, partitioning, and performance tuning.
• Experience working with structured and semi-structured data formats (e.g., JSON, Parquet, Avro, XML).
• Knowledge of data governance, quality assurance, and compliance best practices.
• Solid grasp of core computer science fundamentals (e.g., data structures, search algorithms, queues).
• Relevant to performance critical data engineering.