The Analytics Engineer would provide technical expertise in needs identification, data modeling, data movement, and transformation mapping (source to target), automation and testing strategies, translating business needs into technical solutions with adherence to established data guidelines and approaches from a business unit or project perspective.
- Understands and leverages best-fit technologies (e.g., traditional star schema structures, cloud, Hadoop, NoSQL, etc.) and approaches to address business and environmental challenges.
- Provides data understanding and coordinates data-related activities with other data management groups such as master data management, data governance, and metadata management.
- Actively participates with other consultants in problem-solving and approach development.
- Provide a consultative approach with business users, asking questions to understand the business need and deriving the data flow, conceptual, logical, and physical data models based on those needs. Perform data analysis to validate data models and to confirm the ability to meet business needs.
- Assist with and support setting the data architecture direction, ensuring data architecture deliverables are developed, ensuring compliance to standards and guidelines, implementing the data architecture, and supporting technical developers at a project or business unit level.
- Coordinate and consult with the Data Architect, project manager, client business staff, client technical staff and project developers in data architecture best practices and anything else that is data related at the project or business unit levels.
- Work closely with Business Analysts and Solution Architects to design the data model satisfying the business needs and adhering to Enterprise Architecture.
- Coordinate with Data Architects, Program Managers and participate in recurring meetings.
- Help and mentor team members to understand the data model and subject areas.
- Ensure that the team adheres to best practices and guidelines.
- Knowledge of data architecture, data modeling or similar experience.
- Knowledge of data modeling tools (examples: ERwin, ER/Studio,
- Understanding of major database platforms (e.g, Oracle, SQL Server, Teradata, etc.).
- Understanding of major Data Architecture philosophies (Dimensional, ODS, Data Vault, etc.).
- Understanding of modern data warehouse capabilities and technologies such as real-time, cloud, Big Data.
- Knowledge of data warehousing tools such as Informatica, Datastage, SSIS etc.
- Should be able to work with globally diverse teams.
- Indore, Madhya Pradesh, India
- Hyderabad, Telangana, India
About The Modern Data Company
Founded in 2018, The Modern Data Company began with the realization that enterprise-wide data access has been siloed. Data engineers and database administrators have been the longstanding data gatekeepers who funneled data to analysts and data scientists. We aim to change that by freeing enterprises to make better data-driven decisions by democratizing access to data. When all employees, irrespective of their technical skills or background, can easily explore and analyze enterprise data, then both productivity and market expansion are realized at a faster pace.
Modern Data is proud to be an equal opportunity workplace.