Role: Azure Data Engineer.
Location: Cincinnati, Ohio, United States (Onsite).
Job Type: Full Time.
Job Description:
Roles & Responsibilities:
- Gathering business requirements and transforming to functional and technical specifications
- Leading BI team in both technical and functional aspects
- Liaising between business, Client IT and TCS team
- Strong knowledge in AZURE Synapse, Azure Data Factory, Qlik replicate, Qlik Compose & Denodo
- Strong Data Warehouse and Data Visualization skills (Oracle & Microsoft tools), ODI , OBIEE , Power BI , SSIS
- Develop and maintain SQL, PL/SQL, Python code as needed
- Understand and navigate a wide array of source data systems (enterprise data warehouses, relational databases, IT systems, in house and COTS applications, documents, APIs, unstructured data, big data, NoSQL databases, etc.)
- Analyse data and assist with developing insights (e.g., via data visualization tools like Power BI / SAC) to enable business decision making
- Standardize data and reporting across businesses and teams to enable consistency and quality of key business data
- Design and develop enterprise data warehouse platform that conforms to consistent methodologies, standards and industry best practices
- Design, develop, test and document data integrations and assist with deployment, validation and hypercare
- Maintain and support ETL/ELT integrations using technical documentation
- Participate in designing overall logical & physical data warehouse and data mart models and architectures to support business requirements
- Assist with review to confirm technical feasibility of integration development objects based on integration principles and best practices
- Propose new methodologies to demonstrate data to improve existing methodologies
- Developing prototypes and proof of concepts for required solutions
- Implementing information security standards in enterprise data warehouse
- Prepare and present ideas and recommendations to colleagues and management
- Document solutions through high/low level design documentation
- Learn new ground breaking data engineering and analytic tools as needed
- Contribute to development of the overall solution approach
- Recommend solutions to address gaps
- Assist with development estimation
- Supervise and review activities of consultants
