Data Analyst (Principal)

Data Warehouse, MS SQL, ETL, DevOps, Power BI
Full Time
$130,000 - $140,000
Travel required to 10%.

Job Description

Our client needs a Principal Data Analyst who, through research and analysis of data from different functional systems, will develop data integration/aggregation solutions to support data analytics and visualization tools. The ideal candidate will partner with executive stakeholders, finance/operations/sales subject matter experts and functional leaders in creating robust and scalable data analytics solutions for business insight.  The data analyst must possess a collaborative attitude, strong oral/written presentation skills, excellent problem-solving skills, and solid analytical/critical thinking skills.


Essential Duties:

  • Design and implement a flexible data access platform for operational data stores/islands, data warehouses, data marts and data lakes using standard practices as well as documenting the systems of record, data dictionaries and data flow diagrams for strategic data management
  • Using logical data models, help build data marts for analysis to determine trends and significant data relationships across different functional areas
  • Translate business needs into data modeling and reporting initiatives
  • Work with business stakeholders to interpret data to identify trends to go across future data sets
  • Adapt standard or develop novel applications of classification, forecasting, simulation, optimization, and summarization techniques
  • Create compelling interactive visualizations and presentations to enhance decision making capabilities throughout the company
  • Develop extracts, transforms, and loads with SQL  
  • Drive AWS/Azure cloud data platform architectural decisions and development standards
  • Actively contribute towards data migration tasks from on-premises to cloud
  • Multi-task across several ongoing projects and daily duties of varying priorities as required
  • Ability to make good judgments, decisions, negotiate and drive problem resolutions
  • Create detailed technical specifications and release documentation for assigned ETL and reporting projects



Education and/or Experience:

  • Experience with Data Warehousing methodologies and concepts
  • Experience working with large data sets.
  • Expert knowledge of analytical tools and scripting languages
  • Extensive experience with BI/DW lifecycle including source data analysis, ETL, data marts, reporting, dashboards, and analytics
  • 8+ years of experience working with MS SQL Server database. Mastery of SQL, specifically MS SQL Server 2012 and higher.
  • 8+ years of experience developing ETL processes with large scale data warehouses required
  • 2+ years working in DevOps, automating, and deploying packages between different environments
  • 5+ years working in Alteryx, Power BI


Specific Skills/Knowledge:

  • High proficiency in dimensional modeling techniques and their applications including star schemas
  • Familiarity with Data Governance and Master Data Management principles
  • Ability to work with structured and unstructured source data



Dice Id : sumitech
Position Id : 2010
Originally Posted : 2 months ago
Have a Job? Post it

Similar Positions

SQL Developer | Epic Clarity
  • Onpoint Search Consultants
  • Los Angeles, CA