Join the team and be a part of exciting data innovation

Data Engineer

Location:

Remote

Employment Type:

Full Time

Role:

Permanent

Employment Type:

Competitive Salary

Domain 1: Perform Discovery and Determine the Scope

  • Analyse data via from various data sources (CSV, Azure DevOps, Amazon Refshift, Azure) to assess structure, granularity, quality, and fit for analytics.
  • Gather, document, and validate detailed business requirements.
  • Brainstorm, define, and document innovative, actionable analytics and KPIs
  • Prepare high-level project plans including required activities, resources, and timeframes.
  • Given a scenario, recommend the appropriate analytics delivery method.
  • Know and understand how and when to recommend the Power BI platform, mobile, and
  • Embedded Analytics options.

Domain 2: Evaluate, Prepare, and Connect to Data

  • Plan and implement Power BI connections to data sources, particularly Cloud data warehouses such as Snowflake, Redshift and Azure SQL.
  • Collaborate with businesses. And IT&S architects to prepare efficient data sets aligned with requirements.

Data Sourcing

  • Identify and connect to the data source and change settings.
  • Select a shared dataset or create a local dataset, and select a storage mode.
  • Choose an appropriate query type and identify query performance issues.
  • Use or create a PBIDS file and data flows.
  • Connect to a dataset using the XMLA endpoint.

Clean, Transform, And Load Data

  • Resolve inconsistencies, unexpected or null values, and data quality issues.
  • Apply user-friendly value replacements.
  • Identify and create appropriate keys for joins.
  • Evaluate and transform column data types.
  • Apply data shape transformations to table structures.
  • Apply user-friendly naming conventions to columns and queries.
  • Leverage Advanced Editor to modify Power Query M code.
  • Configure data loading and resolve data import errors.

Domain 3: Plan and Implement Data Models & DAX

  • Recommend an efficient calculation method – via Power BI or Data Warehouse.
  • Analyse and validate results.

Design a Data Model

  • Define and configure tables and column properties.
  • Define quick measures.
  • Flatten out parent-child hierarchies.
  • Define role-playing dimensions.
  • Define a relationship’s cardinality and cross-filter direction.
  • Design the data model to meet performance requirements.
  • Create a common date table.
  • Define the appropriate level of data granularity.

Develop a Data Model

  • Apply cross-filter direction and security filtering.
  • Create calculated tables, hierarchies, and calculated columns.
  • Implement row-level security roles.

Company Overview:

SUGANSA – where brilliant people embrace change and seize opportunities to advance their careers and amplify customer success. People are the heart of our business. We support each other and work as a team, globally and locally to deliver excellence for our customers and colleagues. We use the power of technology to deliver mission-critical IT services that move the world. https://www.sugansa.com

We have a wonderful opportunity for a Data Modeler to join our passionate Data & Analytics team. You will work with our clients to gather, review, and analyse data from various sources to provide meaningful information and insights.

We are an Equal Opportunity Employer

SUGANSA is proud to be an equal opportunity employer and we welcome submissions from people from all walks of life. We celebrate our diversity and recognize it is the unique contributions of our people that give us our edge. We stand by the ‘bring your whole-self to work’ philosophy. It is our inclusive culture that powers our results, and our company grows only if our people grow.

Our culture and benefits

SUGANSA is committed to building better futures for our customers, colleagues, environment, and communities. We take care of each other and foster a culture of inclusion, belonging and corporate citizenship. We put this into action developing and implementing societal initiatives within our Social Impact Practice.

Our “people first” philosophy means we offer competitive remuneration, benefits, training, and career opportunities that reflect our commitment to improving the lives of our employees, and the communities in which we live and work.

Create Measures by Using DAX

  • Use DAX to build complex measures.
  • Use CALCULATE to manipulate filters.
  • Implement Time
  • Intelligence using DAX.
  • Replace numeric columns with measures.
  • Use basic statistical functions to enhance data.
  • Create semi-additive measures.

Optimize Model Performance

  • Remove unnecessary rows and columns.
  • Identify poorly performing measures, relationships, and visuals.
  • Improve cardinality levels by changing data types and through summarization.
  • Create and manage aggregations

Domain 4: Design Dashboards and Develop Visualizations/Reports

  • Plan and implement performance best practices.
  • Recommend and develop optimal visualizations for insightful, actionable business use.
  • Design dashboards based on visual analytics best practices and business requirements.
  • Collaborate with business stakeholders to design and iterate insightful dashboards.
  • Support User Acceptance Testing (UAT), performance testing (load times), and deployment.
  • Create reports
  • Create dashboards

Domain 5: Enable Insightful Analysis & AI

  • Enhance reports to expose insights
  • Perform advanced analysis

Domain 6: Deploy Assets and Maintain Access

  • Manage datasets
  • Create and manage workspaces

Skills & Requirements

  • Power BI Data Analyst Certified/Hands-on experiences of 4+ Years
  • Master in Package Configuration
  • Experience in Architecture Knowledge
  • Proficient in Business Analysis, Business Knowledge & Technical Solution Design

Why We Love Working For Sugansa?

SatishTechnical Delivery Manager
Read More
“Sugansa is a fast-growing company with a great portfolio of clients. I work as a Technical Delivery Manager for a leading retailer in the UK through Sugansa. It is a wonderful place to work. The company’s primary expertise is Data Management, Cloud Computing & Business Intelligence. I’ve met some of the most talented people ever here. Really smart people, a lot of opportunity for growth, always encouraged to be innovative, think big, and create something new. Client has immense faith, respect and great expectations on Sugansa colleagues.”
RajasekharDevOps Engineer
Read More
“One of the great places to work. Highly talented and excellent team to work with. Strongly recommended and Great work culture. Management and HR team is very transparent and flexible.” Thanks
KeerthiData Engineer
Read More
“I have joined Sugansa Solutions as a Cloud Engineer. The job is exciting and fast-paced, and the client presents a new challenge and offers a great opportunity for learning and professional advancement. Management is willing to listen and tries its best to provide good work-life balance.”
Srivalli KrishnaTechnical Delivery Manager
Read More
“People first company, Quick and Easy to deal with; Excellence from everyone with whom I have dealt while working. Good people, Great progression options and Inclusive Lots of learning opportunities, an employer that puts people, the local community and sustainability first. Good senior management and a very robust company that continues to grow with a progressive mindset and work ethic. “
Maciej BTechnical Delivery Manager
Read More
"Sugansa Solutions is a company focused on gathering versatile and highly skilled SMEs and Consultants helping Clients with Data Analytics and Management. As a Technical Delivery Manager working on a Data Migration programme in Sugansa, I am lucky to work with real experts making complex”
G ABusiness Analyst
Read More
“As a Business analyst, I have found Sugansa Solution to be an employee-focused consultancy, from pre-employment stage to job placement to be very professional and timely for each employee and the management team ensures the employees’ skillset to project are best suited and provide project support that improves client confidence. “
Previous
Next