Data Engineer

Constellation Consulting

Job Description: Constellation Consulting Group (CCG) is open for talented professionals to join our team. As seasoned consultants, we’re cognizant of having an environment that gives employees a good balance between work and lifestyle. CCG fields a highly accomplished team of seasoned data analytics and business intelligence professionals.

 CCG is now seeking highly motivated Data Engineer to join or Data analytics team.

Primary Responsibilities:  

• Use knowledge to architect data warehousing and BI solutions that solve problems that cut across multiple business functions
• Interact with business customers, gathering requirements and delivering complete Data Engineering, Data Warehousing, and analytics solutions.
• Interface with other technology teams to extract, transform, and load data from a wide variety of data sources
• Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation.

• Job Requirements:  
• Advanced working SQL knowledge and experience working with relational and columnar databases query authoring (SQL) as well as working familiarity with databases.
• Experience building and optimizing data pipelines, architectures and data sets using cloud-based tools
• Experience performing analysis on internal and external data and processes to answer specific business questions and identify opportunities for optimization.
• Strong analytical mind related to working with unstructured datasets across multiple functional areas.
• Build processes supporting data transformation, data structures, metadata, dependency and workload management.
• Hands on knowledge with MS Data Factory & integration mechanisms with varied source systems like Oracle ERP, Oracle Fusion, Salesforce, Yardi and Microsoft Dynamics 365, SAP ERP
• A successful history of manipulating, processing and extracting value from large disconnected and heterogenous datasets.
• Strong team player with ability to work and deliver projects independently with minimal supervision.
• Experience supporting and working with cross-functional, multi-geography teams in a dynamic environment.

1. Strong hands on experience in following areas:
2. Data Stores: Azure Synapse Analytics, Azure SQL, Azure Blob storage, MS Analysis Services
3. Data Integration: Informatica, Azure Data Factory, SQL Server Integration Services, Apache NIFI
4. Programming Language: Python, TSQL, PowerShell
5. Reporting Platforms: Power BI, Tableau, IBM Cognos
6. Additional desirable skills: Exposure to data analytics, statistical model development will be added advantage.
7. Excellent written and verbal communication skills.

Desired Attributes: 

• B.E. / B.Tech (Computer Science, Information systems, IT)
• MCA/MCS