Data Engineer

Proficient in Looker Action, Looker Dashboarding, Looker Data Entry, LookML, SQL Queries, BigQuery, LookML, Looker Studio, BigQuery, GCP.



Remote Working

2 pm to 12 am IST or

10:30 AM to 7:30 PM IST

Sunday to Thursday

Responsibilities:

● Create and maintain LookML code, which defines data models, dimensions, measures, and relationships within Looker.

● Develop reusable LookML components to ensure consistency and efficiency in report and dashboard creation.

● Build and customize dashboard to Incorporate data visualizations, such as charts and graphs, to present insights effectively.

● Write complex SQL queries when necessary to extract and manipulate data from underlying databases and also optimize SQL queries for performance.

● Connect Looker to various data sources, including databases, data warehouses, and external APIs.

● Identify and address bottlenecks that affect report and dashboard loading times and Optimize Looker performance by tuning queries, caching strategies, and exploring indexing options.

● Configure user roles and permissions within Looker to control access to sensitive data & Implement data security best practices, including row-level and field-level security.

● Develop custom applications or scripts that interact with Looker's API for automation and integration with other tools and systems.

● Use version control systems (e.g., Git) to manage LookML code changes and collaborate with other developers.

● Provide training and support to business users, helping them navigate and use Looker effectively.

● Diagnose and resolve technical issues related to Looker, data models, and reports.

Skills Required:

● Experience in Looker's modeling language, LookML, including data models, dimensions, and measures.

● Strong SQL skills for writing and optimizing database queries across different SQL databases (GCP/BQ preferable)

● Knowledge of data modeling best practices

● Proficient in BigQuery, billing data analysis, GCP billing, unit costing, and invoicing, with the ability to recommend cost optimization strategies.

● Previous experience in Finops engagements is a plus

● Proficiency in ETL processes for data transformation and preparation.

● Ability to create effective data visualizations and reports using Looker’s dashboard tools.

● Ability to optimize Looker performance by fine-tuning queries, caching strategies, and indexing.

● Familiarity with related tools and technologies, such as data warehousing (e.g., BigQuery ), data transformation tools (e.g., Apache Spark), and scripting languages (e.g., Python).

• Drive the execution of all product lifecycle processes for the growth of Factory Acquisition product, including product research, market research, competitive analysis, planning, positioning, roadmap development, requirements development, and product launch
• Identify, Plan and execute side Product Hacks to speedup Factory Acquisitions
• Assess current competitor offerings, seeking opportunities for differentiation
• Analyze consumer needs, current market trends, and potential partnerships from an ROI and build vs. buy perspective
• Create product strategy documents that describe business cases, high-level use cases, technical requirements, revenue, and ROI
• Translate product strategy into detailed requirements for prototype construction and final product development by engineering teams
• Build product flows for seamless factory onboarding at scale
• Collaborate closely with engineering, production, marketing, and sales teams on the development, QA, and release of products and balance of resources to ensure success for the entire organization
• Drive the Factory CAC Metric
• Implement, and maintain production timelines across multiple departments
• Appraise new product ideas and strategize appropriate to-market plans

We are hiring a Magento Developer for Dehradun location with Ftechiz Solutions.

• Substantive experience developing on the Magento platform
• Expert in PHP programming along with Zend and CodeIgnitor framework
• Experience with MySQL database design and administration
• Experience with XML / SOAP / WDSL
• Experience with Subversion
• Knowledge of current HTML / CSS / XHTML standards
• Knowledge of JavaScript / AJAX technologies and methods
• Specific Magento experience...
• Configure multiple stores and authentication features
• Integrate creative designs into Magento from HTML templates
• Integrate with payment gateways (authorize.net, etc)
• Integrate with shipping providers (Fedex, UPS, etc)
• Installing and skinning Magento modules
• Creating custom Magento modules, a plus
• Customize product and inventory management features
• Take advantage of Magento web services
• Cross-browser testing and implementation

• Oversees all company social media accounts management and reporting.
• Plan strategies to drive traffic and engagement to generate leads.
• Develop engaging, creative, innovative content and graphics for regularly scheduled posts, which promote brand-focused messages.
• Coordinate with other departments to plan social media activities.
• Design and handle paid advertising campaigns on LinkedIn and Facebook.
• Analyze social media campaigns with tracking systems to gather visitor data and determine efficacy and areas for social media campaign improvement.
• Monitor and develop reports on competitor activity within social media spaces.
• Monitoring users' engagement with and feedback on every post.
• Exploring the potential value of social media sites that are not yet in our repertoire.
• In-depth understanding of all the latest and familiar social media sites with their associated algorithms.
• Finding relevant groups on social channels and contribute.
• Connecting with potential leads, and influencers to build a connection.
• Stay up to date with social media trends.
• Connect with social media influencers to improve brand reputation.

• Experience – 3+ years of experience
• Minimum a bachelor's degree
• Prior social media handling experience min 3 years
• Experience in handling social media automation tools such as Hoot suite, Hub spot, Buffer etc.
• Expert knowledge of all leading social media sites.
• Good communication skills.
• Flexible and engaging writing style.
• Experience with a designing tool (Canva, Illustrator, etc)

• Act as a point of contact and build influential candidate relationships during the selection process.
• The candidate will be responsible to handle the entire cycle of recruitment and selection under the guidance of Head - HR inclusive of the following but not limiting to:.
• Source/ Screen candidates from job portals and other forums.
• Must have Good Communication Skills
• Freshers may apply

• Should have experience researching problem statements and designing solutions that meet the desired UX goals and stakeholder requirements

• Should be able to rapidly prototype ideas; pen and paper will do for mockups. Should be familiar with prototyping tools or front end code for higher fidelity prototyping

• Good communication skills. Must be able to communicate idea to all stakeholders product, engineering and design

• Must have average above average knowledge of the Adobe Suite

• Must be able to look at the product as a whole to design workflows that scale

• Must be able to measure UX changes and suggest further improvements

• Should be able to build UI components that meet the desired UX. Should be able to understand and respect the UX

• Should follow the style guide and design according to the guidelines

• Understanding of typography, typographic grid, grid based systems, design frameworks and responsive design principles is required. Should be able to adapt and extend the style guide as required and define new UI components when needed

• Should be able to build reusable UI components

• Good communication with the product and engineering teams to assess feasibility of UI components

• Experience with motion/interaction design a plus

• Must know the Adobe Creative Suite well. Must also be familiar with prototyping tools