Business Intelligence Developer

Advanced SQL, data modeling skills - designing Dimensional Layer, 3NF, denormalized views & semantic layer, Expertise in GCP services

Role & Responsibilities:

● Design and implement robust semantic layers for data systems on Google Cloud Platform (GCP)

● Develop and maintain complex data models, including dimensional models, 3NF structures, and denormalized views

● Write and optimize advanced SQL queries for data extraction, transformation, and analysis

● Utilize GCP services to create scalable and efficient data architectures

● Collaborate with cross-functional teams to translate business requirements(specified in mapping sheets or Legacy

Datastage jobs) into effective data models

● Implement and maintain data warehouses and data lakes on GCP

● Design and optimize ETL/ELT processes for large-scale data integration

● Ensure data quality, consistency, and integrity across all data models and semantic layers

● Develop and maintain documentation for data models, semantic layers, and data flows

● Participate in code reviews and implement best practices for data modeling and database design

● Optimize database performance and query execution on GCP

● Provide technical guidance and mentorship to junior team members

● Stay updated with the latest trends and advancements in data modeling, GCP services, and big data technologies

● Collaborate with data scientists and analysts to enable efficient data access and analysis

● Implement data governance and security measures within the semantic layer and data model

Key Responsibilities:

Coordinating Production:

•  Collaborate with cross-functional teams to ensure timely and efficient production processes.
• Monitor production schedules, material availability, and resource allocation to meet
• production targets.
• Identify areas for process improvement and implement solutions to enhance productivity.

Managing Dispatch:

• Oversee the coordination of product deliveries and shipments to ensure accurate and timely dispatch.
• Liaise with logistics partners and carriers to optimize delivery routes and minimize delays.
• Address any issues related to dispatch and provide effective solutions.

Managing Customer Support (Logistics and Orders):

• Handle customer inquiries and concerns related to logistics, orders, and deliveries.
• Work closely with customer support teams to resolve issues promptly and maintain high levels of customer satisfaction.
• Provide customers with accurate information about order status, tracking, and delivery times.

Managing Vendors:

• Establish and maintain positive relationships with vendors and suppliers.
• Collaborate with procurement teams to ensure timely and cost-effective sourcing of
• materials and services.
• Negotiate terms and contracts with vendors to achieve favorable terms for the company.

Managing Inventory:

• Monitor inventory levels and coordinate with relevant teams to ensure adequate stock availability.
• Implement inventory control measures to minimize stockouts and excess inventory.
• Analyze inventory data to make informed decisions about reorder points, stock replenishment, and inventory optimization.

Benefits:

• Comprehensive training in operations management practices.
• Opportunity to learn from experienced professionals in the field.
• Fast-track career growth within the organization.
• Exposure to diverse projects and responsibilities.

Bachelor’s degree in Computer Science, Information Systems or related field and/or equivalent relevant experience  Three years of progressively challenging experience working as a CC&B suite Senior Developer in solution architecture, project management, system design, development testing, implementation and support  Advanced knowledge in CC&B Java, C2M, Oracle Database, CC&B data model and Oracle Utilities Application Framework  Proficient in usingHibernateQuery Language, XAIIWSWeb Services, CCB Configuration Tools, web-based languages(e.g., HTML, XML, SOAP, JavaScript, etc.) and UNIX • Extensive experience with Oracle Utilities SDK and Eclipse 3.7 and with writing high performance, multi-threaded, critical java applications over large databases including Oracle 10g and Oracle 11g.  Proficient working knowledge of SQL and relational database concepts and developing stored procedures in Oracle 10g and Oracle 11g  Knowledge and understanding of software development life cycle and industry best practices  Proficient in the use of MicrosoftOffice applications  Experience should include multi-product implementations (CC&Bintegrations with MWM, MDM, WAM, CSS, etc).  Must have experience with other integrations involving the XAI IWS interfaces  Must have in-depth knowledge of field order and field activities workflow, configuration and writing custom services  Must have prior experience implementing MWM (mobile workforce) or any other third party workforce tool with CC&B  Must have prior experience implementing CC&Bwith a customer portal 

AeroLeads is a fast-growing product-based startup with 200,000+ business users and a good number of paying customers including Inc 5000 companies. Companies like IBM have used us and now we are looking for a Content Writer who can help us grow even faster.                                                                                                                                                                                                                                                       What You Will Do

1. Research industry-related topics

2. Write clear marketing copy to promote our services

3. Prepare well-structured drafts using content management systems

4. Proofread and edit blog posts before publication

5. Submit work for input and approval

6. Coordinate with marketing and design teams to illustrate articles

7. Conduct simple keyword research and use SEO guidelines to increase web traffic

What you will get

• Freedom to make your decisions.

• Work on your own as we are a really small team.

• Flexible work timings.

• Competitive market salary.

We are looking to hire immediately.